Excel - Course List
Course Search
Course ID Course Name Hours Price Content Schedule
7000-263-ZZ-Z
Course Number: 7000-263-ZZ-Z
Course Name: Data Analysis for Financial Managers using Microsoft Excel
# of class dates: 0
Description: The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.
Data Analysis for Financial Managers using Microsoft Excel
Course Number: 7000-263-ZZ-Z
Course Name: Data Analysis for Financial Managers using Microsoft Excel

# of class dates: 0

Description: The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.
14 $1159.00
0200-200-04-M
Course Number: 0200-200-04-M
Course Name: Excel 2004 Level 2 for Mac
# of class dates: 0
Description: In this course you will cover how to: enhance Excel spreadsheets by creating and applying templates, create and modify charts, work with graphic objects, calculate with advanced formulas, sort and filter data & use Microsoft Excel with the Web.
Excel 2004 Level 2 for Mac
Course Number: 0200-200-04-M
Course Name: Excel 2004 Level 2 for Mac

# of class dates: 0

Description: In this course you will cover how to: enhance Excel spreadsheets by creating and applying templates, create and modify charts, work with graphic objects, calculate with advanced formulas, sort and filter data & use Microsoft Excel with the Web.
7 $235.00
0200-102-07-W
Course Number: 0200-102-07-W
Course Name: Excel 2007 Beginner Part 1
# of class dates: 0
Description: In this course, you will cover
Excel 2007 Beginner Part 1
Course Number: 0200-102-07-W
Course Name: Excel 2007 Beginner Part 1

# of class dates: 0

Description: In this course, you will cover
0 $0.00
0200-103-07-W
Course Number: 0200-103-07-W
Course Name: Excel 2007 Beginner Part 2
# of class dates: 0
Description: In this course, you will cover
Excel 2007 Beginner Part 2
Course Number: 0200-103-07-W
Course Name: Excel 2007 Beginner Part 2

# of class dates: 0

Description: In this course, you will cover
0 $0.00
0200-104-07-W
Course Number: 0200-104-07-W
Course Name: Excel 2007 Beginner Part 3
# of class dates: 0
Description: In this course, you will cover
Excel 2007 Beginner Part 3
Course Number: 0200-104-07-W
Course Name: Excel 2007 Beginner Part 3

# of class dates: 0

Description: In this course, you will cover
0 $0.00
0200-201-07-W
Course Number: 0200-201-07-W
Course Name: Excel 2007 Intermediate Part 1
# of class dates: 0
Description: In this course, you will cover
Excel 2007 Intermediate Part 1
Course Number: 0200-201-07-W
Course Name: Excel 2007 Intermediate Part 1

# of class dates: 0

Description: In this course, you will cover
0 $0.00
0200-202-07-W
Course Number: 0200-202-07-W
Course Name: Excel 2007 Intermediate Part 2
# of class dates: 0
Description: In this course, you will cover
Excel 2007 Intermediate Part 2
Course Number: 0200-202-07-W
Course Name: Excel 2007 Intermediate Part 2

# of class dates: 0

Description: In this course, you will cover
0 $0.00
0200-203-07-W
Course Number: 0200-203-07-W
Course Name: Excel 2007 Intermediate Part 3
# of class dates: 0
Description: In this course, you will cover
Excel 2007 Intermediate Part 3
Course Number: 0200-203-07-W
Course Name: Excel 2007 Intermediate Part 3

# of class dates: 0

Description: In this course, you will cover
0 $0.00
0200-225-07-W
Course Number: 0200-225-07-W
Course Name: Excel 2007 Plus
# of class dates: 0
Description: In this course, you will cover: getting started with Excel 2007, cursor movement and selecting cells, creating a worksheet, formatting the worksheet, viewing, page layout and printing, proofing and editing your worksheet, working with multiple worksheets, working with data, protecting the worksheet or workbook, referring to data in another worksheet & defining names.
Excel 2007 Plus
Course Number: 0200-225-07-W
Course Name: Excel 2007 Plus

# of class dates: 0

