This one-day course will teach participants how to use advanced features, such as automating common tasks, auditing workbooks to avoid errors, sharing and analyzing data, and using Excel data in other applications. This course is intended for individuals who have experience creating, editing and managing workbooks in Excel.
- Work with multiple workbooks and worksheets simultaneously: Use Links and External References, Consolidate Data, Share and Protect Workbooks, Collaborate on a Workbook, Protect Worksheets and Workbooks
- Automate workbook functionality :Work with Forms and Controls, Apply Validation, Work with Macros
- Apply conditional logic: Use Lookup Functions, Combine Functions
- Audit worksheets: Trace Cells, Search for Invalid Data and Formulas with Errors
- Use automated tools: Determine Potential Outcomes by Using Data Tables and Scenarios
- Present data visually: Use Advance Chart Features, Create Sparklines
December 7, 2023 8:30 am - 4:30 pm Virtual