Master Advanced Excel: Formulas, Functions, PivotTables & PowerPivot

Microsoft Advance Excel Formulas And Functions With PivotTables And PowerPivot

Microsoft Advance Excel Formulas And Functions

Created by : Rated :4.3 41 views

Last Updated: 2024-12-02 05:12:49 English Course Type: Self Learning

Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch.
Automate, streamline, and completely revolutionize your workflow with Excel Advance formula and function like Name Ranges, Vlookup, Hlookup and many more.
Learn to Prepare Microsoft Excel data for PivotTable.
Learn customization, formatting, filtering and many more in PivotTable.
Learn how to Create and manage PivotTable calculations.
Learn how to create Pivot chart base on PivotTable.
Learn PowerPivot to Create and manage Excel Data Models to pull in data from multiple sources and then creating relationship between them.

It's time to learn Advanced Excel Formulas and Functions With PivotTables And PowerPivot.

Whether you're starting from scratch or aspiring to become an absolute Excel power user, you've come to the right place.

This course will give you understanding of the Advanced Excel Formulas and Functions With PivotTables And PowerPivot that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

This Microsoft Excel - Advanced Excel Formulas & Functions With PivotTables And PowerPivot Course will tell you simply what each formula does, how they can be applied in a number of ways.

I have divided this course in different sections including:

Working With Excel List

List Functions

Data Validation

Working With Large Set Of Excel Data

Excel Conditional Functions

Excel Lookup Functions

Excel Text Based Functions

Auditing An Excel Worksheet

Protecting Excel Worksheet and Workbook

Working with Excel What If? Tools

Excel Pivotables

Excel PowerPivot

My teaching style is conversational, authentic, easy and to the point, and I will always communicate complex/ difficult concepts in a framework that is clear and easy to understand.

If you're looking for the course where you can learn Microsoft Excel - Advanced Excel Formulas & Functions With PivotTables And PowerPivot that you need to know to become an absolute Excel Hero, you've found it.

See you in the course!

* NOTE: Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021 & Office 365.

You must have basic Microsoft Excel knowledge.

Those who want to expand their skill set and want to take their career in excel to a new level.
Those who want to write advanced excel formulas from scratch.
Those who want to make there job in excel more dynamic.
Those who want to learn Microsoft Excel - Advance Formulas & Functions, PivotTable, PivotChart and Power Pivot in One Course.
Excel users looking to build powerful analytical thinking and business intelligence skills.

