Excel tips and tricks for business - Session 2 - Key Excel functions

Excel tips and tricks for business - Key Excel functions forms the second part of our six-course series that covers the essentials of using Excel in a business context.

This session discusses the use of different Excel functions, which ones can be replaced by others, and useful functions you might not be aware of:

• Lookup functions: VLOOKUP, INDEX/MATCH, XLOOKUP, and more
• Conditional functions: SUMIF(S), COUNTIF(S), IF, etc.
• Why you should never use VLOOKUP and HLOOKUP
• Text functions
• Date functions
• Useful miscellaneous functions like OFFSET, MOD and others.

In the 'Excel tips and tricks for business' series we look at the core functions and features in Excel that help people build up spreadsheets and solve problems in a manner that is consistent, robust, flexible and transparent.

You can find more information about the other five sessions in the 'Agenda' tab.