Séminaire 2024-10-21 12:00 matin 2024-10-25 12:00 matin
Advanced Excel Formulas And Functions Training Course
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 CONTENT
• 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
CERTIFICATION
Upon successful completion of this training, participants will be issued with a Macskills Training and Development Institute Certificate
TRAINING VENUE
Training will be held at Macskills Training Centre. We also tailor make the training upon request at different locations across the world.
AIRPORT PICK UP AND ACCOMMODATION
Airport pick up and accommodation is arranged upon request
TERMS OF PAYMENT
Payment should be made to Macskills Development Institute bank account before the start of the training and receipts sent to info@macskillsdevelopment.com
meridian best western nairobi
Coordonnées
https://macskillsdevelopment.com/course/advanced-excel-formulas-and-functions-training-course
info@macskillsdevelopment.com