Use Design Ideas in PowerPoint to create an animated title slide

By typing into the title slide you can access a range of design ideas related to the topic of your presentation.

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.

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.

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.

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.

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.

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.

Teach students tech (and more) with award-winning assignments

Learn about some of the assignments and activities that won AICPA Effective Learning Strategies Educator Awards this year.

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.

AICPA, NASBA launch CPA Evolution Model Curriculum

The AICPA and the National Association of State Boards of Accountancy (NASBA) have launched the CPA Evolution Model Curriculum (CPAEMC), a recommended blueprint for an accounting program designed to help educators prepare graduates for the changing demands of the CPA profession.

Use the Camera tool in Excel to create dynamic screenshots

The Camera tool is a handy function that allows you and your students to see how part of one spreadsheet changes in real time when you make changes to another.

See descriptive statistics in Excel

Learn how to use Excel to quickly calculate basic descriptive statistics for a dataset, including mean, standard deviation, minimums, and maximums.

Add the Data Analysis ToolPak to Excel

Excel’s Data Analysis ToolPak allows you to perform many advanced data analytics functions. Here’s how to enable it.

Various ways to display formulas in Excel

There are a number of different ways that you can display formulas in Excel. This can be useful when investigating why a certain formula isn’t working correctly or when grading your students’ worksheets to ensure they are using formulas correctly.

Spend less time on repetitive tasks with Excel macros

Make mundane tasks easier by harnessing the power of automation.

Use VLOOKUP to help manage your gradebook

VLOOKUP is a formula that allows you to “look up” certain data and retrieve it into another table, by row. This function can be especially useful when you have a well-structured table with information organized by rows (such as a gradebook)!

Use the Quick Access Toolbar to increase your efficiency in Excel

Try this tip and have your most-used functions right at your fingertips.

Calculating depreciation using the SLN function

When teaching depreciation in Introduction to Accounting, faculty always cover a variety of different depreciation methods, including straight-line depreciation. Next time you teach this topic, build your students’ Excel skills by showing them how to use the straight-line (SLN) function in Excel.

Use conditional formatting in Excel to visualize letter grades

Highlight different letter grades with different colors so you can see at a glance how your students performed.

Use Excel’s sparklines to quickly show trends in data

Simple to create, sparklines are tiny graphs that help you make sense of data at a glance.