Microsoft Excel Analysing Data

Half Day

This module follows on from our module “manipulating Data”. Delegates will learn how to present data using Pivot Tables, advanced filters and tables to create reports.

Format: Half day, max capacity 6.

Wireless Computer Accessories
microsoft-excel-seeklogo.com.png

Session Topics

 

  • Custom sorting

  • Advanced Filtering

  • Custom number formatting

  • Introduce formatting as table

  • Filters/Slicers

  • Pivot Tables (mulit Column)

  • Interactive Dashboard

  • Multisheet Workbooks

  • 3D referencing

  • Calculating GP margins and mark-up.

  • Calculating sell price from cost price using a set margin.