CONTACT THE BUSINESS LEARNING INSTITUTE
Name*
Email Address*
Phone Number:
Message:
Please enter the following text in the box below:
captcha
ADDRESS: 901 Dulaney Valley Road, Suite 800
Towson, MD 21204
PHONE: 888-481-3500
FOLLOW BLI:
Microsoft Office 2016: Focus on New Features with emphasis on Excel 2016COURSE ID: EXCELFNE
DESCRIPTION

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

DESIGNED FOR: CPAs and Professionals at all levels of an organization who need to know Microsoft Office 2016 and Windows productivity features to stay currentFIELD OF STUDY: Computer ScienceLEVEL: UpdatePREREQUISITES: Prior experience with Microsoft Office software applicationsCOURSE PRODUCER: Business Learning InstituteCREDITS: 8.0OBJECTIVES:
  • 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
HIGHLIGHTS:

* 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

Download the 2016 Business Learning Institute Course Catalog DOWNLOAD PDF
Business Learning Institute - Course Catalog
SUBSCRIBE TO THE BLI BLOG