COURSE INFORMATION
The aim of the course is to allow you to explore further formula options and display your data in charts for quick visual analysis. You will also learn how to work and manage lists of data.
ONIMEX
- Creating Charts
- Intermediate formulas
- Manage Data
- Work with Tables
Creating Charts
- Create Charts
- Explore chart types
- Change the chart layout
- Move and Resize charts
- Add chart elements
- Modify chart data
- Add trendlines
- Create Chart templates
- Create Sparklines
Print and Distribute
- Set Print Area and Page breaks
- Headers and Footers
- Margins and Orientation
Intermediate Formulas
- Review of Absolute & Relative cell references
- Create and use Range Names
- Work with the Insert Function tool
- Try a variety of Functions from popular categories (DATE, LOGICAL, LOOKUP)
Manage Data
- Quick Analysis
- Outline and Subtotals
- Data Validation
Flash Fill - Import and Export data
Tables
- Create a Table
- Sort Data
- Filter Data
- Add Rows and Columns
- Slicers
- Remove duplicates
- Overview of Creating Pivot Tables
Intermediate Formatting
- Conditional Formatting
- Apply Styles
- Create and Modify Styles
- Apply a Theme
Collaboration
- Cell comments
- Version History
- Protect Worksheets
- Protect Workbook structure
- File Protection
- 1 day trainer led or virtual
- £195
- Attendance of the Introduction to Excel course or a sound knowledge of copy/paste options, basic formulas, Absolute vs Relative cell referencing, and use of Autofill is recommended.
- Advanced Excel
- Summarising with Lists
- Formulas and Functions
- Analysing and presenting data
- Charts and Dashboards