Advanced Excel (Part-Time)

Course Overview

This session is the final stage in understanding Excel Spreadsheets and introduces the learner to topics such as charts, and statistics manipulation.  This session also covers some basic Excel programming:

  • Absolute cell references
  • Naming cells and ranges
  • Referring to named cells and ranges in formulae
  • Editing named cells and ranges
  • Setting up entire workbooks with group editing
  • Using VLOOKUP & HLOOKUP statements to retrieve data
  • Editing lookups and ensuring accuracy in returned data
  • Linking spreadsheets and workbooks together with formulas and functions
  • Utilising If statements to assist decision making
  • If statements and calculations
  • Analysing data with the all new conditional formatting features
  • Sorting data numerically and alphabetically
  • Filtering data for range and precision analysis
  • Setting up data validation to ensure integrity of the data
  • Attaching security to a spreadsheet
  • Selective protection i.e. protecting formulas while allowing data entry
  • Setting up and utilising templates
  • Creating and formatting charts
  • Adding trend lines to the chart
  • Utilising custom chart types

Study Mode

Part-Time

Location

Neath College - 01639 648000

Course Length

1 day

Fees

SDF: Free