IT Courses - Basic Excel

Venue: Broomfield Hall
Hours: 0.20
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
IT Courses - Basic Excel 13/11/2017 BOOK Now
IT Courses - Basic Excel 12/02/2018 BOOK Now
IT Courses - Basic Excel 21/05/2018 BOOK Now