Please ensure Javascript is enabled for purposes of website accessibility

Microsoft Excel Introduction

Square One

This course is delivered by Square One
Online with Tutor

About this course

This introduction course designed by leading training experts; we will guide you through all of the key basic features within Spreadsheets to help you become proficient on a day-to-day basis. This course is the ultimate essential guide to beginners on Spreadsheets for those who are self-taught or have little to no experience of using the software. During this course you can expect to leave feeling confident in; how to create formulas, format, enter, edit and analysis data quickly and  confidently. The perfect course for those looking to use Spreadsheets in their day-to-day work.

Topics covered:

  • Getting started with Spreadsheets: Introduction; Navigating the Screen, environment, and Ribbon; Tips and Tricks for Selection and Movement around the screen
  • File Management: Creating and Saving Workbooks; Opening Workbooks
  • Data Input and Selection; Typing and Formatting for Text, Dates and Numbers; Selecting Cells, Rows and Columns using the Mouse and Keyboard shortcuts
  • Using Functions: Using the Sum, Average, Min, Max, Count Functions; Understanding and working with the Function Wizard
  • Working with Dates: Date Calculations; Formatting Dates
  • Copying and Moving Data/Formulae: Using Cut, Copy and Paste; AutoFill; Drag and Drop; Copy and Drop
  • Editing Worksheets: Adding and Deleting Rows and Columns; Sizing Rows and Columns; Hiding/Unhiding Rows and Columns
  • Formatting Worksheets: Working with Fonts, Sizes and Colours; Adding Borders and Fill Colour to Cells; Aligning the Content of a Cell; Applying Number Formatting; Using the Format Painter; Merge and Unmerge Cells
  • Working with Large Worksheets: Freezing Panes; Working with Split Pane View; Filters, Sort; Find and Replace
  • Printing: Using Print Preview; Setting the Print Range; Sizing Spreadsheets to Fit; Working with Margins, Headers and Footers and other useful print settings
  • Multiple Sheets: Creating new Sheets; Colouring Sheet Tabs; Navigating Sheets; Deleting Sheets
  • Charts and Graphs: Creating Charts and Graphs alongside data; Creating Charts and Graphs on a new sheet; Changing the Chart
    Types; Basic Formatting of Charts and Graphs.

Prerequisites

Delegates will need to be familiar with using personal computers and should have experience using a keyboard and mouse. We would expect delegates to know how to: launch and close applications, navigate, save, and open files

Course length:

1 day

Course cost is £234 per delegate
Course cost with Accelerate grant is £104.40 per delegate

Register interest for this course today

Chat Bot Logo
Cheshire and Warrington