Complete Microsoft Advanced Excel Certification

Complete Microsoft Advanced Excel Certification, available at $74.99, has an average rating of 4.32, with 44 lectures, based on 261 reviews, and has 891 subscribers.

You will learn about 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 This course is ideal for individuals who are 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. or Best for Data Analysist, MIS, Finance & Accounting, Data Handling, Supply Chain, Ecommerce etc. It is particularly useful 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. or Best for Data Analysist, MIS, Finance & Accounting, Data Handling, Supply Chain, Ecommerce etc.

Enroll now: Complete Microsoft Advanced Excel Certification

Summary

Title: Complete Microsoft Advanced Excel Certification

Price: $74.99

Average Rating: 4.32

Number of Lectures: 44

Number of Published Lectures: 44

Number of Curriculum Items: 44

Number of Published Curriculum Objects: 44

Original Price: ₹4,499

Quality Status: approved

Status: Live

What You Will 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 Should Attend

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.

Target Audiences

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.

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.

Course Curriculum

Chapter 1: Introduction to Microsoft Excel

Lecture 1: Introduction & Importance of Microsoft Excel

Lecture 2: Quick Tour of Microsoft Excel Software

Chapter 2: Microsoft Excel Fundamentals (Basic Excel)

Lecture 1: Microsoft Excel Layout

Lecture 2: Data Editing

Lecture 3: Copy Paste Special

Lecture 4: Working with Numbers

Lecture 5: References in Excel

Lecture 6: Hide & Unhide

Lecture 7: Advance Fill

Lecture 8: Text To Column

Lecture 9: Flash Fill

Lecture 10: Customized View

Lecture 11: Comparing data from different sheets

Lecture 12: Working with Hyperlinks

Lecture 13: Basic Functions (Sum, Average, Count, Max, Min)

Lecture 14: Proofing (Spelling & Thesaurus)

Lecture 15: Page Layout

Chapter 3: Microsoft Excel Advance Functions (Advance Excel)

Lecture 1: Conditional Formatting

Lecture 2: Advance Table

Lecture 3: Advance Filter

Lecture 4: Sort & Subtotal

Lecture 5: Formulas and Functions – Topic 1 – Text Function

Lecture 6: Formulas and Functions – Topic 2 – Date Function

Lecture 7: Formulas and Functions – Topic 3 – Logical functions (If, And, Or)

Lecture 8: Formulas and Functions – Topic 4 – Statistical Functions

Lecture 9: Vlookup & Hlookup

Lecture 10: Vlookup with Match

Lecture 11: Index & Match Function

Lecture 12: Working with Array

Lecture 13: Error Handling

Lecture 14: Advance Range

Lecture 15: Data Validation

Lecture 16: Data Consolidation

Lecture 17: Solver Add-In

Lecture 18: Illustrations (Pictures, Shapes, SmartArt)

Lecture 19: Working with Charts (Graphs)

Lecture 20: Pivot Table

Lecture 21: What if Analysis (Goal Seek, Data Table, Scenario Manager)

Lecture 22: Import & Export

Chapter 4: Dashboard Creation for Automatic Data handling in Excel

Lecture 1: Dashboard Creation

Chapter 5: Microsoft Excel VBA & Macro

Lecture 1: Introduction to VBA & Macro

Lecture 2: Recording Macro

Lecture 3: Working with VBA (Writing a code for Macro)

Chapter 6: Shortcut Keys in Microsoft Excel

Lecture 1: Shortcut Keys in Microsoft Excel

Instructors

Vivek PMP
PMP Certified Project Manager. 19+ Years Experience
Tejaswini G
Software Engineer, 15+ Industry Experience

Rating Distribution

1 stars: 7 votes
2 stars: 9 votes
3 stars: 27 votes
4 stars: 84 votes
5 stars: 134 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu