New MACPA.org Launching 4/1! Stay tuned for a brand new online experience.

Microsoft Office 2010: Focus on New Features with Emphasis on Excel (133153-12)

Description

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 choice:” hands-on, instructor-led training”)

Highlights

User Interface New Features Effectively 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
Understand new Author Permissions settings to share file editing Control
document meta-data easily for security Explore new SharePoint
interactivity Explore new time-saving print options Explore the 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

Office Web Apps Explore the web enabled versions of the Office programs
for file collaboration

Excel 2010 New Features 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

Word 2010 New Features 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

Outlook 2010 New Features Use Outlook’s color category feature
effectively Integrate tasks into the Outlook calendar to manage daily
priorities in one place Use new search features Use the new Jumplist
features such as Outlook 2010 processes 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 Quick Steps feature to
create single click links to perform multiple steps used day to day

PowerPoint 2010 New Features 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 Learn to
broadcast presentations to clients with Office Live Workspace features
Learn to record slideshows as videos

Learning Objectives
  1. Understand the new Office 2010 user interface productivity features Review file formats and compatibility issues with previous Office versions Explore analysis and reporting tools across Office 2010 Excel, Word and PowerPoint
  2. 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 Be able to 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
Provider
SCG Training & Consulting
Course Level
Update
CPE Field of Study
Computer Science*
8
Location
Gateway Building
Event Information
When
May 24, 2012
8:30 am - 4:30 pm EST
Location
Gateway Building
Total CPE Credits
8
Format
In-Person

MEMBER


$ (% off)
$330.00

NON-MEMBER


$ (% off)
$480.00
Become A Member

Register for this Event

Microsoft Office 2010: Focus on New Features with Emphasis on Excel (133153-12)


Loading
Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×