Microsoft Excel - Beginner to Advanced in MS Excel

Name: Microsoft Excel - Beginner to Advance in MS Excel
Price: 9.99 USD
Rating: 3.8 (3 reviews)
Author: Fayaz Fizoolie

Become an Excel expert with this beginner to advanced course

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Fayaz Fizoolie

architecture icon Office Productivity,Microsoft,Excel

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint 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 - Beginner to Advanced in MS Excel

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

Fundamental Concepts in MS Excel
12 Lectures

Basic Functions and Formulas in Excel
7 Lectures

Hyperlink and Password Protection
2 Lectures

Advance Concepts and Functions
19 Lectures

Conditional Formating
5 Lectures

Tables, Pivot Tables & Power Pivot
7 Lectures

More Advance Concepts & Functions
4 Lectures

Excel Dashboard
11 Lectures

Instructor Details

Fayaz Fizoolie

My name is Fayaz Fizoolie. I am a fully qualified ACCA Chartered Accountant. Also, I am eligible to do a first-class degree in Applied Accounting offered by Oxford Brookes. I have been using Excel for almost 12 years. As you know, we Accountants use Excel very often for various purpose. I have used excel for book-keeping, preparing reconciliations, preparing final accounts and for creating various other reports. With the experience and exposure of using MS Excel, its important functions and techniques to speedup any workflow, I created this course. This course will enable to students to master excel in a very short time span. What I learnt in 12 years, you can learn the same in a very short period.