Contact for queries :
020 3900 4072

Want to get a new job or become better at your existing one?

MS Excel is the highest used and most in demand tool for processing your data. When you acquire this skill, you will become a sought after employee. If you are proficient in Excel, you can see your business in a completely different light. 

So, if you are looking for a job or even developing your business, learning Excel Essential is for you.

This Microsoft Excel Course is intended for beginners and we will cover all the Excel essentials here.

After soft skills, having a good understanding of Microsoft Excel is one of the most sought after skills employers look for today. Make sure you can Excel in the competitive job market of the time and keep yourself valuable.

If you are a novice looking for starting with Excel, or you want to revise the basic excel formulas, you’ve come to the right place.

Why take this course?

Our instructor of this course, Alan Jarvis has been using Excel for over 20 years now. But when it comes to being good at something and being able to teach it, there is a huge difference. He has tens of thousands of students in his portfolio. And he held their hands from the beginner stage to mastery.

This course took over 4 months for him to produce. He tested it extensively with hundreds of people. If something didn’t work or wasn’t clear, he revised the course until it did. His mission was to make this the best possible course on Excel.

Who is this course for?

This Microsoft Excel Essentials: Level 1 Basics – Excel Made Easy course is suitable for Absolute beginners. Also those who want to build a solid foundation upon which they can build their skills. Anyone interested in working in this sector or who simply wants to learn more about the topic can benefit from this course. If you’re an individual looking to excel within this field then Microsoft Excel course is for you.

Course Requirements

The Microsoft Excel Essentials: Level 1 Basics – Excel Made Easy course is open to all. There is no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

How is the course assessed?

To successfully complete the course you have to pass an automated, multiple-choice test. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £5 and Hardcopy Certificate for £15.

Why choose the Institute of Accountancy:

  • High-quality e-learning study materials.
  • Step-by-step guideline.
  • 24/7 Access to the Learning Portal.
  • Recognised Accredited Qualification.
  • Study in a user-friendly, advanced online learning platform.
  • Excellent customer support.

Career Prospects

This Microsoft Excel Course could lead you to the way of transforming your life. Being an expert in Excel can unlock the door to many career opportunities such as:

  • Administrative Assistant
  • Data Analyst
  • Accountants
  • Financial Analyst
  • Retail Store Manager
  • Project Manager
  • Business Analyst
  • Financial Planner
  • Investment Banker
  • Corporate Development Officer

Course Curriculum

Intro
Level 1 Welcome FREE 00:02:00
Start Here- All TheBasic
Opening Excel, And Creating A Shortcut 00:04:00
The Anatomy Of A Workbook 00:15:00
A Quick Review Of What’s Where 00:06:00
Always Do This First! – Save Your New Workbook 00:02:00
Let’s Enter Some Data 00:02:00
Editing Data 00:02:00
Ooops I Made A Mistake – Undo and Redo 00:01:00
Changing Appearance Of Text With Formatting – Fonts 00:09:00
A Quick Word On Formatting 00:01:00
Formatting Text – Alignment 00:03:00
Saving Time With AutoFilling Sequences 00:05:00
NEW! – POWER USER – Adding Your Own Lists To Autofill 00:04:00
Saving Time with Format Painter 00:03:00
Changing The Column Width 00:04:00
Tidy Large Titles With Merge And Centre 00:03:00
A Couple Of Shortcuts For Entering Data 00:04:00
Doing The (Simple) Math
Sums – The Old Fashioned Way! 00:03:00
Sums – Using Autosum 00:06:00
Copying Formulas 00:03:00
SUMming Horizontally 00:03:00
Basic Formulas – Subtraction 00:02:00
Basic Formulas – Multiplication 00:02:00
Basic Formulas – Division 00:01:00
Average Function 00:03:00
The Order Of Mathematical Operation 00:07:00
POWER USER – Evaluate Formula 00:05:00
Rearranging Things
Inserting New Columns And Rows 00:06:00
Moving Existing Columns And Rows 00:02:00
Cutting, Copying, Inserting And Deleting 00:06:00
Hiding Columns And Rows 00:03:00
Formulas: Learning The Clever Stuff
ROUNDing Functions 00:06:00
Formatting Numbers 00:02:00
A Primer In Building Complex Formulas 00:03:00
Buliding a Compex Formula 00:04:00
A Few more Essentials
Sorting 00:04:00
Wrapping Text And Soft Enter 00:04:00
Adding A New Worksheet 00:01:00
Creating A Simple Chart 00:04:00
Adding Borders 00:03:00
Customizing the Quick Access Toolbar 00:02:00
Simple Printing 00:04:00
Freezing For An Easier View 00:04:00
Getting Help 00:02:00
Filters 00:06:00
Highlighting Cells 00:04:00
Closing 00:02:00
Bonus Section: Absolute and Relative Cell References 09:16
A1 Style – Relative Relative 00:02:00
$A$1 Style – Absolute Absolute 00:03:00
$A1 Style – Absolute Relative 00:02:00
A$1 Style – Relative Absolute 00:02:00
Additional Resources
Resources :Microsoft Excel Essentials: Level 1 Basics – Excel Made Easy 00:00:00

Course Reviews

4.5

4.5
1 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • £319.00 £18.00
  • UNLIMITED ACCESS
  • Course Certificate
  • Number of Units52
  • Number of Quizzes0
  • 3 hours, 6 minutes
  • CPD Accredited
  • Gift this course

Instructors

1 STUDENTS ENROLLED

    Our Students Say..

    Google Rating
    5.0