Advanced Excel Tips and Tricks Every Business Must Know

05/27/2021 CST • Workshop Room 2

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:

  • 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 editing worksheets in bulk.
  • 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 Power Query and how can it help you become a data wizard fast!
  • Attendees will leave the session with tips and suggestions on how to even further their advancement on Excel, while getting their work done.

Presented by:

Karina Arceo Academic Director and Trainer, iKnowledge Training Services

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.As a consultant, she has worked on large projects within high-caliber teams such as Miami-Dade Family Learning Partnership, Hewlett Packard, Carolina’s Pediatric Emergency Fellowship, Price Waterhouse Cooper (Pwc). Also, prominent social influencers and Miami-based corporations are currently employing her training and online marketing skills to maintain their success and evolution. Today sh
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.As a consultant, she has worked on large projects within high-caliber teams such as Miami-Dade Family Learning Partnership, Hewlett Packard, Carolina’s Pediatric Emergency Fellowship, Price Waterhouse Cooper (Pwc). Also, prominent social influencers and Miami-based corporations are currently employing her training and online marketing skills to maintain their success and evolution. Today she continues to train business professionals to develop their different online channels while preserving their unique identities.For seven years she worked in a hybrid role of Helpdesk Specialist and IT Trainer at The Children’s Trust, awarded with different recognitions including the prestigious Employee Of The Year recognition in 2013. Her versatility and dynamic approach in training & development has set her apart throughout the years.

UPDATES & INSPIRATION