Microsoft Excel Intermediate Training - Excel Tutorial Class
Expand your Excel skills in this comprehensive 5-hour tutorial for intermediate users. Learn to utilize logical functions like IF, COUNTIF, and SUMIF, as well as lookup functions such as VLOOKUP, HLOOKUP, INDEX, and MATCH. Master advanced filtering techniques, custom date formats, and data manipulation tools. Explore new functions like UNIQUE, CONCAT, and XLOOKUP. Practice with downloadable exercise files to reinforce your learning. Discover how to improve spreadsheet readability, control data input, and add navigation buttons. Dive into topics such as nested IFs, error handling, sorting methods, and working with dates and times. Learn to import, clean, and format data efficiently. By the end of this tutorial, gain a solid foundation in Excel 2021/365, enhancing your ability to analyze and present data effectively.