Free Online Training: Macros and Advanced Queries in Excel 2016

macros-and-advanced-queries

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

 

Comments

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

Member Login

Business Insights & Tips

Leaderboard

1
Jill Holtz
969 Points
2
Michael Lane
799 Points
3
Ron Immink
732 Points
4
Fionan Murray
709 Points
5
ContentLive
310 Points
View Leaderboard