Participants will learn how to create Pivot Tables using a large data set, apply filters in a Pivot Table, use field and report filters on a Pivot Table, create calculated fields in a Pivot Table, create logical tests using basic IF functions, evaluate when to use the AND & OR functions with IF functions, and create nested IF statements.
This course will be held virtually on December 11, from 10:00am to 3:30pm. The course is limited to 12 grant participants.
Pivot Tables allow you to present your data in a professional and organized manner. You can also create Pivot Charts to add visual appeal to your summary data. Pivot Tables and Pivot Charts are a quick and easy way to see comparisons, patterns, and trends. Both Pivot Tables and Pivot Charts enable you to make informed decisions about your data. Content for this course is compatible with the following Excel versions: 2016, 2021 and Office 365.
Upon completion of this course, the learner will be able to:
• Create, organize, and format a pivot table.
• Change how values in your pivot table are displayed.
• Filter, Slice, and Group the Pivot Table data.
• Create calculations in your Pivot table.
• Create different types of Pivot Charts to visually represent the data.
• Use the VLOOKUP and HLOOKUP to look up values arranged in a vertical or horizontal layout.
• Review and use the IF function to evaluate a scenario.
• Learn how to create nested IFs.
• Review the setup and use of the AND function in combination with the IF function.
• Review the setup and use of the OR function in combination with the IF function.
• Review the setup and use of the INDEX and MATCH lookup functions.
This course would be beneficial to anyone who needs to sift through a large amount of data looking for trend and patterns or looking for an easy way to summarize data.
Point Value: 4