Microsoft Excel Advanced

Learn the more advanced features of Microsoft Excel including analytical tools, pivot tables, Solver, outlining and summarising plus some key automation features such as Macros. This course assumes a good general understanding of the software and experience in the construction and modification of workbooks including the ability to copy within Excel, create charts and create basic formulas.

Participants will:

• use a range of formula techniques,
• protect data in worksheets and workbooks,
• use an advanced filter to analyse data in a list,
• use a variety of data validation techniques,
• apply conditional formatting to ranges in a worksheet,
• use goal seeking to determine the values required to read a desired result,
• create, use and modify data tables,
• create and work with scenarios and Scenario Manager,
• understand and create simple PivotTables,
• construct and operate PivotTables using some of the more advanced techniques,
• use data linking to create more efficient workbooks, and
• use the Data Consolidation feature to combine data from several workbooks into one.

Upon completion of the course you will receive a Certificate of Participation.

Please refer to the Student Fact Pack for additional College and support information.