Course ID: EXCELFNE

Microsoft Office 2016: Focus on New Features with emphasis on Excel 2016

Every professional will be affected by the many enhancements and features in the Microsoft Office 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 2016. Special emphasis will be given to the new productivity features in Excel and Word, PowerPoint, and Outlook as they apply to accountants. Windows 7 and 10 operating system tips will also be covered. Participants will take away tips, templates, and tutorial references for after class use. (Format: “hands-on, instructor-led group training”)


LEARNING OBJECTIVES
  • Utilize changes in the Office 2016 user interface
  • Identify file formats and compatibility issues with previous Microsoft Office versions
  • Explore analysis and reporting tools across Office 2016 Excel, Word and PowerPoint
  • Utilize Excel’s new FlashFill 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
  • Become familiar Windows 7 and 10 tips for managing files and programs

MAJOR TOPICS
  • Efficiencies and quicker ways to complete assignments
  • Microsoft Office 2016 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
  • 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 2016 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
  • Windows 7 and 10: File Explorer, Settings, Desktop, Interface customization tips, The Lock Screen, The Start Screen, Running Apps and Programs, Task Manager, antivirus utilities

DESIGNED FOR
CPAs and Professionals at all levels of an organization who need to know Microsoft Office 2016 and Windows productivity features to stay current

FIELD OF STUDY
Computer Science

PREREQUISITES
Prior experience with Microsoft Office software applications

COURSE PRODUCER
Business Learning Institute

CPE CREDITS
8.0

LEVEL
Update

This course is avaliable for your group as:

Group Live
 

Let's Roll!

To learn more or customize this course for your group, complete this form and a BLI team member will get back with you shortly.


Or, contact BLI: 888-481-3500 or learn@blionline.org