Excel - Course List
Course Search
Course ID Course Name Hours Price Content Schedule
0200-999-13-W
Course Number: 0200-999-13-W
Course Name: Advanced Excel 2013
# of class dates: 0
Description: In this course, you will cover: · Macros; Visual basic · Advanced functional statements; Using VLOOKUP and HLOOKUP · Pivot Tables · Slicers and Sparklines · IF statements · Merging data from multiple worksheets · Updating data using external references · Using Scenario tool to generate what-if analysis · Update data across multiple spreadsheets · PowerPivots, for making charts and dashboards · Correlating data fields · Techniques to extract parts of cells and paste them in a cell in the same row (other than using =left or =right) · Using Excel across the Microsoft suite – (i.e. within the other programs like PowerPoint and Word. For example, best practices in linking/copying charts etc.) · Creating Clustered Stacked Bar Charts · Linking Worksheets and Workbooks · Combination charts · Conditional formatting · Using Excel as a database Integrating with other tools
Advanced Excel 2013
Course Number: 0200-999-13-W
Course Name: Advanced Excel 2013

# of class dates: 0

Description: In this course, you will cover: · Macros; Visual basic · Advanced functional statements; Using VLOOKUP and HLOOKUP · Pivot Tables · Slicers and Sparklines · IF statements · Merging data from multiple worksheets · Updating data using external references · Using Scenario tool to generate what-if analysis · Update data across multiple spreadsheets · PowerPivots, for making charts and dashboards · Correlating data fields · Techniques to extract parts of cells and paste them in a cell in the same row (other than using =left or =right) · Using Excel across the Microsoft suite – (i.e. within the other programs like PowerPoint and Word. For example, best practices in linking/copying charts etc.) · Creating Clustered Stacked Bar Charts · Linking Worksheets and Workbooks · Combination charts · Conditional formatting · Using Excel as a database Integrating with other tools
21 $700.00
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-230-07-W
Course Number: 0200-230-07-W
Course Name: Excel 2007 Charts
# of class dates: 0
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 2007 Charts
Course Number: 0200-230-07-W
Course Name: Excel 2007 Charts

# of class dates: 0

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 $210.00
0200-400-07-W
Course Number: 0200-400-07-W
Course Name: Excel 2007 Database Features for Windows
# of class dates: 0
Description: In this course, you will cover how to: find features using the Ribbon; freeze panes; manage multiple windows; compare workbooks side by side; work with tables and lists; validate data; work with outlines; work with PivotTables and PivotCharts; export and import data from Excel and Access; get data from the internet; create a web query; work with lookup and data tables; use VLOOKUP; link, consolidate and combine workbooks; and if time allows use Scenarios and Analysis features.
Excel 2007 Database Features for Windows
Course Number: 0200-400-07-W
Course Name: Excel 2007 Database Features for Windows

# of class dates: 0

Description: In this course, you will cover how to: find features using the Ribbon; freeze panes; manage multiple windows; compare workbooks side by side; work with tables and lists; validate data; work with outlines; work with PivotTables and PivotCharts; export and import data from Excel and Access; get data from the internet; create a web query; work with lookup and data tables; use VLOOKUP; link, consolidate and combine workbooks; and if time allows use Scenarios and Analysis features.
7 $235.00
0200-240-07-W
Course Number: 0200-240-07-W
Course Name: Excel 2007 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 2007 Formulas
Course Number: 0200-240-07-W
Course Name: Excel 2007 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.
4 $210.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-200-07-W
Course Number: 0200-200-07-W
Course Name: Excel 2007 Level 2 for Windows
# of class dates: 0
Description: In this course you will cover: more calculations and formatting by summarizing data and finding its error and making corrections. Also, this course will cover in customizing the charts and graphics, data lists, and acquiring data from multiple sources such as different workbook and internet.
Excel 2007 Level 2 for Windows
Course Number: 0200-200-07-W
Course Name: Excel 2007 Level 2 for Windows

# of class dates: 0

Description: In this course you will cover: more calculations and formatting by summarizing data and finding its error and making corrections. Also, this course will cover in customizing the charts and graphics, data lists, and acquiring data from multiple sources such as different workbook and internet.
7 $235.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-220-07-W
Course Number: 0200-220-07-W
Course Name: Excel 2007 VBA Programming
# of class dates: 0
Description: In this course, you will cover how to: use Visual Basic Editor for applications terminology, manipulate data by declaring variables and procedures of correct scope, control program flow by using decision structures to perform decision tasks and loop structures to perform repetitive tasks, work with custom dialogue boxes, add a user form to projects, add controls on a form, handle events associated with form controls and validate data entry on forms, identify errors in code, use various debugging tools & write error-handling code to trap errors.
Excel 2007 VBA Programming
Course Number: 0200-220-07-W
Course Name: Excel 2007 VBA Programming

# of class dates: 0

Description: In this course, you will cover how to: use Visual Basic Editor for applications terminology, manipulate data by declaring variables and procedures of correct scope, control program flow by using decision structures to perform decision tasks and loop structures to perform repetitive tasks, work with custom dialogue boxes, add a user form to projects, add controls on a form, handle events associated with form controls and validate data entry on forms, identify errors in code, use various debugging tools & write error-handling code to trap errors.
7 $295.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-230-10-W
Course Number: 0200-230-10-W
Course Name: Excel 2010 Charts
# of class dates: 0
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 2010 Charts
Course Number: 0200-230-10-W
Course Name: Excel 2010 Charts

# of class dates: 0

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 $210.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-600-10-W
Course Number: 0200-600-10-W
Course Name: Excel 2010 Dashboards
# of class dates: 0
Description: In this Microsoft Excel 2010 Dashboards course students will give you the skills to use Excel 2010 Dashboards at an advanced level. Microsoft Excel 2010 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 2010 Dashboards
Course Number: 0200-600-10-W
Course Name: Excel 2010 Dashboards

# of class dates: 0

Description: In this Microsoft Excel 2010 Dashboards course students will give you the skills to use Excel 2010 Dashboards at an advanced level. Microsoft Excel 2010 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 $245.00
0200-400-10-W
Course Number: 0200-400-10-W
Course Name: Excel 2010 Database Features
# of class dates: 0
Description: In this course, you will cover how to: find features using the Ribbon; freeze panes; manage multiple windows; compare workbooks side by side; work with tables and lists; validate data; work with outlines; export and import data from Excel and Access; get data from the internet; create a web query; work with lookup and data tables; use VLOOKUP; link, consolidate and combine workbooks; and if time allows use Scenarios and Analysis features.
Excel 2010 Database Features
Course Number: 0200-400-10-W
Course Name: Excel 2010 Database Features

# of class dates: 0

Description: In this course, you will cover how to: find features using the Ribbon; freeze panes; manage multiple windows; compare workbooks side by side; work with tables and lists; validate data; work with outlines; export and import data from Excel and Access; get data from the internet; create a web query; work with lookup and data tables; use VLOOKUP; link, consolidate and combine workbooks; and if time allows use Scenarios and Analysis features.
7 $235.00
0200-240-10-W
Course Number: 0200-240-10-W
Course Name: Excel 2010 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 2010 Formulas
Course Number: 0200-240-10-W
Course Name: Excel 2010 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.
4 $210.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-200-10-W
Course Number: 0200-200-10-W
Course Name: Excel 2010 Level 2 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 2 for Windows
Course Number: 0200-200-10-W
Course Name: Excel 2010 Level 2 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