Advanced Microsoft Excel Training. 10th to 14th August 2020

FineResults Research Services invites you to training on:

Topics: Advanced Microsoft Excel Training

Date:    10th to 14th August 2020

Cost:      USD 800 or Ksh 65000

Contacts: +254 759 285 295, [email protected].

Venue    :  FineResults Research, Nairobi, Kenya Training Centre.

INTRODUCTION

Excel has powerful tools that enable busy users to set up systems that simplify data analysis and interpretation. 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, such as array functions. We look at data entry and management, pivot tables, and graphics. We also review Excel's facilities for statistical analysis, advising on their use and limitations, and we show how add-ins can be used to enhance Excel's capabilities. 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 OUTLINE

Module 1

•           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

•           Excel Formula Basics

 

Module 2

•           Introduction to Pivot Table

•           Creating Pivoting Tables

•           Summarizing PivotTable Data

•           Sorting and Filtering Pivot Table

•           Formatting PivotTable

•           Applying Conditional Formatting

•           Printing Pivot Tables and Pivot Charts

•           The “if” Function

 

Module 3

•           Printing Pivoting Tables

•           Using Date and Time Functions

•           Look Up functions

•           Data Validation

•           Data Validation Exercises

•           Linking Sheets

 

Module 4

•           Creating Forms

•           Introducing Macros

•           Sorting and Filtering data

•           Formatting Dashboards

•           Macros continued

•           Macros - Advanced

 

Module 5

•           Introduction to VBA

•           Basics of VBA Programming

•           VBA Conditional Statements

•           VBA Loops Statements

•           VBA Message Box and input

•           VBA Miscellaneous & Macros

 

NB: We are offering you a half day, fun and interactive team building event!

Be part of the Training

• Click HERE for the individual registration.

 

Engage with us on  

Visit our face book page

Visit our linkedin page  

Visit our twitter account

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Others Details

Excel has powerful tools that enable busy users to set up systems that simplify data analysis and interpretation. 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.