Introduction To Excel

This course is best suited for beginners who want to learn Excel from scratch

What you'll learn

Ms Excel

Basics of Excel

Conditional Formatting and Cell Referencing

Excel Formulas/Calculations, data consolidation and V lookup

Requirements

This course is good for anyone who wants to learn Excel from scratch!

Description

MS-Excel contains more functions and features than any other spreadsheet software. It's capable of handling larger spreadsheets. At a basic level, it is used for storing information, analyzing and sorting, and reporting. It’s extremely popular in business because spreadsheets are highly visual and fairly easy to use.Some of the most common business uses of MS Excel are for business analysis, managing human resources, performance reporting, and operations management.Why this Course?This course will help you in building your excel skills from scratch. It will foster your fundamental knowledge for Excel that will help you in core managerial functions. This course will help you in digitization and easy maintenance of your data that will ultimately build your overall working efficiency and command. This course will explain each and every basic features and facility of excel that will help you in understanding this software logically. Excel helps us in making our routines processes simple and convenient. This course will include18 Modules.Practice Excel Sheets.In simplified language for easy understandability.Functions where Excel can help you?Attendance ManagementPayroll ProcessingProject ManagementAccountsChartingFinancial PlanningMIS reportsAssignmentsData BaseCRMPhone Book.Who is your Trainer?Trainer for this course in Mr. Sambhav Jain. He is an Excel expert and an IIT Mumbai Alumni and currently working as a Management Consultant. He is also a co-founder of channel Labour Law Advisor. He is also an Active Investment Consultant.

Overview

Section 1: Introduction

Lecture 1 Lecture 1 : Introduction

Lecture 2 Lecture 2 : Text editing

Lecture 3 Lecture 3 : Sheet Formatting

Lecture 4 Lecture 4 : Condition Formatting

Lecture 5 Lecture 5 : Sort & Filter

Lecture 6 Lecture 6 : Basic Calculations

Lecture 7 Lecture 7 : Cell Referencing

Lecture 8 Lecture 8 : Logical Reasoning

Lecture 9 Lecture 9 : Logical statements

Lecture 10 Lecture 10 : Calculations

Lecture 11 Lecture 11 : Data visualization & summarization

Lecture 12 Lecture 12 : Data visualization & summarization (Detailed analysis)

Lecture 13 Lecture 13 : Data summarization (Detailed analysis)

Lecture 14 Lecture 14 : Pivot tables (Detailed analysis)

Lecture 15 Lecture 15: Data Consolidation

Lecture 16 Lecture 16 : Data consolidation Part 2

Lecture 17 Lecture 17 : Data consolidation Part 3

Lecture 18 Lecture 18 : V Lookup

Students,Beginners in Business,Beginners in Professional Field