Workshops Committee Programs Management Training Series Library Leadership Ohio
 
Microsoft Excel Advanced
Thursday, October 27, 2005
9:00:00 AM - 4:00:00 PM

Location:
Cuyahoga County Public Library--Administration Building
Electronic Classroom

2111 Snow Road Parma, Ohio

Map

Cost:
$75 CAMLS Members
$85 Affiliate Members
$150 Non-members
Free for guests/speakers

Deadline: Thursday, October 20, 2005
Limit: 18
Registered Now: 0
Contact Hours: 6

**Notes:
Fee includes materials only

Participants will learn to use conditional formulas such as SumIf and CountIf, as well as how to utilize three-dimensional formulas and range names. Student will create multiple spreadsheet variations within a single file using Scenario Manager, and customized displays using View Manager. Spreadsheet data will be analyzed through a combination of outlines, Pivot Tables, Data Tables, and Subtotals. Finally, students will learn to solve for complex target values using Goal Seek and Solver.

Prerequisite: Microsoft Excel Intermediate

COURSE CONTENTS

  • Using advanced formulas
  • Customizing spreadsheet displays
  • 3-Dimensional formulas and range names
  • Reporting and analyzing data with Excel
  • Solving for complex values
  • Choose Title

    Audience: This course is for anyone wishing to learn Excel’s reporting and analytical capabilities, and advanced formulas.
    Presenter:
    John Paul is the President and owner of Winsoft, a software training firm. He has been a professional speaker for over eight years. He routinely conducts computer seminars nationwide and is an expert in the Microsoft Office product line.

    More on this topic: