Excel and Google Sheets from Zero to Confident PRO: formulas, data processing, pivot tables and dashboards

You open a spreadsheet with hundreds of rows of data and don't know where to start. Your manager asks for totals, but calculating manually takes an hour and risks errors. This course will teach you to turn chaos into working reports in minutes.

You'll go through four stages of analytics: data cleaning (removing duplicates, fixing formats), formulas for calculations (SUM, SUMIF, SUMIFS), finding data through VLOOKUP and XLOOKUP, and most importantly — pivot tables that aggregate thousands of rows in a minute. Then you'll build charts and place everything on one sheet as a ready-made dashboard.

The course is designed for office workers, managers and beginner analysts with no programming experience. You won't become a data scientist, but you'll stop being afraid of spreadsheets and be able to solve work tasks with data on your own.

By the end of the course, you'll assemble a complete report from a raw file: clean the data, calculate metrics with formulas, create a pivot table and visualize the results. You'll be able to explain every number in the report.