Tutorialspoint

#May Motivation Use code MAY10 for extra 10% off

Microsoft Excel Course- Beginner to Advanced

person icon Fayaz Fizoolie

4.4

Microsoft Excel Course- Beginner to Advanced

Become an Excel expert with this beginner to advanced course

updated on icon Updated on May, 2024

language icon Language - English

person icon Fayaz Fizoolie

English [CC]

category icon Office Productivity,Microsoft,Excel

Lectures -76

Duration -13.5 hours

4.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

This course will teach you Microsoft Excel from beginner to advanced level in the shortest time possible. The course is designed to be easy to understand and follow, even if you have no prior experience with Excel.

Microsoft Excel Course Overview

This course is perfect for anyone who wants to learn Excel or improve their Excel skills. Whether you are a student, a business professional, or just someone who wants to learn a new skill, this course is for you. The course is divided into 6 sections:

  • Section 1: Introduction to Excel

  • Section 2: Formatting in Excel

  • Section 3: Formulas and Functions

  • Section 4: Data Validation and Filtering

  • Section 5: Pivot Tables and Dashboards

  • Section 6: Visualizing Data with Excel Charts

The course also includes 3 projects:

  • Project 1: Creating an invoice

  • Project 2: Getting information from external websites and creating charts from them

  • Project 3: Creating a dashboard

Goals

What will you learn in this course:

  • Creating and managing spreadsheets

  • Create a dashboard and analyze the data

  • Creating charts and graphs to visualize data

  • Share your work with others

  • Open, navigate, and use the Excel interface

  • Enter and format data

  • Learn to use formulas and functions

  • Use data validation and filtering

  • Create pivot tables and dashboards

  • Master Microsoft Excel, within the shortest time possible

  • More than 50 Vital Functions

  • Extract information from websites into MS Excel and create charts

Prerequisites

What are the prerequisites for this course?

  • This course was created with Excel 2019. All features will work in Excel 2010, 2013, 2016, and Microsoft 365 (Unless stated in the videos), and most will work in 2007.

  • Some features and techniques might not be available for Mac Users.

Microsoft Excel Course- Beginner to Advanced

Curriculum

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

Getting Started
1 Lectures
  • play icon Important Notice for Mac Users 01:02 01:02
Introduction to MS Excel
7 Lectures
Tutorialspoint
Fundamental Concepts in MS Excel
12 Lectures
Tutorialspoint
Basic Functions and Formulas in Excel
7 Lectures
Tutorialspoint
Hyperlink and Password Protection
2 Lectures
Tutorialspoint
Advance Concepts and Functions
19 Lectures
Tutorialspoint
Conditional Formating
5 Lectures
Tutorialspoint
Tables, Pivot Tables & Power Pivot
7 Lectures
Tutorialspoint
More Advance Concepts & Functions
4 Lectures
Tutorialspoint
Excel Dashboard
11 Lectures
Tutorialspoint

Instructor Details

Fayaz Fizoolie

Fayaz Fizoolie

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

Feedbacks

J

justingabb

e

It would be nice if you could download the sample data that is used in each of the tutorial sections.

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