Good
Advanced Excel Crash Course
Learn advanced Excel features, including pivot tables, macros, and VBA.
Office Productivity,Advance Excel
Lectures -135
Resources -1
Duration -8.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Excel is one of the most widely used pieces of software in companies throughout the world. You will build on the solid Excel foundations at all of the subsequent levels, including Basic and Intermediate Excel Skills, in this course.
Advanced Excel Crash Course Overview
You won't need to use any code to design effective processes thanks to this course. The modules are designed with the learners' needs and requirements in mind, and they will make it easier for them to construct processes.
The cost of the course and the required reading is affordable. Automate your routine and become 4 times more productive by learning the finest practices, shortcuts, and tactics in the business.
Who is this Course for?
Professionals working with large amounts of Data.
somebody looking to gain a tangible skill on your resume or gain a competitive advantage over your peer.
An analyst or the ones who work in consulting management, or supervisory roles.
Graduate students who aspire to become investment bankers, financial advisory professionals, consultants, etc.
Goals
Learn to become an advanced Excel user and reduce the complexity of spreadsheets.
Learn to manipulate data with calculations.
Learn to save time using Excel tricks and automate tasks using Excel.
Learn to create dynamic reports and use pivot tables.
Learn to unlock the power of dynamic formulas.
Learn to make custom formulas/functions.
Learn to set up special commands and build valuation models.
Learn to apply easy coding techniques and conquer logical operators.
Learn to master unique tips and build spreadsheets.
Prerequisites
The course works on all Microsoft Excel versions 2003, 2007, 2010, 2013, 2016. Of course the newer the better, but some features work the same in all the versions.
Basic understanding of Excel because we'll take you to the advanced level in this Excel Dashboard crash course.
![Advanced Excel Crash Course Advanced Excel Crash Course](https://d3mxt5v3yxgcsr.cloudfront.net/courses/2339/course_2339_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Downloadable Files
1 Lectures
-
Excel Practice Files
Ninja Shortcuts
10 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Business Math Calculations
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Formatting Tricks
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Formula Pre-Requisite
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Special Cell selections
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Sort & Filter
14 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Working with Dates
10 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Input
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Organising Data
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Pivot Table
18 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Lookup & Conditional Calculations
20 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Cleaning
16 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Conditional Formatting
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
What-If Analysis
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Yoda Learning](https://www.tutorialspoint.com/assets/profiles/138773/profile/200_8206-1570792210.jpg)
Yoda Learning
20,000 Classroom Students | 100,000+ Students Online
ex-KPMG, ex-J.P. Morgan | Chartered Accountant
Taught 12k+ participants across PwC, EY and Deloitte over last 10 years
I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time)
After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work.
If I’m going to succeed in my mission of helping 1 million professional in the next five years, I NEED YOU to succeed… I can’t reach my goal without helping you reach yours!
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)
Feedbacks
Great
Good
this class very excited about the
will see later
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)