Checkboxes can help you create interactive to-do lists and other types of lists that track progress.
Microsoft Excel
Quickly clean data with Excel’s TRIMRANGE and trim references
The TRIMRANGE function eliminates blank rows or columns from the boundaries of a specified range. This can be helpful when importing data from external sources, which can result in inconsistent formatting.
3 ways to use ChatGPT-4o with Excel
This column looks at three ways to use
ChatGPT-4o with Excel.
Say bye to PivotTables with Excel’s new PIVOTBY function
This column introduces PIVOTBY, a new Excel function that may let you say bye-bye to PivotTables.
Using Excel’s GROUPBY function as a PivotTable alternative
This month’s column introduces Excel’s GROUPBY function as a PivotTable alternative.
How to use Excel’s AGGREGATE Function
This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.
Doing accounts receivable aging reports in Excel
This article provides an example of building a dynamic AR aging schedule in Excel.
How to use Excel’s UNIQUE Function
Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.
Using Excel’s What-If Analysis with Data Table for data analysis
This column shows how to use the Data Table option in Excel’s What-If Analysis tool.
Using Excel’s Goal Seek for data analysis
This month’s column shows how to use Excel’s Goal Seek for data analysis.
Using Excel’s Scenario Manager for decision-making
This column shows how to quickly project financial possibilities with Excel Scenario Manager.
10 types of Excel charts for data visualization
This column tours of some of the most useful charts, starting with the basic ones and moving to the more advanced.
Using ChatGPT-4o with Excel
Learn how to use the new ChatGPT-4o (Omni) to interact with Microsoft Excel.
Identify and delete duplicates in Excel
This article looks at a few ways to identify duplicates in Excel.
How to create a watermark in Excel
This column shows a couple of ways to create a watermark in Excel.
Features
SPONSORED REPORT
Smart Strategies in Data Security and Risk Management
In an increasingly digital profession, data security has become one of the most critical challenges facing finance and accounting professionals today. Stay up to date with practical guidance to help you mitigate these risks and strengthen your security posture.