Training & Events

Microsoft Excel Boot-Camp Training - Sold Out

Microsoft Excel Boot Camp -  March 3, 24 & 31

 Excel2016Bootcamp_grande (002).gif (17 KB)

Microsoft Excel Level 1 - Sold Out
This course is intended for new Microsoft Excel 2016 users

Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:

  • Create, save, open, close and move around in an Excel workbook to learn navigation skills necessary for creating and using Excel worksheets. 
  • Organize columns and rows to accommodate information and edit the contents of cells to organize the information in your worksheet.
  • Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute cell reference, create formulas by typing functions or build more complex formulas using the Insert Function dialog box.
  • Format worksheets and use view features to more effectively review large worksheets.
  • Use views to determine the layout of a worksheet, change the page setup, and preview/print workbooks.

 

Microsoft Excel Level 2 - Sold out

Who should attend?
This course is intended for participants who are familiar with Microsoft Excel 2016.

Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:

  • Organize, protect, and display data using various tools.
  • Use the IF function, create linking formulas, and manage links.
  • Manage and arrange multiple workbooks, insert and manage multiple worksheets within a workbook, and consolidate data from multiple sources.
  • Create and modify charts to present data effectively; customize charts to enhance their appearance.
  • Create, apply and modify styles to format worksheets consistently and quickly; use comments, text boxes to annotate worksheets, and sparklines to highlight and explain data.

 

Microsoft Excel Level 3 Sold Out

Who should attend?
This course is intended for participants who are familiar with Microsoft Excel 2016

Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:

  • Create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form, as well as look up data.
  • Sort records in a data list using a variety of methods.
  • Filter data in a list using a variety of methods, as well as work with filtered data.
  • Create and work with subtotalled lists, as well as use various database functions to summarize data.
  • Create, modify, and work with PivotTables, PivotCharts, and Slicers.
  • Import external data from a variety of sources into Excel.

 

Microsoft Excel Level 3 - March 31, 2020

  • $100.00 (Members pay $65.00)

Back