Home Education and Training eContent OCLC Services Consulting and Custom Training Digitization and Preservation

Microsoft® Excel for Power Users 1c: Excel Charting & Organizing Data

Register for upcoming sessions of this course

Policies, cancellations, and inclement weather information.

Prerequisites

Basic Windows^® skills, working knowledge of Excel, Microsoft Excel for Power Users 1a: Creating and Modifying Worksheets (S 101) and Microsoft Excel for Power Users 1b: Formatting, Managing, & Customizing Workbooks (S 201).

Course description

Custom Training Course

Learn how to be more effective when using Excel. This 1/2 day course is designed to review three components of the software program in order to help you become more efficient and successful.

Why take this course?

You already know how to create, edit, format, and print basic spreadsheets. You now have a need to use charts and graphics to display spreadsheet data in more visually effective ways and to sort data.

What you will learn

Creating and Modifying Charts

Create a Chart
Format Chart Items
Change the Chart Type
Create a Diagram

Working with Graphic Objects

Insert Graphics
Create AutoShapes
Format Graphic Objects
Change the Order of Graphic Objects
Group Graphic Objects
Move, Copy, and Resize Graphic Objects

Sorting and Filtering Data

Sort Data Lists
Filter Data Lists
Create and Apply Advanced Filters
Calculate with Database Functions
Add Subtotals to a Worksheet

Course details

Course: S 305

Duration: 1/2 Day

Fee:

Members:		112.00
Non-Members:		160.00

Instructor: