Advanced Excel

Event description

THIS WEBINAR IS PRESENTED IN SPANISH.

This information-packed session will demonstrate, with realistic examples, some of Excel's advanced functionalities, carefully selected based on our clients' requests and 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.
• Instructions on how to perform advanced functions such as: protecting your worksheet, quick shortcuts for finding errors and worksheets.
• Advanced formulas allow the calculation of data based on conditions and rules (SUMIF, COUNTA, ABS, conditional formatting)
• Complex functions to identify maximum or minimum values, remove or identify duplicates, and conditional formatting.
• An introduction to standard charts, pivot tables, and virtual lookup formulas.

Learn about the functionality of dashboards, slicers, and dynamic charts.

Attendees will end the session with tips and suggestions for further progress in Excel as they complete their work.

Cost: Free

A copy of the recording and the materials will be sent to the attendees.