Microsoft Excel - Advanced Excel Formulas & Functions

Focused View

Nikkyani Academy

3:00:23

51 View

1. Introduction

1. Introduction.mp4

01:54

2.1 Excel 1.1 (Advance).xlsx

2.2 Excel 1.1.xlsx

2. Course Excercise Files.mp4

00:56

2. Excel PivotTables

1. Understanding Excel PivotTables.mp4

02:28

2. Creating Excel PivotTable In Same Worksheet.mp4

06:18

3. Creating Excel PivotTables In New Worksheet.mp4

05:18

4. Grouping PivotTable Data In Excel.mp4

04:08

5. Formatting PivotTable Data In Excel.mp4

02:49

6. Modifying PivotTable Calculations In Excel.mp4

04:04

7. Drilling Down Into PivotTable In Excel.mp4

01:32

8. Creating PivotChart Base On PivotTable In Excel.mp4

04:21

9. Filter Option In PivotTable Data In Excel.mp4

02:37

10. Filtering With Slicer Tool Technique In Excel.mp4

03:16

11. Excel PivotTable Quiz.html

3. PowerPivot

1. Explaining PowerPivot And Add-In PowerPivot Tab In Ribbon.mp4

03:01

2. Creating Data Model For PowerPivot In Excel.mp4

03:10

3. Creating Relationship After Creating Data Model.mp4

04:04

4. Creating PivotTable Base On Data Model.mp4

04:45

5. Excel Power Pivot Quiz.html

4. Working With Large Set Of Excel Data

1. Freeze Panes Tool In Excel.mp4

02:33

2. Grouping (Outline) Data In Excel.mp4

04:25

3. Linking Worksheet In Excel.mp4

03:09

4. Linking Worksheet With Consolidate Tool In Excel.mp4

03:51

5. Print Options For Large Set Of Data In Excel.mp4

07:28

6. Excel Large Set Quiz.html

5. Working With Excel Conditional Function

1. Working With Name Ranges In Excel.mp4

08:47

2. Editing Name Ranges In Excel.mp4

02:16

3. Using If Function In Excel.mp4

05:05

4. Nesting or Multiple Functions In Excel.mp4

06:28

5. Using And Function With If Function Together.mp4

04:23

6. Using CountIf Function In Excel.mp4

02:03

7. Using SumIf Function In Excel.mp4

04:52

8. Using IfError Function In Excel.mp4

02:37

9. Excel Conditional function Quiz.html

6. Working With Lookup Function In Excel

1. Using Vlookup Function In Excel.mp4

04:11

2. Using Hlookup Function In Excel.mp4

05:32

3. Using Index Function In Excel.mp4

05:19

4. Using Match Function In Excel.mp4

03:20

5. Using Hlookup+Match Function In Excel.mp4

05:51

6. Excel Lookup Function Quiz.html

7. Working With Excel Text Based Functions

1. Using Left, Right & Mid Function In Excel.mp4

05:25

2. Using Len Function In Excel.mp4

01:26

3. Using Concatenate Function In Excel.mp4

02:16

4. Excel Text Based Quiz.html

8. Working With Formula Auditing In Excel Worksheet

1. Using Trace Precedent In Excel.mp4

02:52

2. Using Trace Dependents Function In Excel.mp4

02:12

3. Using Show Formula Function In Excel.mp4

01:54

4. Using Watch Window Function In Excel.mp4

04:34

5. Excel Formula Auditing Quiz.html

9. Protecting Excel Worksheets And Workbooks

1. Protecting Complete Or Specific Cell In A Worksheet.mp4

04:02

2. Protecting The Structure Of A Workbook In Excel.mp4

01:49

3. Protecting Workbook With Password In Excel.mp4

02:38

4. Excel Protection Quiz.html

10. Using What-If Analysis Tools In Excel

1. Using Goal Seek Tool In Excel.mp4

05:02

2. Using Data Table Tool In Excel.mp4

03:54

3. Using Scenario Manager Tool In Excel.mp4

05:28

4. Excel What-if Analysis Quiz.html

Description

Master Microsoft Excel - Advanced Excel Formulas & Functions, PivotTable, PivotChart and Power Pivot

What You'll Learn?

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.

Who is this for?

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.

What You Need to Know?

You must have basic Microsoft Excel knowledge.

You are able to write basic formulas and are familiar with the Excel spreadsheet environment.

More details

Description
It's time to learn Advanced Excel Formulas and Functions,Â PivotTable, PivotChart and Power Pivot
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,Â PivotTable, PivotChart and Power Pivot that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.
This Microsoft Excel - Advanced Excel Formulas & Functions,Â PivotTable, PivotChart and Power Pivot 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:
PivotTable
PivotChart
Power Pivot
Conditional Functions
Lookup Functions
Text-Based Functions
Formula Auditing
Protecting Excel Worksheet and Workbook
What-if Analysis Tools
As the founder of Nikkyani Academy. 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 ONE course where you can learn Microsoft Excel - Advanced Excel Formulas & Functions,Â PivotTable, PivotChart and Power Pivot that you need to know to become an absolute Excel Hero, you've found it.
See you in the course!
Nikk ( Founder, Nikkyani Academy)

*NOTE: Full course includes downloadable resources, course quizzes and lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021 & Office 365.

Who this course is for:
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.

User Reviews

Rating

average 0

Total votes0

Focused display

Hi, My name is Nikk. My online institution name is Nikkyani Academy.I have over ten years of experience in teaching various subjects.Now I am continuing my teaching passion in Udemy.My talent is taking complex subjects and making them simple to learn.I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery.Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy.

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.