Impress your coworkers with these nifty tricks.

The Office Scripts action recorder can generate code snippets for Excel changes, but some actions still require manual ...

Glide turns an Excel spreadsheet into an inventory app; computed columns replace formulas, giving live stock-on-hand totals ...

Stop sacrificing screen space—Excel tables, Watch Window, Focus Cell, and split views keep context without locking rows.

Calculating payroll can be a time-consuming endeavor, so automating as much of the process as possible will save you hundreds of hours by the end of the year. Fortunately, Microsoft Excel comes with a ...

Learning to use Excel worksheets like relational databases can help you save time, eliminating duplication when managing large projects. A relational database is useful because information resides in ...

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them. Microsoft Excel offers a plethora of tools for ...

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...

Working with multiple worksheets can be quite tough for Excel users, especially if there is a lot of work. In Microsoft Excel, there are several tricks that individuals can use to switch between Excel ...