Excel Essentials Course
Go from zero to hero with Excel!
Updated on May, 2024
Language - English
Excel,Office Productivity,Microsoft,Microsoft Office
Lectures -32
Resources -11
Duration -6 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Excel Essentials is a course designed for complete beginners to excel - no previous knowledge required! This course will provide you the foundation you need to work successfully with Excel for a variety of great job titles. Want to become a data analyst? Work in Finance? If so, this course is perfect for you.
Excel is a powerful tool that provides great opportunities in the fields of Finance, IT, Project Management and more - dealing with data is an everyday occurrence in so many roles now, and Excel is the go-to tool - so you should separate yourself from the competition and know how to really use it with confidence!
It also is a great refresher and chance to skill up further for those that have used Excel previously, and will bring you up to speed quickly and then show you what you've been missing with new tips and tricks!
Goals
What will you learn in this course:
- Learn to confidently use Excel, from scratch!
- Learn to use formulas skillfully, including vlookups, SUMIFs, INDEX, and more!
- Understand and apply usage of the most useful Excel features!
- Apply practical application of Excel in building a budget tool!
- An end of course challenge to apply the skills you've learnt - with a worked solution!
Prerequisites
What are the prerequisites for this course?
- No prerequisites!
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction to Excel
9 Lectures
-
Course Overview
01:50
01:50
-
Buying/Trialling an Excel License (If you don't have Excel!)
01:32
01:32
-
First Steps into Excel
12:10
12:10
-
Introduction to Formulas & Functions
12:30
12:30
-
Order of Operations
10:57
10:57
-
Relative and Absolute cell references
10:00
10:00
-
More Formulas & Functions
13:24
13:24
-
General Usage Features
07:39
07:39
-
Build a Budget - Checkpoint 1
12:19
12:19
Exploring Excel
6 Lectures
Working with Data
7 Lectures
Advanced Features
4 Lectures
Exercises
3 Lectures
Project
2 Lectures
Wrap up
1 Lectures
Instructor Details
Aamir Janjua
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