Available Online

Problem Solving Using Excel

Learn how to take advantage of the amazing features and tools in Excel

  • Started Nov 18, 2020
  • 450 euros
  • Online classes

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.

Upcoming Sessions

Cancellation Policy

Please check our cancellation policy.

Contact Details

+34 644 310 240

info@lurning.eu

LURNING, Gran Via de Carles III, Barcelona, Spain