Intermediate Excel: Setting up Spreadsheet (Part-Time)

Course Overview

This course follows on from the introductory session and covers more advanced topics in the use and manipulation of data:

  • Learn how to use formulas and functions
  • Explore the various user interface elements
  • Use the Excel galleries
  • Customise the interface
  • Creating forms with Excel
  • Replicate formulas & functions
  • Create an absolute reference
  • Range names and how they are applied
  • Using Freeze Panes
  • Recording the current date and time on the printed spreadsheet
  • Turning your figures in to charts
  • Formatting charts

Study Mode



Neath College - 01639 648000

Course Length

1 day


SDF: Free