We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

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 10/08/2020 to 14/08/2020

Event information

Course Name : Advanced Microsoft Excel Training

Venue : FineResults Research, Nairobi, Kenya
Event Date : 10/08/2020 to 14/08/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: [email protected]

PAYMENT

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

Visit our website for more details

How to participate

Individual Registration

Contact information

Email:[email protected]

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

Schedules

No. of Days: 5
Total Hours: 50
No. of Participants: 50
Reviews
Be the first to write a review about this course.
Write a Review

FineResults Research Services offers training solutions to individuals, communities, governments and civil society organizations, both local and international.

We also provide application-oriented and field-based consultancy services in all aspects of research and evaluations from inception to completion. This includes research designs, designing monitoring and evaluations systems, technical reviews, programme evaluations, questionnaire validation, data collection, data capture, data analysis and report writing. FineResults Research Services is a limited company incorporated under the laws of Kenya. Its head office is in Nairobi Kenya.

The organization has a wide range of experience working with both local and international organizations in both consultancies and capacity building in Africa and beyond.

Mission

A world class training and research organization for the realization of individuals, organizations and community welfare.

Vision

To provide world class training and research services that increase individuals and organizations productivity in their development role.

Our Value Statement
  • We cherish partnerships.
  • We believe that our Training and Research Solutions can re-energise organisations by creating vision, certainty and strategic intent. ...
FineResults Research Services
Nairobi, Kenya
+254732 776 700
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.