Course Duration:
1 day
Prerequisites:
Delegates must have an excellent knowledge of Excel, be familiar with Pivot Tables and using various functions
Target Students:
Users who wish to produce front end user Dashboards that are interactive and eye catching
Objectives:
On successful completion of the course, delegates will be able to work with various functions, use Pivot Tables, Slicers and Timelines, use advanced techniques to present data graphically including conditional formatting, objects, graphs, images.
Subject Areas:
Overview of how dashboards are so useful
Various Functions
- IF, AND, OR
- SUMIF / AVERAGEIF / COUNTIF / COUNTIFS
- SUMIFS / AVERAGEIFS
- IFERROR
- VLOOKUP
- MATCH
- Names Ranges
Conditional Formatting
- Icon sets
- Data Bars
- Colour Scales
- High and Low
Graphical Images
- Inserting Shapes
- Using the Snipping Tool
- Images from the Internet
Creating Graphs
Representing data using various graph options:
- Donut, Waterfall
- Pie, Line, Column
- Sparklines
Pivot Tables
- Storing data as Tables
- Creating Pivot Tables
- Using Slicers
- Slicer Options and formats
- Using Timelines
- Timeline Options and formats
Using the Camera
Macros – To Automate and Navigate
- Creating, Editing and Running Macros
- Running Macros to buttons
General Excel Options
- Hiding Sheets
- Hiding Formula Bar
- Sheet displays
- Password Protecting
- Column, Row Headings – Hiding
- Scroll Bars – Hiding
Bringing it all together
If you would like to book onto a course or find out more information please fill out our contact form or call us on 01454 203 355.
