Microsoft Excel Training - Advanced Course

Course Content

Pivot Tables

*An interactive table that summarises or cross tabulates large amounts of data

• Creating
• Updating
• Adding Fields
• Field Options
• Manipulating
• Consolidation
• Charts

Outlining

* Summarises worksheet data

• Creating an Outline
• Group/Ungroup
• Manipulating
• Removing

Scenario Manager

* Uses a set of values to forecast the outcome of a formula

• Adding
• Updating
• Merge
• Summary
• Printing

Customising the Toolbar

• Add/Remove Button
• Create New Toolbar
• Default Toolbar

Charts

• Adding 2nd Y Axis
• Custom Charts
• Trend Lines

Intro. To Macro

* A series of repetitive actions grouped together and assigned to the kayboard or toolbar button

• Recording Macros
• Assign to Keyboard
• Assign to Toolbar
• Save in Personal.xls
• Save in Workbook

Functions

• Logical
  Determines true or false conditions
• Lookup
  Returns a vlue from arange of cells
• Mathematical-
  Performs mathematical calculations
• Date/Time
  Analyses date and time values
• Text
  Manipulates strings in formulas
• Information-determines the type of data stored in a cell
• Statistical
  Enables statistical analysis on a range of cells
• Financial
  Performs common business calculations
• Nested
  Uses the 'if' function

General

• Goal Seek
  Used when you know the desired result of a formula but not the input
• Array
  A single formula that performs a calculation on multiple inputs
• Styles
  A collection of formatting attributes
• Auditing
  Traces relationships between cells
• Mixed References
  Relative andabsolute cells
• Options
• Custom Lists
• Text Joining
• Formatting Numbers

Who Should Attend

The Microsoft Excel training course is aimed at sophisticated users who wish to exploit the full capabilities of their spreadsheet software.

Venue & Duration

This is a two-day course held at Smart Learning Solutions' Premises or on-site.