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 worksheets.
· Advanced formulas allowing the calculation of data based on conditions and rules (SUMIF, COUNTA, ABS, Conditional Formatting)