Excel 2010 (Advanced)

Start Date: 24/07/2015

Duration: 1 Day

Full Fee: €395

Network Members Fee: €205

Programme overview

This course covers aspects of Excel beyond building basic workbooks. It deals with workbook automation, productivity features, data analysis tools and automating workbook operations using macros. On the course you will be introduced to many of the topics required for the Microsoft Office Specialist (MOS) Expert level.

Learning outcomes
Use this section to give an overview/list/bullet points for what the outcomes of the course will be

Who Should attend?

This course is designed for Microsoft Excel users who have a good knowledge and understanding of Excel but are not yet at expert level. It will suit users who wish to extend their knowledge and skills.

Course Content

Analyzing Data

  • Use Outlining Tools to Collapse and Expand a Range of Cells
  • Create Subtotal Reports
  • Use What-If Analysis Tools – Goal Seek, Scenario Manager and Solver to Automate Reporting

Collaborating with Others

  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Merge Workbooks
  • Restrict Document Access

Streamlining Workflow

  • Record and modify a Macro
  • Apply Conditional Formatting
  • Working with Name Ranges
  • Inserting Hyperlinks
  • Add Data Validation Criteria
  • Update a Workbook’s Properties

Analyse Data with Logical and Lookup Functions

  • VlOOKUP, HLOOKUP, INDEX, MATCH and CHOOSE
  • Using IFERROR with VLOOKUP
  • Troubleshoot Invalid Data and Formulas

Working with Multiple Workbooks

  • Calculate and Link Data Across Worksheets and Workbooks
  • Consolidating and Combining Data in a Workbook

Customising and Enhancing Workbooks

  • Customise Workbooks
  • Manage Themes
  • Create and Use Templates

Using Specialised Functions

  • FV, PMT, RATE,SUMIF ,SUMIFS,AVERAGEIFS, CONCATENATE,CLEAN,LEFT,RIGHT and EXACT

Analysing Data using PivotTables, Slicers and PivotCharts

  • Creating a PivotTable Report
  • Filter Data using Slicers
  • Analyse Data using Pivot Charts
  • Using PowerPivots Tables

Trainer Profile