SP905 - Excel Formulas and Functions

Course Description

This course concentrates on Excel functions and formulas. Look at commonly used text and data functions, including changing the case of text, combining text cell contents (e.g., first and last names), and comparing cell contents. Work with date and time functions and logical functions. Other topics will include using simple form fields to select items from a list (note that this will not cover creation of custom forms, as that requires VBA), using the formula editing toolbar to check your data and solve formula errors, and working with arrays.

By the end of this course, you will be able to: 

• Creating and using Mega Formulas 

• Working with Text functions 

• Working with Date and Time functions 

• Using Information functions 

• Alternate uses of Statistic functions 

• Using Lookup and Reference functions 

• Using a Form Control to select lookup values 

• Exploring Array formulas and constants 

Applies Towards the Following Certificates

• Excel Certificate : Excel Power User
• Excel Power User : Required Courses