Advanced Excel Formulas and Functions course

"Promoting organisational effectiveness"
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 todayaa‚¬a„¢s organizations needs. It will equip participant with complex functions within Excel, including tools for .. continue reading analyzing, linking and exporting data. Course Objective: aa‚¬A¢ Functions in Excel mostly used in business aa‚¬A¢ analyzing large data aa‚¬A¢ Management dashboards aa‚¬A¢ Automate and Customize data entry forms aa‚¬A¢ Multiple Variable styles aa‚¬A¢ Custom Formulas/Functions aa‚¬A¢ Generate Reports aa‚¬A¢ Control of forms, Buttons and Drop-down menus aa‚¬A¢ Special Commands aa‚¬A¢ Using forms for data entry and report generation control. aa‚¬A¢ Course content aa‚¬A¢ Introduction aa‚¬A¢ Excel Formulas aa‚¬A¢ Conditional Statements & Logical Operators