About This Class This course is part 1 & 2 of a 9-part series on Excel Formulas & Functions: from basic to advanced. In Excel Formulas 101, we'll explore Excel's formula library and auditing tools, practice basic formula syntax, and learn the importance of fixed, relative, and mixed reference types. From there we'll dive into common errors, helpful PC & Mac shortcuts, and more. This will give you the tools you need to cruise through the rest of the series and emerge a certified Excel ninja. About the Excel Formulas & Functions Series: In this series, you will develop tools to transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Courses cover 75+ formulas, and feature hands-on, contextual demos and practice exercises designed to help you not only memorize formula syntax, but to think like Excel. You'll learn how to write complex, powerful functions from scratch, allowing you to: If you're looking for the ONE series covering all of the advanced formulas and functions that you need to become an absolute Excel rock star, you've found it!
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.