Excel Workshops

To ensure that our Data Visualization with Excel training benefits all participants, we ask that attendees come with an intermediate level of Microsoft Excel knowledge. To this end, CNE, in coordination with PVCC’s WorkforceServices, will offer two stages of Excel training. Participants can register for either or both of these sessions when registering for Data Visualization with Excel.

Excel Fundamentals I

Date/Time: Tuesday, May 14, 10:00 a.m. to 12:00 pm

Level: Beginner

Registration fee: $35 for CNE Members; $55 for nonmembers

Outline:

  1. II. Cut, Copy, Insert, Delete, Paste Special
  2. Custom Formatting, Undo, Redo
  3. Excel Formulas — The least you should know
  4. Useful functions and Paste Function
  5. Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear
  6. Essential Printing
  7. Data Sorting, Hiding, AutoFormats
  8. Protection, Basic Charts, Basic Formatting
  9. “If” Function

Excel Fundamentals II

Date/Time: Tuesday, May 14, 1:00 to 4:30 pm

Level: Intermediate

Registration fee: $55 for CNE Members; $75 for nonmembers

Outline:

  1. Naming Cells and Ranges
    • Defining Named Cell Ranges
    • Editing and Deleting Named Ranges
    • Using Named Ranges in Formulae
  2. Working with Worksheets
    • Inserting and Deleting Worksheets
    • Renaming Worksheets
    • Moving and Copying Worksheets
    • Using Grouped Worksheets
  3. Linking and Consolidating
    • Linking Cells and Formulae between Sheets and Workbooks
    • Consolidating Multi-Worksheet Data
  4. Formulate and Functions
    • Absolute Cell Referencing
    • Statistical Functions Max/Min/Average/Count Functions
  5. Introduction to Database Features
    • Using the Data Form
    • Sorting Data
    • Filter Data Using AutoFilter
    • Using Find and Replace
  6. Charting and Drawing
    • Creating Charts using the Chart Wizard
    • Editing and Formatting Charts
    • Printing Charts

If you have questions about these programs, please contact Andrew Robinson, Program Manger.

© Center for Nonprofit Excellence 2019

Contact Us

Center for Nonprofit Excellence
1701-A Allied Street
Charlottesville, VA 22903
434.244.3330

Office Hours

Mon – Thurs: 9:00 AM – 5:00 PM
Fri: 9:00 AM – 4:00 PM