Learn Excel Essentials
Go from zero to hero with Excel!
Updated on Sep, 2023
Language - English
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!
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!
What are the prerequisites for this course?
- No prerequisites!
Check out the detailed breakdown of what’s inside the course
Introduction to Excel
- 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
Working with Data
Aamir Janjua(ACMA, CGMA)
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video CoursesView More
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video CoursesSubscribe now
Master prominent technologies at full length and become a valued certified professional.Explore Now