Excel Basics
How to Make a Budget in Excel (simple monthly budget, step by step)
Make a monthly budget in Excel from a blank sheet: income, expense categories, planned vs actual, what's left, and a bar that shows overspending.
Author: Srini Vanamala
Dates & Times
Convert Text to Date in Excel: 3 fixes that always work
Convert text to real dates in Excel with Text to Columns, DATEVALUE, or DATE with pieces — for dd/mm/yyyy, 20260929, and dates with dots.
Data Cleaning
How to Separate Data in a Cell in Excel (names, addresses, codes)
Separate data in one Excel cell into several: by comma or space with Text to Columns, by pattern with Flash Fill, or with TEXTSPLIT — and which to pick.
Macros & VBA
How to Open the VBA Editor in Excel (Alt+F11) and find your macro
Open the VBA editor in Excel with Alt+F11 or the Developer tab, find the module holding your recorded macro, read the code, and change one value safely.
Shortcuts
Excel Filter Shortcut: Ctrl+Shift+L and the keys inside the filter
The Excel filter shortcut Ctrl+Shift+L to turn filters on and off, Alt+Down to open a filter menu, keys to search and tick values, and clearing with Alt A C.
Charts
Excel Stacked Bar Chart: parts and totals in one bar
Make an Excel stacked bar chart, show totals on top of each bar, switch to 100% stacked for shares, and know when clustered bars work better.
Print, Share & Protect
How to Insert a Page Break in Excel (and remove or see them)
Insert a manual page break in Excel so each section prints on its own page, see where breaks fall with Page Break Preview, move them, and remove them.
Shortcuts
Excel Merge Cells Shortcut: Alt H M M (and the safer alternative)
The keyboard shortcut to merge cells in Excel (Alt, H, M, M), merge and centre, unmerge, and Center Across Selection which does the same without the problems.
Dates & Times
How to Sort by Date in Excel (and why it sorts wrong)
Sort by date in Excel oldest to newest, keep rows together, sort by month ignoring the year, and fix the sort when dates are stored as text.
152 tutorials · Page 6 of 17
