Cancellation Policy
Cancellation Policy
Cancellation Policy
Cancellation Policy
FREE Course Guide Download
Microsoft Excel Intermediate
Course Overview
FREE Course Guide Download
Overview
This course has been developed for people wanting to utilise Excel to perform calculations using a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.
Target Student
This course is for individuals whose job responsibilities include creating more advanced functions, creating charts and analysing data using Pivot tables.
Prerequisites
Previous experience using Microsoft Excel at a basic level is an essential prerequisite for this course.
Duration
1 day
Course Outline
1. Working With Functions
-
Topic A: Work with Ranges
-
Topic B: Use Specialized Functions
-
Topic C: Work with Logical Functions
-
Topic D: Work with Date and Time Functions
-
Topic E: Work with Text Functions
2. Working With Lists
-
Topic A: Sort Data
-
Topic B: Filter Data
-
Topic C: Query Data with Database Functions
-
Topic D: Outline and Subtotal Data
3. Analyzing Data
-
Topic A: Create and Modify Tables
-
Topic B: Apply Intermediate Conditional Formatting
-
Topic C: Apply Advanced Conditional Formatting
4. Visualizing Data With Charts
-
Topic A: Create Charts
-
Topic B: Modify and Format Charts
-
Topic C: Use Advanced Chart Features