Microsoft Office 2013 New Productivity Features for CPAs: Excel, Outlook, Word, PowerPoint, OneNote (130214-15)
Description
Every professional will be affected by the many enhancements and
features in the new Microsoft Office 2013 programs. Excel analysis tools
and presentation graphics are among the many updates. This course will
tell you what you need to know to migrate to Office 2013. Special
emphasis will be given to the new productivity features in Excel, Word,
PowerPoint, Outlook and OneNote as they apply to CPAs. Participants will
learn many time-saving tips and receive course take-away resources.
(Format: hands-on, instructor-led)
Learning Objectives
After completing this course, participants will be able to: •
Understand changes in the Office 2013 user interface • Review file formats and compatibility issues with previous Microsoft Office versions • Explore analysis and reporting tools across Office 2013 Excel, Word, Outlook, PowerPoint, and OneNote •
Understand Excel's new flash fill and other new data analysis features • Track formulas and protect data • Explore new Pivot Table features and the PowerPivot add-in • Use Outlook's new productivity features • Examine new Word features for ease of document creation, manipulation and review • Use new time-saving PowerPoint features to quickly create new presentations with dynamic graphic elements •
Learn how OneNote can become an important collaboration tool
Major Topics
Efficiencies and quicker ways to complete assignments
Microsoft Office
2013 Ribbon, Quick Access Toolbar, Contextual tabs, and Styles
Settings
and important program defaults
Compatibility of file formats with
earlier versions of Office
New save to OneDrive and device
synchronization
Simultaneous editing and document sharing using web
enabled versions of the software
Excel’s conditional formatting
features and icon sets for budgeting and tracking key performance
indicators
Enhanced Pivot Table features and slicers for on-demand data
analysis
Dynamic Excel charts using fewer steps
Linking and updating
between Excel and other Office programs
Word’s quick formatting
capabilities
Word reviewing features to incorporate changes by
multiple reviewers
Protection of private information
Efficiencies in
Outlook
Calendar sharing in Outlook
New Contact Cards to aggregate
information
New navigation bar for appointment and email processing
Attachment reminder
Unread mail button
All messages preview
Instant
Search across all email folders and archive files
New PowerPoint 2013
enhanced presentation graphics
Video use and other multimedia effects
Presentation broadcast to clients
Presentation file compression
Presentation templates to update the look and feel of older
presentations
OneNote digital note-taking, note searching, and
collaboration features