The skills and knowledge acquired in Microsoft Excel 2010 Intermediate are designed for experienced users who are comfortable writing basic formula and would like to use complex functions and manipulate large spreadsheets.

Microsoft Excel 2010 Intermediate assumes the delegate has completed Excel 2010 Fundamentals or has equivalent knowledge.

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

  • Understand and use formula cell referencing to create more complex formulas
  • Use a range of formula techniques and use a range of logical functions
  • Use a range of lookup and reference functions
  • Use the mathematical functions in Excel
  • Use a range of text and information functions
  • Sort data in a list in a worksheet
  • Filter data in a table and use advanced filters to view or extract matching records from a list of data
  • Use a range of techniques to enhance charts
  • Protect data in worksheets and workbooks
  • Use comments to provide additional context to your worksheet data
  • Use data linking to create more efficient workbooks
  • Group cells and use outlines to manipulate the worksheet
  • Use the formula auditing tools to find and fix formula errors
  • Analyse your data and visually enhance your findings using conditional formatting techniques
  • Open and arrange multiple workbooks
  • Revision of fundamentals
  • Formula auditing
  • Working with names
  • Customising the quick access toolbar
  • Protecting data
  • Conditional formatting
  • Working with comments
  • Logical functions
  • Lookup functions
  • Using maths functions
  • Working with dates
  • Text functions
  • Number formatting techniques
  • Sorting data
  • Filtering data
  • Advanced charting techniques
  • Using data validation
  • Grouping and outlining
  • Multiple workbooks
  • Advanced charts