Microsoft Excel Charts and Pivot Tables
March 14 @ 12:00 pm - 3:00 pm
Microsoft Excel Charts and Pivot Tables
Guaranteed to Run
- Course Duration: 3 hours
- Level: Beginner, Intermediate
- Delivery Format:
UTB Virtual Classroom
Time: March 14 @ 12:00 pm – March 14 @ 3:00 pm
Course Overview
Do you find it difficult to understand and use Excel’s built-in formulas and functions? Do you find Pivot tables a challenge? Struggle to create and format pivot tables and use the right fields to summarise and analyse data?
Choosing the right chart type, organising and structuring data in meaningful ways, and the list goes on. Well, whilst the list might go on, you don’t need to struggle any longer.
This course is designed to skill you up so you never struggle again inside Excel. Swap your confusion and spreadsheet headaches for eye-catching data displays and meaningful data reporting.
$180
You’ll find our approach engaging AND our information applicable or your money back
Designed For
Anyone who has to summarise and present data. This course will teach you how to not only summarise larger sets of data, but to be able to illustrate that graphically.
What You'll Learn
- Create a Chart
- Changing Chart location to a separate sheet
- Move a chart within a worksheet
- Resize a chart
- Change an existing chart to a different chart type
- Overall Chart Design
- Chart Styles
- Chart Layout
- Chart Shape Design
- Shape Styles
- Shape Colours
- Shape Outlines
- Shape Effects
- Chart Text Design
- Chart Labels
- Chart Axes
- Chart Gridlines
- Chart Background
- Moving an Embedded Chart
- Resizing an Embedded Chart
- Adding More Data
- Selecting the Correct Chart & Data
- Select a chart element by using the mouse
- Select a chart element from a list of chart elements
- Changing the Chart Type
- Changing the cells to be plotted
- Changing fonts and formats
- Understanding Series
- Creating a sparkline
Tables - Add data to a Table
- Total the data in an Excel table
- Summarising data with PivotTables
- Creating a Pivot Table
- Formatting the Pivot Table
- Calculated Fields
- Calculated Items
- Creating a Pivot Chart
- Formatting the Pivot Chart
- Modifying the Pivot Chart
Distribution
Do any of these statements fit the bill for you?
- I struggle with understanding and using Excel’s built-in formulas and functions for data analysis.
- I have difficulties creating and formatting pivot tables in Excel.
- I find it challenging to create and format charts in Excel that are visually appealing.
- I have difficulty understanding and using macros and VBA in Excel.
- I struggle with organising and managing large amounts of data in Excel.
- I have difficulties understanding and implementing data validation and protection tools in Excel.
- I find it challenging to collaborate and work on Excel files with others.
Then this training is the right fit for you.
Prerequisites
A basic understanding of excel and a desire to manage and interpret larger data sets
$180
You’ll find our approach engaging AND our information applicable or your money back
No Courses currently
scheduled that suit
your calendar?
Interested in a private
training course for
your team?
It really gets you thinking about ‘why’ you do what you do. Great to have time out from the classroom to experiment and have time to think and discuss different ideas.
Abbey Howard
Mike, awesome course, fantastic resources and a real wake-up for someone who considers himself technically astute but not necessarily updated!
Shaun Hardy
No fat, no rambling, just clean, concise explanations where needed. James was awesome.
