Excel for Accountants: Volume 1

Learn how to complete your job tasks more quickly and build a strong foundation.

Created by: Jeff Lenning
Microsoft Certified Trainer

What Will I Learn?

• Recall at least 3 shortcuts to improve your speed
• State how to name a cell with the name box
• Recall the special properties of tables
• Identy the feature that can create an in-cell drop down
• State which feature will format a cell based on the value of a cell
• Recognize which feature can simulate a bar chart
• State why the SUBTOTAL function is preferred to the SUM function in many situations
• Identify a technique that helps ensure that a new row inserted between the last data row and the formula row is included in the total row formula
• State whether or not values on a hidden worksheet are available to formulas on other sheets
• Recall the cell style name introduced for input cells
• State the purpose of an error check worksheet
• Identify whether or not it is a good idea to split the data from the report
• Recognize at least three workbook design principles

Requirements

• To work on the exercises, please have Excel 2007/2010/2013 for Windows.

Target audience

• This course is designed for accountants seeking to use Excel to complete their tasks more quickly.
• This course is not designed for people seeking generic Excel training, as the features covered are relevant to accountants.