Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Microsoft Excel - Advanced Excel Formulas & Functions

person icon Nikhil Lakhyani

4

Microsoft Excel - Advanced Excel Formulas & Functions

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

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Nikhil Lakhyani

category icon Excel Formulas and Functions,Excel,Excel Pivot,Excel Charts,Microsoft Excel

Lectures -57

Resources -2

Quizzes -9

Duration -3 hours

4

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course 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)

Goals

What will you learn in this course:

1. Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch.

2. Automate, streamline, and completely revolutionize your workflow with Excel Advance formula and function like Name Ranges, Vlookup, Hlookup and many more.

3. Learn to Prepare Microsoft Excel data for PivotTable.

4.Learn customization, formatting, filtering and many more in PivotTable.

5. Learn how to Create and manage PivotTable calculations.

6. Learn how to create Pivot chart base on PivotTable.

7. Learn powerpivot to Create and manage Excel Data Models to pull in data from multiple sources and then creating relationship between them.

Prerequisites

What are the prerequisites for this course?

1. You must have basic Microsoft Excel knowledge.

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

Microsoft Excel - Advanced Excel Formulas & Functions

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
2 Lectures
  • play icon Introduction 01:54 01:54
  • play icon Course Excercise Files 00:56 00:56
Excel PivotTables
11 Lectures
Tutorialspoint
PowerPivot
5 Lectures
Tutorialspoint
Working With Large Set Of Excel Data
6 Lectures
Tutorialspoint
Working With Excel Conditional Function
9 Lectures
Tutorialspoint
Working With Lookup Function In Excel
6 Lectures
Tutorialspoint
Working With Excel Text Based Functions
4 Lectures
Tutorialspoint
Working With Formula Auditing In Excel Worksheet
5 Lectures
Tutorialspoint
Protecting Excel Worksheets And Workbooks
4 Lectures
Tutorialspoint
Using "What-If Analysis" Tools In Excel
4 Lectures
Tutorialspoint
Working With Color Cells
1 Lectures
Tutorialspoint

Instructor Details

Nikhil Lakhyani

Nikhil Lakhyani

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515