Excel Intermediate Webinar-Half Day-29th March

Course Outline: Microsoft Excel Intermediate Webinar

• Introductions
• Keyboard Shortcuts
• Basic Formulas & Functions Recap
• Absolute Referencing
• Advanced Functions (Vlookup, Sumifs, Countifs)
• Date Functions (Workday, Networkdays, Today, Now, Weeknum)
• Text Functions (Trim, Len, Concat, Left, Right, Search, Proper)
• Database Fundamentals
• Conditional Formatting Basics
• Conditional Formatting Advanced
• Data Validation
• Removing Duplicates
• Q&A
• Conclude