Excel Training for Professional Development

This series of Excel courses is designed for staff at Bowdoin. Each course covers a range of topics with hands-on exercises.

Excel Basics (1.5 hours)

This course covers basic features and navigation in Excel. It is offered twice to accomodate schedules:

Tuesday, Feb 26 - 3:00 - 4:30pm - Register
Friday, Mar 1 - 9:00 - 10:30am - Register


Topics Covered:

  • Sorting and filtering
  • Entering data with AutoFill
  • Find and replace
  • Splitting and combining information in separate columns
  • Basic formulas (sums, counts, averages, percents)
  • Formatting cells (date/time, currency, percentages, text, etc.)
  • Adding and removing hyperlinks
  • Basic exports (csv, pdf)
  • Mail merges

 

Charts and Tables (1.5 hours)

In this course you will learn how to create charts, build and format tables, and set up spreadsheets for presentations. If you are new to Excel, please plan to attend Excel Basics before registering for this course. Charts and Tables is offered twice to accomodate schedules:

Thursday, Mar 7 - 3:00 - 4:30pm - Register
Friday, Mar 29 - 9:00 - 10:30am - Register


Topics Covered:

  • Working with tables
  • Conditional formatting
  • Hide/Show columns and rows
  • Inserting comments, shapes, and arrows
  • Creating charts and graphs
  • Axes, labels, gridlines, legends
  • Exporting charts for use in other programs

Working with Data (1.5 hours)

This course covers features in Excel that help you analyze, compare, and consolidate your data. If you are new to Excel, please plan to attend Excel Basics before registering for this course. Working with Data is offered twice to accomodate schedules:

Friday, Apr 5 - 3:00 - 4:30pm - Register
Tuesday, Apr 30 - 9:00 - 10:30am - Register


Topics Covered:

  • Advanced formulas (relative and absolute values, SUM IF, percent change, referencing values from other worksheets)
  • Data validation (restrict the data than can be entered in a cell)
  • VLOOKUP
  • Working with pivot tables
  • Slicing data

Details

Article ID: 25513
Created
Thu 2/23/17 10:24 AM
Modified
Thu 4/4/19 4:39 PM

Files (6)

jpg

bowdoin_wordmark.jpg

2/23/2017 10:39:43 AM 
xlsx

Excel Basics.xlsx

2/27/2019 1:23:47 PM 
xlsx

Excel Charts.xlsx

3/7/2019 5:49:46 AM 
docx

mail merge letter.docx

2/25/2019 3:49:08 PM 
xlsx

mail merge list.xlsx

2/25/2019 3:49:08 PM 
xlsx

Working with Data.xlsx

4/4/2019 4:37:59 PM