-552x564.jpg "Advanced Excel: Search for solutions, analytics")
| This
course focuses on analyzing data in Excel, not just learning about buttons
and menus. Accordingly, it is a way to learn how to use Excel's
out-of-the-box functionality and add-ins for modeling, forecasting over time,
and finding optimal solutions to business problems. Even humanities can master this advanced Excel functionality: there are NO complex formulas and functions, macros, languages (DAX, M) in the course - you will work mainly with the user interface and program windows. Everything is explained in simple and understandable language The course teaches you how to work with a set of Excel functionalities and add-ins to fully solve applied cases and tasks (many instructors will teach this functionality in at least 2 different courses). The functionality covered in the course is sufficient to solve 90% of applied business problems related to situation modeling, time series analysis and forecasting, optimization and finding the best solution from possible options/scenarios. Who this course is for: Managers and analysts of various business functions/directions (marketing, technical functions, manufacturing, MTO, finance, HR, etc.) Executives making business decisions or preparing information for decision making Management consultants developing optimal solutions for clients from a variety of alternatives. What you will learn What-If modeling to solve business problems (and more) Selecting parameters for formulas (formulas work "in reverse": selecting a value based on the result you need) Modeling multiple scenarios (e.g. realistic, pessimistic and optimistic scenarios for a project, budget, balance sheet, etc.). Using substitution tables: modeling the results of calculations for different values of 1 or 2 variables (for example, what will be the income at different variants of % discount and different volumes of purchased goods). Automatic search for the most optimal solution for business problems among hundreds and thousands of possible alternatives. Optimization tasks by selecting the most optimal variant from a set of alternatives (e.g. delivery of materials from different warehouses/suppliers based on the distance from them to the production site). Course content 6 sections - 55 lectures - Total duration 7 hours 20 minutes
|