Microsoft Office 2013/2016: Focus on New Features with emphasis on Excel
Description
Please Note: The number of MACPA computers we have available for this course is limited. Due to high registration numbers, we no longer have any available for use. However, you may bring your own laptop or you can attend the class without a computer and participate in a regular lecture format.
Every professional will be affected by the many enhancements and features in the new Microsoft Office 2013 and 2016 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 or 2016. 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
Understand changes in the Office user interface
Review file formats and compatibility issues with previous Microsoft Office versions
Explore analysis and reporting tools across Excel, Word and PowerPoint
Understand Excel's new flash fill and other new data analysis features
Track formulas and protect data
Explore new Pivot Table features and PowerPivot
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 Windows tips for managing files and program
Take away templates and references for after class use
Major Topics
Efficiencies and quicker ways to complete assignments
Microsoft OfficeRibbon, Quick Access Toolbar, Contextual tabs, and Styles
Settings andimportant program defaults
Compatibility of file formats with earlierversions of Office
New save to OneDrive and device synchronization
Simultaneous editing and document sharing using web enabled versions ofthe software
Excel’s conditional formatting features and icon sets forbudgeting and tracking key performance indicators
Enhanced Pivot Tablefeatures and slicers for on-demand data analysis
Dynamic Excel chartsusing fewer steps
Linking and updating between Excel and other Officeprograms
Word’s quick formatting capabilities
Reviewing features toincorporate changes by multiple reviewers
Protection of privateinformation
Efficiencies in Outlook
Calendar sharing in Outlook
NewContact Cards to aggregate information
New navigation bar forappointment and email processing
Attachment reminder
Unread mailbutton
All messages preview
Instant Search across all email foldersand archive files
New PowerPoint enhanced presentation graphics
Videouse and other multimedia effects
Presentation broadcast to clients
Presentation file compression
Presentation templates to update thelook and feel of older presentations
Windows 10: File Explorer, Tiles,Desktop, Metro Interface customization tips, The Lock Screen, The StartScreen, Running Apps and Programs, Task Manager, antivirus utilities.
Provider
Business Learning Institute
Course Level
Update
Professional Area of Focus
Technology
CPE Field of Study
Computer Science*
8
Who Should Attend
CPAs and Professionals at all levels of an organization who need to know Microsoft Office productivity features to stay current
