Excel Introduction

In today’s workplace, Microsoft Excel is the de facto tool for working with data on the desktop. Knowing how to leverage Excel enables you to simplify complex tasks, essential to daily work responsibilities. In this introductory course, you gain the skills needed to create Excel worksheets, develop formulas and apply sophisticated formatting to capture and present your data.

Course Topics

Excel Basics

starting and exiting Excel • the Excel screen • the Office Ribbon • the Quick Access Toolbar • the Backstage view • Using Tell Me (Excel 2016)

Creating Simple Worksheets

starting, opening and closing workbooks • the cell pointer • moving around the worksheet • entering and editing data • AutoComplete • undo feature • entering values • changing columns widths/row heights • numeric values • AutoFit • Flash Fill

Worksheet Formatting

selecting cells • changing the font and size of data • adding borders and shading • using the format painter

Working with Calculations

writing simple formulae • copying formulae • using built-in functions • fill handle • creating formulae • AutoSum • using the formulae palette • order of precedence • quick data analysis

Printing Documents

viewing workbooks in print preview • changing the page orientation • enlarging and reducing data • centring data on the page • adding headers and footers

Copying & Moving Data

using drag and drop to rearrange data • using copy and paste • using the fill handle

Charts – time allowing (Sway alternative)

creating a chart • recommended charts • changing the chart type • adding data • improving the appearance of a chart

Follow on Courses

• Excel Intermediate
• Excel Advanced

company testimonial

“We have used Blue Novation for a couple of their advertised courses – feedback from the participants had been really positive and has helped the attendees in their current roles.  We have also used them at our own premises to deliver a range of Microsoft courses (at different levels).  The team is well organised and punctual, but more important their delivery style suits our staff and our organisational needs.  We would not hesitate to use them again.”

Sarah Ammar, Education Support Officer

ST Elizabeth Hospice