Thankfully we have 11 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.
This class isn't on the schedule at the moment, but
save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.
You will need an Internet connection and administrator access on your computer or laptop.
Additional information on how to log into the online environment will be provided after purchasing the class.
In Microsoft Excel PivotTables classes, you will learn the right ways to easily analyze large amounts of data in just a few clicks. Instead of wasting valuable time with standard Excel look-up features, PivotTables allow you to do quick, easy grouping, summarizing, and filtering of data. If you are looking to add high demand career skills to your resume or to improve your Excel productivity, this Excel PivotTables training is right for you.
In this Microsoft Excel PivotTables class, you will master both PivotTables and PivotCharts, starting with the basics. You will leave this excel class confident in creating an advanced PivotTable and performing advanced data analysis in a short amount of time. Extend your Excel training to be more productive at work and save time today.
As you work through the sessions of Microsoft Excel PivotTables, each class will be a hands-on and intensive workshop, designed to help make difficult topics easier to understand. Your instructor, a Microsoft expert, will work with you closely to make sure that you avoid common mistakes in Excel PivotTables and apply best practices when possible.
Upon successful completion of the Microsoft Excel PivotTables class, students will be able to:
Talk to a student advisor to ensure you have the right pre-requisites for each class or program.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.
Still have questions? Ask the community.
If you would like to cancel or transfer a class, please write to [email protected]
This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
Booking for more than 6+?
See more dates and classes for private groups
Get quick answers from CourseHorse and past students.
Empowering you with Skills, not degrees.
Established in 2006, the Digital Workshop Center is a community center for education, coworking, and professional development. A premier independent provider of higher education and certificate credential programs, DWC has become a vital training option for nontraditional...
This school has been carefully vetted by CourseHorse and is a verified Online educator.
Learn the basics of working with spreadsheets using Microsoft Excel. Topics include entering data and formulas, moving and copying data, formatting & print previewing worksheets. Please note: Must register with a valid email address. You will receive an email 2 hours prior to the start of the class with the link to join the virtual...
Thursday Feb 9th, 1:30pm - 3pm Eastern Time
Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas...
Monday Feb 6th, 9am - 4pm Central Time
Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Class Outline: Lesson 1: Working with Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date & Time Functions Topic E: Work...
Tuesday Feb 7th, 9am - 4pm Central Time
Excel Dashboard Reporting: Intro to Dashboards Using Excel A dashboard is a way to visually present data in summary form. Chart-rich reports visually compare patterns of performance among many charts, making it easier to remember performance results. In this one-day session, problems will be introduced to help you build your dashboard reporting and...
Tuesday Feb 7th, 12pm - 3pm Pacific Time
Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more! Course Outline: Unit 1: Logical and statistical functions Topic A: Logical functions (IF, OR, AND, NOT, IFERROR) Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND) Unit 2: Financial and date functions...
Wednesday Feb 8th, 9am - 4pm Central Time
In this three-hour session for Windows users only, you will import external data and create queries using Power Query to bring in data from external sources. You will sort lists by multiple columns, generate automatic subtotals on sorted data, including multi-level subtotals. Finally, you will convert data into a table, apply automatic formatting...
Wednesday Feb 15th, 8am - 11am Pacific Time
In this three-hour session for Windows and Mac users, you will learn how to work on multiple worksheets simultaneously, how to set up what-if analyses models using Goal Seek, Scenario Manager and one- and two-input data tables. You will also learn how to record and edit simple macros. Prerequisites This class is ideally suited for people who have...
Wednesday Feb 15th, 12pm - 3pm Pacific Time
This three-hour session for Windows and Mac users introduces you to Excel’s interface and fundamental capabilities. By the end of the session, you will be easily getting around in Excel’s Ribbon-based interface, able to enter and edit labels, values and dates, extend series of dates and months, cut and paste entries, insert and delete cells and...
Thursday Feb 16th, 8am - 11am Pacific Time
In this three-hour session for Windows and Mac users, you will learn the most efficient ways to format cell text, dates and numbers, applying and defining cell styles to automate formatting. You will also create several types of charts, learning how much data to select, which chart types will best present your data, how to add and format various chart...
Thursday Feb 23rd, 8am - 11am Pacific Time
This three-hour session for Windows and Mac users teaches you how to write formulas in Excel. You will perform calculations using functions like SUM, AVERAGE, write arithmetic formulas by hand, parse text strings with the LEFT, MID, RIGHT and SEARCH functions, and perform calculations on dates. You will use HLOOKUP and VLOOKUP to retrieve data based...
Tuesday Feb 7th, 8am - 11am Pacific Time
In this three-hour session for Windows and Mac users, you will learn how to write complex formulas using Excel's advanced built-in functions. You will expand your library of functions to include lookup and reference functions, conditional logic, database summarization functions, and dynamic array functions. You will also become expert at using mixed...
Thursday Mar 2nd, 12pm - 3pm Pacific Time
Know someone who would like this class but not sure of their schedule? (We recommend this!)
Know their schedule better than your own? Book a date and time directly.
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.