Skip to content
Educora
EN
AzərbaycancaEnglishРусскийTürkçe
My learningEducora StudioSettings

Excel

Spreadsheets, formulas, charts and analysis

Go from zero to confident in Excel: enter and format data, calculate with formulas and functions, and analyse information with IF, COUNTIF and VLOOKUP. By the end you will sort and filter tables, build charts and PivotTables, and prepare a sheet for printing.

27 lessons7 modules≈ 8.1 hBeginnerIntermediateAdvancedUniversity
Progress0%

0 of 27 lessons completed

Start course

The Excel window: workbooks, sheets and cells

Course content

All tests · 13Formulas & shortcuts
1

Excel basics

Beginner

The Excel window, entering data, AutoFill and formatting cells.

3 lessons
  1. 1The Excel window: workbooks, sheets and cellsGet to know the main parts of the Excel window, learn to read cell addresses, move quickly around a sheet and save your file.
  2. 2Entering data and AutoFillLearn to type text, numbers and dates into cells, edit them, and complete whole lists in seconds with the fill handle and Flash Fill.
  3. 3Number formats and cell formattingLearn to show numbers as manat, percentages and dates, and make a table easy to read with fonts, colours, borders and alignment.
2

Formulas and functions

Beginner

First formulas, relative and absolute references, and core functions such as SUM, AVERAGE and COUNT.

3 lessons
  1. 4First formulas and operatorsLearn that every formula starts with `=`, how the arithmetic operators and the order of operations work, and what Excel's error values mean.
  2. 5Relative and absolute references ($A$1)Find out why references change when you copy a formula, how to “lock” them with the `$` sign, and the secret of the `F4` key.
  3. 6Core functions: SUM, AVERAGE, MIN, MAX, COUNTUse ready-made functions to find totals, averages, the largest and smallest values, count cells, and calculate in one click with AutoSum.
3

Logic, text and lookup

Intermediate

Conditional formulas, counting and summing by criteria, text functions and lookups with VLOOKUP/XLOOKUP.

4 lessons
  1. 7Conditional formulas: IF, AND, ORTeach Excel to make decisions: choose a result by a condition with IF, build a grading scale with nested IFs and combine conditions with AND and OR.
  2. 8Counting and summing by criteria: COUNTIF, SUMIFLearn to count and add up only the cells that match a condition: sales by category, values above a limit, text containing a keyword.
  3. 9Text functions: LEFT, MID, LEN, TRIM, CONCATLearn to cut pieces out of text, count characters, remove extra spaces, change letter case and join text together.
  4. 10Looking things up: VLOOKUP and XLOOKUPLearn to find a product's name and price from its code automatically: how VLOOKUP works, what #N/A means and why the modern XLOOKUP is better.
4

Organizing data

Intermediate

Excel Tables, sorting and filtering, conditional formatting and data validation.

2 lessons
  1. 11Sorting, filtering and Excel TablesLearn to sort long lists, show only the rows you need with a filter, and turn data into a “smart” Excel Table with `Ctrl+T`.
  2. 12Conditional formatting and data validationLearn to colour important values automatically, write rules with formulas and make sure only valid data can be typed into a cell.
5

Analysis, printing and pro habits

Advanced

Charts and PivotTables, page setup, printing and time-saving shortcuts.

2 lessons
  1. 13Charts and PivotTablesLearn to choose and build the right chart for your data and to summarise thousands of rows in seconds with a PivotTable.
  2. 14Printing, page setup and shortcutsLearn to print a sheet neatly and turn it into a PDF, plus the shortcuts and habits that make you twice as fast in Excel.
6

Advanced Excel: functions and analysis

Advanced

XLOOKUP and INDEX/MATCH, dynamic arrays, multi-criteria logic, date and text functions, PivotTables in depth, Power Query and what-if analysis.

7 lessons
  1. 15XLOOKUP in depth and INDEX/MATCHMaster all six arguments of XLOOKUP, the classic INDEX/MATCH pair, two-way lookups and approximate matching for grade, commission and tax bands.
  2. 16Dynamic arrays: FILTER, SORT, UNIQUE, LET, LAMBDAModern Excel, where one formula returns a whole table: spilling, FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, plus LET and LAMBDA for building your own functions.
  3. 17Multi-criteria formulas: COUNTIFS, SUMIFS, IFS, SWITCHLearn to count, sum and average by several criteria, build multi-step decisions with IFS and SWITCH, and handle errors with IFERROR.
  4. 18Dates and text: professional functionsHow Excel stores dates, calculating periods with EDATE, EOMONTH, NETWORKDAYS and DATEDIF, formatting with TEXT, and splitting and joining text with TEXTSPLIT, TEXTJOIN and Flash Fill.
  5. 19PivotTables in depthGrouping dates and numbers, shares and growth with Show Values As, calculated fields and their trap, slicers and timelines, PivotCharts and refreshing the right way.
  6. 20Power Query: importing and cleaning dataRecord the monthly manual work once: import from CSV and folders, cleaning steps, stacking tables (Append), joining them by a key (Merge) and turning columns into rows (Unpivot).
  7. 21What-if analysis: Goal Seek, scenarios, Data Tables and SolverAnswer “what if…?” questions in a model: find the input that hits a target with Goal Seek, compare scenarios, calculate hundreds of variants at once with a Data Table and find the optimal plan with Solver.
7

Professional Excel: finance, statistics and automation

University

Financial and statistical functions, dashboards, macros and VBA, Power Pivot and the Data Model, professional workbook habits and Copilot.

6 lessons
  1. 22Financial functions: loans, savings and investmentsThe maths behind PMT, IPMT, PPMT, FV, PV, NPV and IRR, the sign convention, a loan amortisation schedule built with formulas and worked examples in manat.
  2. 23Statistics in Excel: averages, spread, correlation and regressionMeasures of central tendency, STDEV.S versus STDEV.P, CORREL, linear regression and forecasting, a regression report with the Analysis ToolPak and histograms — together with what the formulas mean.
  3. 24Dashboards and data visualisationThe maths of KPIs (achievement, variance, growth, CAGR), choosing the right chart, sparklines, conditional formatting for KPIs and the layout rules of a dashboard that reads at a glance.
  4. 25Macros and VBA: automate repetitive workRecording a macro, reading and cleaning the code in the VBA editor, writing a simple Sub with a loop and a condition and your own function, plus macro security and the .xlsm format.
  5. 26Power Pivot and the Data Model: relationships and DAXLink several tables with relationships instead of VLOOKUP columns, build a star schema and understand the basic DAX measures (SUM, CALCULATE, DIVIDE) together with filter context.
  6. 27Professional workbooks: structure, auditing, protection and CopilotOrganise a workbook with a reliable structure, use named ranges, check formulas with Trace Precedents, Evaluate Formula and Error Checking, protect sheets and use Copilot in Excel wisely.

Microsoft Office

Power BIInteractive reports and dashboards from data: Power Query, modelling, DAXWordProfessional documents, formatting and templatesPowerPointImpactful presentations and slide designOutlookEmail, calendar and time management