INTRODUCTION

Excel has powerful tools that enable busy users to set up systems that simplify data management, analysis and presentation. Effectively using Excel allows users to devote their time more profitably to making decisions about and acting on results, with more effective outcomes. This 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. In addition to the practical component, all participants will also receive a manual describing all the techniques learned.

DURATION

5 days

LEARNING OUTCOMES

By the end of the training, participants should be able to:

•        Familiarize with advanced formulas and functions in Microsoft Excel

•        Combine data, 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, analyse and present data through pivot tables and charts.

COURSE OUTLINE

Module 1:

Introduction

•        Navigating within the sheet

•        Making selection

•        Entering data

•        Data management in Excel  

•        Deleting unwanted data

•        Find errors, conditional formatting and data validation

Module 2:

Introduction to Excel FORMATING

•        Adjusting Numeric Formats

•        Controlling Fonts, Borders and Cell Color

•        Alignment Tools & Other formatting Tools

•        Row, Column and Sheet Adjustment & Adding Picture

•        Referencing in Excel

•        Working with Structured tables

•        Excel Formula Basics

•        Keyboard shortcuts in Excel

Module 3:

Pivot Table and Pivot Charts

•        Preparing data for use with Pivot Table

•        Creating Pivoting Tables

•        Summarizing PivotTable Data

•        Sorting and Filtering Pivot Table

•        Formatting PivotTable

•        Applying Conditional Formatting

•        Working with Calculated Fields

•        Grouping Data

•        Filters and Advanced Filter

•        Advanced Data Field Settings

•        Creating Pivot Chart

•        Power Query

•        Printing Pivot Tables and Pivot Charts

•        GETPIVOTDATA function

Module 4:

Excel Functions

•        Lookup/Ref Functions

•        String/Text Functions

•        Date/Time Functions

•        Math/Trig Functions

•        Statistical Functions

•        Logical Functions

•        Information Functions

•        Financial Functions

•        Database Functions

•        Engineering Functions

Module 5:

Practical application of Excel

•        Project assignment involving huge application of Pivot Tables, Formulae and Shortcuts

•        Recap of entire course

•        Course evaluation

•        Action planning

***************************

TRAINING CUSTOMIZATION

This training can also be customized for your institution upon request. You can also have it delivered your preferred location. For further inquiries, please contact us through Mobile: +254 732 776 700 or +254 759 285 295. You can also email us on: training@fineresultsresearch.org

REQUIREMENTS

Participants should be reasonably proficient in English.  During the trainings, participants should come with their own laptops.

TRAINING FEE

The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact us through Mobile: +254 732 776 700/+254 759 285 295 or Email: training@fineresultsresearch.org

PAYMENT

Payment should be transferred to FineResults Research Limited bank before commencement of training. Send proof of payment through the email: training@fineresultsresearch.org

CANCELLATION POLICY

• All requests for cancellations must be received in writing.
• Changes will become effective on the date of written confirmation being received.