You are here

Excel

Featured in 

PowerPivot works closely with the Excel Data Model to allow users to create pivot tables from multiple data sources. These PowerPivot tables can be significantly more flexible that ordinary pivot tables with the ability to create calculated columns and fields (measures) that change depending on how the data as filtered. Time Intelligence functions can also be used to easily create year-over-year comparisons, for example. Excel Versions PowerPivot is an add-in programs for Excel 2010 and Excel 2013. PowerPivot is integrated into Excel 2016.

Wednesday, June 6, 2018 - 10:00am
Featured in 

This one-day class offers tips, tricks and timesavers that will help you get the most from Excel. It is a easy quick-paced class that will touch on most of the popular Excel features and how to access them efficiently. Version Note While this class is being taught using the 2016 version of the Excel software, almost all topics (except for a few new 2016-only chart types) will be applicable to users of Excel 2013. Target Student You already know Excel and have been working with it regularly. Some of your skills are self-taught and you might have taken formal training.

Thursday, July 19, 2018 - 10:00am
Featured in 

This one-day class offers tips, tricks and timesavers that will help you get the most from Excel. It is a easy quick-paced class that will touch on most of the popular Excel features and how to access them efficiently. Version Note While this class is being taught using the 2016 version of the Excel software, almost all topics (except for a few new 2016-only chart types) will be applicable to users of Excel 2013. Target Student You already know Excel and have been working with it regularly. Some of your skills are self-taught and you might have taken formal training.

Thursday, June 7, 2018 - 10:00am
Featured in 

Advanced Excel users encounter repetitive tasks such as: reports that need to be produced, data that needs to be updated or tables that need to be formatted on a regular basis. Using Macros many of these routine tasks can be automated. Using advanced knowledge of Excel learned in this class they can record the steps or operations that they want to perform, and then press a button to repeat them over and over again (and again). Prerequisite Proficient knowledge of Microsoft Excel. This class is for non-programmers.

Thursday, May 31, 2018 - 10:00am
Featured in 

Prerequisite: Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required. Course Outline: Getting Started Working with Procedures and Functions Understanding Objects Using Expressions, Variables, and Intrinsic Functions Controlling Program Execution Working with Forms and Controls Working with the PivotTable Object Debugging Code Handling Errors

Monday, June 18, 2018 - 10:00am
Featured in 

Prerequisites Excel 2010 Intermediate or equivalent skills. Must be able to work with multiple worksheets, use named ranges, and work with functions.

Friday, June 1, 2018 - 10:00am
Featured in 

Prerequisites Excel 2010 Intermediate or equivalent skills. Must be able to work with multiple worksheets, use named ranges, and work with functions.

Wednesday, May 30, 2018 - 10:00am
Featured in 

Prerequisites Excel 2010 Intermediate or equivalent skills. Must be able to work with multiple worksheets, use named ranges, and work with functions.

Tuesday, May 22, 2018 - 10:00am
Featured in 

Prerequisites Excel 2010 Intermediate or equivalent skills. Must be able to work with multiple worksheets, use named ranges, and work with functions.

Friday, May 18, 2018 - 10:00am
Featured in 

Excel is our most popular series classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment, it is best to register for this class at least three weeks in advance. Overview Learn the essentials regarding managing data and creating PivotTables in Excel. Create tables; import, modify and analyze data; create and enhance PivotTables.

Thursday, June 14, 2018 - 10:00am

Pages