Microsoft Office Training

Excel Pro for Accounting

Course Description

Excel is no doubt a useful tool for accountants to building financial statements, budgets, and other analysis reports, yet not much of accountants have received any formal Excel training. As a result, they are spending more time than needed to complete their work and prone to potential errors in the tasks. From making some of the mundane tasks more tolerable through automation, to everyday functional tasks. Microsoft Excel is definitely an essential end-user computing tool that helps accounting professionals to perform a wide range of tasks.

This course emphasizes on the fundamental concepts of Excel and the implementation of spreadsheet tools that foster analysis and calculation techniques. For instance, Participants will learn how to import and export accounting data, as well as how to sort and filter data to analyze and generate account report. Through this training, participants will also be taught on how to protect their workbooks and discover how to use Data Validations to reduce account entry blunders.

Array of formulas and accounting applications like Sum Wizard, text functions, VLOOKUP will be explained specifically to the participants so they can better manage numerous account codes and construct checks and controls to eradicate account inaccuracies.

Accounting professionals will greatly benefit from this comprehensive course whereby they will be able to learn how to automate the formulae entry as well as developing inventory, depreciation and financial summaries. Apart from that, the training will equipped the participants with the efficient skills in using Excel's data analysis tools, including the pivot table feature which allows users to excerpt summary details from a database and further evaluate its information.

Who should attend:

• Industry-wide Professional Accountants
• Directors of corporate accounting and financial reporting, controllers and senior accountants
• Auditors and other professionals involved with financial reporting
• Financial Analysts and other financial statement users

Pre-requisites

General familiarity with Microsoft Excel 2010 is expected but no assumption of knowledge of specific tools or techniques is assumed.

Area of focus

• Using lists in excel
  • Sorting on multiple keys
  • Auto-filtering excel list
  • Getting more from advanced filters
  • Handling the total row and data form
• Pivot tables
  • All about data summaries
  • Manipulate and sort financial data
  • Creating pivot tables and grouping numeric fields
  • What’s up with the data cache?
  • Static and dynamic name range
  • Common sizing income statements

• Charting
  • Standard chart vs. Pivot chart
  • Budget variances over time
  • Time series chart

• Tools for accountants
  • Built-in lists
  • Working on custom and complex list
  • What can a Macro do?
  • trace cells and troubleshoot formula errors
  • Keyboard shortcuts
• Scenarios in Excel
  • Scenarios, multiple inputs & worksheets
  • Using goal seek and solver

• Excel functions
  • Develop standard financial calculations for business plans, pro-forma & tax issues
  • Payment functions (PMT, PV, NPER, RATE)
  • Depreciation functions (SLN, DB, SYD, DDB, VDB)
• Quickbooks
  • Exporting & importing data from IIF file
  • Profile and standard list
  • Adjusting entries