Upgrade your spreadsheets with BYCOL to consolidate column logic, prevent manual errors, and build automated reporting dashboards.

Create a self-updating Excel checklist with checkboxes, IFS due-date priority, and a progress data bar for faster tracking.

BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.

Tracie Lee, a lecturer in the College of Business and Economics, has significantly expanded educational resources for students by recording 21 new Excel tutorial videos for McGraw Hill. McGraw Hill ...

Suzanne is a content marketer, writer, and fact-checker. She holds a Bachelor of Science in Finance degree from Bridgewater State University and helps develop content strategies. Learn about our ...

Microsoft has announced a new feature for Excel called the Copilot function, which brings artificial intelligence (AI) directly into spreadsheet cells. The tool allows users to type plain-language ...

Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might expect that pivot tables—which can be used to summarize rows and columns of ...

Have you ever found yourself endlessly dragging formulas across rows or columns in Excel, only to realize there’s got to be a better way? Maybe you’ve spent hours creating helper columns or ...

Reviews and recommendations are unbiased and products are independently selected. Postmedia may earn an affiliate commission from purchases made through links on this page. Excel is the most widely ...

While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such cases, Excel's LOOKUP function can be extremely useful. It allows you to ...

Restoring the drag-and-drop menu in your Excel Pivot Table is typically a quick fix. By using either right-click options or ribbon commands, you can easily access the field list again. If all else ...