Advanced Microsoft Excel

Course Objectives

A comprehensive tour around the abilities of Microsoft Excel. Calculations; Worksheet auditing; Lists of data; Forms; Charts; Pivot Tables; Macros.

Prerequisites

Some experience in using/creating spreadsheets would be beneficial.

Course Duration

2 days

Course Content

  • Functions
    • Statistical Functions
    • Math & Trig Functions
    • Text Functions
    • Logical Functions
    • Table Lookup Functions
  • Handling Worksheets
    • Conditional Formatting
    • Data Validation
    • Worksheet and Formula Auditing
    • Formula Evaluator / Error Checker
    • Using Views and Scenarios
  • Using Lists
    • Sorting on Multiple Columns
    • Sorting with Custom Lists
    • Advanced Filter
    • Database Functions
  • Data Entry Forms
    • Drawing the Controls
    • Formatting the Controls
    • Features Available
  • Charting
    • Revision of Basic Features
    • Understanding Series and Categories
    • Adding Data to a Chart
    • Types of Chart:
    … Column / Line / Pie / Bar
    … Area / Scatter / Stock / Doughnut
    … Radar / Surface / Bubble
  • Summarising a List
    • Sub-totalling Data
    • Creating a Pivot Table
    • Modifying a Pivot Table
    • Using Slicers
    • Creating a Pivot Chart
  • Other Features
    • Date and Time Functions
    • Information Functions
    • Absolute, Relative & Mixed References
    • Formulas between Worksheets and Workbooks
    • Protecting the Workbook
  • More about Lists
    • Text to Columns Wizard
    • Removing Duplicates
    • Comparing Lists
    • Converting a List into a Table
  • Simple Macros
    • Recording a Macro
    • Running a Macro
    • Editing a Macro
  • Customising Excel
    • Setting Options
    • Custom Number Formatting
    • Templates

Download Course Content PDF

Acrobat-PDF

Download Full Course Schedule PDF

Acrobat-PDF

Ask a question

Please contact us to make a booking or book now on-line.

All courses are available for both scheduled (open) and dedicated (bespoke) delivery. Please contact us for details and pricing.

If you can’t see the course you are looking for – contact info@base2.co.uk