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.
Dear all,
RE:Advanced Microsoft Excel Training
FineResults Research Services would like to invite you to high impact training on Advanced Microsoft Excel Training to be held in Nairobi from 17th - 21st February 2020
Event information
Course Name : Advanced Microsoft Excel Training
Venue : FineResults Research, Nairobi, Kenya
Event Date : 17th - 21st February 2020
Course Fee : KES 65000 or USD 800
Registration : REGISTER HERE
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!
ACCOMMODATION
Accommodation is arranged upon request. For reservations contact us through Mobile: +254 732 776 700 / +254 759 285 295 or Email: gro.hcraeserstluserenif@gniniart
PAYMENT
Payment should be transferred to FineResults Research Services Limited bank before commencement of training. Send proof of payment through the email: gro.hcraeserstluserenif@gniniart
Visit our website for more details
How to participate
Individual Registration
Contact information
Email:gro.hcraeserstluserenif@gniniart
TEL: +254 732 776 700 / +254 759 285 295
Website: fineresultsresearch.org/training/
Visit our face book page
Visit our linkedin page
Visit our twitter account
Date: 17 February 2020
to 21 February 2020
Time: 08:00 - 17:00
Venue: FineResults Research services training center, Nairobi
Cost: USD 800
More info: Located in Fahari Palace Hotel, Off Church rd, Westlands, Nairobi