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.
If you want to learn Microsoft Excel Course Online and have a basic understanding of Excel Essentials, this course is for you.
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 have a Microsoft Excel Course Certification in your CV or portfolio, this place is truly for you.
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 2 course is suitable for beginners to amateurs. After you take the decision of taking a Microsoft Excel Course Online, you probably want a course that will hold your hand as you go from beginner to advanced level. 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 Essentials: Level 2 course is for you.
The Microsoft Excel Essentials: Level 2 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 Microsoft Excel Course Certification 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.
A Microsoft Excel Course Online could take you a long way in terms of your career. Being an expert in Excel can unlock the door to many career opportunities such as:
- Administrative Assistant
- Data Analyst
- Financial Analyst
- Retail Store Manager
- Project Manager
- Business Analyst
- Financial Planner
- Investment Banker
- Corporate Development Officer
|Welcome To The Course|
|Project 1 - Creating A Data Entry Screen To populate Multiple Template|
|Proof Of Concept||00:05:00|
|Creating Our Data Entry Screen||00:04:00|
|(Custom) Formatting Dates And Time||00:06:00|
|Simple Calculations With Time||00:03:00|
|More (Useful) Calculations With Time||00:08:00|
|It’s About Time (And Dates)||00:08:00|
|Adding With Time||00:04:00|
|Creating A Template From An Image||00:12:00|
|Importing A Template From An Existing Excel File||00:02:00|
|Converting Time To A Decimal||00:06:00|
|A Little Bit Of Simple Data Entry||00:03:00|
|Simple Conditional Formatting For A Cleaner View||00:05:00|
|Calculating Time Out Of House Using Travel Time||00:05:00|
|Simple Logical Testing And Nested Logical Testing||00:08:00|
|Building Text Strings With A Formula||00:12:00|
|Before We Move OnAccessing The Developer Ribbon||00:01:00|
|A Tick Box Exercise (Of Sorts)||00:07:00|
|Auto-populating Check Boxes||00:12:00|
|PRACTICE EXERCISE 1 – Time To Add A New Entry||00:02:00|
|Defining A Working Area, And Protecting Your Work||00:05:00|
|PRACTICE EXERCISE 2 – Set Up A Working Area, And Limit User Entry||00:01:00|
|Project 2 - Building A Database With Excel|
|Step 1 – Get Some Data In, And Split It||00:04:00|
|Using Data Validation To Get The Right Input||00:04:00|
|Let’s Build Our Database!||00:06:00|
|Importing Data From A Text File||00:02:00|
|Importing Data From A Word File||00:03:00|
|Pulling Data From Multiple Sources||00:04:00|
|Using OTHER Look-Ups To Look Up!||00:05:00|
|LOOKUP From A LOOKUP With No Intermediary Step||00:02:00|
|Data Arrays Don’t Have To Start At A1||00:03:00|
|Some Common Reasons VLook-Ups Fail||00:06:00|
|One Inherent Flaw In Vlook Up||00:01:00|
|POWER USER – A Breakdown Of Looking Up Backwards||00:07:00|
|POWER USER – The Other Way Of Looking Up Backwards||00:07:00|
|Backwards Look-Ups In Action||00:04:00|
|POWER USER – Dealing With Inconsistencies In User Entry||00:08:00|
|POWER USER – Fuzzy VLOOKUPs||00:04:00|
|Power User – VLOOKUPs With Multiple Inputs||00:10:00|
|Power User – Looking Up Multiple Inputs Using An Array Formula||00:05:00|
|POWER USER – The Holy Grail – How To Return Multiple Values From A Single Look Up||00:13:00|
|What To Look For When THAT Formula Didn’t Work||00:04:00|
|The Fastest Way To Modify Your Column Numbers||00:07:00|
|POWER USER – Vlook-Ups With Moving Columns||00:03:00|
|Putting It All Together||00:10:00|
|The Finishing Touch – How Many Records Did I Find||00:05:00|
|Project 3 - Named Ranges|
|A Simple Static Named Range Using A Single Cell||00:04:00|
|Creating A Named Range Using A Range Of Cells||00:03:00|
|Using Row Labels To Name Multiple Ranges||00:03:00|
|POWER USER – A Magic Trick Using Row And Column Labels||00:05:00|
|POWER USER – Dynamic Named Ranges||00:08:00|
|POWER USER – What To Do With Dynamic Names Ranges With Titles||00:05:00|
|3035 – POWER USER – Dynamic Charts||00:12:00|
|3040 – Horizontal Dynamic Named Ranges For Charts||00:11:00|
|Project 4 - What Can I have For Dinner?|
|What This Project is ACTUALLY Used For!||00:01:00|
|Hyperlinking To A Different Sheet In The Same Workbook||00:04:00|
|Creating Our First Macro||00:06:00|
|Assigning A Macro To A Button||00:04:00|
|Creating A List For Our Dropdown Using A Dynamic Named Range||00:02:00|
|Using A Conditional Format To Know When A Value Is Missing||00:05:00|
|Copying Conditional Formats And Creating Our Drop-Downs||00:03:00|
|Building Our FormulaINDIRECT Function||00:03:00|
|Building Strings For Indirect Sheet And Cell References||00:07:00|
|It’s A One Or A Zero||00:03:00|
|Working The Percentages And Adding Traffic Lights||00:04:00|
|POWER USER – The HYPERLINK Function (And Problem)||00:03:00|
|PRACTICE EXERCISE 1 – Fill In The Blanks||00:01:00|
|PRACTICE EXERCISE 2 – Pretty It Up (With A Macro)||00:02:00|
|PRACTICE EXERCISE 3 – Create A VLOOKUP Using A Built String With INDIRECT||00:02:00|
|Project 5 - Using Excel For Gantt Charts....Timelines And Project Plans!|
|Creating A Gantt Chart Using A Worksheet||00:08:00|
|Building The First Part Of Our Logical Test||00:04:00|
|Multiple Logical Tests At Once Using AND||00:08:00|
|Conditional FormattingWhere The Magic Happens||00:06:00|
|Gantt Charts Using The Built In Charting Tools||00:05:00|
|Gantt Charts With Different Colors For Different Criteria||00:08:00|
|Bonus Section - Just For Fun|
|How I Created Randomly Generated License Plate Numbers!||00:07:00|
|Student Questions Answered!|
|Calls Text Data – Or How To Return a Column Title If Value is 1||00:07:00|
|Calls Text Data 2 – This Time Using Text!||00:09:00|
|Extracting Phone Numbers From A Cell||00:03:00|
|What Is The CHOOSE Function Really Used For||00:15:00|
|Casing And Text Functions||00:07:00|
|Dynamic Charting From A Drop Down||00:10:00|
|SUMIF With Dynamic Sum Range||00:06:00|
|VLOOKUPs With Pictures!||00:05:00|
|Data Validation With Dependent Dropdowns||00:04:00|
|Data Validation With Dependent Dropdowns (Dynamic Named Range Workaround)||00:09:00|
|Kinda A Vlookup From 2 Drop-down Lists||00:07:00|
|The Middle Name Problemand Solution!||00:09:00|
|Finding Matches, And Counting Entries||00:08:00|
|Fee Calculator, or LOOKUPs That Are True, Not False||00:06:00|
|Resources : Microsoft Excel Essentials: Level 2 – Intermediate/Advanced||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.