Excel - Advanced

Course Details

In this intensive 1 day course you will find the more useful advanced features. Though previous attendance at our intermediate course is assumed those with a comparable understanding are welcome to enrol. Please call a course administrator for clarification.

On our courses both keyboard and mouse skills are taught. All courses are instructor led and include comprehensive notes.

RECAP OF INTERMEDIATE

• Linking spreadsheets
• Consolidating data and using workbooks
• Database and sorting
• Word and graphic tools
• Absolute referencing

STYLES & ANNOTATIONS

• Using Autoformat
• Create, edit, use and merge styles

USING FORMULAS

• If, date and lookup tables
• What if analysis, Scenarios, Goal Seeking, Solver
• Tables

CHARTS

• Creating 2D and 3D charts
• Graphing isolated rows
• Creating overlay charts

REPORTS & VIEWS

• Using Report and View Managers

DATABASE

• Sorting and querying
• Database statistical functions
• Using the Pivot table wizard

DATA ANALYSIS

• Solving “What if” problems
• Scenario Manager
• Goal seeking and solver

MACROS

• Macro recording and running
• Automatic executing macros
• Assign macros to buttons and graphic objects

MISCELLANEOUS & TIPS

• Exchanging data with other documents
• Setting up a workspace
• Specifying startup directory
• Create and use document templates
• Protecting Data

Venue

TBA

Dates