Microsoft Office 2013: Focus on New Features with emphasis on Excel 2013 (133321-14)
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 and
Word, PowerPoint, and Outlook as they apply to accountants. Tips
covering the Windows 8 operating system will also be covered.
Learning Objectives
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 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 8 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 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 Skydrive 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 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
Windows 8: File Explorer, Tiles, Desktop, Metro Interface
customization tips, The Lock Screen, The Start Screen, Running Apps and
Programs, Task Manager, antivirus utilities.
