Intermediate Microsoft Excel

In this class we'll learn some more conditional yet powerful techniques for Excel, including:

• GO TO Special - a modified version of Find/Replace to look up formulas, errors and more.
• Pivot Tables - A formatting tool for creating smaller tables from existing data within your spreadsheet.
• How to create a Named Range.
• Inserting Drop Down lists into your worksheet.
• What is Conditional Formatting and how to use it.
• Using the Text to Column feature to split information in one column into two separate ones, as long as that information is divided by a comma, colon or space.

Host or Publisher Parkman | Detroit Public Library