Course ID: EXCEL-L

Excel Refresher and Update for CPAs

About & Customize

Popular Options

  • In-Person
  • Live Webcast

  • 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

  • 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.

To get started, contact BLI:
(888) 777-7077
team@blionline.org