Free Online Training: Macros and Advanced Queries in Excel 2016


Would you like to speed up your data processing on Excel? Have you ever used macros? Then this might be of interest: we have a free online training course called Macros and Advanced Queries in Excel 2016 available for Business Achievers members.

Join our Business Achievers community and get access to downloads to help your business, free online training courses and network with members to help grow your business. 

About the Training Course

Using macros in Excel 2016 lets you save time when performing repetitive tasks. This course covers the options available when you are running macros, and also how to create your own custom macros. You will also learn about advanced functions that allow you to perform calculations using date and time, how to look up data, and how to perform advanced conditional queries.

Who the Course is For

End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

What the Course Covers

It takes just over an hour to go through and the course covers:

- configuring macro security settings 
- running a macro
- recording simple and custom macros
- using functions such as NOW, TODAY, DATE functions 
- using TRANSPOSE to alter a worksheet
- looking up data using the VLOOKUP and HLOOKUP functions
- using the IF function with other functions 
- performing advanced queries

To access this free online training course click here



No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Wednesday, 11 December 2019
If you'd like to register, please fill in the username, password and name fields.

Member Login

Business Insights & Tips


Jill Holtz
2343 Points
Tena Glaser
1395 Points
Michael Lane
802 Points
Ron Immink
732 Points
Fionan Murray
721 Points
View Leaderboard