Excelling @ Excel: Data Analysis using Pivot Tables and Subtotals |
This half day course covers creating and downloading databases and then how to analyze data through Pivot Tables and SubTotals.
Data analysis is a powerful Excel feature and we will look in depth at creating and editing Pivot Tables and Pivot Charts for analysis. We will look at other database features such as Subtotals and using the Name Manager. We will use sorting and filtering to help restrict our data and use Pivot Tables for Sum, Average, and Count functions. Using Office 2007/2010 we will use the new Format as a Table feature and learn the advantages and disadvantages of using Format as a Table. |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
DATA ANALYSIS (23AUG2013)
Learn More... |
Aug 23, 2013 |
Aug 23, 2013 |
Alpharetta Campus |
$250.00 |
Greg Creech
|
Register |
Excelling at Excel 2010 Level 2 |
THIS CLASS WILL COVER BOTH EXCEL 2007 AND 2010
Learn the four Fs of Excel — formatting, fills, functions/formulas, and filters...tools that help you create effective and clear spreadsheets. Understand formatting and basic formulas as you begin building budget and expense spreadsheets. We go on to explore filters, fills, complex formulas, macros, charts and conditional formatting. These tools help you to create fully functional monthly and annual budget tracking spreadsheets. |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
EXCEL2010-LVL2 (05JUN2013)
Learn More... |
Jun 5, 2013 |
Jun 12, 2013 |
Briarcliff Campus |
$425.00 |
Greg Creech
|
Register |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
EXCEL2010-LVL2 (25JUN2013)
Learn More... |
Jun 25, 2013 |
Jun 27, 2013 |
Alpharetta Campus |
$425.00 |
Greg Creech
|
Register |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
EXCEL2010-LVL2 (11JUL2013)
Learn More... |
Jul 11, 2013 |
Jul 18, 2013 |
Briarcliff Campus |
$425.00 |
Greg Creech
|
Register |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
EXCEL2010-LVL2 (05AUG2013)
Learn More... |
Aug 5, 2013 |
Aug 12, 2013 |
Briarcliff Campus |
$425.00 |
Greg Creech
|
Register |
HR - Excel and Access |
| This course is designed for the Human Resources Generalist, Specialist, or Manager to analyze and track HR data and information using databases including Excel and Access. This unique two day course combines Excel and Access databases for the HR person to manipulate data and to analyze data using Excel’s PivotTables and Access’ Queries and objects. Here are some of the items we will learn:
Know differences between Access and Excel Human Resources databases and information systems,
Analyze Human Resources data using Excel’s PivotTables and Access Queries and Reports,
Customize Excel information after downloading from HR applications, such as PeopleSoft, ADP, and Ceridian,
Manipulate data through Sorting and Filtering in Excel and Access
Create and edit Access queries and set criteria for data
Develop custom Total Compensation workbooks and worksheets using industry constructs |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
HR - EXCEL/ACCESS (07AUG13)
Learn More... |
Aug 7, 2013 |
Aug 14, 2013 |
Briarcliff Campus |
$415.00 |
Greg Creech
|
Register |
More Excelling at Excel Day 3 |
| Students will customize their workbooks through more functions, such as If . .. Then . . . Else and Data Validation, learn more functions, collaborate with other users, and enhance their spreadsheets using charts. This class will cover both Excel 2007 and 2010. |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
EXCEL2010-LVL3 (19JUN2013)
Learn More... |
Jun 19, 2013 |
Jun 19, 2013 |
Briarcliff Campus |
$375.00 |
Greg Creech
|
Register |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
EXCEL2010-LVL3 (29AUG2013)
Learn More... |
Aug 29, 2013 |
Aug 29, 2013 |
Briarcliff Campus |
$375.00 |
Greg Creech
|
Register |
MS Excel 2010 Level 1: Introduction |
| Excel is one of the most powerful and frequently used tools in an office environment. Get the most out of Excel 2010 by learning to create, edit, and print basic Excel documents with the latest version of this application! In this course, you will learn to speed up data entry, move and copy information, and create formulas to perform calculations. You'll prepare a document for printing by setting margins, page breaks, and more. Finally, you'll learn to manage large Excel documents, making your data more readable and more attractive with formatting techniques. |
| Inquire |
