FAST3 banner
Faculty and Staff Technology Training Team
  Home Workshops Calendar Registration General Information About FAST3 Contact Us  

Microsoft Excel Training

 

Excel 2013: Getting Started

In this 2-hour short course you will learn how to comfortably move around in the Excel 2013 environment. Additional topics will include entering text and values in a worksheet, basic formatting, printing and using Help.

Prerequisite: Familiarity with Windows
Instructor:
FAST3 Staff
Hours:
2 hours
Fee: $49

Date / Time: Sept. 18, 2014 (Th); 10:00 a.m. - 12:00 p.m.
Registration Code: W-2835-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

Excel 2013, Level 1

This 6-hour course is designed for those who desire to gain skills to create, edit, format, and print basic Microsoft Excel 2013 worksheets. Upon successful completion of this course, attendees will be able to: create a basic worksheet using Excel 2013; perform calculations in an Excel worksheet; modify and format an Excel worksheet; manage an Excel workbook; and print the contents of an Excel workbook.

Prerequisite: Familiarity with Windows
Instructor: FAST3 Staff
Hours:
6
UIUC CEUs: 0.6
CPDUs: 6 (Illinois teachers are eligible to earn 6 CPDUs for this workshop)
Fee: $159

Date / Time: July 8 & 9, 2014 (TuW); 9:00 a.m. - 12:00 p.m. on Tuesday; 1:00 p.m. - 4:00 p.m. on Wednesday
Registration Code: W-2787-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Date / Time: July 29 & 31, 2014 (TuTh); 1:00 p.m. - 4:00 p.m.
Registration Code: W-2797-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

Excel 2013, Level 2

In this 6-hour Excel 2013 Level 2 course, you will create advanced formulas; analyze data with logical and lookup functions; organize worksheet data with tables; visualize data by using charts; and analyze data with PivotTables, slicers, and PivotCharts. This course is about one simple idea: asking your data questions and using Excel 2013 to find the answers.

Prerequisite: Completion of Excel 2013 Level 1, or equivalent knowledge
Instructor: FAST3 Staff
Hours:
6
UIUC CEUs: 0.6
CPDUs: 6 (Illinois teachers are eligible to earn 6 CPDUs for this workshop)
Fee: $159

Date / Time: Aug. 7 & 8, 2014 (ThF); 9:00 p.m. - 12:00 p.m.
Registration Code: W-2802-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

Excel 2013: Formulas & Functions

In this 2-hour short course you will learn how to add, divide, multiply, and subtract by entering formulas into Excel 2013 worksheets. Other topics will include an exploration of just a few of the hundreds of functions available in Excel. We will learn how to find a specific function, as well as how to get help while entering arguments. Finally, we will sample a function or two from some of the more commonly used categories of functions including statistical, logical, financial, and date & time.

Prerequisite: Completion of Excel: Getting Started or equivalent knowledge
Instructor:
FAST3 Staff
Hours:
2 hours
Fee: $49

Date / Time: Sept. 18, 2014 (Th); 1:00 p.m. - 3:00 p.m.
Registration Code: W-2836-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

Excel 2013: Data Analysis

Although you might think of Excel as just a spreadsheet program mainly used to record and calculate data, it is also an excellent tool for analyzing data. This short course will look at one of the most appropriate categories of functions for analysis--statistical functions--including VAR, NORMDIST, and STDEV. We will also explore Excel 2013's analysis tools such as Goal Seek, Solver, and Scenarios

Prerequisite: Completion of Excel: Getting Started or Excel  Level 1, or equivalent knowledge
Instructor:
FAST3 Staff
Hours:
2 hours
Fee: $49

Date / Time: Aug. 21, 2014 (Th); 10:00 a.m. - 12:00 p.m.
Registration Code: W-2813-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

Excel 2013: PivotTables

When you analyze large amounts of data you can look at the same information in many different ways. How you organize and group the data often determines whether you find or overlook important trends. A PivotTable report is an interactive way to quickly summarize and analyze large amounts of data. This short course introduces Pivot Tables, Pivot Charts (the graphical and interactive version of a Pivot Table), and Slicers—all features in Excel 2013 that make working with data that much easier.

Prerequisite: Completion of Excel: Level 1 or equivalent knowledge
Instructor:
FAST3 Staff
Hours:
2 hours
Fee: $49

Date / Time: Aug. 18, 2014 (M); 1:00 p.m. - 3:00 p.m.
Registration Code: W-2811-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

Excel 2013: Database Functions

In this 2-hour workshop we will explore the whole set of features for managing information in tables in Excel 2013. These features make all the typical tabular manipulations—sorting, filtering, analyzing, and formatting, easier than ever. Topics will include learning about sorting on as many criteria as you need (including the ability to sort by color fills in cells); filtering on multiple criteria or icon sets applied with conditional formatting; highlighting and removing duplicate data; and applying consistent and professional-looking formatting.

Prerequisite: Completion of Excel: Getting Started or Excel  Level 1, or equivalent knowledge
Instructor:
FAST3 Staff
Hours:
2 hours
Fee: $49

Date / Time: Aug. 15, 2014 (F); 1:00 p.m. - 3:00 p.m.
Registration Code: W-2810-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

