IT Courses - Basic Excel

Venue: Broomfield Hall
Hours: 7.00
Cost (£): 75.00

Course Overview

Microsoft Excel is the world's favourite spreadsheet application and has an incredible number of uses. 

Validated by Derby College, the Excel for Beginners workshop is designed to give individuals with little or no experience of Microsoft Excel the knowledge, skills and expertise to build practical, functional spreadsheets that aid productivity both in the workplace and at home.

Course Content

Section 1 – Introduction to Excel

  • The Anatomy of Excel
  • Opening, Closing and Saving Spreadsheets
  • File Formats
  • Saving and Using Templates

Section 2 – Editing Cells 

  • Overtyping
  • Editing data in the formula bar
  • In Cell Editing
  • Deleting Cell Contents
  • Find and Replace

Section 3 – Formatting Worksheets

  • Renaming and Navigating Worksheet
  • Rows and Columns
  • Hiding and Un-hiding Rows and Columns
  • Freezing Panes

Section 4 – Formatting Cells

  • Formatting Cells
  • Cell Styles
  • Using Cell Styles

Section 5 – Printing Spreadsheets

  • Print Preview and Print Setting
  • Margins
  • Scaling
  • Print Titles
  • Headers and footers

Section 6 – Understanding Formulas

  • Mathematical Operators
  • Calculating Percentages
  • AutoSum and The Fill Handle

Section 7 – Using Functions

  • How to insert a Function
  • Using Functions including: AVERAGE, MIN, MAX, COUNTA and COUNTBLANK

Course Dates

Course Title Course Date


Broomfield Hall


Ilkeston DE7 6DN

Phone: (01332) 836638

Sign Up Now

Subscribe to our mailing list

* indicates required