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.
Advertisement
TOPICS
Information management and technology assurance
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.
Creating the right visuals for your data
Two leading figures in the field of data visualization explain how CPAs can best use visual depictions of numbers and how history’s “heroes of visual thinking” transformed numbers into images that carry ideas and meaning.
The Excel Advanced Filter function gives you flexibility
Advanced Filter allows you to generate a unique list of items and extract those items to another place in your worksheet or workbook.
Cleaning and joining data using Excel’s Power Query
This month’s column shows how to clean and join data using Excel’s Power Query.
Don’t get victimized by a cybercriminal
CPAs must create data security protocols and implement and follow them consistently to help reduce the risk of a cyber incident.
How to use COSO to implement and scale AI projects
The COSO enterprise risk management framework can help leaders manage risks associated with their AI strategies.
How Excel COUNTIF function saves time when analyzing final grades
When analyzing grades (especially for a large class) the COUNTIF function in Excel can be extremely helpful.
2021 tax software survey: Shares of respondents and product and company information
Bonus: The percentages for all 13 products, including a breakdown of their usage among firms ranked by ranges of numbers of preparers, in the 2021 tax software survey.
Add Favorites to the Ribbon
You can add all your favorite or frequently used Excel features in one tab on your Ribbon.
Print comments and notes in one place
It is very simple to view and print all the notes and
comments within an Excel worksheet in one place.
Helping clients before a cyberattack
CPAs play critical roles in helping companies prepare for online attacks.
2021 tax software survey
See how the brands compare in CPAs’ annual assessment of their tax preparation programs.
A take on cryptoasset transactions, investments, and risk
CFOs need to gain perspective on how to handle the accounting, tax, internal control, and risk management challenges of cryptoasset transactions.
Edit PDF documents in Word to save time
Did you know that you can edit PDF documents in Microsoft Word? Simply open a PDF document in Word.
4 tips for optimizing Outlook
Here are four tips for making the most efficient use of Outlook. These are based on the online version of Outlook.
Ask the expert: What is an API?
Calvin Leong helps firms understand what APIs are available at Thomson Reuters and how to use them.