Microsoft Office 2010: Focus on New Features with emphasis on Excel 2010 (133152-13)
Description
Microsoft Office 2010 enhancements, including collaboration tools, offer
professionals many new features to increase productivity. Once again,
Excel analysis tools and presentation graphics have improved. This
course will focus on new features added in Microsoft Office 2010 to
migrate effortlessly to this new version. Special emphasis will be given
to the new productivity features in Excel as well as Word, PowerPoint
and Outlook as they apply to accountants. (Format: hands-on
instructor-led training)
Learning Objectives
Understand the new Office 2010 user interface productivity features
Review file formats and compatibility issues with previous Microsoft
Office versions
Explore analysis and reporting tools across Office
2010 Excel, Word and PowerPoint
Understand Excel's new compliance
features for tracking formulas and protecting data
Explore Excel's
enhanced data analysis features including new Pivot Table features and
slicers
Use Outlook's new conversation tracking 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
Take away templates and
references for after class use.
Major Topics
Use Interface New Features:
Use the Microsoft Office Ribbon, Quick
Access Toolbar, Contextual tabs, and Galleries
Learn new customization
features for the Ribbon and the Quick Access Toolbar
Understand
backwards compatibility of file formats with earlier versions of Office
Change important program defaults
Use the new screen capture tools
for reporting
Understand protected mode when opening files
Control
document meta-data easily for security
Explore new SharePoint
interactivity, new time-saving print options and new features in the new
File menu called Backstage
Understand the new autosave feature
Explore the save to Skydrive feature
Learn how to share documents for
simultaneous editing using Office Web Apps
Explore the web enabled
versions of the Office programs for file collaboration
Use Excel's
conditional formatting features and icon sets
Track key performance
indicators with new business dashboards
Use Excel's table feature for
quick data analysis
Use enhanced Pivot Table features and slicers to
filter data
Create dynamic Excel charts in fewer steps
Incorporate
sparkline graphics into cells to show trends in data
Explore
interactivity between Excel and other Office programs
Use Word's quick
formatting capabilities and Live Preview
Use the new interface to
merge changes by multiple reviewers
Use Quick styles and document
themes
Use the new drag-and-drop navigation pane editing features to
rearrange parts of a complex document quickly
Use new options to
protect private information
Use Outlook's color category feature
effectively
Integrate tasks into the Outlook calendar to manage daily
priorities in one place
Use new instant search features across all
folders and archive files
Learn the tools to integrate Outlook with
social networks
Use the new conversation view to track and cleanup
email threads quickly
Explore the new Ignore button to delete
conversation threads no longer needed
Use the Outlook Quick Steps
feature to create single click rules for day-to-day repetitive steps
Use new PowerPoint 2010 tools and design templates for enhanced
presentation graphics
Learn to insert videos into a presentation with
little effort and new enhancements
Broadcast presentations to clients
Convert PowerPoint presentations to videos
Learn to easily compress
media to reduce file size.
