Up-skilling SPF123

Advanced Excel

• Advanced Excel

  Advanced Excel

  Course Content:

  • 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 and HLOOKUP statements to retrieve date
  • 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 whilst allowing data entry
  • Setting up and utilising templates
  • Creating and formatting charts
  • Adding trend lines to the chart
  • Utilising custom chart types