Search
Free Excel tutorials by Vaishvi Desai
Stuck in a spreadsheet? Find the fix here.
Plain-language answers to everyday Excel questions: which formula to use, how to build a Pivot Table, when a short VBA macro will save you time. Each one walks through a worked example.
710+ free tutorials
5 Excel topic libraries
3 Windows 11 guides
3 free Excel tools
About the author
Hi, I’m Vaishvi Desai
I started using Excel seriously as a financial analyst, where formulas, Pivot Tables and VBA were part of the daily job. ExcelSamurai is where I write up what I have learned, in plain language and with worked examples, for professionals, students and anyone who works in spreadsheets.
Read all tutorials by Vaishvi DesaiExcel topics
Start with the topic you need
Five collections cover the Excel questions people ask most, from a first SUM formula to a macro that builds a report.
Excel formulas
Lookups, IF logic, dates, text and totals. Each formula is shown on a worked example you can adapt.
Browse Excel formulasExcel shortcuts
Keyboard shortcuts for Windows and Mac that replace the clicks you repeat every day.
Browse Excel shortcutsPivot Tables
Build, group, sort and filter Pivot Tables, and fix the ones that won't update.
Browse Pivot TablesExcel guides
Charts, printing, data validation, file conversions and fixes for common errors.
Browse Excel guidesExcel VBA
Copy-ready macros for filtering, formatting, emails and files, with the code explained.
Browse Excel VBANew on ExcelSamurai
Latest Excel tutorials
The most recently published tutorials, newest first.
Beyond Excel
Windows 11 guides
Short, practical fixes for everyday Windows 11 tasks, like finding a saved Wi-Fi password or taking a screenshot.
How to Change Administrator Account in Windows 11?
Learn how to change administrator account in Windows 11 using Settings, Control Panel, netplwiz, and Command Prompt with easy steps.
How to Find WiFi Password on Windows 11?
Learn how to find your WiFi password on Windows 11 using Settings, Control Panel, Command Prompt, PowerShell, or your router.
How to Take a Screenshot on Windows 11: Easy Guide
Learn how to take a screenshot on Windows 11 using Snipping Tool, PrtScn, keyboard shortcuts, and automatic screenshot saving.
Free Excel tools
Free tools for everyday Excel jobs
Free Online VBA Code Generator
Pick a task such as sorting, filtering or sending an email, fill in your range, and get VBA code to paste into the editor.
Use the toolOnline Excel Formula Beautifier
Paste a long nested formula and get it back indented and colour-coded, so you can see which part does what.
Use the toolFree Excel Shortcut Cheat Sheet
Search 180+ Excel keyboard shortcuts by key or by what you want to do.
Use the toolKeep it handy
Get the free Excel shortcut cheat sheet
186 shortcuts on one searchable page. Type a key or a task, like “F4” or “worksheet”, and the list narrows as you type.
Open the cheat sheet