Problem Solving Using Excel

Service Description

Course goal and learning outcomes This course aims to develop an advanced level of Microsoft Excel skills. The course will cover the essentials of this powerful tool before progressing to the advanced level. The focus will be on how to navigate the user interface, clean and organize data, perform basic and advanced calculations using formulas and functions, apply conditional logic to help in the decision making process, professionally format and visualize data, create meaningful reports and dashboards, solve problems, forecast and model data, add layers of automation, and increase efficiency and productivity. Core competencies Competency 1: Data analysis Competency 2: Data presentation Competency 3: Problem solving Competency 4: Decision making Competency 5: Dashboards Course plan Day 1: Working with data (filter, sort, conditional formatting, text-to-column, etc.), basic functions (if, sum, average, etc.) Day 2: Advanced functions (array, lookup, index), data validation Day 3: Pivot tables, summarizing data (countif, averageif, etc.) Day 4: Charts, visualizations, dashboards Day 5: Solver, goal seek, forecast, automation Cancellation policy Full refund if requested 15 business days before the start of the course.