Excel 2007 Advanced Courseware Materials

Rate this post

Microsoft Excel 2007 Advanced Training Materials for IT Trainers

Computer Training materials for Teaching Microsoft Office 2007

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

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

A FIRST LOOK AT EXCEL2007 PIVOT TABLES

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

SCENARIOS

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

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

  • 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

 

Powered by WordPress. Designed by Woo Themes