Still finding Excel daunting? Then it’s time to get to grips with the basics. Spend the day working on spreadsheets, mastering techniques and shortcuts. You will leave feeling like an Excel pro!

This course will enable you to perform simple calculations with confidence using formulas, learn key features and find your way around the Excel ribbon, do your work faster thanks to Excel shortcuts and present your work professionally whether on screen or printed.

This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Microsoft Excel 2016 worksheets. 

By the end of this course, you will be able to:

  • Perform simple calculations with confidence using formulas
  • Use key features and find your way around the Excel ribbon
  • Do your work faster thanks to Excel shortcuts
  • Present your work professionally whether on screen or printed

Module 1: Getting Started with Excel 2016 

  • Excel and the Excel environment 
  • Navigate and select in worksheets 
  • Create a basic workbook 
  • Open, save and close workbooks 
  • Use Microsoft help 

Module 2: Modifying a Workbook 

  • Cut, copy and paste commands 
  • Flash fill 
  • AutoFill options 
  • Find and replace 
  • Spelling 
  • Undo and redo 
  • Insert and delete options 
  • Column width and row height 
  • Hide and unhide options 

Module 3: Using Formulas and Functions 

  • Create relative formulas 
  • AutoCalculate 
  • Insert functions 
  • Use AutoSum 
  • Copy formulas 
  • Create absolute formulas 

Module 4: Formatting an Excel Worksheet 

  • Font group 
  • Add borders and fill colours 
  • Cell alignment 
  • Number formatting 
  • Cell styles and galleries 

Module 5: Managing Worksheets and Workbooks 

  • Manage worksheets 
  • Freeze rows and columns 
  • View options for worksheets and workbooks 

Module 6: Printing Options 

  • Print preview 
  • Print worksheets and workbooks 
  • Page setup 
  • Print titles 
  • Page layout view
  • Use a mouse 
  • Type and use a keyboard
  • Navigate through Windows files and folders
  • Work with Windows - minimise, maximise, open and close