Advanced Microsoft Excel Training

Posted By : User Ref No: WURUR71989 0
  • Image
  • TypeTraining or Development Class
  • Image
  • Location Westlands Nairobi kenya, Nairobi, Kenya
  • Price
  • Date 15-02-2021 - 19-02-2021
Advanced Microsoft Excel Training, Westlands Nairobi kenya, Nairobi, Kenya
Training or Development Class Title
Advanced Microsoft Excel Training
Event Type
Training or Development Class
Training or Development Class Date
15-02-2021 to 19-02-2021
Last Date for Applying
12-02-2021
Location
Westlands Nairobi kenya, Nairobi, Kenya
Organization Name / Organize By
FineResults Research Services Ltd
Organizing/Related Departments
Training coordinator
Organization Type
Organization
Training or Development ClassCategory
Both (Technical & Non Technical)
Training or Development ClassLevel
All (State/Province/Region, National & International)
Related Industries

Education/Teaching/Training/Development

Research/Science

Computer Science

Administration/Management

Computer/Technology

Location
Westlands Nairobi kenya, Nairobi, Kenya

FineResults Research Services would like to invite you to take part in our upcoming workshops on Information Communication & Technology courses at our FineResults Services training facilities in Nairobi, Kenya.

Date:                                          Event

15th-19th/02/2021 : Advanced Microsoft Excel Training

22nd- 26th/03/2021Advanced Microsoft Excel Training

19th- 23rd/04/2021 : Advanced Microsoft Excel Training

Venue: FineResults Research Services, Nairobi, Kenya Training Centre.

Click to Register: Physical class USD 800

                            : Online Training USD 700

Contact us: email: [email protected] or Cell phone (+254 759 285 295)

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

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 759 285 295) or Email: [email protected] 

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 759 285 295)

or Email: [email protected] 

PAYMENT

Payment should be transferred to FineResults Research Limited bank before commencement of training. Send proof of payment through the email: [email protected] 

CANCELLATION POLICY

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

Visit our website for more details

View related courses

The most popular courses

Payment should be transferred to FineResults Research Services account through bank on or before C.O.B. 12th February 2021  

 
Send proof of payment to
[email protected]

View our Information Communication & Technology course Catalogue

For any registration of 3 or more participants; we offer a discount of up to 10%.


Click here now to Register.

For further inquiries email [email protected] or contact us on Tel: +254 759 285 295

 

 

 

Others Details

For further inquiries email [email protected] or contact us on Tel: +254 759 285 295

Registration Fees
Available
Registration Fees Details
usd 800
Registration Ways
Email
Phone
Website
Address/Venue
  FineResults Research Services, Nairobi, Kenya Training Centre. 
Landmark
fahari palace hotel alongside church road
Official Email ID
Contact