Learn Excel in English — free

What you will learn, module by module

1. 1. Architecture & Navigation 5 topics

   • Workbook architecture/grid/Ribbon/Formula BarA guide to Microsoft Excel on the M4 iPad Pro. Tool bars, formulas, pivot tables, and more! — Tech Dad
   • Files/formats/directory hygieneEX-07-17 – Importing External Data from ASCII & Delimited Files into Excel — Computer Software Training
   • Range navigation/selectionExcel VBA - Selection, Active Cell, Range - Part 7 — Learn Google Sheets & Excel Spreadsheets
   • Rows/columnsWhat is Rows and Columns in MS Excel | Basics of Microsoft Excel for Beginners | #msexcelcourse — Marketing Fundas
   • WorksheetsMS Excel - Working with Worksheets — TutorialsPoint
2. 2. Data Entry & Layout 5 topics

   • Identifier corruption/leading zeros/scientific notation/15-digit precisionStop Excel From Eating Your Leading Zeros — SheetWise
   • Enter/edit text, numbers, datesDates & Time in Excel | Format Numbers in MS Excel | Excel : Home Tab -Number Block-Dates & Time-12 — Gyanyagya
   • AutoFill/custom series/Flash FillCreate Custom Autofill Lists a.k.a AutoFill Series in Excel Super Easily — Hasaan Fazal
   • Freeze Panes/splitFreeze Panes and Split Window | How to Use Freeze Panes and Split Window | Excel Tutorial Part 9 — My Computer Course
   • Wrap Text/Center Across SelectionMy Excel Power: Merge and Center, Center Across Selection, Shrink to Fit, Wrap text — My Excel Power
3. 3. Presentation & Print 4 topics

   • Number formats/underlying precisionWorking with Different Number Formats in Excel Profelper Basic Excel Training — Profelper
   • Fonts/gridlines/borders/fillsSecrets to Perfect Excel Formatting: Borders, fills & fonts! — Excel4Today
   • Format Painter/Cell Styles/ThemesEasy Excel | Fast Formatting with Format Painter and Cell Styles — Kits and Bits
   • Page setup/print titles/scaling/page breaks/PDFExcel Print Page Setup | Printing Tips for Excel | How to Print in Excel |Every Excel User Must Know — mybigguide
4. 4. Formula Syntax & Math (Basic) 3 topics

   • Arithmetic formulas/operators/BODMASExcel Beginner Tutorial part 18 | Excel Formulas & Functions Explained | SUM, Operators, and BODMAS — That Dubai Analyst
   • Relative/absolute/mixed referencesExcel Class 7 : Cell References -Relative, Absolute & Mixed References Simplified — COPAGURU
   • Formula errors/auditingMost Common Excel Errors #️⃣ and How To Fix Them - Avoid Broken Formulas — Leila Gharani
5. 5. Standard Summary 2 topics

   • SUM/AVERAGE/MIN/MAX/COUNT/COUNTA/AutoSumAutosum, Average, Max, Min, Count & Autofill Functions | Excel — The Organic Chemistry Tutor
   • ROUND/ROUNDUP/ROUNDDOWN/LARGE/SMALLAdvance Excel | Uses of Round function | RoundUP() Rounddown() in Excel | Computer Tech Academy — Computer Tech Academy
6. 6. Tables & Navigation 5 topics

   • Tables/structured refs/calculated columns/dynamic expansion/Total RowsLock Structured References in Excel Tables (No More Formula Errors) — MyOnlineTrainingHub
   • SortingMS Excel - Data Sorting — TutorialsPoint
   • FilteringMS Excel - Filtering Data — TutorialsPoint
   • Duplicates/composite keysERPstuff Excel vlookup composite key — ERPstuff
   • Find/Replace/Go To SpecialA Drop of Excel - 10 | Paste Special, Find & Replace, Go to Special — Excel Rush
7. 7. Data Validation & Integrity (Basic) 2 topics

   • Validation/dropdowns/constraints/error alertsMS Excel - Data Validation Error Alert — TutorialsPoint
   • Sheet protection/formula locksHow to Lock Cells 🔒in Excel to Protect your Formulas & Only Allow Input where Needed — Leila Gharani
