o‘zing o‘rgan
All courses
Filbek · Data specialist

Excel and Google Sheets

Spreadsheet basics, formulas and the $ sign, IF/COUNTIF/SUMIF, VLOOKUP/XLOOKUP, pivot tables, Power Pivot, DAX, financial modeling and cloud integration — for office and deep data analysis.

20 lessons ~7 h
Start for free 1-darsni ro‘yxatsiz sinab ko‘rish

Chapter 1. Working with spreadsheets

5 lessons
  1. Spreadsheet basics ro‘yxatsiz sinab ko‘ring 4 questions 15 min
  2. Formulas and relative/absolute references ro‘yxatdan o‘tgach 4 questions 20 min
  3. Conditional functions: IF, COUNTIF, SUMIF ro‘yxatdan o‘tgach 4 questions 20 min
  4. Lookups: VLOOKUP, XLOOKUP, INDEX/MATCH ro‘yxatdan o‘tgach 4 questions 20 min
  5. Sorting, filtering, pivot tables and charts ro‘yxatdan o‘tgach 4 questions 20 min

Intermediate level

Ro‘yxatdan o‘tib, oldingi darajani tugatgach — kirish imtihoni bilan ochiladi.

Chapter 2. Text, dates, cleaning and dashboards

5 lessons
  1. Text functions ro‘yxatdan o‘tgach 3 questions 20 min
  2. Dates and times ro‘yxatdan o‘tgach 3 questions 20 min
  3. Cleaning data ro‘yxatdan o‘tgach 3 questions 20 min
  4. Dynamic arrays: FILTER, SORT, UNIQUE ro‘yxatdan o‘tgach 3 questions 20 min
  5. A small dashboard and report ro‘yxatdan o‘tgach 3 questions 20 min

Advanced level

Ro‘yxatdan o‘tib, oldingi darajani tugatgach — kirish imtihoni bilan ochiladi.

Chapter 3. LAMBDA, Power Query, the data model and automation

5 lessons
  1. LET and LAMBDA: your own functions ro‘yxatdan o‘tgach 3 questions 20 min
  2. Power Query: preparing data automatically ro‘yxatdan o‘tgach 3 questions 25 min
  3. Several tables: the data model ro‘yxatdan o‘tgach 3 questions 20 min
  4. What-if analysis: Goal Seek, Data Table, Solver ro‘yxatdan o‘tgach 3 questions 20 min
  5. Automation and next steps ro‘yxatdan o‘tgach 3 questions 20 min

Chapter 4. Power Pivot, DAX, financial modeling and cloud integration

5 lessons
  1. Power Pivot and DAX formulas ro‘yxatdan o‘tgach 4 questions 25 min
  2. Financial modeling: PMT, NPV, IRR ro‘yxatdan o‘tgach 4 questions 20 min
  3. Interactive dashboards: Slicers and visualization ro‘yxatdan o‘tgach 4 questions 25 min
  4. Data validation, auditing and error handling ro‘yxatdan o‘tgach 4 questions 20 min
  5. Google Sheets and the Cloud: IMPORTXML and collaboration ro‘yxatdan o‘tgach 4 questions 20 min