Aurora Training Advantage Webinar

Excel Formulas and Functions

Although it is perfectly possible to use Excel without ever creating a formula or using a function, if you don’t, you’re missing out on a huge part of the application’s power. In this 90-minute session, with the help of real-world examples, you’ll learn about some of Excel’s most important and most useful functions that will save you time, reduce errors and help you to construct powerful spreadsheets.

Amongst the topics covered are:

• The difference between formulas and functions
• More than one way to do a LOOKUP
• Using functions to manipulate text
• Using the IF function to automate data entry
• Using functions to manipulate date and time entries
• Creating complex functions and breaking them apart

Guest Speaker


Mike Thomas

Mike Thomas has worked in the IT training business for 26 years. His expertise and experience covers designing and delivering training courses, creating written training materials (Quick Reference Guides and step-by-step tutorials), recording and editing video-based tutorials and providing support to users. He is a subject matter expert in a range of Microsoft technologies including Microsoft Office, Lync/Skype for Business and SharePoint. He has extensive experience of working with Cloud-based collaboration tools such as Box and OneDrive and has worked…View Full Profile

CPE Credit

Level: BasicFormat: Live WebcastField of Study: Computer Software and Applications (2 hours)Program Prerequisites: NoneAdvanced Preparation: NoneAurora Training Advantage is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:www.learningmarket.orgFor more information regarding administrative policies such as complaint and refund, and cancellation please contact our offices at