About Course
A Compulsion Course for Financial, MIS, Data Analysis, Tax Professional, Auditors & Business Management sectors, Medical Coding, Data Entry, Hospital Management and everyone in every field
What Will You Learn?
- MS Excel Basics
- MS Excel Advanced
- MS Excel Dashboards
- Chats, Pivot Tables and many more
- *You will earn a Certificate of Completion with QR Code, Sharable Link, Downloads in PDF, JPEG
Course Content
S1. Free Sample Videos
S2. Course Tips, Download Materials and Practice Notes
-
Download Course Materials
00:00
E1. MS Excel – Start-up
-
E1.1 How to Open MS Excel
03:06 -
E1.2 Start Screen – Navigating MS Excel
04:28 -
E1.3 User Interface – Navigating MS Excel
08:04 -
11:25
-
11:46
E2. MS Excel – Basic Tools to know
-
E2.1 Customize Ribbon Bar – Tabs, Groups, Commands I Tools
04:55 -
E2.2 Text to Column – Multiple methods
07:25 -
E2.3 Speak Cells – Data Reading Tool
04:00 -
E2.4 Comments – Add, Edit, Delete and Customize
08:23 -
E2.5 Filters in MS Excel
04:24 -
E2.6 Freeze Panes and Split Screen
04:41
E3. MS Excel – Fill Series and Data, Sheet Controls
-
E3.1 Fill Series – Basics
03:27 -
E3.2 Fill Series – Advanced
07:36 -
E3.3 Fill Series – Flash Fill
05:26 -
E3.4 Conditional Formatting
04:09 -
E3.5 Hyperlinks to Sheets, Webpages, Files
09:00 -
E3.6 Header and Footer Settings
08:26 -
E3.7 Printing and Paper Settings
05:49 -
E3.8 Import data from web
05:47 -
E3.9 Import data from text document with auto refresh
03:08 -
E3.10 Import-text word ppt jpeg video- pdf & more objects
08:03
E4. MS Excel – Working with Sheets
-
E4.1 Characteristics of a cell
01:45 -
E4.2 References – Relative Ref, Absolute Ref, Mixed Ref Cell
13:58 -
E4.3 Custom View
04:02 -
E4.4 Sheet protection
05:37 -
E4.5 Cell Protection
04:49 -
E4.6 Compare sheets side by side I View Sheets side by side
05:15 -
E4.7 Compare sheets from Multiple Files
02:38 -
E4.8 Working with cells, rows, columns, Specific Size, Auto Fit
09:27 -
E4.9 Working with sheets rename, colour, copy, move, grouping
07:08
E5. SUM related formulas
-
E5.1 Things to remember before starting formulas
09:41 -
E5.2 SUM
08:51 -
E5.3 SUMIF
05:51 -
E5.4 SUMIFS
08:43 -
E5.5 SUBTOTAL
04:43 -
E5.6 AGGREGATE
03:07 -
E5.7 SUMPRODUCT
03:53 -
E5.8 SUMSQ
03:25 -
E5.9 SUMX2MY2, SUMX2PY2, SUMXMY2 I Maths and Trigonometry
08:06 -
E5.10 DSUM – DATABSE SUM
04:06 -
E5.11 IMSUM vs IMSUB – Complex Data Calculations
03:31
E6. AVERAGE related formulas
-
E6.1 AVERAGE
01:23 -
E6.2 AVERAGEA
02:43 -
E6.3 AVERAGEIF vs AVERAGEIFS
05:28 -
E6.4 Weighted Average with VBA Code
04:20
E7. COUNT related formulas
-
E7.1 COUNT, COUNTA, COUNTBLANK
03:05 -
E7.2 COUNTIF vs COUNTIFS
04:59
E8. LOGIAL- IF related formulas
-
E8.1 LOGICAL TEST with Comparative Operators
03:39 -
E8.2 IF
06:03 -
E8.3 IF AND vs IF OR
05:04 -
E8.4 IFS vs NESTEDIF
07:17 -
E8.5 IFERROR
03:37 -
E8.6 SWITCH
05:26
E9. TEXT EXTRACTION AND MANIPULATION
-
E9.1 LEFT, RIGHT, MID and LEN
04:45 -
E9.2 FIND vs SEARCH
02:13 -
E9.3 REPLACE vs SUBSTITUTE
05:23
E10. TEXT FORMATTING AND CONVERSTION
-
E10.1 CONCAT vs CONCATENATE
02:13 -
E10.2 TEXT
09:06 -
E10.3 UPPER, LOWER, PROPER
01:09 -
E10.4 TRIM
01:04 -
E10.5 SPELLNUMBER with VBA code
04:11 -
E10.6 TEXT-TO-NUMBER with VBA code
02:14
E11. Date & Time Related Formulas
-
E11.1 Using TODAY, NOW
03:19 -
E11.2 DATE, DATEVALUE, TIME, TIME VALUE
08:21 -
E11.3 DATEDIF AND EXTRACT YEARS, MONTHS, DAYS, HOURS, MIN, SECONDS
07:33 -
E11.4 Calculating Future and Past Dates -EDATA, EOMONTH, WORKINGDAYS, NET WORKINGDAYS
08:24 -
E11.5 Calculate Days using – DAY, DAYS, NETWORKING DAYS
02:23 -
E11.6 Calculate Hours and Hourly Charges
04:46
E12. Finance related formulas
-
E12.1 PMT – EMI Calculator
05:00 -
E12.2 PPMT, IPMT – Loan Statement Preparation
18:28 -
E12.3 FV – Investment Calculator
03:59
E13. DATA SEARCH – Lookup related formulas
-
E13.1 VLOOKUP – Basics – Rules – Exact Match – Approx Match
11:03 -
E13.2 HLOOKUP – Basics
02:17 -
E13.3 XLOOKUP Function – with VBA Code
03:48 -
E13.4 MATCH Function vs INDEX Function
05:14 -
E13.5 VLOOKUP-Advanced-1-Applying across multiple cells at a time
02:36 -
E13.6 VLOOKUP-Advanced-2-Applying across multiple sheets
03:01 -
E13.7 VLOOKUP-Advanced-3-Applying on large data
09:44 -
E13.8 VLOOKUP-Advanced-4-Applying across multiple workbooks
09:39
E14. Pivot Table
-
E14.1 Pivot Table Basics
05:43 -
E14.2 Pivot Table Basics – common mistakes
06:04 -
E14.3 Pivot Tables – Advanced Tips
08:28 -
E14.4 How to Combine Multiple Sheet Data into One
07:02 -
E14.5 Pivot Table on Multiple Sheets, Workbooks
03:33
E15. Charts, 2D Maps and 3D Maps
-
E15.1 MS Excel Charts – Basics – Insert, Data Control, Improve Chart, Change Series
12:21 -
E15.2 Pie Charts
03:43 -
E15.3 Charts – Doughnut Charts
04:31 -
E15.4 Bar Charts
05:47 -
E15.5 Bubble Charts
06:27 -
E15.6 3D Containers or Cylinders or Stacked column
09:45 -
E15.7 2D Map Charts-Basics
05:50 -
E15.8 2D Map Charts-Advanced
01:34 -
E15.9 3D Map Charts – Basics
06:48 -
E15.10 3D Map Charts – Sales with Time lapse, scenes creation
08:08 -
E15.11 3D Maps Charts -Population with Time lapse, scenes creation
05:37
E16. Macros and VBA
-
E16.1 How to Enable Developer Tap
01:22 -
E16.2 Macros and VBA Basics
06:58 -
E16.3 Macros Example-1
02:11 -
E16.4 Macros Example-2
02:30 -
E16.5 VBA Example-1
02:46 -
E16.6 VBA Example-2
05:00 -
E16.7 1-10 VBA Codes
03:22 -
E16.8 11-20 VBA Codes with Shortcut key explanation
03:13 -
E16.10 VBA Case Study 1
00:10 -
E16.11 VBA Case Study 2
00:10
E17. Fire Your Boss
-
E17.1 Student Mark Sheet Calculation
21:02 -
E17.2 Spark Lines
00:38 -
E17.3 Lines for User Forms
01:14 -
E17.4 Data re-arrangement with Text to columns
01:07 -
E17.5 Insert Check Boxes
01:06 -
E17.6 Insert Data Forms
01:12 -
E17.7 AUTO BORDER
01:38 -
E17.8 WRAPROWS WITH VBA
01:56 -
E17.9 Compare Data Easily
00:42 -
E17.10 Slicer in Excel
01:36 -
E17.11 ADJUST IMAGE IN EXCEL
01:17 -
E17.12 DYNAMIC SEARCH BAR CREATION
08:12 -
E17.13 BAR CODE CREATION IN EXCEL
05:09 -
E17.14 Data Consolidation
01:38 -
E17.15 Copy Paste excluding Hidden Data
00:52 -
E17.16 Delete blank Cells
00:42 -
E17.17 ADVANCED SELECTION, MIN, MAX
01:05 -
E17.18 ROUND ROUNDUP MROUND
03:10 -
E17.19 SWAP COLUMSN DATA
01:32 -
E17.20 Sheet Controls
01:24
E18. Chat GPT – AI Tools – ADD Ins
-
E18.1 MS Excel with ChatGPT – Manual Script
05:09 -
E18.2 MS Excel with ChatGPT – upload image
02:53 -
E18.3 MS Excel with ChatGPT – upload and download with formulas
02:12 -
E18.4 MS Excel with AI Tools – Ai-Aided formula Editor
02:51 -
E18.5 MS Excel – Add IN – Wikipedia – to collect info
02:16 -
E18.6 MS Excel – Add IN – FRED – ECONOMIC DATA
02:16 -
E18.7 MS Excel -Add IN – Mini Calendar
01:40 -
E18.8 MS Excel -Add IN – Symbols and Characters
01:48 -
E18.9 MS Excel – Chat GPT AI ASK
02:31 -
E18.10 MS Excel – Chat GPT AI FILL
01:21 -
E18.11 MS Excel – Chat GPT AI Translate
01:27 -
E18.12 MS Excel – ChatGPT AI Extract
01:44 -
E18.13 MS Excel – ChatGPT AI Table
01:50
E19. Data Validation
-
E19.1 Data Validation – Basics
06:55 -
E19.2 Drop Down List – Dependent Drop Down List
14:20 -
E19.3 Data Validation – on Student Registration
21:29
E20. Excel Projects, Dashboards, Info Graphic, Data Visualization
-
E20.1 Automation – Student Admission Management
21:30 -
E20.2 Complete Billing Automation – Invoice Design, Tax Calculation, Logo n more
01:13:04 -
E20.3 Comparison Table: Perpetual Dashboards vs Interactive-Dynamic Dashboards
02:08 -
E20.4 Perpetual-Static Dashboards I Part-1 I Creating KPI Key Performing Indicators
15:32 -
E20.5 Perpetual-Static Dashboards I Part-2 I KPIs to Visualization
26:07 -
E20.6 Interactive-Dynamic Dashboards I Creating Connected KPI I Connect Dashboards
27:15 -
E20.7 Financial Reporting Dashboards Sales, Profit, Country wise, Product Wise
20:09
Student Ratings & Reviews
5.0
Total 2 Ratings
5
2 Ratings
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
nice course with practice materials
i have taken all course of ravi sir, his teaching skills are superb, very easy to learn complete excel.