Introduction
Discover Excel’s more powerful features like sorting, filtering data and creating charts.
Duration
1 Day
Pre-Requisites
We assume you have a basic understanding of Windows and Microsoft Excel, including creating workbooks, using AutoFill and AutoSum, constructing formulas, Absolute Cell References and formatting worksheets.
Course Contents
Worksheet Techniques
- Inserting and Deleting Worksheets
- Copying and Renaming a Worksheet
- Moving a Worksheet
- Hiding and Unhiding Worksheets
- Copying and Moving Sheets to other Workbooks
- Changing Worksheet Tab Colours
- Grouping Worksheets
- Hiding and Unhiding Rows and Columns
- Freezing Rows and Columns
- Splitting Windows
Some Useful Functions
- COUNT, COUNTA and COUNTBLANK
- COUNTIF
- SUMIF and SUMIFS
- CONCATENATE
Creating Charts
- Choosing the Right Chart
- Using a Recommended Chart
- Creating a New Chart
- Working With an Embedded Chart
- Resizing and Repositioning Charts
- Creating a Chart Sheet
- Changing the Chart Type, Layout and Style
- Embedding a Chart Into a Worksheet
- Printing an Embedded Chart and Chart Sheet
- Understanding Chart Elements (Title/Axes/Legend)
Special Pasting
- Pasting Formulas and Values
- The Paste Special Dialog Box
- Copying Validations
- Copying Column Widths
Custom Views
- Adding and Creating a Custom View
- Working With Custom Views
Sorting Data
- Understanding Lists
- Performing an Alphabetical and Numerical Sort
- Sorting on More Than One Column
- Sorting Numbered Lists
- Sorting by Rows
Filtering Data
- Applying and Using a Filter
- Creating Compound Filters
- Multiple Value Filters
- Creating Custom Filters
- Using Wildcards
Conditional Formatting
- Formatting Cells Containing Values
- Top Ten Items
- More Top and Bottom Formatting Options
- Working With Data Bars and Colour Scales
- Creating and Editing Sparklines
- Creating Custom Rules
- The Conditional Formatting Rules Manager
Worksheet Tables
- Creating a Table From Scratch
- Working With Table Styles
- Table Columns
- Converting a Table to a Range
- Creating a Table From Data
- Inserting or Deleting Table Records
- Removing Duplicates
- Sorting, Filtering, Renaming, Splitting Tables
The Quick Analysis Tools
- Quick Formatting
- Quick Charting
- Quick Totals
- Quick Sparklines
- Quick Tables