11 Advanced Excel Tricks That Will Help You Get An Instant Raise At Work By Walt Hickey 2013-05-03T19:15:00Z ...

Some Groundwork. Okay, let’s cover some basics, so we can get to the cool stuff. First of all, if you’re formatting your data as a table, you’ll already have access to quite a few filters ...

In this guide, learn the process of creating and using Pivot Tables, from basic setup to advanced techniques. Excel Pivot Tables are one of the most powerful tools available for data analysis ...

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

How to use And and Or operators with Excel’s Advanced Filter Your email has been sent Editor’s Note: This article was originally published in July 2010 and the video tutorial for this article ...

Excel's HLOOKUP (Horizontal Lookup) function can search for a value in the first row of a table and then return a value in the same column from a row you specify.

elearnExcel: The Excel Certification School Bundle offers 60 hours of content through 300 easy-to-follow lessons to help you accomplish tasks and solve problems with efficiency and effectiveness.

This month, Susan Harkins introduces an Excel user to advanced filtering and helps a PowerPoint user reduce his work when positioning pictures in PowerPoint.

As you’re working on your own pivot tables, you can experiment to see how added and removing fields affects the data that’s displayed. You’ll find that Excel does a great job of making ...