Description

Duration

2.25 Days

13.5 CPD hours

This course is intended for

The job roles best suited to the material in this course are: sales personnel, accountants, administrators, auditors, lab assistants, office job positions.

Overview

Work with functions.
Work with lists.
Analyze data.
Visualize data with charts.
Use PivotTables and PivotCharts.
Work with multiple worksheets and workbooks.
Share and protect workbooks.
Automate workbook functionality.
Use Lookup functions and formula auditing.
Forecast data.
Create sparklines and map data

This course provides the knowledge to create advanced workbooks and worksheets that can deepen the understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it and present that information to decision makers. In addition this course will give you the ability to collaborate with colleagues, automate complex or repetitive tasks and use conditional logic to construct and apply elaborate formulas and functions which will allow you to work through a lot of data and generate the answers that your organisation needs.

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

WORKING WITH LISTS

Topic A: Sort Data

Topic B: Filter Data

Topic C: Query Data with Database Functions

Topic D: Outline and Subtotal Data

ANALYZING DATA

Topic A: Create and Modify Tables

Topic B: Apply Intermediate Conditional Formatting

Topic C: Apply Advanced Conditional Formatting

VISUALIZING DATA WITH CHARTS

Topic A: Create Charts

Topic B: Modify and Format Charts

Topic C: Use Advanced Chart Features

USING PIVOTTABLES AND PIVOTCHARTS

Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Timelines and Slicers

WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS

Topic A: Use Links and External References

Topic B: Use 3-D References

Topic C: Consolidate Data

SHARING AND PROTECTING WORKBOOKS

Topic A: Collaborate on a Workbook

Topic B: Protect Worksheets and Workbooks

AUTOMATING WORKBOOK FUNCTIONALITY

Topic A: Apply Data Validation

Topic B: Search for Invalid Data and Formulas with Errors

Topic C: Work with Macros

USING LOOKUP FUNCTIONS AND FORMULAS AUDITING

Topic A: Use Lookup Functions

Topic B: Trace Cells

Topic C: Watch and Evaluate Formulas

FORECASTING DATA

Topic A: Determine Potential Outcomes Using Data Tables

Topic B: Determine Potential Outcomes Using Scenarios

Topic C: Use the Goal Seek Feature

Topic D: Forecast Data Trends

CREATING SPARKLINES AND MAPPING DATA

Topic A: Create Sparklines

Topic B: Map Data

Course Images

Excel for business professionals

By Nexus Human

Booking options

Highlights

Description

About The Provider

Tags

Reviews