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 100-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
Among 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
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 ... View Full Profile
Aurora 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.nasbaregistry.org.
For more information regarding administrative policies such as complaint and refund, and cancellation please contact our offices at 407-542-4317 or email@example.com.