Thankfully we have 23 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.
Learn the essentials regarding visualizations in Excel. Create charts, use styles and templates, manage advanced worksheet formatting.
This course is for individuals whose job responsibilities include publishing spreadsheet results and need to create visualizations and manage formatting and advanced reports.
Excel Introduction or equivalent skills.
Understanding Chart Types
Creating a Chart
Changing the Chart Location and Size
Changing the Chart Type
Modifying Chart Elements
Formatting Chart Elements
Adding and Removing a Data Series
Applying a Chart Filter
Working with Charts
Creating a Hierarchy Chart
Creating a Histogram
Creating a Pareto Chart
Creating a Box and Whisker Chart
Creating a Waterfall Chart
Creating a Combo Chart
Creating a Sparkline
Creating and Using a Chart Template
Creating a Dashboard
Using Styles, Themes, and Templates
Working with Cell Styles
Creating a Template
Using a Personal Template
Working with Formatting
Creating and Using Custom Formats
Applying Conditional Formatting
Creating a New Conditional Formatting Rule
Working with Conditional Formatting Rules
Using the Quick Analysis Tool
Using Print Options
Using Print Areas
Creating and Using a Range Name for Printing
Working with Print Settings
Using Page Setup Tools
Using Page Break Preview
Using Print Titles
Using Headers and Footers
Printing Gridlines and Row and Column Headings
Using Custom Worksheet Views
Saving a Worksheet as a PDF File
Using Excel Data in Other Office Applications
Understanding Pasting, Linking and Embedding
Pasting an Excel Range into a Word Document
Pasting an Excel Chart into a Word Document
Pasting an Excel Range into PowerPoint
Pasting an Excel Chart into PowerPoint
Creating a Chart in Word or PowerPoint
Modifying a Chart in Word or PowerPoint
Still have questions? Ask the community.
This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.
Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...
This school has been carefully vetted by CourseHorse and is a verified Chicago educator.
WorkShop Includes: How to Record and Use Macros VBA Syntax Introduction to VBA Development Writing to Cells & Ranges Modifying Recorder Macros If Then Else Statement Simple For Loops Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work...
Monday Oct 21st, 1pm - 4pm
WorkShop Includes: Logical Test IF, AND, OR Functions SUMIFS Function INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data Date Function Table Objects
Monday Oct 28th, 9am - 12:30pm
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...
Wednesday Oct 23rd, 9am - 4pm
Learn how to build basics spreadsheets & get comfortable using Microsoft Excel in working environment. This workshop is best suited for those who have very little or no experience with Microsoft Excel. Workshop Includes: Overview Of Microsoft Excel User Interface Working with Workbook Working with Worksheets Working With Worksheet Tabs ...
Monday Oct 21st, 9:15am - 1pm
Learn the essentials managing large worksheets, creating models, and working financial, date, and logical functions. Target Student The course is for individuals who are responsible for managing and creating large worksheets and models in Excel. Prerequisites Excel Introduction or equivalent skills. Course Outline Working with Workbooks ...
Thursday Oct 24th, 9am - 3:45pm
This instructor-led course will help advanced Excel users to develop new skills to write and debug powerful VBA code to automate Excel operations such as inserting and formatting text, sorting and duplicating data, generating reports and more. Youâ€™ll also learn how to create interactive forms, insert calculations and handle run-time errors....
Thursday Nov 14th, 9am - 4:30pm
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...
Friday Oct 25th, 9am - 4pm
Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Course Outline Unit 1: Using multiple worksheets and workbooks Topic A: Using multiple workbooks Topic B: Linking worksheets with 3-D formulas Topic C: Linking workbooks Topic D: Managing workbooks Unit 2: Advanced formatting ...
Thursday Oct 24th, 9am - 4pm
You can't get a job today without Excel. This class will show you the basics of working with spreadsheets using Excel. First we'll get comfortable in the Excel workspace, then we'll cover the basics: entering numbers and text, formatting, and performing basic calculations. Then we'll look at sorting data, creating charts, and more advanced use of formulas. ...
Saturday Nov 2nd, 10am - 5pm
Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data. You will learn to: Prepare data for PivotTable reporting and create PivotTables from various data sources; Analyze Data Using PivotTables; Work with PivotCharts. This course is taught with the Office 2013 version software....
Monday Nov 4th, 9am - 1pm
WorkShop Includes: Filters, SUBTOTAL VLOOKUP Merge Data with Lookup Functions Error Handling Tables Pivot Tables Must-Know Keyboard Shortcuts Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work files after class. They serve as a great...
Monday Oct 21st, 1:30pm - 4:30pm
This course will introduce students to spreadsheets and the fundamentals concepts of Microsoft Excel. Learn these features of Microsoft Excel and get more done quickly. Learn how to: Quickly set up workbooks Enter data, and format it for easier viewing Perform calculations and find and correct errors Visualize data with charts and...
Thursday Nov 7th, 9am - 4pm
You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! This course is ideal for people new to Excel who need to produce reports, budgets, lists...
Monday Nov 11th, 9am - 4:30pm
You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others. This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. Prerequisite: You should have completed...
Tuesday Nov 12th, 9am - 4:30pm
This course will teach students how to perform more advanced calculations and work with larger worksheets in Microsoft Excel. In this intermediate Excel course, you will learn how to: Perform Calculations on Data Manage Worksheet Data Reorder and Summarize Data Combine Data from Multiple Sources Analyze Alternative Data Sets and Collaboration...
Friday Nov 8th, 9am - 4pm
For most professionals, the ability to organize information is quickly becoming a fundamental part of the job description. Whether you already consider yourself an expert or are just getting started with spreadsheets, this hands-on workshop will allow you to take your skills to the next level and become a “power” user. We’ll start with the absolute...
Tuesday Nov 12th, 6pm - 8pm
This hands-on class is suitable for Excel 2010, 2013 and 2016 users. On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis,...
Wednesday Nov 13th, 9am - 4:30pm
This course will teach students advanced tasks in Microsoft Excel. In this advanced Excel course, you will learn about: Alternative Data Sets Dynamic Worksheets with PivotTables Automating Repetitive Tasks with Macros Working with Other Microsoft Office Apps Business Intelligence Analysis and Forecasts and Visualizations Excel Versions...
Wednesday Nov 13th, 9am - 4pm
This course builds upon the foundational knowledge presented in the Excel Basic/Level 1 courses and will help start you down the road to creating advanced workbooks and worksheets that you can use to create dashboards. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers...
Thursday Nov 14th, 9am - 4pm
Students will gain proficiency in creating procedures that run in response to specific events, working with control structures,developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
Friday Nov 22nd, 9am - 4pm
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.