EX201: Excel 2013 for Data Analysts

EX201: Excel 2013 for Data Analysts

This course will teach you the skills to master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook.

Duration: 6 Hours (2*3 Hours)

Course Outline

Section 1: Sharing Workbook with Others

Lesson 1: Introduction

Lesson 2: Save and Send Options

Lesson 3: Using Comments in Excel

Lesson 4: Using Hyperlinks

Section 2: Protecting and Maintaining a Workbook

Lesson 1: Introduction

Lesson 2: Customising Advanced Properties

Lesson 3: Saving As a Template

Lesson 4: Importing And Exporting XML Data

Lesson 5: Protecting A Worksheet And Workbook

Section 3: Track Changes

Lesson 1: Introduction

Lesson 2: Turning On Track Changes

Lesson 3: Accept And Reject Changes

Lesson 4: Sharing Workbooks

Lesson 5: Restricting Access To A Shared Workbook

Section 4: Naming Cells

Lesson 1: Introduction

Lesson 2: Naming A Cell Or A Range Of Cells

Lesson 3: Moving To Named Cells

Lesson 4: To Delete Or Edit A Named Cell

Section 5: Data Lists

Lesson 1: Introduction

Lesson 2: Adding Custom Lists

Lesson 3: Advanced Sort Options

Lesson 4: Applying Conditional Formatting

Lesson 5: Applying Filters

Lesson 6: Applying Custom Filters

Lesson 7: Subtotalling a List

Lesson 8: Grouping and Outlining Data

Lesson 9: Data Validation

Lesson 10: Drop Down Menus Using Validation Lists

Lesson 11: Creating a Table To Manage Lists

Section 6: Advanced Formulae

Lesson 1: Introduction

Lesson 2: V and H Lookup Functions

Lesson 3: SUMIF Function

Lesson 4: COUNTIF Function

Lesson 5: Arrays

Lesson 6: Database Functions

Section 7: Advanced Charts and Graphs

Lesson 1: Introduction

Lesson 2: Trendlines

Lesson 3: Dual Axes

Lesson 4: Saving a Chart Template

Lesson 5: Sparklines

Lesson 6: Advanced Sparklines Options

Section 8: Pivot Tables and Pivot Charts

Lesson 1: Introduction

Lesson 2: What is a Pivot table?

Lesson 3: How to create a pivot table

Lesson 4: Working with an existing pivot table

Lesson 5: Slicer tool