Learn how to organize, analyze, and summarize data in Excel using Pivot Tables!
September 10, 2021
This session is based on Learnit's full-length workshop on Excel Pivot Tables. Everyone who attends all of Learnit's free Friday events in September will receive a badge of certification in Excel Power User.
Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, stay organized with checklists, and much more! In this short session, you'll learn how to organize, analyze and summarize data using Excel Pivot Tables.
1. Organize and clean data in spreadsheets for pivot table analysis
2. Manage and update pivot table source data to display new values
3. Edit pivot table report formats and settings
4. Format default layout for pivot table reports
Anyone looking for tools and tips on how to use Excel Pivot Tables to work more effectively and efficiently!
September 29, 2023
In this session, you’ll learn how to increase your productivity with OpenAI’s flagship product: ChatGPT.