Skip to content

Our computer skills workshops are a great tool to take your Microsoft Excel and Microsoft Access skills to the next level. These workshops are hands-on and seating is limited to ensure small class size.

Due to their demand and in-depth focus, these workshops are fee-based. Please confirm space availability with the Achievement and Learning Center prior to registration.

Payment is required to reserve a seat: $10/UB students, $20/UB staff and alumni, $30/general public. Our registration form is available here.

Click the [+] alongside the titles to read the workshop descriptions and view upcoming dates.


  • Access 1

    Why create a database? What can Access do that a spreadsheet can't? Learn the difference between Access and Excel and build a simply database from scratch. Create and relate tables of information, make forms to easily enter data, and produce basic reports.

    Saturday , Sept. 26, 9 a.m.-1 p.m.
    Saturday , Nov. 14, 9 a.m.-1 p.m.

    required: basic knowledge of Windows environment

  • Access 2

    Import and manipulate data from a spreadsheet like Excel and produce visually appealing reports. Learn about sophisticated functions such as using advanced queries, updating information, finding what you need and deleting what you don't, and performing calculations. 

    Saturday , Sept. 26, 1:30-5:30 p.m.
    Saturday , Nov. 14,
    1:30-5:30 p.m.

    required: skills covered in Access 1; see above for details

  • Access 3

    Now that you can manipulate data in Access, add advanced control features and visualize your data in charts. Learn how to minimize errors during data entry, save time by automating processes and protect your database.

    Saturday , Dec. 5, 1:30-5:30 p.m.

    required: skills covered in Access 1 and 2; see above for details

  • Excel 1

    Easily manipulate tables of information—contact lists, schedules, budgets, and more—for presentation and analysis. Learn to sort alphabetically, chronologically, large to small, etc.; use basic formulas to add, subtract, multiply, and divide; and format and print with headers, footers, and gridlines.

    Friday, Sept. 11, 1:30-5:30 p.m.
    Friday, Oct. 9, 9 a.m.-1 p.m.
    Friday, Oct. 23, 1:30-5:30 p.m.

    required: basic knowledge of Windows environment

  • Excel 2

    Perform more complex calculations in several tables. Create multi-step formulas and replicate patterns of numbers, dates, etc. without typing. Use pivot tables and functions to summarize your data (count, find average and locate maximum and minimum values) and display your results in charts and graphs.

    Saturday, Sept. 19, 9 a.m.-1 p.m.
    Saturday, Oct. 24, 9 a.m.-1 p.m.
    Saturday, Nov. 21, 9 a.m.-1 p.m.

    required: skills covered in Excel 1; see above for details

  • Excel 3

    Perform sophisticated analyses on large tables of data using time-saving tools and more advanced graphics. Learn to automate repetitive processes with macros, perform "if...then" calculations, display only the data you need and change the look of cells based on their values. You'll also create advanced charts (dual axis, stacked, area, and trendlines). 

    Saturday, Oct. 24, 1:30-5:30 p.m.
    Saturday, Nov. 21, 1:30-5:30 p.m.

    required:  skills covered in  Excel 1  and some skills from  Excel 2;  see above for details


Last Published 10/2/15