Microsoft Excel training
Microsoft Excel training courses to develop your skills and productivity
Excel training advanced and basic levels
- use Excel formulas,
- Excel if statement,
- merge cells
- split cells
- excel budget templates
Useful practical skills you can use straight away.
Our Excel training courses have been designed to support beginners and intermediate users in developing improved Microsoft Excel skills.
Excel training will extend how much you can do with excel software, with less mistakes and more accurate calculations. Developing key excel skills (excel formulas, excel if statements, exccel merge cells) will make a dramatic difference on how efficiently you can work with excel spreadsheets, and save you a lot of time.
Level 1: Excel Beginner
Who for?
This course is for anyone who has no experience or very limited use of Excel (might have basic experience editing data but are not confident creating calculations and charts).
Anyone in the organisation who wishes to optimise their use of Excel software.
Info:
Duration: 1day
Content
At the end of the training you will be able to:
- Create, save, close and print spreadsheets
- Insert and delete rows or columns in your spreadsheet
- Create and use formulas in your spreadsheet: sum feature
- Sort large databases into order and filter to show only the data you need
- Use conditional formatting to change the look of the numbers and text, add comments, layout text with merged cells, use cell styles, change the layout for printing.
- Visually represent numbers and text (as a chart) in your spreadsheet, to make them stand out and easy to understand
Level 2: Excel Intermediate
Who for?
This intermediate Excel training course is for anyone who has a basic working knowledge and use of Excel to create and manipulate spreadsheets and perform basic calculations.
Learners must have used Excel before and be familiar with using basic formulas for calculations.
Anyone in the organisation who wishes to optimise their use of Excel software.
Info:
Duration: 1 day
Content
At the end of the training you will be able to:
- Create formulas using different formats
- Paste special, copy your Excel spreadsheet to a Word document and have any changes made in Excel updated in the Word document
- Use functions such as average, minimum and maximum to create statistical information
- Use Conditional Formatting to automatically change the look of cells depending on their value
- Create a calculation based on a condition, such as add a 10% additional bonus in salary to all staff who have done over time
- Count entries IF they meet a condition. e.g. count the number of customers who live in Leeds
- Create and work on more than one worksheet and group them to make changes simultaneously
- Link formulas across Worksheets
- Protect cells and data from deletions or changes
- Create a basic Pivot Table