Microsoft Excel Training on Pivot Tables Formulae and Shortcuts

Course Date Onsite fees: Location Register
24/06/2024 To 28/06/2024 1,000 USD, 90,000 Ksh Nairobi
23/09/2024 To 27/09/2024 1,000 USD, 90,000 Ksh Nairobi
09/12/2024 To 13/12/2024 1,000 USD, 90,000 Ksh Nairobi

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

 

COURSE OBJECTIVES

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.

 

 

TOPICS TO BE COVERED

Module 1:

Introduction

        Navigating within the sheet

        Making selection (Shift+Spacebar; Ctrl + spacebar)

        Entering data

        Data management in Excel (Text to column, filtering, sorting, flashfill, remove duplicates, data validation)

        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 (Ctrl + T)

        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 and lunch.

 

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 Services 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.
Call us on +254 732 776 700/ +254 759 285 295
Book your Training (Training Calender)
Follow us