Learn Excel Essentials

person icon Aamir Janjua

Buy Now

Learn Excel Essentials

Name: Learn Excel Essentials
Price: 9.99 USD
Rating: 5.0 (1 reviews)
Author: Aamir Janjua

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

Add to Cart Buy Now

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!

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

(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.