Advanced Excel Formulas And Functions Course

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 organization’s 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 via email.