8. 8. Conditional Formatting (Basic) 1 topics

   • Standard rules (conditional formatting)How to use standard formulas in conditional formatting in Microsoft Excel — NILC Training
9. 9. Formula Syntax & Math (Intermediate) 2 topics

   • Name Manager/defined namesDefined Names in MS Excel | Name Manager in MS Excel — COMPUTER LAB
   • 3D cross-sheet/workbook linksCreating links across worksheets and workbooks in Excel — Cubicle Overlords
10. 10. Data Validation & Integrity (Intermediate) 2 topics

    • Dynamic/dependent dropdownsExcel Secrets Revealed: Mastering Dynamic Multi-Dependent Dropdowns on Every Row — Up4Excel
    • Workbook protection/hiding/co-authoringExcel 2019 & 365 Tutorial Co-authoring Workbooks Microsoft Training — TeachUComp
11. 11. Conditional Formatting (Intermediate) 2 topics

    • Rule hierarchy/custom formula rulesRules Hierarchy of Oracle Fusion Incentive Compensation Rules using custom excel addin — A3Bigas AssignmentRules
    • Operational audit/deadlines/errorsInternal Audit Template | Easy Audit Reporting Process in Excel! — Someka
12. 12. Logical & Conditional Aggregation 3 topics

    • IF/AND/OR/IFSHow to Use the IFS Function in Excel — Leila Gharani
    • IFERROR/IFNAHow to Use IF, IFS, COUNTIFS, SUMIFS, IFERROR, and IFNA in Excel — Simon Sez IT
    • SUMIFS/COUNTIFS/AVERAGEIFSHow to Use SUMIFS, COUNTIFS and AVERAGEIFS in Excel (Multiple Criteria) — Leila Gharani
13. 13. Lookup 4 topics

    • VLOOKUP + vulnerabilitiesExcel VLOOKUP and CONCATENATE for Vulnerability Analysis — Dewayne Hart, aka "Chief of Cybersecurity"
    • INDEX/MATCHExcel Index Match Tutorial — TEKNISHA
    • XLOOKUPXlookup In Excel: Explained In 3 Minutes — Excel Campus - Jon
    • XLOOKUP vs INDEX/MATCH vs VLOOKUPXLOOKUP VS INDEX-XMATCH BY EXCEL IN A MINUTE — Excel in a Minute
14. 14. Text 2 topics

    • LEFT/RIGHT/MID/LEN/FIND/TRIM/CLEANText Functions in Excel | Lecture 13 | Replace | Left and right | Len | Find | Mid — AVR EdTech Services
    • TEXTJOIN/CONCAT/SUBSTITUTE/Text to ColumnsHow to Join Text in Excel Concatenate, &, Concat, TextJoin — Learn With Lokesh Lalwani
15. 15. Date & Time 2 topics

    • DATE/EOMONTH/DATEDIF/NETWORKDAYSExcel Date Functions Explained | EDATE, EOMONTH, NETWORKDAYS & DATEDIF — IICA Computer Education
    • Imported text dates/parsingMS Excel - Text to Columns — TutorialsPoint
16. 16. PivotTables 3 topics

    • Build/configure/value aggregation/% displayCreate Pivot Tables In Excel | Use of Pivot Table - Pivot Table Tutorial — Rishabh Mishra
    • Grouping/Slicers/Timelines/Calculated FieldsExcel PivotTable Full Tutorial | Calculated Fields, Grouping & Slicers Timelines Explained #excel — Skills Boost with Umair
    • Pivot cache/format/source expansion troubleshootingHow to Update Pivot Table When Source Data Changes in Excel - Tutorial — Excel Tutorials by Y. Acosta
17. 17. Business Charting 2 topics

    • Professional business chartsAWESOME Excel Charts & Visuals | For Business & Finance Professionals — Kenji Explains
    • PivotCharts + Slicers/Timelines[5.8] - Microsoft Excel Tutorial - Slicers, timelines, and PivotCharts to analyze PivotTable data — Analytics Fun
