Home

/

Courses

/MS Excel - Zero to Hero - For Beginners
Course | {{title}}

MS Excel - Zero to Hero - For Beginners

CA Alok Sethi

3 modules

English

Lifetime access

<p>Customised course for Beginners to enable them to get familiar with the functions and formulas of MS Excel and to get an insight into how to use Excel for getting productive results at work !</p>

Overview

In this beginner-friendly course, you will go from being a complete novice to a proficient Excel user, mastering essential skills and functionalities along the way. Whether you have never opened Excel before or have only a basic understanding of the program, this course will build your expertise from zero to hero. You will start by familiarizing yourself with the Excel interface and learn how to navigate workbooks efficiently. Step-by-step guidance will help you grasp the core concepts of data entry, basic formulas, and formatting techniques. Through hands-on practice sessions and real-world examples, you will gain confidence in using functions, creating charts, and analyzing data effectively. As you progress, you will delve into more advanced features such as conditional formatting, pivot tables, and data validation. These tools will enable you to organize and visualize data in a meaningful way, making your Excel projects more professional and insightful. By the end of the course, you will have the skills to automate tasks using macros and optimize your workflow with time-saving tips and tricks. With a focus on practical applications and problem-solving, this course equips you with the knowledge and confidence to tackle Excel tasks with ease. Whether you are a student, professional, or simply looking to enhance your spreadsheet skills, "MS Excel - Zero to Hero - For Beginners" will empower you to unleash the full potential of Excel and elevate your productivity to new heights.

Modules

Introduction to Excel - Day1

5 attachments • 1 hrs

Introduction to Excel Interface and Terminologies

Excel Shortcut Keys - Excel Vibez

Excel Literate - Day1: Terminology

Excel - Different Approach !! || CA Alok A Sethi

Office 365 on One Drive !!

Cell Referencing & Freezing

2 attachments • 1 hrs

Cell Freezing and Referencing - Excel Vibez

video1594280187

Mathematical & Statistical Functions

27 attachments • 28.16 mins

SUM, SUMIF, SUMIFS, SUBTOTAL - ExcelVibez

video1225964084

SUM, SUMIF, SUMIFS, SUBTOTAL, COUNT, COUNTIF, COUNTIFS - Case Studies

Mathematical & Statistical Functions - Case Study

Grades-Merit-performance-ExcelVibez

Mathematical Functions with Drop Down List

SUM IF FUNCTIONS -2

Sum Function

Automize Calculations using Dynamic Functions

IF Function - Case Study - Students Result

Drop Down Functions in Excel

Katrisa Excel Session

Katrisha Excel Session - 15th Jun 24

Katrisa Excel Session - 16th Jun 24

Katrisha Excel Session - 16th Jun 24

Katrisa Excel Session - 19th Jun 24

Katrisha Excel Session - 20th Jun 24

Katrisha - 21Jun24

Katrisha - 22-6-24

Katrisha - 26-6-24

Katrisha - 27 jun 24

Katrisha - 28th jun 24

Katrisha - 30-6-24

Katrisha - 1 July 24

Katrisha - 2 july 24

Katrisha - 3th july 24

Katrisha - 4-7-24

About the creator

About the creator

CA Alok Sethi

A result oriented professional, 10+ years overall experience in Corporate Training and Development. Possessing exceptional team building skills for increasing a company's productivity by imparting new skills and upskilling employees/students. I conduct seminars, lectures, webinars and workshops on Academic, Technical, Financial & Soft Skills  to update employees/students on company goals and procedures and help them upskill themselves to make them more efficient and effective.

 

Rate this Course

Free

×

Order ID:

This course is in your library

What are you waiting for? It’s time to start learning!

Illustration | Payment success

Share this course

https://undefined/courses/MS-Excel---Zero-to-Hero----For-Beginners--63d74875e4b0130df0b1ccb8-63d74875e4b0130df0b1ccb8

or

×

Wait up!

We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?

Illustration | Already enrolled in course