Special Note to New Hampshire Residents
Excel Database Features and PivotTables (365/2019/2016) Course Outline
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.
SPECIAL AFTER-HOURS CLASS
This class is part of our special after-hours series of events that meet after the regular workday, typically on Monday through Thursday evenings. Below is some additional background information on our after-hours classes.
When does the class meet?
To see the class meeting times for your time zone, hover the mouse over the date listed on this outline page and the class times will pop up. Classes typically start at 8 pm Eastern, 7 pm Central, 6 pm Mountain, and 5 pm Pacific. Classes meet from 2 to 3 hours each night, depending on the particular class.
Where does the class meet?
All After-Hours classes must be taken from your home or office. If you want to attend a class from one of our physical training locations, you will need to take the version of this class that meets during the regular weekday. Follow this link to see our weekday class schedule and review the list of over 300 locations available when you enroll.
Excel Database Features and PivotTables Weekday Class
Is this the same content as the daytime class?
The instructor will review the most important topics during the live instructor-led session. However, the duration of the evening class is slightly less than the daytime class. To compensate for the reduced hours, we include our ONLC On-Demand content. These are self-study materials that will not only fill in the gaps in your learning, but you will also give you the opportunity to review concepts for 6 months after the class. In addition, should you not be able to attend one of the evening sessions, you will have the On-Demand content to bring you back up to speed. We've got you covered!
What software and hardware is needed?
- You need just a basic computer with an internet connection. The software will be loaded on our servers and you will connect to that computer. (So no software is needed on your computer). Here's a more detailed list:
- At least 1 monitor (Dual monitors or 2 devices would be helpful, but not required.)
- Audio Connection. You can use audio from your computer with a microphone (a standalone microphone, headset, or even a camera that has a microphone.) Most laptops will have a built-in microphone and speaker.Or use your cell phone.
Learn the essentials regarding managing data and creating PivotTables in Excel. Create tables; import, modify and analyze data; create and enhance PivotTables.
The course is for individuals who are responsible managing data and creating PivotTables in Excel.
Excel Introduction or equivalent skills.
*** NEW: Excel Power User Class ***
Are you looking for a comprehensive intermediate or advanced Excel class that covers a wide range of topics? Our Excel Power User class provides the "best of" topics from 5 of our Excel classes. This class will bring you up to speed on the latest features of Excel across all topics such as charting, database features, pivot tables, multiple worksheets, advanced functions and even an introduction to Macros. If you have a good foundation in Excel and want to be a Power User, this class is for you! For details on this class, go to
Excel Power User
Using Auto Fill to Enter Data
Creating and Using Absolute Named Ranges
Working with Data Validation
Inserting and Deleting Columns or Rows
Freezing and Unfreezing Panes
Splitting a Worksheet Window
Using Functions with Lists
Using Table Features
Creating a Table
Formatting a Table
Sorting a Table
Filtering a Table
Creating a Slicer
Working with the Total Row
Creating a Calculated Column
Working with Data
Importing Data from a Text File
Converting Text to Columns
Using Flash Fill
Using Text Functions
Connecting to Data in an Access Database
Creating a Web Query
Importing Web Data using a Saved Query
Working with Hyperlinks
Creating and Working with PivotTables
Creating a PivotTable using Worksheet Data
Creating a PivotTable using an External Data Connection
Laying out a PivotTable on a Worksheet
Modifying PivotTable Fields
Using a Report Filter
Refreshing a PivotTable
Formatting a PivotTable
Using VLOOKUP to Add a Column to a List
Working with Summary Functions
Creating a Slicer
Using a Timeline
Creating a Calculated Field
Creating a Calculated Item
Creating a PivotChart
View outline in Word