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
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