25.8.20
This website uses cookies to ensure you get the best experience on our website. Learn more

Advanced Excel Course

This training empowers Excel users to elevate their knowledge and skills in Microsoft Excel and apply them to perform data manipulation for work needs. This program is composed of 6 hours of instruction, divided into two sessions. Session #1 (3 hours): Participants will learn the following Excel features. LookUp Index Match Advanced formulas Conditional formatting Macros Data Models Session #2 (3 hours): In a workshop setting, participants will gain hands-on practice with department-related worksheets that participants will bring to the session. Participants will solve data problems and transform workbooks for decision making, using the new concepts, formulas, and skills learned in the first session. Participants will receive instructor guidance throughout the process.

Skills / Knowledge

  • LookUp
  • Index
  • Match
  • Advanced Formulas
  • Conditional Formatting
  • Macros
  • Data Models