Excel 2010 New Features Update and Tips (133135)
REGISTRATION STATUS:
Online registrations are closed for this event. We can take your registration over the phone at 800-782-2036.
Description:
This refresher course covers Excel 2010 Worksheet features in a fast-paced format to benefit beginner through intermediate level users. The many new business productivity enhancements in Excel 2010 will be covered. Participants will learn about file compatibility issues with earlier versions of Excel and how to save time with many quick tips. (Format: hands-on instructor-led training)
Objectives:
Understand the new Office 2010 user interface productivity features Learn proven single and multiple worksheet design techniques Enter text, values and formulas in worksheets Create a variety of formulas and functions and use new structured referencing and formula autocomplete Create relative and absolute formula references Move and copy data by using shortcut menus, mouse pointer shapes and many tips Restructure worksheets to accommodate new data, columns and rows Use time-saving data entry techniques Use the time-saving ribbon tools and customize the quick access toolbar Use time-saving keyboard shortcuts Change the appearance of worksheet data by using business formatting techniques and the new table styles gallery Use fast formatting with the new cell styles Use border line combinations and features for separating lines for financial reports Use a variety of print options and the new page layout view for single page and multiple page worksheets Learn multiple worksheet features Incorporate worksheet data into bar and pie charts using the new chart features Evaluate the advantages and disadvantages of paste, paste as picture and paste link Excel data and charts to Word or PowerPoint
Major Topics:
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 protected mode when opening files Understand new Author Permissions settings to share file editing Complete the day having learned many Excel tips Explore formula building techniques and learn new functions Compare relative and absolute formula references Learn to save time with Excel keyboard shortcuts and new ribbon features Use the new Table feature for manipulating lists Incorporate new bar graph and pie chart templates into an Excel file for presentation quality graphics Understand formatting techniques to enhance the presentation of worksheet data Understand time-saving printing features for single or multiple page worksheets
Who Should Attend:
CPAs and Professionals at all levels of an organization needing to save time with the day-to-day features of Excel
Prerequisite:
Knowledge of MS Excel
