Microsoft Excel 2000: The Next Level

  • Facebook
  • LinkedIn
  • Twitter
  • Google Buzz
  • Forward


Microsoft Excel 2000: The Next Level

Excel spreadsheet software is a powerful tool for organizing, comparing, calculating and displaying library data. But Excel has so many features that they can't all be covered in a single day. Designed for people who've already gotten their feet wet with Excel, this intermediate course picks up where Infopeople's beginning Excel workshop left off.

  • Are you comfortable with Excel basics and ready to go on to the next level?
  • Do you need to learn how to roll data automatically from one or more spreadsheets to another?
  • Have you ever wondered what the heck a "Pivot Chart" is?
  • Do you want to publish spreadsheets on your Web site?

Learning more about how to harness the power of Excel will enable you to create complex spreadsheets more effectively. Whether you are comparing data across years, coping with various budget scenarios, or using Excel to manage a multitude of library statistics, this course will help you use Excel more productively in your library.

Workshop Description: This all-day workshop will provide hands-on experience of the more sophisticated features of Excel, including using pivot charts for summarizing data, creating multiple spreadsheets for statistical analyses, writing macros to increase efficiency and publishing on the Web. Using library examples, the course will focus on practical, useful tips that can be applied immediately in your work.

Topics to be covered:

  • Review of Basic Excel Concepts
    • Data entry principles
    • Formatting worksheets
    • Creating lists in Excel
  • Creating Multisheet Workbooks
    • Inserting and renaming individual worksheets
    • Copying and editing formulas across worksheets
    • Creating summary sheets
  • Using Excel's Analysis Features
    • Creating a pivot table to summarize data
    • Embedding worksheets and charts in documents
    • Creating what-if scenarios
  • Tips & Tricks
    • Writing macros
    • Publishing to the Web
    • Converting documents from and to Excel

Who Should Attend: Anyone in a California library with an interest in learning more about using Microsoft Excel 2000's powerful features and their usefulness in the library setting.

Prerequisites: While there will be a review of the basics of Excel, this course is not suitable for beginners. Students should be familiar with basic Excel features and should be comfortable moving around Excel spreadsheets and inputting data.

Please Note: There is a $75.00 fee for this workshop. Infopeople does not provide parking passes, lunch or refreshments.

Check-in: 8:30 to 9 AM Instruction: 9 AM to 4:30 PM

Available for contracting: 
No