Excel Classes Chicago, IL

This 24-hour Excel Specialist Certification program will provide students with a hands-on learning experience to ensure they have the skills and confidence to work in spreadsheets like a seasoned professional. This course consists of three sections: Beginner, Intermediate, and Advanced. In the beginner section, students learn the basics of working with spreadsheets and get introduced to formulas, charts, tables, hotkeys, and more. In the intermediate section, students take what they learned in the beginner section but develop those skills and are introduced to new skills, including LOOKUPs, PivotTables, data validation, and more. Finally, in the advanced section, students will build on what they learned in the first two sections while also learning advanced functions, like INDEX-MATCH, working with advanced PivotTable features, and students will learn how macros can help them automate simple tasks. This course also comes with two hours of private training, the Microsoft Excel Specialist Exam, and the course is free to retake to ensure students get the most out of the course.

This 3-day Microsoft Excel Bootcamp consists of three courses and helps students with little to no prior Excel experience go from novice to pro in a couple of days. The first course, Excel for Business Fundamentals, covers the basics, including writing formulas, using absolute references, formatting, common charts and designs, as well as general workbook best practices. The second course, Intermediate Excel for Business, introduces students to more advanced topics, including advanced paste functions, working with text, VLOOKUP, PivotTables, statistical functions, and some advanced charts. The third and final course, Advanced Excel for Business, walks students through some common skills used primarily by more experienced Excel users, including cell management, nested IF statements, What If analysis, advanced analytical tools, INDEX-MATCH, and macros to help automate repetitive tasks. Each course concludes with a final project to help cement the skills students learn in each course.

This 1-day introduction to Microsoft Excel teaches participants how to create, manage and work with spreadsheets. Throughout this experience, students will learn how to use Microsoft Excel to organize and analyze data. They will gain practice with writing formulas, creating tables, and presenting data in charts and reports.

Intermediate Microsoft Excel users can improve their skills with this 1-day program. This program explores the advanced editing tools of Excel, such as text-wrapping, borders, and effects. Students will learn how to adjust page layouts, insert page and section breaks, and handle multiple window views.

This 1-day program teaches experienced Microsoft Excel users how to leverage more advanced tools. This course teaches students how to use PivotTables to analyze data, trace precedents to understand cause and effect within the data, audit worksheets, and convert text. They will learn how to use macros to automate scripts and integrate Excel spreadsheets with other Microsoft Office tools.

In this comprehensive Excel bootcamp, participants learn beginner to advanced Excel techniques, including formulas & functions, VLOOKUP, macros, and more. Students learn how to work more efficiently, summarize, and analyze data with tables, charts, and PivotTables. By the end of this hands-on course, participants will be ready to use Excel for everyday business tasks. The course has flexible scheduling options and is available live online or in NYC. Tuition includes hands-on training, a free retake, course manual, and supporting video tutorials.

Get started with Microsoft Excel in this beginner-friendly course. Learn calculations, basic formulas and functions, tables, charts, and tips for efficiency with hands-on exercises. By the end of this course, you'll build a strong foundation for using Excel as a vital tool in your daily workflow. The course has flexible scheduling options and is available live online or in NYC. Tuition includes hands-on training, a free retake, course manual, and supporting video tutorials.

In this course for those comfortable with the basics of Excel, participants will learn intermediate-level tools, including PivotTables, splitting and joining text, VLOOKUP, IF Statements, and more. Learn by completing hands-on projects to reinforce concepts. The course has flexible scheduling options and is available live online or in NYC. Tuition includes hands-on training, a free retake, course manual, and supporting video tutorials.

This 1-day Microsoft Excel course is intended for those who have little to no prior Excel experience looking to build foundational skills working with spreadsheets. This course covers all the basics to make students feel at ease when working with Excel. There are a number of topics covered in this course, including data entry, working with basic formulas, formatting data, an introduction to charts and tables, and workbook management. The course is punctuated by a final project to help review and solidify the major topics covered in the class.