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 Live12/11/2017 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.001805563
DC Downtown, DC(Metro Center)12/11/2017 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.001814880
Virtual Live1/15/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.001805567
MD Rockville1/15/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.001814673
VA ALEXANDRIA1/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.001803700
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.001805571
NY New York1/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.001814824
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.001803703
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.001805574
MD LAUREL2/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.001814791
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.001805560
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.001803695
DC Downtown, DC(Metro Center)3/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.001814763
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.001805564
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.001803699
ON Toronto5/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.001814715
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.001805568
DC Downtown, DC(Metro Center)6/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.001814747
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.001805572
VA ALEXANDRIA7/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.001814760
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.001805575
VA ALEXANDRIA7/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.001803702
NY New York7/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.001814733
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.001805578
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.001803706
MD Rockville9/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.001814683
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 26 of 26 items