Microsoft Excel Course - Beginner to Advanced
Become an Excel expert with this beginner to advanced course
Office Productivity,Microsoft,Excel
Lectures -76
Duration -13.5 hours
30-days Money-Back Guarantee
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
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
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 Microsoft Excel Course - Beginner to Advanced](https://d3mxt5v3yxgcsr.cloudfront.net/courses/4818/course_4818_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
Getting Started
1 Lectures
-
Important Notice for Mac Users 01:02 01:02
Introduction to MS Excel
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Fundamental Concepts in MS Excel
12 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Basic Functions and Formulas in Excel
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Hyperlink and Password Protection
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Advance Concepts and Functions
19 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Conditional Formating
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Tables, Pivot Tables & Power Pivot
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
More Advance Concepts & Functions
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Excel Dashboard
11 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Fayaz Fizoolie](https://www.tutorialspoint.com/assets/profiles/350380/profile/200_78525-1624680040.jpg)
Fayaz Fizoolie
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)