Excel 2021: Advanced

In this course you will learn advanced features of Microsoft Excel such as advanced formula design which will include order of operations, conditional operators, and referencing other worksheets and workbooks. Learners will be introduced to common statistical tools that can be used to find the mean, median, and mode. The lessons will also cover conditional formatting, charts, creating pivot tables, and querying using the VLOOKUP function.