Who is this training course suitable for?

Our Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.

Prerequisites

A working knowledge of Excel or our Excel Intermediate course.

Benefits

At the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications.

Course Syllabus

The course will cover a mixture of the following - dependant on the needs of the delegates

• Recording Macros
• Absolute/relative recording
• Where macros are stored
• Assigning macros to buttons
• Charts
• Selecting data
• Formatting your chart
• Advanced charts
• Combination charts
• Picture charts
• Custom chart types
• Regression and trendlines
• Lists
• Sorting lists
• Filtering lists
• Extracting subtotals
• The definition of a list
• Pivot tables
• Creating pivot tables
• Swapping rows, columns and pages
• Grouping fields
• Drill-down
• Multiple worksheets
• Copying, moving and renaming sheets
• The dangerous group mode
• Summing across worksheets
• 3-D range names
• Consolidation (*)
• Using formulae
• Using arrays
• Using data consolidation
• Using pivot tables
• Range names and absolute references
• Absolute references ($ symbol)
• Fixing only the row/column
• Creating range names
• Labelling ranges automatically
• The amazing 40% rule
• IF and LOOKUP functions
• The conditional (IF) function
• Nested IFs are evil
• Lookup tables
• The mysterious fourth lookup argument
• Number formatting
• Conditional number formats
• The four parts of a format
• Creating custom formats
• Formatting dates and times
• Styles (*)
• Creating formatting styles
• Using the style drop-down box
• The NORMAL style
• Validation and protection
• Setting cell validation
• Protecting cells/worksheets
• Cell comments
• Other techniques (*)
• Goal-seeking
• Creating scenarios

Next course - TBA

Course Duration: 1 day

Course cost: £120

Tags: excel, microsoft, office