Advanced Excel Workshop@ Ordre de Malte

In today's data-driven world, Excel proficiency is essential for professionals.

This  6-hour  course during 2 days for 2 different groups is  designed  to  take  participants  from  beginners  to experts.

Covering 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.

Sylla​bus

• 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