Are the Excel courses live and instructor-led?

Yes. PCWorkshops provides live, instructor-led Excel training online and can also arrange classroom Excel training in London.

Which Excel course is suitable for beginners?

The Excel course taster provides a short introduction, while the SQL Course for Beginners provides a more comprehensive introduction to Excel.

Are the Excel courses suitable for data analysts?

Yes. The Excel training includes querying, filtering, joins, grouping, aggregation, subqueries and other techniques useful for data analysis.

Can I attend Excel training online?

Yes. PCWorkshops provides live online instructor-led Excel training. Classroom training in London can also be arranged.

Can the Excel course be customised for a business?

Yes. Excel training can be customised by content, number of delegates, dates, times, location and exercises. Training can also be adapted around suitable anonymised business data.

What is included with the Excel courses?

The Excel courses include a course certificate on completion, course notes, practical SQL exercises and one hour of free online revision after the course. The maximum listed group size is four.

Excel Dashboards Course | 1-days

Excel Pivots and Dashboards Course

Excel Dashboards will summarize and present the key indications of large data in an attractive visual display, hightlighting the most important trends so the most important aspects of data could could be seen in a snap second by glancing at attractive, colourful charts. Pivot Tables help analyze the data and brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. Pivots help analyze and understand the growing quantities of data that are created on a daily basis.

Who should attend the Excel Pivots and Dashboards Course?

Business users who analyse data with Excel or create management reports
Excel users who want to analyze large data sets and also create relationships between tables
Excel users who know how to Pivot Tables and Pivot Charts
Excel users who wish to create interactive dashboards

Excel Pivots and Dashboards Course Outline

Introduction: Activating Power Pivot in Excel
Browse, Filter and Sort PowerPivot Data
PowerPivot Menu Options
The AutoSum Function in Power Pivot
Relationships:

Create Relationships with Excel PowerPivot Data
Create Relationships to Master Data
Create PivotTables with Table Relationships

Excel techniques that are essential for Dashboards:

Offset
Lookup formulae (Vlookup, Hlookup, Match, Index)
Conditional formulae (If, Countifs, And, Or, etc.)
Aggregate formulae
Advanced filters to organise columns and filter rows

Creating Excel Pivot Tables:

Creating PivotTables
Changing the Method of Calculation
Pivot Table Calculations
Filtering with Slicers
Excel PivotTable Filters and Slicers
Filtering Excel PivotTables and PivotCharts
Creating Hierarchies

Creating Visuals in Excel:

Sparklines
Create dashboard heat maps and other shapes
Conditional Formatting
Top and bottom filters

Creating and Formatting Charts and Graphs in Excel:

Charting: Pie, Line, Area, Column, Scatter, Bar charts,
Charting: Axes, 2D, 3D chart elements, Sizing of charts
Selecting data, changing data ranges, refreshing data
Formatting of charts
Colour and Font schemes and Customising Themes
Using Standard Chart Templates
Adding and removing chart elements
Chart Filters and Slicers

Adding inter-activity:

Forms and controls (for drop down lists to choose what you are comparing)
Dynamic Filters and Slicers
Go-to's with drop lists
Linking Excel cells to a text box
Linking cells to chart labels
Linking dynamically to changing ranges and values

Refreshing:

Refreshing Excel Dashboards in line with changing data

Book the Excel Dashboards Course

Contact us / Customise your Excel course

EMF HTML Contact Form

What makes the Excel course special?

Excel Instructor-led Learn from an experienced instructor live online, ask questions and get immediate assistance.

Personalised attention Small groups of max 4 delegates makes for personalised attention and successful training.

Practical Exercises Get experience and familiarity with Excel by doing practctical exercises.

London Online, Classroom, Onsite Mostly online, instructor-led. Request Excel classroom in London or onsite training by emailing us about it.

Request a Free Excel trial

Want to experience the instructor-led training before booking? Request a free Excel trial or contact us to discuss your Excel training requirements.

Request a Free Excel trial Email PCWorkshops Call 07784-357309

Contact PCWorkshops

Excel Pivots & Dashboards Course