Master Microsoft Excel 2019 - Basic to Advanced

Name: Master Microsoft Excel 2019 - Basic to Advanced
Rating: 4.3 (110 reviews)

Learn Excel functions, charts, formatting, dashboards and much more from industry professional

Created byAakash Aggarwal

Last updated 11/2023

Hindi

What you'll learn

Commonly used Hotkeys that will increase the speed of the learner on Excel
Basic and Advanced Functions that will help the learners to build complex formulas to meet their work requirement
Formula Merging Technique that will help the learners in building big formulas easily
Various Type of Charts in Excel
Data Modelling and Power Pivot Concepts or RDBMS Concepts
Power Query and Its Functionalities
Dashboards and Report Prepration
Tips & Tricks that will help the learners to handle real time challenges while working

Course content

1 section • 109 lectures • 10h 12m total length

Study Material & Assignments0:18
Paste Special 114:21
Paste special 24:38
Paste Special 34:31
Wrap text & Column Autofit2:27
How to learn and use shortcut keys9:14
Number Formats9:59
Number formats 26:36
Conditional formatting8:39
Conditional formatting 24:34
Conditional formatting 37:04
Format as table3:24
Cell styles2:24
Quick shortcuts5:10
Quick shortcuts 26:12
Autosum1:38
Formula dragging3:01
Clear content & Formats4:33
Filtering7:20
Find & Replace2:41
Sum Avg Min Max2:40
Count CountA CountBlank3:52
Lower Upper Proper1:26
Concatenate2:24
If4:29
If with And & Or12:45
Nestedif7:15
Goto - Blanks3:25
Date Functions4:20
Time functions2:43
Mod1:14
Randbetween2:04
Product1:10
Todaynow1:09
Edate EOmonth5:19
Roman0:38
Even Odd1:58
Char Code6:55
Abs1:25
Rounding functions3:48
Choose Rank Large Small7:07
Rank1:35
Fact1:18
Mode Median Int Power Sign7:25
Workday Networkday5:37
Hiding the text3:54
Text Functions - Left Right Mid Trim Len Find Search10:07
Text Functions 22:35
Formula Merging14:58
Substitute6:39
Replace4:44
Simple vlook up part 17:10
Vlook up with different references12:06
Vlook up with partial reference part 36:50
Vlook up by array4:53
Vlook up with approximate match7:04
Index Match8:14
Index with Double Match3:36
Vlook up match7:01
Indirect Function using References (Dependent Dropdown)13:43
Address Function (Overview)4:37
Address Function with Indirect and Match13:11
Datedif3:19
Countif and Countifs6:11
Countif with Wildcards3:32
Sumif and Sumifs5:02
Averageif and Averageifs2:19
Dmax and Dmin4:35
Isblank Isnumber Exact Clean10:05
Sumproduct4:42
Offset8:55
Pivot table dynamic range5:41
Advanced Filters6:18
Calculation Option7:12
Filters6:58
Flashfill3:27
Hyperlink4:32
Object Embedding3:19
Sorting5:00
Sparklines3:45
Text to column3:38
Validation7:20
Pivot Table14:29
Pivot Table 23:32
Pivot table 32:09
Charts7:31
Combo chart3:22
Slicers3:42
Timeline2:13
Dashboarding22:10
Power Query Part 110:29
Power Query Part 212:06
Power Query Part 3 (Joins)8:39
Understanding Sample Superstore Data4:53
Power Query Part 4 (Data Merging)6:22
Power Query Part 5 (Data Appending)4:24
Data Modelling and PowerPivot24:19
Remove duplicates4:53
Consolidate2:20
What if Analysis - Goal Seek2:47
What if Analysis - Data Table5:16
Group and Ungroup1:24
Protection - Workbook Protection2:21
Protection - Workbook Structure1:57
Protection - Data Protection7:23
Protection - Formula Protection4:33
Freezing4:38
Arrange All2:32
Split2:09

Requirements

Anybody can learn Excel so there are no prerequisites.

Description

Just having an intermediate knowledge of Excel isn’t enough. Take your Excel skills to a whole new level with our Advanced Excel course. By the end of the training, you will soon be using advanced excel formulas, creating graphs and charts like a pro and much more. If you want to use Excel with confidence and ease at work opt for this course today.

The Advanced Excel training at Learnitix covers the basic and advanced Excel modules. Under this training, you will learn all about the Concepts of Microsoft excel and how to use Excel. For clearing any doubt, students can post their doubts and get solutions within 24 hours.

Microsoft Excel is one of the most important industry-standard spreadsheet programs worked for data analysis, visualization, calculations, etc .it is considered the best tool for financial calculations, statistics, data modeling, and one can obtain data from its external databases. Advanced Excel courses are needed for business analytics, accounting, and data analysis jobs.

Excel is a handy tool and can be utilized for anything that you can imagine: Charts and Diagrams, Cards, calendars, budgets, Agendas, Flyers, financial tools inventories, forms, Invoices, Planners, reports, Timesheets, Schedules, Reports, and many more.

Once you master Excel you can apply for the positions like MIS executive, Reporting Analyst, Business Analyst, or Data Analyst.

Who this course is for:

Freshers or experienced professionals who are willing to learn excel and want to master it.