Workshop Duration
1 day
Prerequisites
Delegates must have attended an Excel Introductory course, or have an equivalent working knowledge of Excel.
Who will the course benefit?
Users of Excel who wish to develop their skills in this application.
Course Content
Overview
- Short overview of introductory topics e.g. formulas/functions, formatting
Charting
- Overview of creating Charts
- Embedding Charts within spreadsheets Predefined Chart Layouts and Chart Styles Formatting charts e.g. adding titles, legends Redefining the Source Data
- “Sparklines”
Outlining
- The concept and use of outlining
- Using automatic and manual methods to produce an outlined spreadsheet
- Collapsing and expanding outlines
- Selecting “visible” cells for charting purposes
Group Edit
- Using Group Edit for entering data into several sheets
- Using Fill, Across Worksheets
- Creating dynamic links to data
Conditional Formatting
To discover patterns and highlight trends in your data
Logic Functions
- Understand logical functions IF, OR, and AND functions
- Using NESTED IF Functions IFERROR
Database Management
- Creating a spreadsheet database Sorting the database via key fields Finding and Extracting data
- Using the Form feature
- AutoFilter
- Multi-select Autofilter
- Filter by Colour and quick filters
Functions
- Using SUMIF/COUNTIF Using
- SUMIFS/COUNTIFS
Database Statistical Functions
- Producing statistics based on criteria
- Creating Subtotals (SUBTOTAL)
Pivot Tables
- Building and using pivot tables and pivot charts Creating SUMS, AVERAGES, % of
- Total Group Data and Dates Formatting the Pivot Table
Using the slicer
Skills gained
On successful completion of the course, delegates will be able to produce effective graphs, use named ranges within calculations, produce drawing objects e.g. lines, text boxes, understand logical functions and use Excel as a database facility.
For more information on this course or to book spaces fill out our contact form or call us on 01454 203 355.
