Course Description
Creation of formula and organise data into tables, as well as looking at charts and templates.
Target Student:
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.
Prerequisites:
- 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
Performance-Based Objectives
- 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
