How to Use Excel Pivot Tables, Charts, Macros & More to Boost Your Productivity Webinar
Link Copied!
Overview
Microsoft Excel continues to be a widely used program in the business world that helps users remain professionally organized and efficient. In this 4-hour webinar, we will discuss how to get the most use out of several of Excel’s trickier but incredibly helpful features that will allow you to stay ahead at the workplace. This will include:
- Time-saving tips and tricks
- Pivot tables and analysis
- Data visualizations
- Macros and VBA
Objective
To show CPAs and other financial professionals how to utilize many of the most helpful features of Excel in an effort to improve their professional capabilities, streamline their workflow, and save time.
Emphasis
- Excel Fundamentals
– Interface
– Ribbon
– Keyboard shortcuts - Advanced Tools
– Flash fill
– AutoFill
– Convert text to columns - Customizing Tables
- Data Visualizations
- Using Format Painter
- Applying Advanced Formatting
- Advanced Pivot Table Tools
– Report layouts
– Changing summary calculation
– Filtering
– Creating or deleting calculated fields - Creating and Formatting Charts
- Using Macros for Repetitive Tasks
- Custom Automation using Visual Basic for Applications (VBA)
- Create Dashboards with Button-Triggered Macros
View Dates
| Date | Time | Subscriptions | Register |
|---|---|---|---|
| Wed, Nov 4, 2026 Code WO169KCPR03026 | 2:00 PM – 6:00 PM PT | Register | |
| Thu, Nov 12, 2026 Code WO169KCPR01026 | 12:00 PM – 4:00 PM ET | Register | |
| Mon, Nov 16, 2026 Code WO169KCPR01126 | 1:00 PM – 5:00 PM ET | Register | |
| Wed, Dec 2, 2026 Code WO169LCPR01026 | 12:00 PM – 4:00 PM ET | Register | |
| Tue, Dec 8, 2026 Code WO169LCPR03026 | 2:00 PM – 6:00 PM PT | Register | |
| Mon, Dec 14, 2026 Code WO169LCPR01126 | 8:00 PM – 12:00 AM ET | Register | |
| Tue, Dec 15, 2026 Code WO169LCPR01226 | 10:00 AM – 2:00 PM ET | Register | |
| Wed, Jan 13, 2027 Code WO169ACPR01027 | 10:00 AM – 2:00 PM ET | Register | |
| Mon, Jan 18, 2027 Code WO169ACPR03027 | 9:00 AM – 1:00 PM PT | Register | |
| Mon, Jan 25, 2027 Code WO169ACPR01127 | 4:00 PM – 8:00 PM ET | Register | |
| Wed, Feb 3, 2027 Code WO169BCPR01027 | 9:00 AM – 1:00 PM ET | Register | |
| Fri, Feb 19, 2027 Code WO169BCPR01127 | 12:00 PM – 4:00 PM ET | Register | |
| Tue, Feb 23, 2027 Code WO169BCPR03027 | 11:00 AM – 3:00 PM PT | Register |
This course is included in the following subscriptions:
Need more than one course? Upgrade to a subscription and save.
View SubscriptionsPrerequisite
None
Level of Knowledge
Basic
CPE Credits
4
Hours
NASBA Field of Study
Computer Software & Applications