Data Management and Analysis Using Advanced Microsoft Excel

This Data Management and Analysis Using Advanced Microsoft Excel course gives practical experience in the use of Microsoft Excel for data summary, presentation and for other basic statistical work. It concentrates on areas where Excel really can excel in your workplace functions. We look at data entry and management, pivot tables, formulae, graphics for results presentation and useful shortcuts. Participants will learn through a series of practical simulations which ensures that they maximize their learning and can use the tools immediately when they return to the office.

PROGRAM OBJECTIVES​

• Familiarize with advanced formulas and functions in Microsoft Excel
• Easily combine, link and export data
• Create key outputs from data (tables and graphs)
• Reduce the amount of time spent in delivering output through Microsoft Excel through time-saving keyboard shortcuts
• Easily summarize, analyze and present data through pivot tables and charts.

MODULES

Module 1: Introduction

Module 2: Introduction to Excel Formatting