Section 1 : Introduction 1 Lectures
Lecture 1 :
Course Introduction Preview
Section 2 : Working With An Excel List 10 Lectures 00:06:08
Lecture 1 :
Understanding Excel List Structure
Lecture 2 :
Sorting A List Using Single Level Sort
Lecture 3 :
Sorting A List Using Multi - Level Sorts
Lecture 4 :
Using Custom Sorts In An Excel List
Lecture 5 :
Filter An Excel List Using The AutoFilter Tool
Lecture 6 :
Creating Sub-Totals In A List
Lecture 7 :
Removing Duplicates Entries In Excel
Lecture 8 :
Format A List As A Table
Lecture 9 :
Using Conditional Formatting To Find Duplicates
Lecture 10 :
Excel List Quiz
This quiz is for working with an Excel list.
Section 3 : Excel List Functions 6 Lectures
Lecture 1 :
Using DSUM Function To Find Sum For Single Criteria
Lecture 2 :
Using DSUM Function To Find Sum For Multiple Criteria
Lecture 3 :
Using DSUM Function To Find Sum For Multiple Headers
Lecture 4 :
Using DAVERAGE Function In Excel
Lecture 5 :
Using DCOUNT Function In Excel
Lecture 6 :
Excel List Functions Quiz
In this section, Quiz is all about Excel List Functions.
Section 4 : Excel Data Validation 4 Lectures
Lecture 1 :
Using Data Validation Function through List Option
Lecture 2 :
Using Data Validation Function Through Decimal Option
Lecture 3 :
Using Data Validation Function For Customization Of Error Alert Message
Lecture 4 :
Excel Data Validation Quiz
In this section, Quiz is all about Data Validation
Section 5 : Working With Large Sets Of Excel Data 6 Lectures
Lecture 1 :
Using Freeze Panes Tools In Excel
Lecture 2 :
Grouping Or Outline Data In Excel Worksheet
Lecture 3 :
Print options For large Set Of Data In Excel
Lecture 4 :
Linking Worksheet (3D Formula) In Excel
Lecture 5 :
Linking Worksheet With Consolidated Tool In Excel
Lecture 6 :
Working With Large Set Of Excel Quiz
In this section, Quiz is all about Large Set Of Excel Data.
Section 6 : Working With Excel Conditional Functions 9 Lectures
Lecture 1 :
Working With Excel Name Ranges
Lecture 2 :
Editing Name Range In Excel
Lecture 3 :
Using If Function In Excel
Lecture 4 :
Nesting Or Multiple Function In Excel
Lecture 5 :
Using If Function With And Function In Excel
Lecture 6 :
Using COUNTIF Function In Excel
Lecture 7 :
Using SUMIF Function In Excel
Lecture 8 :
Using IFERROR Function In Excel
Lecture 9 :
Excel Conditional function Quiz
In this section, Quiz is all about different functions like sumif, countif and so on...
Section 7 : Working With Excel Lookup Functions 6 Lectures
Lecture 1 :
Using VLookUp Function In Excel
Lecture 2 :
Using HLookup Function In Excel
Lecture 3 :
Using Index Function In Excel
Lecture 4 :
Using Match Function In Excel
Lecture 5 :
Using HLookup Function With Match Function In Excel
Lecture 6 :
Excel Lookup Functions Quiz
In this section, Quiz is all about Lookup Functions like VLookup, HLookup and so on....
Section 8 : Working With Excel Text Based Functions 4 Lectures
Lecture 1 :
Using Left, Right & Mid Function In Excel
Lecture 2 :
Using LEN Function In Excel
Lecture 3 :
Using Concatenate Function In Excel
Lecture 4 :
Excel Text Based Quiz
In this section, Quiz is all about text Based Functions.
Section 9 : Auditing An Excel Worksheet 5 Lectures
Lecture 1 :
Tracing Precedents In Excel Formulas
Lecture 2 :
Tracing Dependents In Excel Formulas
Lecture 3 :
Using Watch Window Function In Excel
Lecture 4 :
Using Show Formulas In Excel
Lecture 5 :
Excel Formula Auditing Quiz
In this section, Quiz is all about Auditing.
Section 10 : Protecting Excel Worksheets And Workbook 4 Lectures
Lecture 1 :
Protecting Complete Worksheet And Specific Cells In Excel
Lecture 2 :
Protecting The Structure Of A Workbook
Lecture 3 :
Protecting Complete Workbook With Password In Excel
Lecture 4 :
Excel Protection Quiz
In this section, Quiz is all about protecting our worksheets and workbook.
Section 11 : Using "What-If Analysis" Tools In Excel 4 Lectures
Lecture 1 :
Using Goal Seek Tool In Excel
Lecture 2 :
Using Data Table Tool In Excel
Lecture 3 :
Using Scenarios Manager Tool In Excel
Lecture 4 :
Excel What-if Analysis Quiz
In this section, Quiz is all about "What-If Analysis" Tools.
Section 12 : Excel PivotTables 11 Lectures
Lecture 1 :
Understanding Excel PivotTable
Lecture 2 :
Creating Excel PivotTable In Same Worksheet
Lecture 3 :
Creating Excel PivotTable In New Worksheet
Lecture 4 :
Grouping PivotTable Data In Excel
Lecture 5 :
Modifying PivotTable Calculation In Excel
Lecture 6 :
Formatting PivotTable Data In Excel
Lecture 7 :
Drilling Down Into PivotTable In Excel
Lecture 8 :
Creating PivotChart Base On PivotTable In Excel
Lecture 9 :
Filter Option In PivotTable Data In Excel
Lecture 10 :
Filtering with Slicer Tool Technique In Excel
Lecture 11 :
Excel PivotTable Quiz
In this section, Quiz is all about Excel PivotTables.
Section 13 : Excel PowerPivot 5 Lectures
Lecture 1 :
Explaining PowerPivot And Add-In PowerPivot Tab In Ribbon
Lecture 2 :
Creating Data Model For PowerPivot In Excel
Lecture 3 :
Creating Relationship After Creating Data Model
Lecture 4 :
Creating PivotTable Base On Data Model
Lecture 5 :
Excel Power Pivot Quiz
In this section, Quiz is all about PowerPivot.

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?