Introduction to Excel cover

Introduction to Excel

INTRODUCTION TO EXCEL

star star star star star_half 4.6 (6 ratings)

Instructor: Rishabh Jain

Language: Hindi, English

Validity Period: 365 days

₹1299

Click here to download EMI Moratorium Calculator

Watch Demo Video:

 


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, analysing 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 include

  • 18 Modules.
  • Practice Excel Sheets.
  • Completion Certificate.
  • In simplified language for easy understandability.

Functions where Excel can help you?

  • Attendance Management
  • Payroll Processing
  • Project Management
  • Accounts 
  • Charting 
  • Financial Planning 
  • MIS reports 
  • Assignments 
  • DataBase
  • CRM 
  • Phone 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.

Detailed Course Structure-

The whole course is divided into 5 different categories consisting of total 17 modules. Each module will cover the detailed understanding and learning in an easy and understandable way.

Topic # Subtopic What will be covered
Intro 1 Introduction Why excel? 
Formatting  2 Text formatting Font, alignment, table making, spell check, line removal
3 Sheet formatting  Insert, delete rows column, cell format
4 Conditional formatting High to low, low to high, threashold, 3 split
5 Sort filter and find Sort method - range, equal to color
Computation  6 Basic arithmetic functions What is a formula ,addition, subtraction, multiplication, division, count 
7 Cell referencing, dragging   Floating, fixed, row/column floating, across sheets 
8 Logical statement IF, and, or, nested ifs
9 Advance arithmetic functions Sumif and countif 
10 Special functions  Round, days related functions
Data presentation  11 Charts 1 Bar chart, line chart
12 Charts 2 Pie chart, scatter chart
13 Pivot table 1 Why do we need pivot table
14 Pivot table 2 How to make piviot table
Data consolidation  15 Advance copy-pasting Format, formula, coulmn width, value
16 Data tools 1 Duplicate removal
17 Data tools 2 Text to coulmn
18 Vlookup Why do we need Vlookup, how to use it?

 

 

 

Reviews
4.6
star star star star star_half
people 6 total
5
 
4
4
 
2
3
 
0
2
 
0
1
 
0
Other Courses