Pragmatic Excel - Automating Financial Statements
As an alternative to building cumbersome accounting worksheets for each month of the year, Excel expert David Ringstrom, CPA, explains how to use Excel functions, including VLOOKUP, OFFSET, and SUM, to quickly create accounting reports that allow you to switch to any reporting period with ...
On demand, 2 hour(s)
Who Would Be Interested in This Course:
Practitioners who will benefit from learning how to create monthly financial statements more effectively in Excel.
• Creating an in-cell list by way of Excel’s Data Validation feature.
• Improving the integrity of spreadsheets with Excel’s VLOOKUP function.
• Discovering how to incorporate Check Figures and Alarms into your work.
• Overcoming VLOOKUP’s quirks by using SUMIF to look up numeric values.
• Using Excel’s VLOOKUP function to look up an item description based on an input provided by the user.
• Using Conditional Formatting to draw attention to reports that don’t balance to the source data.
• Learning a simple design technique that greatly improves the integrity of Excel’s SUM function.
• Learning why, in many cases, you should export reports intended for spreadsheet analysis to a .CSV file instead of an Excel workbook.
• Seeing how to use the Trusted Document feature in Excel 2010 and later to suppress the Data Connection security prompt.
· Define how to create accounting reports for any month of the year on a single worksheet.
· Apply Excel’s OFFSET function to isolate monthly amounts and sum YTD amounts.
· Recall how the VLOOKUP function can be used to look up an item description based on user input.
Experience Working with Excel Spreadsheets Recommended