Our firm bills clients in six-minute increments, so I’ve started tracking my beginning and ending time for each job in Excel. Is it possible to round my time calculations to the nearest six-minute increment (a 10th of an hour) in Excel? To read the full article in the Journal of Accountancy, click: Microsoft Office: Rounding Time in Excel.
-
-
What is the best choice when faced with an array of choices for finding specific data in a financial model? Consider this vector analysis. Conspicuous by its absence, LOOKUP may seem a less versatile function upon first glance, but it is quite useful for modelling. To read the full article in Financial Management, click: Things Are Looking Up With This Excel Function.
-
Q. I have a large Excel workbook with many worksheets, and I’d like to summarize the key elements of this workbook into a single dashboard-type report. What’s the best way to do this? To read the full article in the Journal of Accountancy, click: Microsoft Excel: Create a Picture-Based Dashboard Report.
-
The IRS issued a draft version of the 2019 Form W-4, Employee’s Withholding Allowance Certificate, and instructions for the form, in an attempt to further simplify the task of determining income tax withholding for individual taxpayers after the passage of P.L. 115-97, known as the Tax Cuts and Jobs Act of 2017 (TCJA). The TCJA eliminated personal exemptions, increased the standard deduction, increased the child tax credit, limited or discontinued certain deductions, and changed the tax rates and brackets. To read the full article in The Tax Advisor, click: Draft 2019 Form W-4 and Instructions Posted.