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
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
- Financial Planning
- MIS reports
- 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|
|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?|
|Lecture 1 : Introduction|
|Lecture 2 : Text Editing|
|Lecture 3 : Sheet Formatting|
|Lecture 4 : Condition Formatting|
|Lecture 5 : Sort & Filter|
|Lecture 6 : Basic Calculations|
|Lecture 7 : Cell Referencing|
|Lecture 8 : Logical Reasoning|
|Lecture 9 : Logical statements|
|Homework Lec 9|
|Lecture 10 : Calculations|
|Lecture 11 : Data visualization & summarization|
|Lecture 12 : Data visualization & summarization (Detailed analysis)|
|Lec 12 homework|
|Lecture 13 : Data summarization (Detailed analysis)|
|Lec 13 homework|
|Lecture 14 : Pivot tables (Detailed analysis)|
|Lecture 15: Data Consolidation|
|Lecture 16 : Data consolidation PART 2|
|Lecture 17 : Data consolidation PART 3|
|Lecture 18 : V Lookup|
|Lec 18 homework|
|FINAL ASSESSMENT TEST|
After successful purchase, this item would be added to your courses.
You can access your courses in the following ways :
- From Computer, you can access your courses after successful login
- For other devices, you can access your library using this web app through browser of your device.