Instantly jump between sheets and datasets using secret menus, name boxes, custom dashboards, and powerful double-vision ...

Those of us over a certain age will remember using paper lookup tables for logarithms or trigonometry functions. Those who are younger will have been exposed to lookup tables in their programming ...

Microsoft Excel has been the premier spreadsheet software for decades, since outdoing the once venerable Lotus 1-2-3, the first killer app for PCs in the 1980s. And Excel's dominance has yet to be ...

Office Q&A: Excel referencing, Word field codes, and a table trick Your email has been sent It’s been a month of easy answers for the most part. The problems seem big, but as usual, there’s an easy ...

Excel isn’t the sexiest application in the world—it has an unfortunate association with the type of Milton-esque office drones we all wish we weren’t. All the same, you’re going to have to use at some ...

There are two kinds of Microsoft Excel users in the world: Those who make neat little tables, and those who amaze their colleagues with sophisticated charts, data analysis, and seemingly magical ...

Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...

Excel puts lots of great tools on your desktop, but what each one of them does isn’t always obvious, especially since so many Excel features are hidden. Would you like to create multiple lines of text ...

Excel is a powerful tool for managing and analyzing data, but to truly harness its potential, it’s crucial to understand and implement effective data management techniques. By optimizing visibility, ...

Excel is the best piece of software ever made. We've talked a lot about basic formulas and advanced tricks that will make you way better at the program, but we've been remiss and forgot about our ...