- TypeTraining or Development Class
- Location Nairobi, Kenya
- Date 24-06-2024 - 28-06-2024
Education/Teaching/Training/Development
Research/Science
Business Development
Course: Advanced Microsoft Excel Training
Course Date
Onsite fees:
Registration
25/03/2024 To 29/03/2024
1,000 USD
90,000Ksh
https://bit.ly/47HGb7g
24/06/2024 To 28/06/2024
1,000 USD
90,000Ksh
https://bit.ly/48qnftV
23/09/2024 To 27/09/2024
1,000 USD
90,000Ksh
https://bit.ly/3Ni68lJ
09/12/2024 To 13/12/2024
1,000 USD
90,000Ksh
https://bit.ly/489I5O2
For more information: https://bit.ly/3RdMJDN
Contact: +254 732 776 700 / +254 759 285 295
Email: [email protected]
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 732 776 700 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 732 776 700 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.