|
In this 1-hour overview, we will explore the new look and feel of Excel 2013.
We’ll take a look at templates first thing-- they do most of the set-up and
design work for you, so you can focus on your data. There are templates for
budgets, calendars, forms, reports, and more. Next we’ll explore some new tools,
including the new Power View sheet. Power View is essentially an interactive
canvas that allows you to display charts, tables, maps, and slicers in one
dashboard window. We’ll also see how much easier it is to work with charts by
trying out the Quick Analysis tool which lets you convert your data into a chart
or table in two steps or less and the Chart Recommendations which suggests the
most suitable chart for your data. We will see how to use a standalone
PivotChart (interactive chart) that does not need to be associated with a
PivotTable.
We will explore some of the new functions in the math and
trigonometry, statistical, engineering, date and time, lookup and
reference, logical, and text function categories, as well as a few Web
service functions for referencing existing Representational State
Transfer (REST)-compliant Web services.
We will look at what’s new when working with data, including creating
relationships between related data and drilling up or down through
complex layers of data. Slicers in 2013 will also be explored to display
graphical representation of filter values.
Prerequisite: Familiarity with Windows and completion of an Excel
Getting Started or Level 1 workshop (or equivalent knowledge)
Instructor: Staff, WebStore Training Services
Hours: 1 hour
Fee: $29
Date / Time: June 4, 2013 (Tu); 9:00 a.m. -
10:00
a.m.
Registration Code: W-2532-C
Location:
UIUC (Champaign) --
Illini Hall, Suite 26 (lower level)
Date / Time: July 30, 2013 (Tu); 11:00 a.m. -
12:00
p.m.
Registration Code: W-2565-C
Location:
UIUC (Champaign) --
Illini Hall, Suite 26 (lower level)
Date / Time: Aug. 28, 2013 (W); 9:00 a.m. -
10:00
a.m.
Registration Code: W-2591-C
Location:
UIUC (Champaign) --
Illini Hall, Suite 26 (lower level)
Calendar
Back to Top
Registration Options
UI:
Register via department charge (CFOAP and UI netid required)
UI:
Register via credit card (personal credit card and UI netid required; UI P-Card not allowed)
General Public (not UI):
Register via credit card (all major credit cards accepted)
Everyone: To register now but pay later (via check or credit card),
call 217-333-6285 OR email
training@illinois.edu with the following information:
Workshop Name and Date; plus your Name, Telephone, and Email Address
(We apologize for the inconvenience;
this is a temporary process until our registration system is fully
revised.)
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: Staff, WebStore Training Services
Hours: 2 hours
Fee: $49
Date / Time: Aug. 19, 2013 (M); 1:00 p.m. -
3:00
p.m.
Registration Code: W-2582-C
Location:
UIUC (Champaign) --
Illini Hall, Suite 26 (lower level)
Calendar
Back to Top
Registration Options
UI:
Register via department charge (CFOAP and UI netid required)
UI:
Register via credit card (personal credit card and UI netid required; UI P-Card not allowed)
General Public (not UI):
Register via credit card (all major credit cards accepted)
Everyone: To register now but pay later (via check or credit card),
call 217-333-6285 OR email
training@illinois.edu with the following information:
Workshop Name and Date; plus your Name, Telephone, and Email Address
(We apologize for the inconvenience;
this is a temporary process until our registration system is fully
revised.)
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: Staff, WebStore Training Services
Hours: 6
UIUC CEUs: 0.6
CPDUs: 6 (Illinois teachers are eligible to earn 6 CPDUs for this workshop)
Fee: $159
Date / Time: June 19, 2013 (W); 9:00 a.m. - 4:00
p.m. (lunch on your own)
Registration Code: W-2544-C
Location:
UIUC (Champaign) --
Illini Hall, Suite 26 (lower level)
Date / Time: July 9, 2013 (Tu); 9:00 a.m. - 4:00
p.m. (lunch on your own)
Registration Code: W-2554-C
Location:
UIUC (Champaign) --
Illini Hall, Suite 26 (lower level)
Calendar
Back to Top
Registration Options
UI:
Register via department charge (CFOAP and UI netid required)
UI:
Register via credit card (personal credit card and UI netid required; UI P-Card not allowed)
General Public (not UI):
Register via credit card (all major credit cards accepted)
Everyone: To register now but pay later (via check or credit card),
call 217-333-6285 OR email
training@illinois.edu with the following information:
Workshop Name and Date; plus your Name, Telephone, and Email Address
(We apologize for the inconvenience;
this is a temporary process until our registration system is fully
revised.)
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: Staff, WebStore Training Services
Hours: 6
UIUC CEUs: 0.6
CPDUs: 6 (Illinois teachers are eligible to earn 6 CPDUs for this workshop)
Fee: $159
Date / Time: July 30 & Aug. 1, 2013 (TuTh); 1:00 p.m. - 4:00
p.m.
Registration Code: W-2566-C
Location:
UIUC (Champaign) --
Illini Hall, Suite 26 (lower level)
Calendar
Back to Top
Registration Options
UI:
Register via department charge (CFOAP and UI netid required)
UI:
Register via credit card (personal credit card and UI netid required; UI P-Card not allowed)
General Public (not UI):
Register via credit card (all major credit cards accepted)
Everyone: To register now but pay later (via check or credit card),
call 217-333-6285 OR email
training@illinois.edu with the following information:
Workshop Name and Date; plus your Name, Telephone, and Email Address
(We apologize for the inconvenience;
this is a temporary process until our registration system is fully
revised.)
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: Staff, WebStore Training Services
Hours: 2 hours
Fee: $49
Date / Time: Aug. 20, 2013 (Th); 1:00 p.m. - 3:00
p.m.
Registration Code: W-2585-C
Location:
UIUC (Champaign) --
Illini Hall, Suite 26 (lower level)
Calendar
Back to Top
Registration Options
UI:
Register via department charge (CFOAP and UI netid required)
UI:
Register via credit card (personal credit card and UI netid required; UI P-Card not allowed)
General Public (not UI):
Register via credit card (all major credit cards accepted)
Everyone: To register now but pay later (via check or credit card),
call 217-333-6285 OR email
training@illinois.edu with the following information:
Workshop Name and Date; plus your Name, Telephone, and Email Address
(We apologize for the inconvenience;
this is a temporary process until our registration system is fully
revised.)
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: Staff, Training Services
Hours: 2 hours
Fee: $49
This workshop is not currently being offered.
Please contact us via our
contact form, or call (217) 333-6285 for more information.
Calendar
Back to Top
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: Staff, Training Services
Hours: 2 hours
Fee: $49
This workshop is not currently being offered.
Please contact us via our
contact form, or call (217) 333-6285 for more information.
Calendar Registration
Form Back to Top
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: Staff, Training Services
Hours: 2 hours
Fee: $49
This workshop is not currently being offered.
Please contact us via our
contact form, or call (217) 333-6285 for more information.
Calendar
Registration
Form Back to Top
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: Staff, Training Services
Hours: 2 hours
Fee: $49
This workshop is not currently being offered.
Please contact us via our
contact form, or call (217) 333-6285 for more information.
Calendar
Back to Top
|
