Our Workshops

Description

Our Microsoft workshop presenters are Microsoft Certified Trainers as well as Microsoft Certified Technology Specialists

One day Workshop

Discover how to display data from any number of sources, of any kind, using virtually any design...all in one report.

Learn how to create mini-charts for Dashboard reporting

Learn how to create figures that use both Charts and Worksheets

Discover how to use Excel’s Camera Tool

Learn how to funnel data into Dashboard Reports

Learn how to use Spreadsheet databases for Dashboard Reporting

Learn how formulas in any number of high-quality Excel reports can link to general-purpose Excel databases, or to Excel-friendly OLAP databases.

Discover how, by using the proper techniques, Excel users can update their reports in seconds...rather than minutes, or hours….

Discover how to create magazine-quality Excel reports.

Discover how to change the reports quickly, to respond to managers’ changing information needs.

• The Excel Window Components
• Advanced Chart Creation
• Advanced Chart Formatting    
• Supporting Skills for Dashboard Creation
• The Excel Camera Tool
• Creating Traffic Lights 
• Dashboard Reports 

WORKSHOP OUTCOMES

Understanding Decision Support Systems

•             Understanding what is the taxonomy of a good decision
•             Understanding the principles of good dashboard design
•             Designing a report that will lead to a good decision
•             Examine the pitfalls of dashboards

Developing the Data Model for better Decisions

• Cleaning Data
• Understanding Date values

Introducing Visualisation

•             Understanding Custom Formatting
•             Clearing Chart Junk
•             Building Dynamic Text Statements
•             Using Conditional Formatting to enhance analysis
•             Introducing the "CAMERA" tool

Developing Chart Objects

•             Understanding Excel Chart Object
•             Introducing Advanced features of Charting
•             Choosing the right charts to assist in decisions

Creating Forms Control Objects and Dynamic Charting

•             Scroll Bar
•             Check Box
•             Combo Box
•             Introducing MATCH and INDEX functions

Additional Visualisation Techniques

•             Chart Banding
•             Dynamic Labelling
•             Advanced Conditional Formatting
•             Using SPARKLINES

Working with Pivot Tables

•             Introduction to Pivot Tables and its functionality
•             Formatting the Pivot Table
•             Advanced features of Pivot Table

Formatting a Table

•             Why we format a table
•             Features of a formatted table

Developing the Dashboard Layout

•             Developing the Dashboard User Interface

Populating the Dashboard

•             Understanding how to use Pivot Tables in Dashboards
•             Developing Dynamic charts using PivotCharts
•             Introducing "SLICERS" to customise filters
•             Placing Chart and other Object in the Dashboard
•             Developing MACROS to automate Refresh function

_______________________________________________________________________________________________________________________________________________________________

On-Site Workshops

• All workshops are offered in-house at your offices to a minimum of 5 delegates
• You provide the venue and refreshments, Front Foot supply all the workshop material – including laptops for computer-based training sessions

 Remote Workshops

• All workshops are offered remotely to a minimum of 5 delegates
• Front Foot supply all the electronic workshop material

________________________________________________________________________________________________________________________________________________________________