Excel Certificates Los Angeles, CA

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.