Description

Staff accountants often need guidance to learn which features can help them create effective Excel workbooks. This course will teach them about many of Excel’s accounting-centric features enabling them to work more efficiently and generate accurate results.

Course Objectives

• Identify five critical best practices associated with creating workbooks

• Use PivotTables and PivotCharts to quickly summarize and present data without generating formulas

• Select from functions such as VLOOKUP, XLOOKUP, SUMIFS, CHOOSE, XNPV, XIRR, PMT, IPMT, ACCRINT, and TRIM, when creating financially-oriented calculations in your worksheets

• Use Tables from ranges of Excel data and identify the primary advantages of working with Tables

• Apply formats quickly and efficiently to Excel reports and understand the importance of Styles

• Use date-oriented data in Excel and create calculations involving the passage of time

Subjects

• Best practices for creating and working with Excel workbooks

• The importance of PivotTables in modern reporting environments

• Best practices for formatting your workbooks

Prerequisites

Fundamental knowledge of Microsoft Excel