Spreadsheet Track

Registration is required and begins four weeks before the class.

Register online or call the Main Library Computer Center at 216-991-2030 x2385.  If you reach the library’s automated attendant, choose Option 8 to reach the Computer Center.


  • Excel 2013 I

    Excel is a great way to track budgets, analyze data, and make charts. Learn the basics of spreadsheet construction: how to enter, edit, sort, and format data. We will also go over how to do basic calculations.

    At the end of this class, participants should be able to:

    • Launch Excel 2013 and create a new workbook
    • Enter, edit, and sort data
    • Change the formatting on the text
    • Calculate sums and averages
    • Create new worksheets
    • Save and print

     

    Proficiency with a keyboard and mouse are required for this class.

    View Link Website (external link)

  • Excel 2013 II

    Explore the ways Excel can display data as tables or visualize your information with charts. Learn how to sort data, use autofill, and use formulas.

    At the end of this class, participants should be able to:

    • Autofill
    • Create tables
    • Use formulas
    • Create sparklines
    • Generate charts

     

    Concepts covered in the Excel 2013 I class are required for this class.

    View Link Website (external link)

  • Excel 2013 III

    Find trends in your data or organize it in useful ways! Learn to create Pivot Tables to display data in different ways. We will review Pivot Charts and conditional formatting, which offer dynamic ways to present your information graphically.

    At the end of this class, participants should be able to:

    • Structure your data for analysis
    • Create and modify PivotTables
    • Apply conditional formatting
    • Create and modify PivotCharts

     

    Concepts covered in the Excel 2013 I and II classes are required for this class.

    View Link Website (external link)