Excel

Level 3: Advanced

Master Excel Like a Pro!

  • Do you find yourself spending a lot of time manually performing repetitive tasks in Excel?
  • Have you ever encountered errors in your Excel formulas and struggled to identify and fix them?
  • Do you need to create complex reports or presentations using Excel data?
  • Do you work with multiple Excel workbooks and struggle to keep them organized and linked?
  • Do you need to automate certain tasks or processes in Excel to save time and increase efficiency?
  • Do you need to collaborate with others on Excel workbooks and want to learn how to use Excel Online?
  • Do you need to create and share forms to collect data in Excel?
  • Do you want to learn how to use advanced data analysis tools in Excel to gain insights and make better decisions?
  • Do you want to improve your overall proficiency in Excel and learn advanced features and techniques to enhance your productivity?

If so, then the Excel Level 3: Advanced course will help you.

MORE DETAILSDOWNLOAD BROCHURE

AT A GLANCE

Audience

This workshop is intended to help all users get up to speed quickly on the advanced features of Excel. We will cover using the new functions in Excel, worksheet Automation, auditing and error checking, data analysis and BI, working with PivotTables and Visual Basic.

Format ​

  • 1 x 1-day, instructor-led online sessions
  • Public workshops are available for all our Excel courses.

What’s Included

  • Comprehensive Learning Guide and Resource Manual
  • Subscription to our monthly LearningLink e-newsletter

Master Excel's advanced tools for data mastery and automation

Learn how to master a wide range of advanced Excel skills that enable more efficient and powerful data analysis and workbook automation.

This course will help you:

  • Use the new features in MS Excel
  • Create Dashboards using Camera Tool.
  • Understand and use new Functions in Excel
  • Create Tables, use PivotTable, PivotCharts & Slicers.
  • Use PowerPivot to analyse large data sets
  • Understand Data analysis and Business intelligence features in Excel
  • Use advanced Data Analysis functions in DAX
  • Automate some Tasks using Macros/VBA
FULL OUTLINEMake an enquiry

What You Will Learn

Advanced Excel Usage

Gain proficiency in using Excel Online, automating worksheets, auditing and error checking, data analysis, working with multiple workbooks, and exporting and sourcing data.

Efficiency and Automation

Learn to automate tasks, manage workbook properties, use advanced formula auditing tools, and analyse data effectively using advanced Excel features.

Data Analysis

Master the art of analyzing data using PivotTables and Pivot Charts.

Advanced Data Handling

Acquire skills in consolidating data from multiple sources, creating and maintaining links between workbooks, and utilising different data sources for analysis and reporting.

Detailed Synopsis

This Microsoft Excel advanced course will extend your knowledge into some of the more specialized and advanced capabilities of Excel by using the data analysis and business intelligence features. You will learn how to use the newer functions and features including PivotTables and Power Pivots for analysis of large data sets. Using Get and Transform functions are always popular sections on the course, as well as a first look at creating Macros using the powerful point and click features available in Microsoft Excel.

Unit 1 What’s new in Excel

  • Named Ranges, Copy&paste options,Camera Tool, Notes,Comments
  • Creating a MS Excel Dashboard, KPI example
  • Using Quick Analysis, Summations, Data bars, Rules, Charts, Tables

Unit 2 New functions in Excel

  • New functions in Excel – Ifs, Switch, MaxIfs, MinIfs, Countifs, SumIfs, Iferror
  • Excel functions – TextJoin, Concat, vLookup / xlookup examples

Unit 3 Analysing Data using PivotTables

  • Changing the layout and format of the PivotTable
  • Calculations and analysis in Pivot Tables
  • Using Slicers to filter the PivotTable data
  • Using Pivot Charts

Unit 4 Data Analysis and BI

  • Introduction to Power Pivot
  • Using the Power Pivot for Business Analysis and reporting
  • Using Get and Transform
  • Power Query and data models
  • Power Maps
  • Business Intelligence, DAX for Business Analysis and reporting

Unit 5 Visual Basic for Applications

  • Visual Basic Editor
  • Recording macros
  • Creating user functions using Visual Basic for Applications
  • Lambda Functions
DOWNLOAD BROCHUREMake enquiry