In today's data-driven world, Excel proficiency is essential for professionals.
This six-hour course was conducted for Ordre de Malte teams over two days for two different groups.
The course covers basic to advanced Excel features, including pivot tables and macros, participants will gain hands-on experience in data analysis and visualization. Emphasizing practical application and efficiency, this course equips learners with the skills needed to excel in their careers.
Syllabus

• ICE BREAKING
• INTRODUCTION
• AUTOFILL KEYBOARD SHORTCUTS IN EXCEL
• ADVANCED KEYBOARD SHORTCUTS
• WORKBOOK INSTRUCTIONS
• EXCELNAVIGATION&VLOOKUP
• VLOOKUP FUNCTIONALITY
• ADVANCED VLOOKUP TECHNIQUES
• DIFFERENCE BETWEEN FORMULAS AND FUNCTIONS
• SUMIFS, AVERAGEIFS, &COUNTIFS
• CONCATENATE FUNCTIONS
• THE IF FUNCTION
• ADVANCED FILTERING TECHNIQUES CONDITIONAL FORMATTING FOR DATA MANAGEMENT
• DATA VALIDATION
• ADVANCED DATA ANALYSIS FUNCTIONS