- TypeWorkshop
- Location Nairobi, Kenya
- Date 02-07-2018 - 06-07-2018
Business Development
Finance
Advanced Excel Formulas and Functions course -(July 2 July 6, 2018 for 5 Days)
Register online to attend: https://bit.ly/2y9Y5TS
Organizer : Foscore Development Center(www.fdc-k.org)
Venue:Clarion Hotel, Nairobi,Kenya
Course fee: $ 1,000, Ksh 70,000
Introduction
The course focuses on those aspects that are important in everyday day operation of organization. Intermediate users will also benefit from this course as it covers the in-depth topics of Complex Charts, PivotTables, Pivot Charts and management Dashboards.
DURATION
5 days
WHO SHOULD ATTEND?
The course is targeted excel uses to improve their Skills for today’s organizations needs. It will equip participant with complex functions within Excel, including tools for analyzing, linking and exporting data.
Course Objective:
Functions in Excel mostly used in business
analyzing large data
Management dashboards
Automate and Customize data entry forms
Multiple Variable styles
Custom Formulas/Functions
Generate Reports
Control of forms, Buttons and Drop-down menus
Special Commands
Using forms for data entry and report generation control.
Course content
Introduction
Excel Formulas
Conditional Statements & Logical Operators
Statistical Functions
lookup/Reference Functions
Text Functions
Date & Time Functions
Formula-Based Formatting
Array Formulas
Functions
Advanced IF Statements
Advanced Lookup Functions
Complex Logical and Text Functions
Formula Auditing
What-If Analysis Tools
Worksheet and Workbook Protection
Advanced Use of PivotTables and Power Pivot
Automating with Macros
Working with Form Controls
Ensuring Data Integrity
Managing & Enriching Data
Data Analysis
Presentation
Custom Views In Excel
Scenario
Auditing And Troubleshooting Formulas
Pivot Tables
Pivot Charts
Goal Seek And Solver and data tables
Macros
Basic Visual Bascis
General Notes
All our courses can be Tailor-made to participants needs
The participant must be conversant with English
Presentations are well guided, practical exercise, web based tutorials and group work. Our facilitators are expert with more than 10years of experience.
Upon completion of training the participant will be issued with Foscore development center certificate (FDC-K)
Training will be done at Foscore development center (FDC-K) center in Nairobi Kenya. We also offer more than five participants training at requested location within Kenya, more than ten participant within east Africa and more than twenty participant all over the world.
Course duration is flexible and the contents can be modified to fit any number of days.
The course fee includes facilitation training materials, 2 coffee breaks, buffet lunch and a Certificate of successful completion of Training. Participants will be responsible for their own travel expenses and arrangements, airport transfers, visa application dinners, health/accident insurance and other personal expenses.
Accommodation, pickup, freight booking and Visa processing arrangement, are done on request, at discounted prices.
One year free Consultation and Coaching provided after the course.
Register as a group of more than two and enjoy discount of (10% to 50%) plus free five hour adventure drive to the National game park, in Nairobi.
Payment should be done two week before commence of the training, to FOSCORE DEVELOPMENT CENTER account, so as to enable us prepare better for you.
For any enquiry at:[email protected] or +254712260031
Download our brochure here-http://fdc-k.org/FDC%20Brochure.pdf
Request for Invoice and Invitation letter using this link-https://bit.ly/2y9Y5TS
View Business and Governance courses calendar 2018-2019 – http://bit.ly/2FERaSh
View All Courses calendar 2018-2019 -http://bit.ly/2mB2p5w
Course Fee:KES:70000|USD:1000|EURO:900|POUND:800