PrintDURATION: 1 day |
| TIME: 09:00 to 16:00 GMT |
Join our Microsoft Excel basic course for beginners. Improve your confidence using Excel and create formulas, update and analyse business data plus create simple but effective charts. IPSO FACTO is based at Fareham, between Southampton and Portsmouth, Hampshire, UK. However, our course can be delivered live online or onsite across the UK.
IPSO FACTO’s popular Microsoft Excel training course has been designed to improve the confidence of delegates when using Excel in the work place. It can be daunting to be faced with a spreadsheet full of company data, formulas and graphs and be asked to update it with new information. This course is relaxed and informal where you are encouraged to ask questions. Prior knowledge of Excel is not required but beneficial. We even try to have fun.
If you have to work with Excel updating company records, creating or amending simple formulas and updating charts, then this course will give you confidence to complete these tasks with ease. There’s plenty of time for questions and to gain confidence with Excel.
We’ll get back to you one you’ve completed our Excel training questionnaire.
Virtual classroom using Microsoft Teams: £700 for up to 8 delegates
On-site: £800 – up to 8 delegates
By the end of this course you will be able to:
Learn a few important facts about Excel – Techniques for selecting cells and data – Enter spreadsheet data – use shortcuts – Prepare the quick access toolbar – Saving to local – 365 SharePoint – OneDrive.
Learn common mistakes – Use different techniques to create formulas – BODMAS – AutoSum – Insert Function – Formulas tab – Percentage calculations – Validate simple formulas – Referencing cells – Managing sheets.
Learn how to use a range of formatting techniques to create structure in your spreadsheet.
Interrogating and manipulating lists of business data are important skills. Learn how to input data using shortcuts, manipulate data, and quickly answer a range of questions relating to the data.
Learn how to use important selection techniques – chart options – create and edit charts
Understand how to: Print lists – Print charts – use Page Break Preview
There are many useful time saving shortcuts included in the course
[ Excel level 2 ] [ Excel level 3 ] [ Data Analysis ] [ PowerBI ]
Please download a copy of the shortcut pdf’s for future use.
With the right training Microsoft Excel can become easy to use, and not that complicated scary tool that you have to use at work. Once you’ve learnt some of the basics, and how to quickly recover from mistakes, your confidence will start to grow. The more you use Excel the more you will gain confidence with this tool.
