There are a couple of ways to have Excel open most conveniently for you.
Microsoft Excel
Smart Lookup in Microsoft Excel
You can quickly look up text from your Excel spreadsheets from several online sources.
Increase time increments by minutes in Excel
You can incrementally increase times for your agenda by a certain number of minutes.
Change the case of text in Excel
You can change the case of a text string in Excel by using LOWER, UPPER, and PROPER, and they are all so simple to use.
Using 3D formulas in Excel
Using 3D formulas is a easy way to manage files than summing each individual spreadsheet tab.
Extract and present information about dates in Excel
This article looks at a few ways to extract and present information about the day, month, and then year.
When autocorrect is a problem in Excel
There are two ways to solve an autocorrect problem such as the one in the question above — a temporary solution and a permanent solution.
Using SUMIFS to sum with multiple conditions
If you need to create a sum based on more than one criteria, you can use SUMIFS.
Add color to your Excel workbooks
There are several ways to add color to your Excel workbooks.
Create your own custom Excel functions with LAMBDA
If you are routinely creating formulas that accomplish the same purpose, spending a little extra time upfront to create a function that can be reused will save you time in the end.
What is so special about Paste Special in Excel?
This month’s column walks you through all the special ways you can paste text, data, and even application capabilities in Excel.
Creating a drop-down list in Excel
Creating drop-down lists in your spreadsheets is a great way to ensure that only certain information
is entered into a cell.
Combining formulas and text in the same cell in Excel
You can include both a formula and text in the same cell in Excel.
How to easily transpose data in Excel
The Transpose feature allows you to rotate data from columns to rows and vice versa from rows to columns without reentering any of the data.
A blockchain glossary, the CPA firm of the future, and Excel malware
Blockchain — what does it mean to you? A glossary of terms offers clarity. Also, hear or read more about accounting firms’ tech-integrated future.
Features
SPONSORED REPORT
Agentic accounting has arrived: What’s hype and what’s real?
Artificial intelligence (AI) is moving beyond chatbots and into accounting workflows. A new generation of agentic AI tools can plan, execute, and adapt as they complete tasks, raising expectations for what automation can do inside firms and finance departments. What can agentic AI realistically do today and what challenges are there in its implementation? Find out in this Journal of Accountancy sponsored report.
