Excel Advanced
Join Linda Muchow for a 3-hour live virtual Excel Advanced Course! This is a hands-on course to introduce you to using Lookup Functions with a Table and referencing data from another worksheet, combining (nesting) functions such as IF and AND, and utilizing SUMIFS functions and much more!
Description
This course will introduce you to using Lookup functions with a Table and referencing data from another worksheet, combining (nesting) functions such IF and AND, and utilizing SUMIFS functions. We will utilize named ranges in functions and formulas, and discuss how to use Data Validation to create dynamic dropdown menus. We will create custom number formats and explore how Macros can help automate your work.