Online Microsoft Excel Advanced Training Course

• Basic PC knowledge is required and a basic understanding of your operating system (Windows or MacOS)
• The software installed on your PC
• Access to Zoom via the Zoom app or your browser

Those who attend this Microsoft Excel Advanced Training Course will be able to:

• Create sophisticated spreadsheets that include complex functions
• Use analysis tools to summarise and extract data
• Use pivot tables, scenarios and database functions and auditing tools
• Use macros to automate tasks

Formulas and Functions

• Date and time functions
• Math and trig functions
• Logical functions
• Statistical functions
• Look up and reference functions
• Text functions
• Financial functions
• Data tables
• Information functions

Formula Auditing

• Cell comments
• Formula error checking
• Using the watch window
• Copy and paste special

What-IF Analysis Tools

• Creating, editing and deleting scenarios
• Scenario summary reports
• Using goal seek
• Using solver

Multiple Workbooks

• Arranging workbooks
• Entering formulas across workbooks
• Linking information across workbooks
• Linking information across applications

Advanced Lists

• Advanced filters
• Database functions
• Grouping and outlining
• Data validation
• Go To Special

Introducing Pivot Tables

• Creating a pivot table
• Extracting data from a pivot table
• Pivot calculations
• Sorting, grouping and filtering pivot data
• Pivot chart reports

Templates and Views

• Designing and saving templates
• Creating and using custom views

Charts

• Amending chart values
• 3-D Charts
• Creating projections with trend lines
• Creating combination charts
• Custom chart templates

Automation and Macros

• Recording and running macros
• Deleting macros
• Editing macros
• Macro virus protection

We can deliver this Microsoft Excel Advanced training course as an in-house virtual course for your business.

What is a Virtual Training Course you may ask? Rather than have our trainer travel to you to deliver a course, our trainer will join you via our conference system to deliver the course.

It means you can get your team together where ever they are based. You can get the team together in the same room. Or, have individuals join from where they are based.

Our Virtual Training Courses are normally one day in length and we deliver them in all subjects that are available on our site.

Because there is no travel involved, they are very cost-effective and good for the environment too.

We’ve made sure that you don’t lose any of the benefits of having a trainer with you in the room. Our Virtual Training Courses are still interactive, come with training materials and also include exercises, case studies and discussions.

To find out more about having an in-house virtual Microsoft Excel Advanced training course delivered for your business, fill in the form below and we’ll get back to you.  Be sure to tell us what course you are looking for.  Alternatively you can call us on 015549779.

The reviews below are submitted by past delegates. If you would like to see more then please get in touch. We can pull together some feedback from our evaluation forms to help you make a more informed decision about this course.

Download a copy of the Online Microsoft Excel Advanced course overview by clicking here.