Pivot Tables are one of the most important features of Excel for search engine marketers. You can slice and dice the data in order to find those great little nuggets of insight you need.

VLOOKUP and Search are two functions that Excel uses to search for text. VLOOKUP finds data in a column and returns the contents of an adjacent cell.

Learn how to easily set up your own search field in Excel to find and filter content within a table.

This video originally appeared on Business Insider.Video The Excel Formatting Shortcuts You Need Most Plus easy ways to remember which shortcut does what.

It explains how to make your own menus in Word, Excel, and PowerPoint (both v.X and 2004), and how to take advantage of Word’s Work menu. Take it away, Kirk! Create a Menu — In this brief tutorial, I ...

Excel VLOOKUP Basics & Top 5 Mistakes Rookies Make An Excel VLOOKUP can be your best friend. It can save you hours of work. Give this formula the information you have and it looks through a long list ...