About
In this course, we blend the power of Excel with realistic and updated Business applications. This course is geared towards learners that are looking to advance in Excel for a professional goal or career advantage. With this course, you will learn Excel skills and functions that are mostly used in different service and manufacturing businesses. You will be able to quickly apply your knowledge right away with our project-based learning in our class, showcase your knowledge with future or current employers and advance in your career. Participants will receive a certificate of completion in both digital and physical formats. Learning Goals: -Understanding of the basic terminology used to describe the most important parts of an Excel file, which will serve as a guide for the rest of the course. -How to Create a Budget in Excel Creating, formatting, and editing TABLES and quick tools that you can use to save hours of work. Analyze a realistic database of sales while learning about VLOOKUP, COUNTIFS, SUMIFS, SUMPRODUCTS WITH IF(AND/OR) Newer features like XLOOKUP, LAMBDA, and FILTER functions. We will learn to organize alphabetically, conditional formatting, and change cell styles. More common advanced functions in Excel such as MEDIAN, AVERAGE, IF, COUNT, SUMIF, GOALSEEK, and absolute references. How to create and modify a Pivot Table How to create a Graph in Excel the easy and effective way In this course, we blend the power of Excel with realistic and updated Business applications. This course is geared towards learners that are looking to advance in Excel for a professional goal or career advantage.</p><p>With this course, you will learn Excel skills and functions that are mostly used in different service and manufacturing businesses. You will be able to quickly apply your knowledge right away with our project-based learning in our class, showcase your knowledge with future or current employers and advance in your career.
You can also join this program via the mobile app. Go to the app