Microsoft Excel 2013 - Module 2

INF1319
978-1-921939-96-9
B&W printed

The skills and knowledge acquired in Microsoft Excel 2013 - Module 2 are sufficient to be able to use a range of techniques including charting and worksheet operation, as well as the use of complex analytical and automation tools.

At the completion of this course you should be able to:

  • modify Excel options
  • construct and operate PivotTables using some of the more advanced techniques
  • understand and use Excel's Quick Analysis tools
  • create more complex formulas and functions
  • work with logical function in Excel
  • use a range of lookup and reference functions
  • apply a range of number formatting techniques to worksheet cells
  • apply conditional formatting to ranges in a worksheet
  • import data into Excel and export data from Excel
  • use the Data Consolidation feature to combine data from several workbooks into one
  • create and use defined names in a workbook
  • use data linking to create more efficient workbooks
  • group cells and use outlines to manipulate the worksheet
  • create summaries in your spreadsheets using subtotals
  • create and work with scenarios and the Scenario Manager
  • use advanced filters to analyse data in a list
  • use a variety of data validation techniques
  • use goal seeking to determine the values required to reach a desired result
  • use Solver to solve more complex and intricate problems
  • create and use a range of controls in a worksheet
  • share workbooks with other users
  • protect data in worksheets and workbooks
  • create recorded macros in Excel
  • use the macro recorder to create a variety of macros

  View outline

View a detailed outline of the course material. You may need to install Adobe Acrobat Reader to open this file.

View Outline

  Download student files

Download working files to go with this course. Read the installation instructions for opening these files.

Download Files Zip