Excel Essentials: Master the Fundamentals
- Free
- No certificate
- Beginner
- 1.9 hours
Excel Essentials: Master the Fundamentals is a free Udemy course from Mohammad Shabbir Taibani and Data Skill Hub, last updated in March 2025. It is short and tightly sequenced: 19 video lectures in six sections, 1 hour 53 minutes in total, with four quizzes placed between sections. The opening section covers the Excel interface, cell addresses and ranges, and the shortcut keys the instructor uses throughout. Excel Basic Function introduces SUM, COUNT and AVERAGE, the difference between COUNT and COUNTA and between SUM and SUBTOTAL under filters, joining text with CONCATENATE or the ampersand, and pasting values only. Reference and Logical Function covers VLOOKUP and IF with worked examples such as awarding a bonus when sales pass a threshold.
Data Tools demonstrates Text to Columns, Flash Fill and Data Validation drop-down lists, including lists driven by a range. The last two sections cover sheet protection and hyperlinks, then building and customising a basic PivotTable. Udemy lists the level as Beginner and states that no programming experience is needed. The course is in English with auto-generated captions. It is free to enrol in, and as with all free Udemy courses there is no certificate of completion, no instructor Q&A or messaging, and ads may appear.
What you’ll learn
- Move around the ribbon, sheets, rows, columns and ranges with keyboard shortcuts
- Use SUM, COUNT, COUNTA, AVERAGE and SUBTOTAL and understand required and optional arguments
- Join text with CONCATENATE and the ampersand and paste values without formulas
- Look up data with VLOOKUP and branch with IF
- Clean and structure data with Text to Columns, Flash Fill and Data Validation
- Protect a sheet, add hyperlinks and build a basic PivotTable
Who it’s for
Absolute beginners and office workers who want the most-used Excel functions in under two hours; anyone already comfortable with VLOOKUP and PivotTables should choose an intermediate course.
Source: Udemy (opens in a new tab) · Verified · Report a change