Microsoft Excel - Intermediate Level

6-week course to update and improve your confidence and skills on Microsoft Excel.

The course will run One 2-hour class per week for the duration of 6 weeks.

Candidates will gain confidence in furthering their skills on Microsoft Excel. You will also learn to manage workbooks & worksheets more effectively, understand key Formulas & Functions as well as controlling access to your spreadsheets using password protection. You will also sort and display your data using Pivot Tables and Charts.

This course requires a good level of working with Excel and is not suitable for beginners.

After this course, candidates will feel more confident in performing daily tasks with this Intermediate course.

They will be able to:

• Understand the key concepts of Spreadsheets.
• Sort a range of data using Lookup functions.
• Create & use Pivot Tables and Pivot Charts
• Apply a range of Mathematical and Logical Functions and Formulas.
• Learn to Password Protect workbooks & certain elements
• Update your spreadsheets whilst automatically reading certain information clearly using Conditional Formatting.

What is Excel used for?

Excel is typically used to organize data and perform financial analysis.  This application is widely used across all aspects of business & personal functions, in companies from small to large and to your personal home accounts.  The Excel software program includes many functions, formulas and shortcuts that can be used to enhance its functionality.