Microsoft Excel Introduction

Course description

Designed for those who are new to spreadsheets. In this one-day tutor-led course delegates will learn how to create a worksheet from scratch, enter formulas to perform calculations on rows and columns of figures, format the worksheet for printing and will be introduced to the concept of working with multiple sheets. Course Content Introduction What is Microsoft Excel? Screen Layout The Home Ribbon Creating a New Workbook Navigating the Worksheet Selecting Ranges of Cells Entering Data Editing Data Saving Workbooks Working with Sheets Creating New Sheets Renaming Sheets Deleting Sheets Viewing the Spreadsheet Normal View Page Break Preview Print Layout View Full Screen View Splitting the Screen Freezing Panes Arranging Workbooks Formatting Data Formatting Cells Formatting Rows and Columns Printing Spreadsheets Print Areas Opening Existing Workbooks Formulae Creating Custom Formulae BODMAS Filling Formulae Relative references Functions AutoSum and other Auto Functions Creating Charts using Microsoft Excel Creating a Chart using a Keyboard Shortcut Creating Charts using the Insert Ribbon Modifying a Chart