Microsoft Office 2013/2016: Focus on New Features with emphasis on Excel
Description
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”)
The number of computers available for use 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 the computer, and participate in a regular lecture format.
Learning Objectives
Upon completion of this seminar, participants will be able to:
Understand changes in the Office user interface: (1) Review file formats and compatibility issues with previous Microsoft Office versions (2) Explore analysis and reporting tools across Excel, Word and PowerPoint
Understand Excel's new flash fill and other new data analysis features : (1) Track formulas and protect data, (2) Explore new Pivot Table features and PowerPivot, (3) Use Outlook's new productivity features, (4) Examine new Word features for ease of document creation, manipulation and review, (5) Use new time-saving PowerPoint features to quickly create new presentations with dynamic graphic elements
Learn Windows tips for managing files and programs: 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
Business & Industry
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.
