Charts
Excel Chart: make one, change its type, and format every part
The Excel chart reference: make a chart, change its type, edit the data range, format axes, colours, labels and gridlines, copy a style, and export it.
Author: Srini Vanamala
Charts
How to Make a Graph in Excel (line, bar, pie — the same 5 steps)
How to make a graph in Excel step by step: set up the numbers, select them, insert the graph type, add a title and labels, and fix the three things that usually go wrong.
Pivot Tables & Tables
Excel Pivot Table: the complete guide (build, group, filter, refresh)
Everything about Excel pivot tables in one place: build one, rows and columns, sum vs count, group dates, filters and slicers, sort, calculated fields, refresh, and the mistakes.
Macros & VBA
Excel VBA Tutorial for Beginners: from zero to a working macro
An Excel VBA tutorial for beginners with no coding background: the editor, your first Sub, variables, ranges, If, loops, a message box, and a button — in one sitting.
Formatting
How to Lock Columns in Excel (for scrolling, or from editing)
Lock columns in Excel two ways: freeze the first column so it stays while you scroll sideways, or lock columns against editing with sheet protection.
Dates & Times
Get the Year from a Date in Excel (YEAR, and grouping by year)
Extract the year from a date in Excel with YEAR, as text with TEXT, the fiscal year, and total or count by year with SUMIF and a pivot.
Macros & VBA
Excel VBA Loop: For Next and For Each, with 3 real examples
Loops in Excel VBA for beginners: For Next to go down rows, For Each to visit every cell or sheet, Do While for 'until empty', with copy-paste examples.
Fixes & Errors
Excel Formula Errors Explained: #N/A, #VALUE!, #REF!, #DIV/0!, #NAME?, #####
Every Excel formula error in one table — what each one means, the usual cause, and the one-line fix — plus how to hide errors and find them all at once.
Fixes & Errors
Excel File Corrupted? How to recover it (5 methods)
Recover a corrupted Excel file: Open and Repair, extract values only, previous versions in OneDrive or Windows, open in Google Sheets, and the last-resort zip trick.
152 tutorials · Page 1 of 17
