Complete Microsoft Advanced Excel Certification

Focused View

Vivek PMP,Tejaswini G

9:14:05

116 View

1. Introduction to Microsoft Excel

1. Introduction And Importance of Microsoft Excel.mp4

02:54

2. Quick Tour of Microsoft Excel Software.mp4

11:13

2. Microsoft Excel Fundamentals (Basic Excel)

1. Microsoft Excel Layout.mp4

18:36

2. Data Editing.mp4

08:11

3. Copy Paste Special.mp4

09:17

4. Working with Numbers.mp4

06:24

5.1 References Exercise.xlsx

5. References in Excel.mp4

06:15

6. Hide And Unhide.mp4

04:02

7. Advance Fill.mp4

10:30

8. Text To Column.mp4

06:35

9. Flash Fill.mp4

04:34

10. Customized View.mp4

06:56

11. Comparing data from different sheets.mp4

03:09

12. Working with Hyperlinks.mp4

12:23

13.1 Basic Functions (Sum, Average, Count, Max, Min) Exercise.xlsx

13. Basic Functions (Sum, Average, Count, Max, Min).mp4

06:13

14. Proofing (Spelling And Thesaurus).mp4

04:43

15. Page Layout.mp4

07:36

3. Microsoft Excel Advance Functions (Advance Excel)

1. Conditional Formatting.mp4

31:58

2. Advance Table.mp4

33:55

3. Advance Filter.mp4

07:56

4. Sort And Subtotal.mp4

05:05

5. Formulas and Functions - Topic 1 - Text Function.mp4

16:00

6. Formulas and Functions - Topic 2 - Date Function.mp4

13:53

7. Formulas and Functions - Topic 3 - Logical functions (If, And, Or).mp4

21:41

8. Formulas and Functions - Topic 4 - Statistical Functions.mp4

22:40

9. Vlookup And Hlookup.mp4

23:19

10. Vlookup with Match.mp4

05:55

11. Index And Match Function.mp4

09:14

12. Working with Array.mp4

10:56

13. Error Handling.mp4

04:29

14. Advance Range.mp4

15:51

15. Data Validation.mp4

22:24

16. Data Consolidation.mp4

08:24

17. Solver Add-In.mp4

04:55

18. Illustrations (Pictures, Shapes, SmartArt).mp4

00:48

19. Working with Charts (Graphs).mp4

35:29

20. Pivot Table.mp4

52:08

21. What if Analysis (Goal Seek, Data Table, Scenario Manager).mp4

24:29

22. Import And Export.mp4

09:44

4. Dashboard Creation for Automatic Data handling in Excel

1. Dashboard Creation.mp4

28:03

5. Microsoft Excel VBA And Macro

1. Introduction to VBA And Macro.mp4

05:09

2. Recording Macro.mp4

09:21

3. Working with VBA (Writing a code for Macro).mp4

00:48

6. Shortcut Keys in Microsoft Excel

1. Shortcut Keys in Microsoft Excel.html

Description

Best for Data Analysist, MIS, Finance & Accounting, Data Handling etc. Excel Version 2010, 2013, 2016, 2019 & Office 365

What You'll Learn?

Master in Microsoft Excel from Zero to Expert. You will learn all about Microsoft excel by easiest way like 1) Basic Excel + 2) Advanced Excel + 3) VBA Macro
Microsoft Excel Basics
Microsoft Excel Advance
Microsoft Excel VBA Macro

Who is this for?

Any student or working professional who is passionate about learning Microsoft Excel. If you are looking to excel your Data analysis skills from beginner to advanced level and beyond, then this course is for you.

Best for Data Analysist, MIS, Finance & Accounting, Data Handling, Supply Chain, Ecommerce etc.

What You Need to Know?

No prerequisites

More details

Description
Microsoft Excel is a spreadsheet program included in Microsoft Office suite of applications. Spreadsheets will provide you with the values arranged in rows and columns that can be changed mathematically using both basic and complex arithmetic operations.
In addition to the standard spreadsheet features, Excel offers programming support via Microsoft's Visual Basic for Applications (VBA), the ability to access data from external sources via Microsoftâ€™s Dynamic Data Exchange (DDE).

Course Objective
Participants will learn to how to use Basic + advanced functions + VBA &Â Macro of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and excel formulas and streamline their operational work.
They will apply visual elements and advanced formulas to a worksheet to display data in various formats.
Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel advanced functionality to simplify and streamline their day-to-day work.

Deliverables
Easy to understand courseware
Training with the focus on useful features &Â Practical examples
Practice Exercises
We start from Microsoft Excel basics to make sure we have the right fundamentals. We them move on to more advanced topics like Conditional Formatting, Excel Pivot Tables and Power Query. We cover important formulas like VLOOKUP, SUMIFS and nested IF Functions.
The course comes with lifetime access. Buy now. Watch anytime.
After Training Lifetime support by email for your day to day queries.
Who this course is for:
Any student or working professional who is passionate about learning Microsoft Excel. If you are looking to excel your Data analysis skills from beginner to advanced level and beyond, then this course is for you.
Best for Data Analysist, MIS, Finance & Accounting, Data Handling, Supply Chain, Ecommerce etc.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Analytics

Excel Dashboard

Excel Modeling

Excel Macros

Excel Charts

Vivek PMP

Instructor's Courses

Mr Vivek has more than 19 + years of industry experience in Project & Quality Management in well know Automotive and Non-automotive industries.His area of specialization includes Project Management, Six Sigma, New product development, Supplier quality assurance, New Supplier development, Supply Management and Supply chain management.He possesses excellent negotiation, organizational, relationship management, problem solving and interpersonal skills with cross-cultural adaptation and creative abilities.Training Portfolio : Six Sigma / PMP & CAPM Training / Primavera P6 / MS Project / Design Thinking / Advance Excel / Soft Skills etc.Professional Qualification :Bachelor of EngineeringMBA (Finance)PMI - PMP CertifiedSix Sigma Black Belt CertifiedScrum Fundamental CertifiedDesign Thinking CertifiedCertified Internal Auditor

Tejaswini G

Instructor's Courses

Tejaswini has more than 15+ years of experience in Data Analysis, Software development, Project Management etc. As a Passionate trainer, she thoroughly unlocks the potentials of audience by incorporating and transforming their values and skills.Training Portfolio : Data Analysis, SQL, Advance Excel, VBA, Scrum, Personality Development, Business English, Digital Marketing.Professional Qualification :MCM (Master in computer management)Scrum CertifiedSix Sigma CertifiedOracle SQL, Java Certified

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.