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

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


This course is for anyone who's interested in this topic and wants to learn more about it. This course will also help you gain potential professional skills.

No prior qualifications are needed to take this course.

You can study this course from wherever and whenever you want. You can study at your own pace and from any device. Just log in to your account from any device and start learning!

Yes, there is a test at the end of the course. Once you’ve completed all the modules of the course, you will have to give a multiple-choice test. The questions will be based on the topics of the modules you studied. And of course, you can take the test at any time, from any device and from anywhere you want.

Don’t worry if you fail the test, you can retake it as many times as you want.

You don’t have to wait a minute after your payment has been received, you can begin immediately. You will create your login details during the checkout process and we will also send you an email confirming your login details.

We make the payment process easy for you. You can either use your Visa, MasterCard, American Express, Solo cards or PayPal account to pay for the online course. We use the latest SSL encryption for all transactions, so your order is safe and secure.

After you complete the course, you’ll immediately receive a free printable PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! You may have to wait for 3 to 9 days to get the hard copy certificate.

Course Reviews


iStudy is a brand of Adams Academy Inc. Ltd. Company Number 10647280, England and Wales, VAT No. GB-267018794

11 Floor, 15 St Botolph Street, London EC3A 7BB
020 3900 4072

Last Tweets

Validate your certificate

Coming soon