Excel for business professionals

2.25 Days

13.5 CPD hours

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

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