Complete Microsoft Advanced Excel Certification

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
Requirements
No prerequisites
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 ObjectiveParticipants 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.DeliverablesEasy to understand coursewareTraining with the focus on useful features & Practical examplesPractice ExercisesWe 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.
Overview
Section 1: Introduction to Microsoft Excel
Lecture 1 Introduction & Importance of Microsoft Excel
Lecture 2 Quick Tour of Microsoft Excel Software
Section 2: Microsoft Excel Fundamentals (Basic Excel)
Lecture 3 Microsoft Excel Layout
Lecture 4 Data Editing
Lecture 5 Copy Paste Special
Lecture 6 Working with Numbers
Lecture 7 References in Excel
Lecture 8 Hide & Unhide
Lecture 9 Advance Fill
Lecture 10 Text To Column
Lecture 11 Flash Fill
Lecture 12 Customized View
Lecture 13 Comparing data from different sheets
Lecture 14 Working with Hyperlinks
Lecture 15 Basic Functions (Sum, Average, Count, Max, Min)
Lecture 16 Proofing (Spelling & Thesaurus)
Lecture 17 Page Layout
Lecture 18 Section Summary
Section 3: Microsoft Excel Advance Functions (Advance Excel)
Lecture 19 Conditional Formatting
Lecture 20 Advance Table
Lecture 21 Filter & Advance Filter
Lecture 22 Sort & Subtotal
Lecture 23 Formulas and Functions
Lecture 24 Index & Match Function
Lecture 25 Vlookup & Hlookup
Lecture 26 Vlookup with Match
Lecture 27 Working with Array
Lecture 28 Error Handling
Lecture 29 Advance Range
Lecture 30 Data Validation
Lecture 31 Data Consolidation
Lecture 32 Solver Add-In
Lecture 33 Illustrations (Pictures, Shapes, SmartArt)
Lecture 34 Working with Charts (Graphs)
Lecture 35 Pivot Table
Lecture 36 What if Analysis (Goal Seek, Data Table, Scenario Manager)
Lecture 37 Import & Export
Lecture 38 Section Summary
Section 4: Dashboard Creation for Automatic Data handling in Excel
Lecture 39 Dashboard Creation
Section 5: Microsoft Excel VBA & Macro
Lecture 40 Introduction to VBA & Marco
Lecture 41 Recording Macro
Lecture 42 Working with VBA (Writing a code for Macro)
Lecture 43 Section Summary
Section 6: Shortcut Keys in Microsoft Excel
Lecture 44 Shortcut Keys in Microsoft Excel
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.
Homepage

https://www.udemy.com/course/complete-microsoft-advanced-excel-certification/