Advanced Microsoft Excel

For those of us who are experienced and compentent users of Excel, but find the knowledge we currently have is not sufficient to overcome some aspects that are still a challenge for us. Our Advanced Microsoft Excel training course will give you the knowledge and the skills to work with data analysis on a more complex level.
On this course you will navigate the more advanced nested functions and capabilities of Microsoft Excel. You will learn how to analyse and extract more complex data information, apply advanced calculations and formatting and create simple coding.
The course will give you hands on experience via structured exercises during the session and will give you the opportunity to practice the skills you have learned. This course is the ideal stepping stone for our VBA Programming Microsoft Excel course.
To get the most out of this course some experience of creating and using spreadsheets is recommended and ideally you should be comfortable with the Microsoft Windows environment.

Course Duration

2 Days

Course Content

Download Course Content PDF

  • 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 Full Course Schedule PDF

Ask a question

I consent to having this website store my submitted information so they can respond to my inquiry. See our privacy policy to learn more how we use data.
 

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