This refresher course covers Excel Worksheet features in a fast-paced format to benefit beginner through intermediate level users. The many new business productivity enhancements in Excel 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 choices: “Lecture/Demonstration with live demo” or “hands-on, instructor-led group training”)
Learning Objectives
Utilize proven single and multiple worksheet design techniques
Use time-saving data entry techniques
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 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
Uae 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 design and printing features for single or multiple page worksheets
Designed For
CPAs and Professionals at all levels of an organization needing to save time with the day-to-day features of Excel
Field of Study
Computer Software & Applications
Prerequisites
Familiarity with Microsoft Excel
Course Producer
Business Learning Institute
CPE Credits
3
Level
Basic
Available Formats
In-Person, Live Webcast
Types
Seminars
This course, like all courses in the BLI catalog, is customizable for your organization.
Format, length, and content customizations are available.