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,
it's a program that most people will end up having to use at some point in
their life, and it's one with a lot of arcane secrets. Read on for 10 quick
Microsoft Excel tips and tricks that will get you accounting like a pro in
no time flat.
Time to Pivot
Time to Pivot
Pivot Tables
are one of Excel’s most useful—and misunderstood—features. Here’s a quick
lesson: Click within a chunk of data, click Insert, and select “Pivot Table.”
Excel should automatically pick the entire range of said data (provided you
don’t have any blank columns interrupting your dataset), and convert this into
an editable, table-as-you-go kind of setup. You can use the various
“fields” on Excel’s new sidebar to basically create new tables of information
(and calculations) on-the-fly.























