Vedanta Courses

💻 Learn & Grow 🚀 Use VEDANTA2025 🚀 for 10% Disc 🎓 Hurry up! ⏳

Login / Register
Login / Register
Course Content
S1. Free Sample Videos
0/4
Start Screen – Back Stage Screen – Options
04:28
Things to remember before starting formulas in Excel
09:41
XLookup with VBA
03:48
MS Excel – EMI and Loan Statement Preparation – PMT PPMT IPMT
18:28
S2. Course Tips, Download Materials and Practice Notes
0/1
Download Course Materials
00:00
E1. MS Excel – Start-up
0/5
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
E1.4 Home Tab Basic Editing Tools
11:25
E1.5 Copy and Paste I using to Multiple Tools in MS Excel
11:46
E2. MS Excel – Basic Tools to know
0/6
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
0/10
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
0/9
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
0/11
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
0/4
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
0/2
E7.1 COUNT, COUNTA, COUNTBLANK
03:05
E7.2 COUNTIF vs COUNTIFS
04:59
E8. LOGIAL- IF related formulas
0/6
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
0/3
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
0/6
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
0/6
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
0/3
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
0/8
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
0/5
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
0/11
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
0/10
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
0/20
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
0/13
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
0/3
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
0/7
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
Microsoft Excel – Beginner to Advanced
Previous
Next
0% Complete