CANCELLED: Excel Worksheet Refresher for CPAs (130225-16)
Description
This refresher course covers Excel Worksheet features in a fast-paced
format to benefit basic through intermediate level users. The many new
business productivity enhancements in Excel will be covered.
Participants will learn worksheet design, formats, reports, data
management in lists, presenting data in charts, new features, and many
quick tips. The content of this presentation applies to Excel 2013, 2010
or 2007. Participants will learn many time-saving tips and receive
course take-away resources. (Format: hands-on, instructor-led)
Learning Objectives
After completing this course, participants will be able to: •
Learn proven single and multiple worksheet design techniques • Use time-saving data entry techniques • Use a variety of formulas and functions for budgeting and reporting • 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 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 new cell styles, the Format Painter tool, and the repeat key • 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
Complete the course having learned many Excel tips
Use formula
building techniques and learn new functions
Compare relative and
absolute formula references
Learn how to save time with Excel keyboard
shortcuts and new ribbon features
Use the new Table feature for
manipulating lists
Compare the Table to the Pivot Table
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
