Description

Now that you have clean, accurate data in your workbook, you need to discover what's really happening within your organization. With logical and lookup functions, combined with Pivot Tables, you can analyze your data in thousands of useful combinations, and visualize the insights you find. In this session, we'll be combining the power of functions and Pivot Tables to deliver real value. Topics include:

• Categorizing data with logical functions
• Categorizing data with lookup functions
• Creating summary tables with Pivot Tables
• Visualizing insights with Pivot Charts
• Deep-diving into analysis with Slicers and Timelines