18. 18. Workplace Reporting/Reconciliation 2 topics

    • Reconcile datasetsHow to Reconcile 2 Datasets Using Ms-Excel - Using 4 Filter Methodology - Using Consolidate Feature — The Excelism
    • Monthly rolling reports/exception trackers/control totalsAutomate Reports in Excel using Office Scripts - Time Saving Tip to Auto Format Reports — Sharon Smith
19. 19. Dynamic Arrays 3 topics

    • FILTER/SORT/SORTBY/UNIQUE/SEQUENCE/spill6 Powerful Dynamic Array Function in Excel | FILTER, UNIQUE, SORT, SORTBY, RANDARRAY and SEQUENCE — PK: An Excel Expert
    • LET optimizationCalculating the Optimal Portfolio in Excel | Portfolio Optimization — Ryan O'Connell, CFA, FRM
    • LAMBDA reusable formulas (G6 only)Hindi video
20. 20. Power Query Foundations 2 topics

    • Ingest/clean/transform CSV/ExcelMaster Data Cleaning Essentials on Excel in Just 10 Minutes — Kenji Explains
    • Append/Merge/query loadingHow to Join Tables in Excel | Merge or Append Data From Different Sheets Using Power Query — Chester Tugwell
21. 21. Advanced Power Query 3 topics

    • Combine monthly files from folderEasiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder) — Leila Gharani
    • Unpivot/normalize headersExcel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query) — Leila Gharani
    • Grouping/custom M/parameters/error handling (G7 only)How To Add Error Bars In Excel (Custom Error Bars) — Steven Bradburn
22. 22. Business Analytics 3 topics

    • Distributions/percentiles/quartiles/outliersHow to Find Outliers with Excel — Absent Data
    • MoM/YoY/moving averages/run ratesMoving Averages in Excel -MAD (MAE), MSE, MAPE | Forecast + Graph — Joshua Emmanuel
    • Pareto/contribution concentrationHow To Calculate A Weighted Average In Excel (With Percentages!) — Steven Bradburn
23. 23. Finance & Accounting 3 topics

    • GL/trial balance/chart-of-accounts mappingTrial Balance Mapping | Trial Balance to Financial Statements | Accounting in Excel — Professional's Legacy
    • AR/AP aging + BRSExcel Tutorial to Quickly Reconcile two sets of Data — TEKNISHA
    • PMT/IPMT/PPMTExcel Financial Functions - PMT, IPMT, PPMT & GOAL SEEK | Excel Formulas and Functions — Deepak EduWorld
24. 24. Financial Modeling 3 topics

    • FAST assumption-driven model/error checks/sensitivityExcel Financial Modeling | Forecast Sensitivity Analysis Tutorial — Matt Brattin
    • NPV/XNPV/IRR/XIRRCapital Budgeting in Excel | PV, FV, NPV, XNPV, IRR, XIRR, Payback — Grevx Academy (Formerly Finsaviours)
    • Goal Seek/SolverExcel Solver & Goal Seek Tutorial — Kevin Stratvert
25. 25. MIS Dashboard 2 topics

    • 3-tier dashboard model/KPI cardsHotel Chains Dashboard in Excel | Revenue, Brands, Channels and Guests — Next Gen Templates
    • Interactive dashboard/linked slicers/dynamic labels/view protectionCreate Excel Dashboard in 10 Minutes 🔥 | Interactive Dashboard with KPI, Charts & Slicers — Satish Dhawale
26. 26. Automation/VBA 3 topics

    • Formulas vs Power Query vs VBA decisionPython in Excel vs Power Query vs Formulas vs Copilot (Which Should You Use?) — Maven Analytics
    • Record/secure/inspect/clean VBA macrosExcel VBA - Record and Run Excel Macro — Contextures Inc.
    • Range/If/Then/button triggers5. Customizing Form Buttons And Other Shape Triggers || VBA Tutorial || Lecture || Microsoft Excel — Sanu Tutorial

Questions

More skills in English

• Spoken English · English
• Video Editing · English
• Computer Basics · English
• Digital Marketing · English