Description: In this course, you will cover: getting started with Excel 2007, cursor movement and selecting cells, creating a worksheet, formatting the worksheet, viewing, page layout and printing, proofing and editing your worksheet, working with multiple worksheets, working with data, protecting the worksheet or workbook, referring to data in another worksheet & defining names.
14 $470.00
0200-101-07-W
Course Number: 0200-101-07-W
Course Name: Excel 2007: New Features
# of class dates: 0
Description: In this course students will be introduced to the new features in Microsoft Office Excel 2007 which help improve the management, presentation and distribution of spreadsheets. Specific topics include: exploring the Excel 2007 environment, organize data in Excel worksheets using enhanced tables and table formats, analyzing Excel data by applying enhanced conditional formatting, presenting Excel data using enhanced charts and illustrations, as well as working with the enhanced options of PivotTables and PivotCharts for conducting selective analysis.
Excel 2007: New Features
Course Number: 0200-101-07-W
Course Name: Excel 2007: New Features

# of class dates: 0

Description: In this course students will be introduced to the new features in Microsoft Office Excel 2007 which help improve the management, presentation and distribution of spreadsheets. Specific topics include: exploring the Excel 2007 environment, organize data in Excel worksheets using enhanced tables and table formats, analyzing Excel data by applying enhanced conditional formatting, presenting Excel data using enhanced charts and illustrations, as well as working with the enhanced options of PivotTables and PivotCharts for conducting selective analysis.
4 $210.00
0200-100-08-M
Course Number: 0200-100-08-M
Course Name: Excel 2008 for Mac
# of class dates: 0
Description: In this course you will cover: introduction to Excel 2008, spreadsheet essentials, modifying worksheets, formulas and functions, working with lists, charts and graphs, database techniques, data analysis and sharing workbooks on the web or on a network.
Excel 2008 for Mac
Course Number: 0200-100-08-M
Course Name: Excel 2008 for Mac

# of class dates: 0

Description: In this course you will cover: introduction to Excel 2008, spreadsheet essentials, modifying worksheets, formulas and functions, working with lists, charts and graphs, database techniques, data analysis and sharing workbooks on the web or on a network.
14 $470.00
0200-301-10-W
Course Number: 0200-301-10-W
Course Name: Excel 2010 Complete
# of class dates: 0
Description: In this course you will cover some of the more advanced features of Excel including the following topics: streamlining workflow and creating macros, collaborating with others, auditing worksheets, analyzing data, Pivot Tables, working with multiple worksheets, importing and exporting data, using Excel with the web and structuring workbooks with XML.
Excel 2010 Complete
Course Number: 0200-301-10-W
Course Name: Excel 2010 Complete

# of class dates: 0

Description: In this course you will cover some of the more advanced features of Excel including the following topics: streamlining workflow and creating macros, collaborating with others, auditing worksheets, analyzing data, Pivot Tables, working with multiple worksheets, importing and exporting data, using Excel with the web and structuring workbooks with XML.
7 $235.00
0200-601-10-W
Course Number: 0200-601-10-W
Course Name: Excel 2010 Custom Class
# of class dates: 0
Description: In this course, you will cover
Excel 2010 Custom Class
Course Number: 0200-601-10-W
Course Name: Excel 2010 Custom Class

# of class dates: 0

Description: In this course, you will cover
7 $0.00
0200-001-10-W
Course Number: 0200-001-10-W
Course Name: Excel 2010 Level 1 for Windows
# of class dates: 0
Description: In this class you will cover: the Excel 2010 environment, working with an Excel spreadsheet by entering and selecting the data in it, modifying a worksheet, performing calculations, formatting a worksheet, developing a workbook, printing workbook contents & customizing the layout of the Excel application window.
Excel 2010 Level 1 for Windows
Course Number: 0200-001-10-W
Course Name: Excel 2010 Level 1 for Windows

# of class dates: 0

