Excel Classes Indianapolis, IN

In this beginner-level Excel workshop, you’ll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This basic Excel class is perfect for those with limited experience looking to expand their proficiency. The course comes with our revolutionary Excel video suite, so you can review the materials anytime after the class.

In this intermediate Excel class, you’ll learn functions such as VLOOKUP and SUMIFS; summarize data with Pivot Tables; sort and filter databases; and split and join text. You'll create advanced combo charts and complete a final project to bring together all the concepts you've learned. The course comes with our revolutionary Excel video suite, so you can review the materials anytime after the class.

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 build on what they learned in the beginner section, further developing 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 and advanced Pivot Table features, and students will also 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 a free retake of the course 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 certification package will prepare participants for the Excel Expert Certification exam, an official certification from Microsoft. The package includes three Excel courses, four hours of private tutoring, and the certification exam with a free retake. Participants will learn formulas, functions, PivotTables, macros, and other advanced Excel features.