You will also learn intermediate and advanced techniques such as how to find a value with VLOOKUP, create and format PivotTables, record basic Macros and more. In 49 engaging lessons you will learn basic techniques including how to use math, statistical, logic and text functions, organize data by sorting and filtering, effectively present your data in several chart formats and more. Looking for an Excel course for beginners to experts? This online course has something for everyone, covering beginner, intermediate and advanced lessons in Excel for Mac.