If you’re still dragging columns around, you’re doing extra work.

Struggling with unwieldy Excel spreadsheets that seem impossible to manage? You’re not alone. Many of us face the challenge of organizing large datasets in a way that makes sense and is easy to ...

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

Excel sheets read data in cells using cell references, which are the addresses that identify each cell. Visual Basic macros also read data using cell references, extracting data by reading the cell's ...

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 ...

Microsoft Excel has great tools to help you in getting important data easily without any research. You can get almost any data in Excel directly with just some functions. The less-used data function ...

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

If you’re a full-time spreadsheet jockey, or just a casual number-cruncher, you’ve come to know and either love or hate Excel’s interface. Well, your world just changed. Throw away almost everything ...