The Microsoft Excel Function, Charts & More Online Course is about preparing and processing data to get information.  This course is about introducing you to a large number of functions in Excel that are commonplace in business and applying them to data to get business insights or results.  Then with those results, we look at protecting and presenting the results using tools such as conditional formatting, and chart dashboards. This course includes best practices and loads of shortcuts and tips to make using Excel actually enjoyable. 
 
The online course includes videos that you can watch and rewind to learn techniques, step-by-step instructions to follow, and loads of exercises and quizzes to reinforce your learning.  The course comes with a tutor who you can call, email or meet via MS Teams if you need that extra bit of support.
 
At the completion of the course, you will be issued with a Certificate of Completion.
 
Register and join us today!
 
Comprehensive coverage of:
statistical functions like COUNTA, and MODE
logical functions like IF, AND, OR, NOT, IFS and nested IF functions
lookup functions like VLOOKUP, LOOKUP, XLOOKUP, INDEX and MATCH
IFS functions including COUNTIFS, SUMIFS and AVERAGEIFS
text functions including PROPER, Ampersand and Text to Columns
date functions including TODAY, YEAR, MONTH and DAY
other functions including CELL and more
auditing features in Excel
protecting the cells, worksheet, workbook and file
conditional formatting
charts and dashboards
and more
 
This Online Course is ideal, if you struggle to find time to attend a course, and you want to learn in the privacy of your own home, during the hours that you find the most convenient. Learn at your own speed and in your own time and don't deal with the pressure of trying to learn in a group classroom setting. Your online classroom does not expire, so you can take your time and you have access to your own personal tutor via phone, email or MS Teams.