With spilling, you can create a formula in one cell, and that formula will then spill over into other adjacent cells when a set of values is calculated.
Information management and technology assurance
Companies urged to bolster defenses against ‘triple threat’
Businesses are experiencing more, and more costly, incidents of fraud, compliance breaches and cyberattacks but are not doing enough to protect themselves, KPMG says in its 2022 Fraud Outlook report, A Triple Threat Across the Americas. The report recommends five steps companies can take to mitigate the risk of losses to this “triple threat” of dangers.
Using range names in Excel
Using range names in Excel allows you to quickly navigate to areas of your worksheet and makes formulas much easier to create.
Card-carrying ways to automate expense reports
Just about everything we do daily has been automated in some way. And that includes expense reports.
4 cool features for optimizing Outlook
Here are four features that can help you make the most efficient use of Outlook.
5 key steps for digital transformation during a crisis
Major changes can be difficult to implement at any time but especially during a pandemic. Here are some lessons learned from a successful system implementation.
Work with other departments to bring more tech to your curricula
Follow these tips for successful interdepartmental collaborations.
Calculating the issue price of a bond using the NPV function in Excel
When teaching financial accounting, faculty often discuss bonds payable and how to calculate the issue price of a bond. Consider teaching students to calculate the issue price by using the net present value function in Excel.
A road map for learning data analytics
Models can help faculty teach — and students grasp — this important subject.
Helping clients build a cyberattack recovery plan
CPAs can play critical roles in helping companies plan
their recovery from online attacks.
How to hide zero values
In certain scenarios, showing zero values can be
very distracting. They can be easily hidden in Excel.
Using stocks and other data types in Excel
You can convert text in Excel to linked data types. This is referred to as “linked” data types because the data is connected to an online data source.
Using the Excel personal assistant
Excel Personal Assistant can help you locate all the features Excel has to offer.
6 lessons from audit experts who adopted AI early
Machine learning is within reach for many audit firms.
Career advice and RPA tips from CPA leaders
One CPA leader shares more on being a lifelong learner and the advice she gives to up-and-coming accountants; another leader explains some of the opportunities that firms have to automate certain processes and begin to offer more advisory services.
Performing a simple linear regression in Excel
When teaching cost behavior in a managerial or cost accounting course, we explain that there are various methods a company can use to estimate its fixed and variable costs, including regression analysis. The next time you cover this topic, consider teaching students how to perform a simple linear regression analysis in Excel.
Ask the expert: Road to digital transformation
Guy Pearson is a Chartered Accountant, Chairman of Interactive Accounting, a progressive accounting firm he founded in 2009, and an angel investor in a portfolio of companies.
Journal-entry testing using Excel
In this example walk-through, learn how to use Microsoft’s spreadsheet application to perform several tasks, including sampling.
5 advanced PowerPoint tips for awesome presentations
This month’s column lays out five tips designed to help even experienced users of Microsoft PowerPoint push their presentations to the next level.
AI in manufacturing: Optimizing costs and enabling the workforce
Manufacturing leaders can use artificial intelligence to improve efficiency and drive growth. But taking full advantage of the technology requires upskilling the workforce.
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.