Online Microsoft Excel Advanced Training Course
Our one day Online Microsoft Excel Advanced training course will provide more advanced knowledge of the use and functions of Microsoft Excel.
Many of us need to use Microsoft Excel in our jobs to produce a range of spreadsheets to show a wide range of business data.
Our Microsoft Excel Advanced Training Course is designed to provide those that attend with slightly more advanced knowledge of how to use this very much used software.
Course Delivery Options
Online Course Details
We run our Microsoft Excel Advanced course as a virtual online training course. The course provides a practical toolkit and is delivered across one day. Despite being online, we try to keep these sessions as interactive as our classroom based courses.
Virtual Online Courses are delivered live by one of our trainers via our online conference system and form part of our online and virtual training service Skills Garage.
Here’s our current online Microsoft Excel Advanced training course schedule. To book, select a date below and click Book Now. We’ll send the details of how to connect to your course a few days before the course date.
3 + Delegates
9.30am to 4.00pm
Price per delegate. Includes delegate course materials.
You can see the full schedule of open courses that we deliver by clicking here.
Click a Tab, Get More Details
- 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
- 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
- Arranging workbooks
- Entering formulas across workbooks
- Linking information across workbooks
- Linking information across applications
- 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
- 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.