This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.
Microsoft Excel
Microsoft Excel: Count the words in a cell
Use this formula to count the number of words in a Microsoft Excel cell.
How to boost Excel efficiency with Power Query
This article shows how Microsoft Power Query for Excel can streamline the ongoing delivery of additional data for analysis by PivotTables.
Microsoft Excel: How to make Social Security numbers private
How to print a report with truncated Social Security numbers.
Microsoft Excel: Fixing a proofing formula that fails every time
The problem, it turns out, is related to Excel’s famous built-in 15-digit number limitation.
Microsoft Excel: 3 quick tips
Handy Excel tips from “Technology Q&A” author J. Carlton Collins, CPA.
Microsoft Excel: How to link text boxes to data cells
Yes, it is possible to link the contents of a text box in Excel to data in a cell.
Microsoft Excel: Modify Excel’s default blank workbook
It is possible to modify Excel’s default blank workbook; you can even modify the default new worksheets that you insert into your existing workbooks.
Microsoft Excel: How to evaluate complex formulas
How to use Excel’s Evaluate tool to understand complicated formulas.
Microsoft Excel: How to reference vertical cells horizontally
A handy trick makes it possible to reference vertical data horizontally.
Microsoft Excel: Rules for designing Excel workbooks
By following a common set of spreadsheet design rules, companies can produce more consistent workbooks that may be easier to review, edit, and use by others in their organizations.
Using Excel and Benford’s Law to detect fraud
This Technology Workshop shows how to use Microsoft Excel to determine whether the numbers in a data set follow Benford’s curve or point to possible malfeasance.
What fonts work best in Excel?
When it comes to choosing the best font for displaying both text and numbers, the font you choose matters.
New mapping tools on Excel 2016
Microsoft Excel 2016 has two new mapping capabilities.
Microsoft Excel: 3 ways to calculate internal rate of return in Excel
Excel offers three functions for calculating the internal rate of return, and I recommend you use all three.
Features
SPONSORED REPORT
Preparing clients for new provisions next tax season
As the 2025 filing season approaches, H.R. 1 introduces significant tax reforms that CPAs must be prepared to navigate. These legislative changes represent some of the most comprehensive tax updates in recent years, affecting both individual and corporate taxpayers. This report provides in-depth analysis and guidance on H.R. 1.
