Microsoft Excel III : Visual Communications
How do you most efficiently show the results of your work ? After all , it doesn ’ t matter how innovative your idea or important your finding is if you can ’ t effectively convey the information ! This intermediate Excel topic will explore tools in the program involving visual displays of data , including the utilization of tables , slicers , charts , and formatting . In this training , you can expect to :
Duration : 120 minutes Location : Virtual via Zoom Target Audience : All employees Recorded : No
» Delve into a better way of formatting with rules and conditions
» Demonstrate ways to convey complex data more simply by creating tables and slicers
» Practice data visualization by creating chart layouts , cell styles , and document themes
Participants will receive a manual and practice files for follow-up work after the class !
Date / Time : Tuesday , June 4 , 2024 at 10 a . m .
Tuesday , November 5 , 2024 at 10 a . m .
Microsoft Excel IV : Data Design & Pivot Tables
Pivot tables allow you to summarize the data easily , providing a flexible and efficient way to analyze and present large sets of data , thus making it easy to identify trends and patterns that might otherwise go unnoticed . This advanced Excel topic will focus on Data Validation with large reports , and how integral this is to creating pivot tables successfully . In this training , you can expect to :
Duration : 120 minutes Location : Virtual via Zoom Target Audience : All employees Recorded : No
» Discuss best practices for normalizing and validating data for us in a pivot table
» Learn about converting imported data from a data range into a table for data analysis and manipulation
» Practice creating pivot table and pivot charts to analyze worksheet data , such as viewing trends and outliers
Participants will receive a manual and practice files for follow-up work after the class !
Date / Time : Tuesday , July 30 , 2024 at 10 a . m .
Wednesday , December 4 , 2024 at 10 a . m .
Page | 18 Dates , times and locations are subject to change . Training & Development Catalog | 2024