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.
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 identity.
For seven years she worked as 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.
Funded in part through a Cooperative Agreement with the U.S. Small Business Administration. All opinions, conclusions, and/or recommendations expressed herein are those of the author(s) and do not necessarily reflect the views of the SBA.
SCORE Southeast Region | 712 H Street NE PMB 98848 | Washington DC , DC 20002 US
