Excel Tips and Tricks for Publishers: VLOOKUP & HLOOKUP

This is the the fourth and final tutorial in a series of Excel tips for Publishers. This series is an introduction to using Microsoft Excel and includes tools such as: using the VLOOKUP & HLOOKUP formulas within the same spreadsheet, in a different sheet, and from a different workbook.

Excel Tips and Tricks for Publishers – GRAPHS & PIVOT TABLES

This is the the third tutorial in a series of Excel tips for Publishers. This series is an introduction to using Microsoft Excel and includes tools such as: creating and formatting graphs, pivot tables.

Excel Tips and Tricks for Publishers – CELL TRICKS

This is the the second tutorial in a series of Excel tips for Publishers. This series is an introduction to using Microsoft Excel and includes tools such as: copying and moving data, removing dashes from an ISBN, merging and hiding cells, and freezing panes.

Excel Tips and Tricks for Publishers – BASICS

This is the first tutorial in a series of Excel tips for Publishers. This tutorial is a very basic introduction to using Microsoft Excel and includes tools such as: formatting numbers and tables, typing and repeating formulas, and organization.

Removing Invisible Apostrophes from Spreadsheets

So you’re happily working away in Excel, performing some sorting wizardry on your piles of data. But then disaster strikes. You notice that some fields of data are not being […]