Description: In this class you will cover: the Excel 2010 environment, working with an Excel spreadsheet by entering and selecting the data in it, modifying a worksheet, performing calculations, formatting a worksheet, developing a workbook, printing workbook contents & customizing the layout of the Excel application window.
7 $279.00
0200-225-10-W
Course Number: 0200-225-10-W
Course Name: Excel 2010 Plus
# of class dates: 0
Description: In this course, you will cover: getting started with Excel 2010, cursor movement and selecting cells, creating a worksheet, formatting the worksheet, viewing, page layout and printing, proofing and editing your worksheet, working with multiple worksheets, working with data, protecting the worksheet or workbook, referring to data in another worksheet & defining names.
Excel 2010 Plus
Course Number: 0200-225-10-W
Course Name: Excel 2010 Plus

# of class dates: 0

Description: In this course, you will cover: getting started with Excel 2010, cursor movement and selecting cells, creating a worksheet, formatting the worksheet, viewing, page layout and printing, proofing and editing your worksheet, working with multiple worksheets, working with data, protecting the worksheet or workbook, referring to data in another worksheet & defining names.
14 $470.00
0200-600-13-W
Course Number: 0200-600-13-W
Course Name: Excel 2013 Custom Class
# of class dates: 0
Description: In this course, you will cover
Excel 2013 Custom Class
Course Number: 0200-600-13-W
Course Name: Excel 2013 Custom Class

# of class dates: 0

Description: In this course, you will cover
7 $0.00
0200-700-13-W
Course Number: 0200-700-13-W
Course Name: Excel 2013 Dashboards
# of class dates: 0
Description: In this Microsoft Excel 2013 Dashboards course students will give you the skills to use Excel 2013 Dashboards at an advanced level. Microsoft Excel 2013 Dashboards are a reporting mechanism that can deliver Business Intelligence (BI) in graphical form. Dashboards take raw data; allow it to be analyzed and presented in a form that is of most benefit to the end user. Participants in this course must have an Intermediate working knowledge of Excel. Course Objectives: ? Differentiate between Reports and dashboards ? Discuss the benefits of an Excel dashboard ? Assemble all data needed for a dashboard ? Identify ground rules for creating effective dashboards ? Create dynamic charts ? Create Pivot tables ? Create Pivot Charts ? Modify Pivot tables and charts ? Apply conditional formatting to a dashboard ? Identify and apply Excel functions (IF, CHOOSE and VLOOKUP) ? Design and build a dashboard from raw data to the finished product
Excel 2013 Dashboards
Course Number: 0200-700-13-W
Course Name: Excel 2013 Dashboards

# of class dates: 0

Description: In this Microsoft Excel 2013 Dashboards course students will give you the skills to use Excel 2013 Dashboards at an advanced level. Microsoft Excel 2013 Dashboards are a reporting mechanism that can deliver Business Intelligence (BI) in graphical form. Dashboards take raw data; allow it to be analyzed and presented in a form that is of most benefit to the end user. Participants in this course must have an Intermediate working knowledge of Excel. Course Objectives: ? Differentiate between Reports and dashboards ? Discuss the benefits of an Excel dashboard ? Assemble all data needed for a dashboard ? Identify ground rules for creating effective dashboards ? Create dynamic charts ? Create Pivot tables ? Create Pivot Charts ? Modify Pivot tables and charts ? Apply conditional formatting to a dashboard ? Identify and apply Excel functions (IF, CHOOSE and VLOOKUP) ? Design and build a dashboard from raw data to the finished product
7 $299.00
0200-240-ZZ-W
Course Number: 0200-240-ZZ-W
Course Name: Excel 2013 Formulas
# of class dates: 0
Description: In this course, you will cover how to: build a formula, use function formulas, work with range names in a formula, use Logical and Lookup function formulas, use Financial function formulas, use the Concatenate function formula, work with the Date, Proper, Upper and Lower function formulas, create a function formulas from scratch & work with data tables.
Excel 2013 Formulas
Course Number: 0200-240-ZZ-W
Course Name: Excel 2013 Formulas

# of class dates: 0

