Welcome to Learn Excel Essentials
Watch the video below for a summary of why this course can streamline your learning AND, more importantly, give you the confidence to skillfully use Excel
Why should you enroll on this course?
If you want to enrich your CV, and enhance your analytical capabilities, with the most widely used spreadsheet software in the world today - this is the course for you.
The Excel skills you learn here will be invaluable to your long-term success - in the fields of Finance, Data Analysis, and Personal Finance Management.
Excel is also heavily and increasingly used for work in HR, Project Management, and Commercial Analysis amongst many other areas.
This course provides an efficient, organised and effective solution to streamline your learning.
This is a practical course, taught in a straightforward and easy to understand manner.
Take a look for yourself at the curriculum and preview videos available below.
What will you learn?
This course is designed to upskill anyone - with no prior knowledge of Excel required - to having complete confidence in using Excel succesfully.
You will learn the core functionality and usage of Excel, from the ground up, and build your knowledge and skill through videos, exercises and quizzes.
The content is designed to build your skill up from the very basics, and additionally uses Checkpoints after each Section of new material to guide you in building a budget, incorporating the new tools and features you've learnt to see how they can be used for a practical, real-world, spreadsheet solution.
Course Curriculum
15 Great Reasons to Join Learn Excel Essentials
- Follow along and practice, at your pace, with over 6 hours of on-demand video to maximise your learning
- Learn to use all core Excel capabilities effectively - with no prior experience required
- Develop valuable skills and techniques to analyse and visualise data in Excel
- Understand the 'why' and not just the 'how' for the tools and techniques you learn
- Learn to use conditional formatting, data validation, workbook protection amongst many other useful features
- Learn to use Pivot Tables and Pivot Charts effectively
- Learn to use lookups, index, match and other advanced functions
- Gain crucial practice via exercises
- Test your knowledge with quizzes
- Create an evolving budget spreadsheet at checkpoints following each Section of new material - incorporating newly learned tools and techniques
- Learn how to approach solving problems in Excel to maximise your time with efficient solutions
- Learn how to effectively use key techniques that are Essential in the areas of Finance and Data Analysis - Including Reconciliations, Effective Data Set-up and Reference Functions
- Learn how to perform actions quicker using Keyboard Shortcuts, including the best ones to master
- Learn using the most up-to-date Excel version, and to use the latest functionality
- Complete a Project task at the end of the course that tests multiple elements of your learning as a challenge
Hi, I’m Aamir
I am a BSc (Hons) Mathematics graduate, with an MSc (Distinction) in International Accounting & Finance. 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 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!
FAQ
How long do I have access to the course?
Permanent access!
What level of pre-requisite knowledge is required?
No previous experience required - the course will bring you up to speed with the basics within a couple videos.
What software / tools are required?
You can simply watch the videos, however the introductory videos will explain how you can obtain Excel (including a potential Free Trial of Excel) - highly recommended in order to follow along and maximise your learning.
What version of Excel is used?
This course uses the latest Office 365 version of Excel.
Have an earlier version? No problem - Excel 2013 and beyond is suitable – even earlier versions will be similar enough to learn easily with.
I've got feedback / queries, how do I send these to you?
Send an email to hello@excelonlinelearning.com
Learn the tools Excel has to offer
From formulas and formatting to shortcuts and graphs - all the core components you need are covered
Develop effective techniques
Learn how to use the options Excel offers efficiently to streamline your spreadsheet solutions
Practical Learning
Ingrain the skills you need by following along and practising alongside the video content