Monthly financial reporting is a pain for accountants, analysts and other professionals who deal with a huge amount of data and reporting. If you are dealing with financial data than there are items such as write-offs, allocations, accruals, elimination, consolidation and more to take care of.
But what if you could generate, real-time, automated financial reports and statements with a few clicks? Wouldn’t that be fabulous? We have got some good news for you; all that’s possible with our very own, the ubiquitous, Excel.
In this practical and informative webinar by Excel expert David Ringstorm, who happens to be a CPA as well, you will get step-by-step guidance on creating dynamic financial reports for any month of the year on a single worksheet. You will be using Excel functions such as VLOOKUP, OFFSET, and SUM, to quickly create accounting reports that allow you to switch to any reporting period with just two mouse clicks.
Learn to export data from your accounting package; improve the integrity of your spreadsheets; incorporate Check Figures and Alarms into you work; and do many more amazing things to pleasantly surprise your boss.
In this session, David will be demonstrating every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel.
- Using the SUMIFS function to sum values for a single account or a range of account numbers
- Adding a refinement to the SUMIFS function to allow the report to consolidate numbers or display departmental values
- Understanding the nuances of using Microsoft Query to extract data from other Excel spreadsheets
- Creating an in-cell list by way of Excel’s Data Validation feature
- Using the LEFT and VALUE functions to separate account numbers from account names when necessary
- Seeing how to use the Trusted Document feature in Excel 2010 and later to suppress the Data Connection security prompt
- Extracting data dynamically for a given month or year to date by way of the OFFSET function
- Using the Query Wizard within Microsoft Query to choose the relevant columns from your accounting report export
- Returning data to an Excel spreadsheet from Microsoft Query
- How Microsoft Query allows you to create self-updating links to databases, spreadsheets, text files, and other data sources
- The best format for getting accounting data to Excel from an accounting package.
- Applying the OFFSET function to return data for a specific month within a range of 12 columns
- Live Q&A session with speaker
- Handouts: PPT, Excel workbook with examples
- Certificate of attendance
Who Will Benefit:
- Financial analysts
- Financial consultants
- Human resource personnel
- All Excel users