Description: In this course, you will cover how to: build a formula, use function formulas, work with range names in a formula, use Logical and Lookup function formulas, use Financial function formulas, use the Concatenate function formula, work with the Date, Proper, Upper and Lower function formulas, create a function formulas from scratch & work with data tables.
6 $279.00
0200-001-13-W
Course Number: 0200-001-13-W
Course Name: Excel 2013 Level 1 for Windows
# of class dates: 0
Description: In this course, you will cover spreadsheet terminology and the fundamental concepts of Microsoft Excel 2013, including identifying Excel window components, navigating worksheets. In addition, you will learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. You will learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns. This course will also teach how to use simple functions, and how to easily apply formatting techniques to worksheet data. Finally, students will review workbooks for spelling errors, modify page setup, and print worksheets.
Excel 2013 Level 1 for Windows
Course Number: 0200-001-13-W
Course Name: Excel 2013 Level 1 for Windows

# of class dates: 0

Description: In this course, you will cover spreadsheet terminology and the fundamental concepts of Microsoft Excel 2013, including identifying Excel window components, navigating worksheets. In addition, you will learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. You will learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns. This course will also teach how to use simple functions, and how to easily apply formatting techniques to worksheet data. Finally, students will review workbooks for spelling errors, modify page setup, and print worksheets.
7 $289.00
0200-002-13-W
Course Number: 0200-002-13-W
Course Name: Excel 2013 Level 2 for Windows
# of class dates: 0
Description: In this course, you will cover how to work with large worksheets in Microsoft Excel 2013, and use multiple worksheets and workbooks efficiently. You will sort and filter data, use conditional formatting, and create and format tables and charts. You will learn how to protect worksheets and files, as well as referring to data in other workbooks thru 3D formulas. Finally, you will create names, customize a template, and work with comments and clipart.
Excel 2013 Level 2 for Windows
Course Number: 0200-002-13-W
Course Name: Excel 2013 Level 2 for Windows

# of class dates: 0

Description: In this course, you will cover how to work with large worksheets in Microsoft Excel 2013, and use multiple worksheets and workbooks efficiently. You will sort and filter data, use conditional formatting, and create and format tables and charts. You will learn how to protect worksheets and files, as well as referring to data in other workbooks thru 3D formulas. Finally, you will create names, customize a template, and work with comments and clipart.
7 $289.00
0200-003-13-W
Course Number: 0200-003-13-W
Course Name: Excel 2013 Level 3 for Windows
# of class dates: 0
Description: In this course, you will cover how to create and work with Macros and VBA Programming, as well as how to add Form Controls and how to assign a Macro to a Form Control. In addition, you will learn about formula auditing, and will learn about common errors, how to correct them, and how to use the Watch Window to see changes in formulas. You will work with creating and modifying hyperlinks, get data from the internet, as well as learn how to save workbooks, worksheets, charts and ranges as web pages. You will create custom styles and learn how to use advanced conditional formatting. Finally you will learn how to create and use a shared workbook, including how to protect, consolidate and resolve editing conflicts in a shared workbook.
Excel 2013 Level 3 for Windows
Course Number: 0200-003-13-W
Course Name: Excel 2013 Level 3 for Windows

# of class dates: 0

Description: In this course, you will cover how to create and work with Macros and VBA Programming, as well as how to add Form Controls and how to assign a Macro to a Form Control. In addition, you will learn about formula auditing, and will learn about common errors, how to correct them, and how to use the Watch Window to see changes in formulas. You will work with creating and modifying hyperlinks, get data from the internet, as well as learn how to save workbooks, worksheets, charts and ranges as web pages. You will create custom styles and learn how to use advanced conditional formatting. Finally you will learn how to create and use a shared workbook, including how to protect, consolidate and resolve editing conflicts in a shared workbook.
7 $299.00
0200-230-16-W
Course Number: 0200-230-16-W
Course Name: Excel 2016 Charts
# of class dates: 10
Description: In this course, you will cover how to create a chart sheet, create an embedded chart, format a chart, create a pie chart, create a 3D Column Chart, create a picture chart, create a combination chart, add new data & create a user-defined chart type.
Excel 2016 Charts
Course Number: 0200-230-16-W
Course Name: Excel 2016 Charts

# of class dates: 10

