Excel 2007 Advanced Courseware

Microsoft Excel 2007 Advanced Level Training Materials

Training Courseware

Training Course Outline

 

EXCEL 2007 FUNCTIONS

  •     Excel 2007 Functions
  •     Getting help about using a particular function
  •     TODAY
  •     DAY
  •     MONTH
  •     YEAR
  •     SUMIF
  •     ROUND
  •     COUNT
  •     COUNTA
  •     COUNTIF
  •     PROPER
  •     UPPER
  •     LOWER
  •     CONCATENATE
  •     FV
  •     NPV
  •     PMT
  •     PV
  •     RATE
  •     HLOOKUP
  •     VLOOKUP
  •     IF
  •     AND
  •     OR
  •     ISERROR
  •     DSUM
  •     DMIN
  •     DMAX
  •     DCOUNT
  •     Nested functions

USING ONE-INPUT OR TWO-INPUT DATA TABLES / WHAT-IF TABLES IN EXCEL2007

  •     Using a one input Data Table command
  •     Using a two input data table command

A FIRST LOOK AT EXCEL 2007 PIVOT TABLES

  •     Creating a PivotTable
  •     Dropping data into the Pivot Table
  •     Modifying data and refreshing the Pivot Table
  •     Grouping data within a Pivot table

EXCEL2007 SCENARIOS

  •     Scenario Manager – an example
  •     Showing a scenario
  •     Viewing an alternative scenario
  •     Create a scenario summary

EXCEL 2007 AUDITING

  •     Tracing precedent cells
  •     Tracing the dependants of a cell
  •     Displaying all formulas within a worksheet
  •     Adding comments
  •     Displaying comments
  •     Removing comments
  •     Editing comments

MACROS WITHIN EXCEL 2007

  •     Displaying the Developer tab
  •     Recording and running macros
  •     Lowering your macro security level
  •     Customizing the Quick Access Toolbar
  •     Changing the Quick Toolbar Macro icon
  •     Removing a macro icon from the quick access toolbar
  •     Raising your macro security level
Rate this post