Learn Excel Essentials

person icon Aamir Janjua

Learn Excel Essentials

Go from zero to hero with Excel!

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Aamir Janjua

architecture icon Excel,Office Productivity,Microsoft,Microsoft Office


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint 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!


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!
Learn Excel Essentials


Check out the detailed breakdown of what’s inside the course

Introduction to Excel
9 Lectures
  • play icon Course Overview 01:50 01:50
  • play icon Buying/Trialling an Excel License (If you don't have Excel!) 01:32 01:32
  • play icon First Steps into Excel 12:10 12:10
  • play icon Introduction to Formulas & Functions 12:30 12:30
  • play icon Order of Operations 10:57 10:57
  • play icon Relative and Absolute cell references 10:00 10:00
  • play icon More Formulas & Functions 13:24 13:24
  • play icon General Usage Features 07:39 07:39
  • play icon Build a Budget - Checkpoint 1 12:19 12:19
Exploring Excel
6 Lectures
Working with Data
7 Lectures
Advanced Features
4 Lectures
3 Lectures
2 Lectures
Wrap up
1 Lectures

Instructor Details

user profile image

Aamir Janjua

Hi, I’m Aamir I am a CIMA qualified Management Accountant (ACMA, CGMA), with extensive Leadership, Mentoring and Technical expertise in Finance and IT, as well as Teaching and Tutoring. I hold a BSc (Hons) Mathematics degree, with an MSc (Distinction) in International Accounting & Finance. I have utilised a wide array of software and tools in my diverse career, and the one constant that remains in demand across a huge range of professions - and you should know how to effectively use - remains Excel. I am passionate about teaching Excel skills to everyone, combining all the knowledge I have gained over the years, to benefit all comers: From those that are new to Excel or are from backgrounds that are not technical to those seeking a refresher or looking to enhance their current knowledge. My aim is to make it easy and understandable!

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best


Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us