MS50449: Useful Excel Formulas and Functions

Course Information

Course Name

MS50449: Useful Excel Formulas and Functions

Duration

1 Day

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

This course is intended for users of Microsoft Office Excel who want to learn about useful formulas and functions.

 Prerequisites

Before attending this course, students should have experience:

• A basic working knowledge of Microsoft Office Excel.

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

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

All Microsoft certification courses are conducted by certified trainers from Iverson.

Digital Methods acts as the official training partner and assists with program consultation, registration, coordination, scheduling, and administrative arrangements to ensure a seamless and professionally managed training experience.