Conquer some of the most daunting features in Microsoft Excel: formulas and functions. In this Excel for Mac 2016 update to his popular series, author Dennis Taylor presents numerous formulas and functions in Excel and shows how to use them efficiently. The course begins with tips and keyboard shortcuts to accelerate the way you work with formulas within one or multiple worksheets. Dennis then covers how to perform logical tests with the IF, AND, OR, and NOT functions; search and retrieve data with lookup functions (VLOOKUP, MATCH, and INDEX); analyze data with statistical functions; use text functions to clean up worksheets; work with array formulas and functions, and master date and time calculations. Dennis focuses on practical examples that transition effortlessly to real-world scenarios. Start watching to take advantage of the tremendous power offered by Excel formulas and functions.
Learn More- Career Communities
- Identity Resources
- Career Planning
- Access Career Tools
- Build Skills at Denison Edge
- Build Your Resume and Cover Letter
- Search for an Internship or Job
- Network with Confidence
- Leverage Winter Break
- Participate in the Denison Internship Program
- Prepare for an Interview
- Plan for Graduate School
- Research Industries and Companies
- Utilize Financial Resources
- Alumni
- Academic Partnerships
- Meet The Team
- Student Employment