Rules for organizing data in Excel tables - course RUB 5,990. from Specialist, training, Date: December 4, 2023.

Module 1. Where to start working on the table so that it is understandable (1 ac. h.)
Make a list of people who will use your spreadsheet;
Conduct an interview and find out what indicators are needed to make what management decisions;
Analyze existing reporting forms, identifying their “pros” and “cons”;
Make a list of all the data you plan to include in the table, as well as the parameters that describe it
Module 2. Designing a report template, typical design errors (2 ac. h.)
Rules for the “header”, analysis of typical errors;
Requirements for the contents of fields and records;
When and why you need to enter masks, lists and restrictions on data entry;
How flat tables differ from cross tables, their pros and cons;
General rules for formatting tables, analysis of common errors;
Filters, sorting, creating structures - solvable tasks;
Selecting visualization tools - practical examples
Module 3. Testing the result: general rules and analysis of typical errors (0.5 ac. h.)
Module 4. Presentation of the report to the customer: trust in the data and transparency of the results obtained (0.5 ac. h.)