Understanding of Excel Workshop

What is the aim of this course?
This course examines the skills necessary to create, edit and enhance spreadsheets. It includes a study of the automated tasks commonly used for data manipulation, calculation and data analysis. The course is designed as a practical workshop, allowing the participant to receive hands-on experience of all topics covered.

What will I learn?
MS Excel is a powerful and versatile spreadsheet tool which enables users to store, manipulate and analyse data quickly and easily. It includes a variety of business features which automate many common tasks, making it an essential application for businesses of all sizes.

The main objective of this course is to enable participants to create effective spreadsheets and apply the automated applications associated in their everyday business activities. The content will be relevant to Excel 2007, 2010 and 2016.

By the end of the course you will have an understanding of the following topics:

Getting Started

• Starting MS Excel
• MS Excel Help Facility

Building and Editing Workbooks

• Entering Data Cells
• Rows & Columns
• Series & Lists
• Naming Cells & Ranges Copying, Inserting & Deleting Worksheets

Formatting

• Fonts & Styles
• Cell Format & Comments
• Conditional Formatting

Formula

• Simple Calculations

Is it for me?

If you wish to learn the essentials of using MS Excel with a view to its application in a business environment then this course is for you.

For practical purposes a PC or laptop is required

This workshop will take place on Zoom – a link will be sent to you for you to join on the day.

Max 2 per business.

We look forward to you joining us on Zoom!