Microsoft Excel is a powerful tool for analyzing financial data and preparing financial reports, but like most powerful tools, it contains hidden features and functionality useful for these purposes that are not obvious to users, both novice and expert alike. The purpose of this course is to uncover these hidden features so that users may prepare computationally accurate and aesthetically pleasing reports in a more effective and efficient manner. It provides solutions for accountants in the following three major topic areas: 1) Techniques for formatting financial statements and other reports; 2) Techniques for financial analysis with Excel, including using PivotTables as analytical tools; and 3) Techniques for consolidating financial data.
Upon completing this section, participants should be able to:
- Describe how to use tools such as the Format Painter, the Accounting Format, and the Hidden Format to format Excel worksheets more efficiently;
- Discuss the purpose of custom format and describe how to create them;
- Explain the significance of Excel Precision as Displayed feature and how to activate it; and
- Describe how to apply conditional formatting to Excel data.
Back to top