Excel 2010: Getting Started

In this 2-hour short course you will learn how to comfortably move around in the Excel 2010 environment. Additional topics will include entering text and values in a worksheet, basic formatting, printing and using Help.

Prerequisite: Familiarity with Windows
Instructor:
FAST3 Staff
Hours:
2 hours
Fee: $49

Date / Time: Sept. 10, 2014 (W); 10:00 a.m. - 12:00 p.m.
Registration Code: W-2821-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

Excel 2010, Level 1

This 6-hour course is designed for those who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2010 worksheets.  Upon successful completion of this course, attendees will be able to:  create a basic worksheet using Excel 2010; perform calculations in an Excel worksheet; modify and format an  Excel worksheet; manage an Excel workbook; and print the contents of an Excel workbook.

Prerequisite: Familiarity with Windows
Instructor: FAST3 Staff
Hours:
6
UIUC CEUs: 0.6
CPDUs: 6 (Illinois teachers are eligible to earn 6 CPDUs for this workshop)
Fee: $159

Date / Time: June 3 & 4, 2014 (TuW); 9:00 a.m. - 12:00 p.m.
Registration Code: W-2769-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

Excel 2010, Level 2

This intermediate-level course will cover topics such as calculating with advanced formulas, organizing worksheet and table data using various techniques, creating and modifying charts, analyzing data using PivotTables and PivotCharts, inserting graphic objects, and customizing and enhancing workbooks and the Excel 2010 environment.

Prerequisite: Completion of Level 1, or equivalent experience
Instructor: FAST3 Staff
Hours:
6
UIUC CEUs: 0.6
CPDUs: 6 (Illinois teachers are eligible to earn 6 CPDUs for this workshop)
Fee: $159

Date / Time: June 11 & 12, 2014 (WTh); 9:00 a.m. - 12:00 p.m.
Registration Code: W-2775-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

Excel 2010: Formulas & Functions

In this 2-hour short course you will learn how to add, divide, multiply, and subtract by entering formulas into Excel 2010 worksheets. Other topics will include an exploration of just a few of the hundreds of functions available in Excel. We will learn how to find a specific function, as well as how to get help while entering arguments. Finally, we will sample a function or two from some of the more commonly used categories of functions including statistical, logical, financial, and date & time.

Prerequisite: Completion of Excel: Getting Started, or equivalent knowledge
Instructor:
FAST3 Staff
Hours:
2 hours
Fee: $49

Date / Time: Sept. 10, 2014 (W); 1:00 p.m. - 3:00 p.m.
Registration Code: W-2823-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

Excel 2010: Charts

In this 2-hour workshop, you will learn how to select data in an Excel 2010 worksheet and work with Chart Tools to customize the chart type, chart layout, and chart style that best represents the data. Once the chart is exactly the way you want it, we will learn how to save it as a template to use again.

Prerequisite: Familiarity with Windows and completion of Excel: Getting Started, or equivalent knowledge
Instructor:
FAST3 Staff
Hours:
2 hours
Fee: $49

Please contact us at 217-333-6285 or email fast3@illinois.edu for information about this workshop.

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

Excel 2010: Data Analysis

Although you might think of Excel as only a spreadsheet program used to record and calculate data, it is also an excellent tool for analyzing data. This short course will explore the use of pivot tables and pivot charts when summarizing large amounts of data. We will also look at one of the most appropriate categories of functions for analysis--statistical functions--including VAR, NORMDIST, and STDEV. And finally we will explore analysis tools such as Goal Seek, Solver, and Scenarios.

Prerequisite: Completion of Excel: Getting Started or Excel  Level 1, or equivalent knowledge
Instructor:
FAST3 Staff
Hours:
2 hours
Fee: $49

Please contact us at 217-333-6285 or email fast3@illinois.edu for information about this workshop.

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

Excel 2010: PivotTable Basics

Your Excel 2010 worksheet has a lot of data, but do you know what the numbers mean? Does the data answer all of your questions? PivotTable reports can help to analyze numerical data. In this 2 hour short course you will learn how PivotTable reports work, how to filter data, and how to use summary functions to calculate numbers. We will also see how easy it is to graphically display data in a PivotTable report as a PivotChart.

Prerequisite: Completion of Excel: Getting Started or Excel  Level 1, or equivalent knowledge
Instructor:
FAST3 Staff
Hours:
2 hours
Fee: $49

Please contact us at 217-333-6285 or email fast3@illinois.edu for information about this workshop.

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

Excel 2010: Database Functions

In this 2-hour workshop we will explore the whole set of features for managing information in tables in Excel 2010. These features make all the typical tabular manipulations—sorting, filtering, analyzing, and formatting easier than ever. Topics will include learning about sorting on as many criteria as you need (including the ability to sort by color fills in cells); filtering on multiple criteria or icon sets applied with conditional formatting; highlighting and removing duplicate data; and applying consistent and professional-looking formatting.

Prerequisite: Completion of Excel: Getting Started or Excel  Level 1, or equivalent knowledge
Instructor:
FAST3 Staff
Hours:
2 hours
Fee: $49

Please contact us at 217-333-6285 or email fast3@illinois.edu for information about this workshop.

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

 

 

University of Illinois at Urbana-Champaign