Event ended
Intermediate Microsoft Excel
Parkman | Detroit Public LibraryDetroit, MI
Multiple Dates
Overview
A class for those already familiar with the basics or Excel and looking to learn a few more techniques.
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.
A class for those already familiar with the basics or Excel and looking to learn a few more techniques.
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.
Organized by
Parkman | Detroit Public Library
Followers--
Events949
Hosting2 years
Related