How to use Microsoft Excel’s Color Scale format.
EXECUTIVE SUMMARY Return-on-equity (ROE) is the correct profit metric to evaluate the performance of a business. However, the primary emphasis on financial ratio analysis must be on operating performance. The “advanced” version of the DuPont model remedies the original model’s failure to cleanly separate the effects of operating and financing...
Microsoft Excel
Microsoft Excel: Become an Excel groupie
Tips for using Excel’s Subtotal and PivotTable tools.
Microsoft Excel: Excel in handcuffs
How to unhide unused columns and rows.
Microsoft Excel: Failure to launch
How to get Excel to open a new blank workbook upon launching the program.
Microsoft Excel: A formula for going green
How to color-code formulas in Excel.
Microsoft Excel: Rowing logically
How to convert these two or three lines of data records into single rows.
Excel: The power of mapping
CPAs often have to produce recurring reports, such as quarterly balance sheets, from datasets, such as trial balances. The process can be tedious and prone to error, but an Excel technique called mapping can show the way to better results. Learn more in this Technology Workshop.
Excel at hyphen removal
J. Carlton Collins outlines two ways to remove hyphens from Social Security numbers in Excel.
Calculate length of service in years and months
How to use Microsoft Excel to calculate employees’ length of service.
Transfer an Excel formula from one worksheet to another
Q. I know how to link data from a cell in one worksheet to another worksheet, but how can I transfer a formula? A. To transfer data, enter them in sheet 1, go to sheet 2 and the cell in which you want the linked number to appear and enter
Split an Excel cell and enter two pieces of information
How to use Excel’s Format command to add two pieces of information to one cell.
Features
SPONSORED REPORT
Be prepared for tax season early
Our expert tax report highlights the important issues that tax preparers and their clients need to address for the 2024 tax year. Stay informed and proactive with guidance on critical tax considerations before year-end.
