Current Status
Not Enrolled
Price
$150.00
Get Started
or

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 problems and streamline your workflow.

Curriculum

We’ll make you master the 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

Expand All
Module 1 -Introduction to Excel Formulas and Functions
Module 2 - Basic Functions
Module 3 - Logical and Lookup Functions
Module 4 - Date & Time Function
Module 5 - Advanced Functions
Module 6 - Financial Functions
Module 7 - Data Analysis Functions

Leave a Comment

$150

Excel for Analysts

$300

SQL for Data Analysis

$100

Data Entry for Analysts