Thankfully we have 15 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.
Still have questions? Ask the community.
Near North Side, Downtown/Loop
500 N Michigan Ave Ste 600
At N Michigan Ave
Chicago, Illinois 60611 Near North Side, Downtown/Loop
500 N Michigan Ave Ste 600
At N Michigan Ave
Chicago, Illinois 60611
Our downtown Chicago classroom is located at the Avenue Business Center in the Magnificent Mile district, close to plenty of restaurants and parking. When arriving for class, please proceed to Suite 600 and the receptionist will guide you to your classroom.
This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
Certified Staffing Solutions specializes in providing computer training and instructors nationwide. Our instructors are professional trainers and utilize hands-on exercises to reinforce lecture. Each averages more than 5 years delivering classes to business professionals.
This school has been carefully vetted by CourseHorse and is a verified Chicago educator.
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 ...
Wednesday Nov 20th, 9am - 4pm
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...
Tuesday Nov 19th, 9am - 4pm
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 Dec 19th, 9am - 4:30pm
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
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...
Monday Dec 2nd, 9am - 4pm
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...
Thursday Nov 21st, 9am - 4pm
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...
Tuesday Dec 3rd, 9am - 4pm
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....
Wednesday Dec 4th, 9am - 1pm
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...
Wednesday Dec 11th, 6pm - 8pm
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...
Friday Dec 13th, 9am - 4pm
In this one day bootcamp, we will move beyond the basics of spreadsheet creation. We will dive into data manipulation and advanced functions to summarize and analyze data with multiple attributes. We will also introduce using slicers with PivotTables, creating interactive reports, and using advanced formulas. Interactive in-class exercises will be...
Saturday Dec 14th, 10am - 5pm
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 Dec 17th, 9am - 4:30pm
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 Dec 18th, 9am - 4:30pm
Are you using Excel for analysis? Spreadsheets are useful for analyzing and visualizing data, but become cumbersome and unwieldy with large datasets. Relational databases address many of Excel's limitations by simplify repetitive tasks and enabling analysis over much larger datasets. The only catch is that you need to know SQL to fully harness the...
Wednesday Dec 18th, 6pm - 8pm
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 Dec 16th, 9am - 4:30pm
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.