Project Based Microsoft Excel Course For Beginners
The best Microsoft Excel course for everyone who wants to learn Microsoft Excel 2016 from the beginning
Updated on May, 2024
Language - English
Excel,Microsoft,Office Productivity
Lectures -29
Resources -1
Duration -2.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
What to expect:
If you have been looking for a suitable Excel course for a complete beginner, you have come to the right place.
This course has helped a lot of students kick-start their analytical skills, and I believe it will do the same for you. I poured out my heart into this course because I am not withholding any knowledge from you.
Course Contents
This course is made up of 5 sections and a duration of 2 hours 30 minutes.
Section 1: Introduction
From the scratch, you will be guided on how to customize your quick access toolbar to keep your tools handy and also made to understand the work interface.
Section 2: Getting Started with Excel
Here we start by showing you how to launch the program and as well explain the pre-made templates
Section 3: References and basic functions
Here we covered the basic functions and also explained the different methods of referencing cells.
Section 4: Conditional Functions
Here we covered the very basics of conditional or logical functions in Excel that is foundational for advanced courses
Section 5: PivotTables
Here we introduced PivotTables to how to create and modify PVT
I decided to bring up the course for beginners first because I believe in learning from scratch and gradually.
Who this course is for:
- This course is for everyone who is eager to learn new things
- It is for those interested in data analysis, accounting, and management
- It is necessary for everyone to take this course
Goals
What will you learn in this course:
- At the end of this course, you will make yourself more employable in different organizations
- At the end of this course, you should confidently embark on any Excel-related projects
- At the end of this course, you will know all the basic things required of an Excel student
- At the end of this course, you should be able to build different project dashboards with Excel
- At the end of this course, you should be able to build a personal budget template with Excel
- At the end of this course, you should be able to use Excel and track your monthly expenditure
- At the end of this course, you should know how to use Excel and plan your daily, weekly, monthly, and yearly budget
Prerequisites
What are the prerequisites for this course?
- No previous knowledge require.
- It is for absolute beginners
- Give your time, PC, and an internet connection to take this course
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
3 Lectures
-
Course Overview
01:51
01:51
-
Why Microsoft Excel is important for everyone
05:10
05:10
-
How you can make the best from this course
05:46
05:46
Microsoft Launching and Interface
4 Lectures
Cell Formatting, Numerical Values, Referencing and Intro to Basic Function()
13 Lectures
Excel Conditional and Intermediate Function()
6 Lectures
How to create PivoTables in Excel
2 Lectures
Congratulations!
1 Lectures
Instructor Details
Mark Asogwa
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
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
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now