Back to all courses

Microsoft Excel Advanced

This course introduces features to Automate tasks with macros; unleash the power of PivotTables and PivotCharts; troubleshoot complex formulas; and more. The aim of the course is to allow you to explore further formula options and display your data in charts for quick visual analysis. You will also learn how to work and manage lists of data.

Save to my Shortlist Save to shortlist Share Share

Certification:

College Certificated

Duration:

  • One day trainer-led or virtual
Enquire now

Who is this course for?

This course is for those seeking to improve their skills with Microsoft Excel.

What qualifications will I gain?

Fife College Certificate of Attendance

What will I learn on the course?

You will complete the following outcomes:
  • Pivot Tables and Charts;
  • Troubleshoot Formulas;
  • Advanced Formatting;
  • Advanced Formulas;
  • Data Analysis Tools;
  • Macro Recording

Pivot Tables and Charts

  • Create Pivot Tables
  • Add data fields
  • Add calculated fields
  • Change Calculation type
  • Format Pivot Tables
  • Refresh Pivot tables
  • Slicers and Timelines
  • Create Pivot Charts
  • Pivot Chart styles
  • Filter Pivot data & Charts
  • GETPIVOTDATA function

Troubleshoot Formulas

  • Handling errors
  • The Watch Window
  • Evaluate Formula tool

Advanced Formatting

  • Customise Conditional Formatting
  • Using Formulas in Conditional Formatting
  • Managing Conditional Formatting
  • Custom Themes
  • Form Controls (Developer Tab)

Advanced Formulas

  • Nested Functions
  • LOGICAL Functions (IFS, AND, OR)
  • SUMIF. AVERAGEIF, COUNTIF
  • TEXT functions (TEXTSPLIT, CONCATENATE)

Data Analysis Tools

  • Goal Seek
  • Scenario Manager
  • Consolidate Data

Macros

  • Macro Overview
  • Recording a Macro
  • Macro Settings and File types
  • Run Macros

Application Information

What further course options are available?

  • Introduction to Excel VBA
  • Introduction to Power BI Desktop

How will this help my career?

This course enhances your proficiency within Microsoft Excel, which you can take back into your workplace activities to improve productivity.

Related courses

View all courses