4 ridiculously useful Excel tools Microsoft barely tells you exist
Excel has been around for decades; somewhere along the way, Microsoft buried a handful of genuinely brilliant features so deep in menus that most people never stumble onto them. These aren’t obscure formulas or power-user shortcuts either. They’re built-in tools that could save you hours if you just knew where to look. Related I typed three semicolons into Excel and found its strangest formatting trick Excel keeps a display layer and a data layer. Not on the ribbon, but three clicks from your toolbar Of everything Excel hides, the Camera tool is probably the most underused. It lets you take a live snapshot of any range of cells, formatting and all, and paste that snapshot anywhere else in your workbook, in another workbook, or even into Word or PowerPoint. The catch, however, is that unlike a regular screenshot, this image stays dynamically linked to the source data. Change a number in the original cells, and the snapshot updates automatically. This makes it perfect for building dashboards, since you can pull together snapshots of tables and …








EmilienItim_0667.jpg?trim=0%2C0%2C0%2C0&width=1200&height=800&crop=1200%3A800&ssl=1)
