Learn Excel Essentials

Go from zero to hero with Excel!

Updated on Sep, 2023

Language - English

30-days Money-Back Guarantee

Training 5 or more people ?

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
4 Lectures
Exercises
3 Lectures
Project
2 Lectures
Wrap up
1 Lectures

Instructor Details

Aamir Janjua

(ACMA, CGMA)
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.