There are no items in your cart
Add More
Add More
Item Details | Price |
---|
INTRODUCTION TO EXCEL | 3 + Hours
star star star star star | 5.0 (13 ratings) |
Instructor: Sambhav Jain
Language: Hindi, English
Validity Period: 365 days
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.
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
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.
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? |