MS Excel Advanced August 30, 2022, 6:30pm EDT August 30, 2022, 8:00pm EDT

This information-packed session will demonstrate with realistic examples some of the advanced functionalities of Excel, hand-picked based on our clients' requests and based on our 20 years of experience in the IT Training industry.

This workshop will include:

  • Best practices when dealing with large amounts of data in Excel.
  • Step-by-step on how to perform advanced functionalities such as: protect your worksheet, quick error-finding shortcuts, and worksheets.
  • Advanced formulas allowing the calculation of data based on conditions and rules (SUMIF, COUNTA, ABS, Conditional Formatting)
  • Complex functions to identify the maximum or minimum values, remove or identify duplicates, conditional formatting.
  • An introduction of standard Charts, Pivot Tables, and VLookup formulas.
  • Learn about the functionality of Dashboards, Slicers, and Pivot Charts.

Attendees will leave the session with tips and suggestions on how to even further their advancement on Excel, while getting their work done.


About the Presenter(s)

Karina Arceo

Karina Arceo is an accomplished IT Trainer from Maracaibo, Venezuela with over 20 years of achievement in the information technology industry. She holds a proven track record of successfully implementing learning processes to products and services that have transformed businesses across South Florida.  

Key Topics

MS Excel Advanced