In this step-by-step Microsoft Excel tutorial taught by a former Microsoft Product Manager, you'll get a hands-on walkthrough of the most common formulas and functions used by Excel power users. This video is perfect for beginners who are brand new to formulas and functions, as well as more advanced users who are still likely to pick up a few new tricks. The course includes an additional interactive Excel workbook. It opens with a survey of basic functions and references (including both absolute references as well as referencing cells on other sheets), as well as the fundamentals of using them. From there, it expands to cover over two dozen of Excel's most useful functions.
Learning Objectives
Upon completion of this course, participants will be able to:
Create and edit formulas in Excel
Reference cells via absolute references as well as cells on other sheets
Use fundamental Excel formulas and functions, including logical functions
Understand XLookup and VLookup