Excel 2013 Training

Brief Description:  creation of formula and organise data into tables, as well as looking at charts and templates.

Duration: 1 day

Who Should Attend:

This course is designed for individuals who already have foundational knowledge and skills in Excel 2013 and are ready to advance their data analysis skills and abilities through the application of advanced Excel 2013 functionality such as tables, charts and formatting.

Description:

This course builds upon the foundational Microsoft® Office Excel® 2013 knowledge and skills you’ve already acquired and sets you on the road to creating advanced workbooks and worksheets.

You’ll learn a lot of things about Excel 2013, including how to create advanced formulas and organize your data into tables.

Participants will:

• Calculate across worksheets and named ranges
• Work with Excel tables
• Organise worksheet data so that data can be sorted and filtered
• Create and modify Charts
• Apply Conditional Formatting
• Change Excel Options

Course Content:

Lesson 1: Calculating With Advanced Formulas

• Use Excel’s Quick Analysis Tools
• Work with Range Names
• Calculating across Worksheets
• Analysing Data Based on Criteria
• Using Logical Functions (IF, AND, OR)
• Applying Lookup Function

Lesson 2: Charts

• Understanding Charts
• Create a Chart
• Modify and Format a Chart
• Add and Remove Chart Data
• Add a Trendline to a Chart
• Analyse Data Using Sparklines

Lesson 3: Mastering Excel Tables

• Introducing Excel Tables
• Creating Calculated Columns
• Formatting a Table
• Using Advanced Table Tools
• Using Slicers
• Converting Tables to Ranges

Lesson 4: Organising Worksheet Data

• Apply Basic Sorting to a Data Range
• Advanced Sorting
• Summarise Data with Subtotals

Lesson 5: Apply Conditional Formatting

• Conditional Formatting
• Customising Conditional Formatting
• Sorting and Filtering by Conditional Formats

Lesson 6: Analysing Selected Data

• Applying Basic Filters
• Advanced Filters
• Use Outlines to Organise Data

Lesson 7: Appendix – Excel Options

Pre-requisites

• Create basic spreadsheets
• Select and edit data
• Perform basic formatting
• Open, close and save files
• Create basic formulas – AutoSum
• Use Insert Function to create built-in functions
• Work with absolute references
• Use the AutoFill feature