Tutorialspoint

#May Motivation Use code MAY10 for extra 10% off

Advanced Excel Crash Course

person icon Yoda Learning

3.9

Advanced Excel Crash Course

Learn advanced Excel features, including pivot tables, macros, and VBA.

updated on icon Updated on May, 2024

language icon Language - English

person icon Yoda Learning

English [CC]

category icon Office Productivity,Advance Excel

Lectures -135

Resources -1

Duration -8.5 hours

3.9

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

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

What will you learn in this course:

  • 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

What are the prerequisites for this course?

  • 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

Curriculum

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

Downloadable Files
1 Lectures
  • play icon Excel Practice Files
Ninja Shortcuts
10 Lectures
Tutorialspoint
Business Math Calculations
7 Lectures
Tutorialspoint
Formatting Tricks
8 Lectures
Tutorialspoint
Formula Pre-Requisite
2 Lectures
Tutorialspoint
Special Cell selections
6 Lectures
Tutorialspoint
Sort & Filter
14 Lectures
Tutorialspoint
Working with Dates
10 Lectures
Tutorialspoint
Data Input
6 Lectures
Tutorialspoint
Organising Data
5 Lectures
Tutorialspoint
Pivot Table
18 Lectures
Tutorialspoint
Lookup & Conditional Calculations
20 Lectures
Tutorialspoint
Data Cleaning
16 Lectures
Tutorialspoint
Conditional Formatting
3 Lectures
Tutorialspoint
What-If Analysis
8 Lectures
Tutorialspoint

Instructor Details

Yoda Learning

Yoda Learning


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

Feedbacks

A

Akhil Khandelwal

e

Good

G

Grace Jerobon Choge

e

Great

S

SAI PRANEETH

e

Good

D

Dayakar

e

this class very excited about the

K

Kapil Singh Tomar

e

will see later

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