Description: In this course, you will cover how to create a chart sheet, create an embedded chart, format a chart, create a pie chart, create a 3D Column Chart, create a picture chart, create a combination chart, add new data & create a user-defined chart type.
4 $219.00
0200-601-16-W
Course Number: 0200-601-16-W
Course Name: Excel 2016 Dashboards
# of class dates: 20
Description: In this Microsoft Excel 2016 Dashboards course students will give you the skills to use Excel 2016 Dashboards at an advanced level. Microsoft Excel 2016 Dashboards are a reporting mechanism that can deliver Business Intelligence (BI) in graphical form. Dashboards take raw data; allow it to be analyzed and presented in a form that is of most benefit to the end user. Participants in this course must have an Intermediate working knowledge of Excel. Course Objectives: ? Differentiate between Reports and dashboards ? Discuss the benefits of an Excel dashboard ? Assemble all data needed for a dashboard ? Identify ground rules for creating effective dashboards ? Create dynamic charts ? Create Pivot tables ? Create Pivot Charts ? Modify Pivot tables and charts ? Apply conditional formatting to a dashboard ? Identify and apply Excel functions (IF, CHOOSE and VLOOKUP) ? Design and build a dashboard from raw data to the finished product
Excel 2016 Dashboards
Course Number: 0200-601-16-W
Course Name: Excel 2016 Dashboards

# of class dates: 20

Description: In this Microsoft Excel 2016 Dashboards course students will give you the skills to use Excel 2016 Dashboards at an advanced level. Microsoft Excel 2016 Dashboards are a reporting mechanism that can deliver Business Intelligence (BI) in graphical form. Dashboards take raw data; allow it to be analyzed and presented in a form that is of most benefit to the end user. Participants in this course must have an Intermediate working knowledge of Excel. Course Objectives: ? Differentiate between Reports and dashboards ? Discuss the benefits of an Excel dashboard ? Assemble all data needed for a dashboard ? Identify ground rules for creating effective dashboards ? Create dynamic charts ? Create Pivot tables ? Create Pivot Charts ? Modify Pivot tables and charts ? Apply conditional formatting to a dashboard ? Identify and apply Excel functions (IF, CHOOSE and VLOOKUP) ? Design and build a dashboard from raw data to the finished product
7 $299.00
0200-405-16-W
Course Number: 0200-405-16-W
Course Name: Excel 2016 Data Analysis
# of class dates: 22
Description: In this course, you will cover creating and modifying table elements, adding and deleting records and fields, and using Data forms and Slicers with table data. You will import data from Access and Excel objects as well as text file types. Proper data management will be discussed to determine structure requirements, sorting, filtering, using flash fill, auto filter and advanced filtering features. The database functions will allow the user to extract data from a large list of content with precision based on specific criteria. Finally, the data modeling features will examine how to take spreadsheet data and create one to many relationships which will expand the functionality of a pivot table for a greater understanding of the data.
Excel 2016 Data Analysis
Course Number: 0200-405-16-W
Course Name: Excel 2016 Data Analysis

# of class dates: 22

Description: In this course, you will cover creating and modifying table elements, adding and deleting records and fields, and using Data forms and Slicers with table data. You will import data from Access and Excel objects as well as text file types. Proper data management will be discussed to determine structure requirements, sorting, filtering, using flash fill, auto filter and advanced filtering features. The database functions will allow the user to extract data from a large list of content with precision based on specific criteria. Finally, the data modeling features will examine how to take spreadsheet data and create one to many relationships which will expand the functionality of a pivot table for a greater understanding of the data.
7 $289.00
0200-400-16-W
Course Number: 0200-400-16-W
Course Name: Excel 2016 Data Analysis with Power Pivot
# of class dates: 12
Description: We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2016 to analyze data from a variety of sources. You will be able to do the following: · Get started with Power Pivot. · Visualize Power Pivot data. · Work with advanced functionality in Power Pivot.
Excel 2016 Data Analysis with Power Pivot
Course Number: 0200-400-16-W
Course Name: Excel 2016 Data Analysis with Power Pivot

# of class dates: 12

Description: We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2016 to analyze data from a variety of sources. You will be able to do the following: · Get started with Power Pivot. · Visualize Power Pivot data. · Work with advanced functionality in Power Pivot.
4 $219.00