Current Status

Not Enrolled

Price

$150.00

Get Started

COURSE INTRODUCTION

Excel is a powerful tool for data analysis, reporting, and decision-making. Understanding how to use functions and formulas effectively can significantly enhance your productivity and efficiency in Excel.

In this course, you will learn the fundamental Excel functions and formulas that are essential for everyday data manipulation and analysis tasks. Whether you’re a beginner looking to build a solid foundation in Excel or an experienced user aiming to enhance your skills, this course will provide you with practical knowledge and hands-on exercises to help you excel in your Excel endeavors.

Throughout the course, you will explore a wide range of functions and formulas, including mathematical and statistical functions, text and logical functions, date and time functions, lookup and reference functions, and more. By the end of the course, you will be equipped with the knowledge and confidence to leverage Excel’s functions and formulas to solve real-world business problems and streamline your workflow.

Curriculum

We’ll make you master the use of Microsoft Excel Functions and Formulas and hand hold you through the journey to ensure you have a full grasp of what the tool is all about and the various use cases. This course uses multiple datasets which can be downloaded from the course materials tab.

Course Overview

This is a Virtual Instructor-Led Training in recorded classes. You’ll have 1year access to the class from the day of enrollment. You’ll have to repurchase the course to gain access after 1 year.

Delivery Mode

Hands-on virtual classes

Prerequisites

You need a laptop to get the most out of this training

What You’ll Learn

  • Mathematics Functions
  • Statistical Functions
  • Text Functions
  • Date & Time Functions
  • Logical Functions
  • Lookup & Reference Functions
  • Financial Functions
  • Data Analysis Functions
  • Information Functions

Course Content

Module 1 -Introduction to Excel Formulas and Functions
Welcome to the Course
Understanding Excel Formulas & Functions 3 Topics
Excel Functions Basics 3 Topics
Module 2 - Basic Functions
Mathematical Functions 3 Topics
Text Functions with Use Case and Examples 1 Topic
Module 3 - Logical and Lookup Functions
Logical Functions 1 Topic
Lesson Content
0% Complete 0/1 Steps
Lookup Functions 1 Topic
Lesson Content
0% Complete 0/1 Steps
Module 4 - Date & Time Function
Date Function 1 Topic
Lesson Content
0% Complete 0/1 Steps
Time Functions 2 Topics
Lesson Content
0% Complete 0/2 Steps
Module 5 - Advanced Functions
Array Functions 2 Topics
Statistical Functions 3 Topics
Module 6 - Financial Functions
Common Financial Functions 3 Topics
Lesson Content
0% Complete 0/3 Steps
Module 7 - Data Analysis Functions
Data Summarization 2 Topics
Lesson Content
0% Complete 0/2 Steps
Data Manipulation 3 Topics

Leave a Reply

Your email address will not be published. Required fields are marked *