Microsoft Excel - Advanced Excel Formulas & Functions
Master Microsoft Excel - Advanced Excel Formulas & Functions, PivotTable, PivotChart and Power Pivot
Excel Formulas and Functions,Excel,Excel Pivot,Excel Charts,Microsoft Excel
Lectures -57
Resources -2
Quizzes -9
Duration -3 hours
30-days Money-Back Guarantee
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
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
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 Microsoft Excel - Advanced Excel Formulas & Functions](https://d3mxt5v3yxgcsr.cloudfront.net/courses/16993/course_16993_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
2 Lectures
-
Introduction 01:54 01:54
-
Course Excercise Files 00:56 00:56
Excel PivotTables
11 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PowerPivot
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Working With Large Set Of Excel Data
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Working With Excel Conditional Function
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Working With Lookup Function In Excel
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Working With Excel Text Based Functions
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Working With Formula Auditing In Excel Worksheet
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Protecting Excel Worksheets And Workbooks
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Using "What-If Analysis" Tools In Excel
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Working With Color Cells
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Nikhil Lakhyani](https://www.tutorialspoint.com/assets/profiles/745182/profile/200_2481326-1697622449.jpeg)
Nikhil Lakhyani
Hi, Myself Nikhil Lakhyani.
I have over ten years of experience in teaching various subjects.
Now, I am continuing my teaching passion in Tutorials Point.
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.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual 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 Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)