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