Understanding when and how to use advanced functions and arrays is an important step in mastering data analyzation in Excel. Discover the importance of multiple functions including logical and conditional functions, financial and statistical functions, and DateTime functions, as well as examine Arrays, in this overview of advanced functions and formulas.
Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.
This course is designed for students with a base knowledge of Excel and want to learn higher-level skills to display data and perform functions. Students should know how to perform calculations, modify worksheets, format worksheets, print workbooks and manage workbooks.
Meet the expert
Sondra Nelson is a Microsoft Certified Trainer and has been teaching Microsoft Office for over 15 years. She has teaching and consulting experience with high school students, college students and corporate employees.
Time to complete
Functions and Formulas
Logical and Conditional Functions (27:35)
Financial and Statistical Functions (19:29)
Date/Time and Arrays (13:11)