Cart 0
Training
Course Information
Course Name
MS50449: Useful Excel Formulas and Functions
Duration
1 Day
Overview
Audience Profile
Prerequisities
At Course Completion
Course Outline
Overview
This 1-day course provides students with the knowledge and skills to the usage of useful formulas and functions in Microsoft Excel.
Overview
Overview
This 1-day course provides students with the knowledge and skills to the usage of useful formulas and functions in Microsoft Excel.
Audience Profile
Audience Profile
This course is intended for users of Microsoft Office Excel who want to learn about useful formulas and functions.
Prerequisities
Prerequisites
Before attending this course, students should have experience:
- A basic working knowledge of Microsoft Office Excel.
At Course Completion
At Course Completion
After completing this course, you will be able to:
- Apply Formula and Functions Basic
- Statistical and Logical Functions
- Lookup and Reference Formulas
- Text Formulas
- Date and Time Formulas
- Array and Database Functions
- Efficiency Tips
Course Outline
Course Outline
Module 1: Making Data Work For You
Module 2: Statistical and Logical Functions
Module 3: Lookup and Reference Formulas
Module 4: Text Formulas
Module 5: Date and Time Formulas
Module 6: Array and Database Functions
Module 7: Efficiency Tips
