Font size:

Troubleshooting and Enhancing Professional Workbooks

  • Deciphering and correcting functions for data integrity
  • Accurately interpreting calculations
  • Implementing Names to enhance your workbook model
  • Monitoring KPIs using conditional formatting

Analyzing Data with Functions

Summarizing business data with functions

  • Identifying the correct statistical function to aid analysis
  • Applying basic financial functions
  • Differentiating serial dates and date presentations
  • Calculating the number of working days

Controlling calculations and nested formulas

  • Interpreting data variations with the IF function
  • Streamlining calculations with referencing
  • Developing nested functions for multiple conditions
  • Capturing information with lookup functions
  • Applying techniques to implement and troubleshoot nested calculations

Optimizing Workbook Models with "What-If" Analysis

Planning for contingencies

  • Managing variables in worksheets with Scenarios
  • Comparing and contrasting different data sets with Scenarios reports

Quantifying variables in a workbook model

  • Determining the magnitude of a variable with Goal Seek to achieve an end value
  • Calculating the optimum variable values in a worksheet model with Solver

Summarizing Business Information

Organizing workbooks and links

  • Arranging multiple workbooks with Workspaces
  • Managing external links

Consolidating ranges

  • Building 3D formulas to analyze worksheet data
  • Summarizing multiple sources of Excel information into one worksheet

Formulating Decisions from Database Information

Distilling data sets for data analysis

  • Managing multiple data sets on a single worksheet with the Table feature
  • Defining an Excel data set to ensure appropriate use of built-in features
  • Extracting unique lists of records from an Excel data set with the Advanced Filter
  • Analyzing data sets with filters and aggregation

Interpreting and refining data with PivotTables

  • Defining data summaries interactively
  • Summarizing data sets with grouping and aggregation
  • Comparing related totals dynamically
  • Filtering details with Report Filters and Slicers

Visualizing and exploring PivotTable reports

  • Presenting PivotTable reports effectively with PivotCharts
  • Examining data patterns with Sparklines
  • Analyzing multiple tables of data with Power Pivots
  • Discovering and presenting information with Power View

Enhancing Excel Usage with Macros

Automating repetitive tasks

  • Simplifying complex tasks and reducing errors
  • Bulletproofing routine editing and formatting
  • Invoking macros with Form controls

Troubleshooting and Enhancing Professional Workbooks

  • Deciphering and correcting functions for data integrity
  • Accurately interpreting calculations
  • Implementing Names to enhance your workbook model
  • Monitoring KPIs using conditional formatting

Analyzing Data with Functions

Summarizing business data with functions

  • Identifying the correct statistical function to aid analysis
  • Applying basic financial functions
  • Differentiating serial dates and date presentations
  • Calculating the number of working days

Controlling calculations and nested formulas

  • Interpreting data variations with the IF function
  • Streamlining calculations with referencing
  • Developing nested functions for multiple conditions
  • Capturing information with lookup functions
  • Applying techniques to implement and troubleshoot nested calculations

Optimizing Workbook Models with "What-If" Analysis

Planning for contingencies

  • Managing variables in worksheets with Scenarios
  • Comparing and contrasting different data sets with Scenarios reports

Quantifying variables in a workbook model

  • Determining the magnitude of a variable with Goal Seek to achieve an end value
  • Calculating the optimum variable values in a worksheet model with Solver

Summarizing Business Information

Organizing workbooks and links

  • Arranging multiple workbooks with Workspaces
  • Managing external links

Consolidating ranges

  • Building 3D formulas to analyze worksheet data
  • Summarizing multiple sources of Excel information into one worksheet

Formulating Decisions from Database Information

Distilling data sets for data analysis

  • Managing multiple data sets on a single worksheet with the Table feature
  • Defining an Excel data set to ensure appropriate use of built-in features
  • Extracting unique lists of records from an Excel data set with the Advanced Filter
  • Analyzing data sets with filters and aggregation

Interpreting and refining data with PivotTables

  • Defining data summaries interactively
  • Summarizing data sets with grouping and aggregation
  • Comparing related totals dynamically
  • Filtering details with Report Filters and Slicers

Visualizing and exploring PivotTable reports

  • Presenting PivotTable reports effectively with PivotCharts
  • Examining data patterns with Sparklines
  • Analyzing multiple tables of data with Power Pivots
  • Discovering and presenting information with Power View

Enhancing Excel Usage with Macros

Automating repetitive tasks

  • Simplifying complex tasks and reducing errors
  • Bulletproofing routine editing and formatting
  • Invoking macros with Form controls
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live1/29/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.002402951
VA Herndon1/29/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.002401095
ON Ottawa1/29/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.002415091
MD Rockville2/12/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.002401099
Virtual Live2/12/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.002402955
ON Ottawa2/12/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.002415146
DC Washington, DC2/26/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.002401103
VA Alexandria3/19/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.002401107
Virtual Live3/19/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.002402959
ON Ottawa3/19/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.002415200
NY New York5/7/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.002401111
Virtual Live5/7/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.002402963
VA Alexandria5/7/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.002415246
DC Washington, DC6/4/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.002401094
Virtual Live6/11/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.002402967
VA Manassas6/11/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.002415313
Virtual Live7/16/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.002402952
ON Toronto7/16/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.002415080
VA Herndon7/30/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.002401098
Virtual Live7/30/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.002402956
MD Columbia7/30/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.002415162
DC Washington, DC8/27/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.002401102
Virtual Live9/17/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.002402960
VA Alexandria9/17/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.002401106
ON Ottawa9/17/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.002415201
NY New York10/29/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.002401110
Virtual Live10/29/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.002402964
MD Annapolis10/29/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.002415267
DC Washington, DC11/26/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days1950.002401114
Virtual Live12/10/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1950.002402968
VA Stafford12/10/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days1950.002415330
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 31 of 31 items