Import, Export & Convert
Excel to Image: save a range or chart as PNG or JPG
Turn an Excel range or chart into an image: copy as picture, save a chart directly as PNG, take a high-resolution screenshot, and paste into email or slides.
Learn Excel the easy way.
Short, plain-English tutorials on formulas, shortcuts, charts and everyday Excel tasks. No jargon. One idea per post.
Start here Get Daily One LessonLatest tutorials
Pivot Tables & Tables
Pivot Table from Multiple Sheets in Excel (combine first, then pivot)
Make one pivot table from several Excel sheets: stack the sheets with Power Query Append, then build the pivot — and the older Data Model way.
Pivot Tables & Tables
Sort a Pivot Table by Value in Excel (largest first)
Sort an Excel pivot table by its values — largest to smallest — with a right-click, sort a specific column when there are several, and keep the sort after refresh.
Import, Export & Convert
Excel to XML: export a sheet as XML (and import XML back)
Export Excel to XML with an XML map, the quick way for a simple list using the Developer tab, a formula-built XML for small sheets, and importing XML into Excel.
Macros & VBA
Excel VBA Message Box: MsgBox with buttons, icons and a Yes/No answer
Use MsgBox in Excel VBA: a simple message, an icon and title, Yes/No buttons that change what the macro does, and a message with a cell's value in it.
Macros & VBA
How to Write a Macro in Excel (your first 5 lines of VBA)
Write a macro in Excel by hand: open the editor, write a Sub that clears a range and adds a date stamp, run it, give it a button, and save it.
Shortcuts
Excel Edit Cell Shortcut: F2 (and moving inside a cell)
Edit a cell in Excel without double-clicking: F2, then Home/End and Ctrl+Arrow inside the cell, replace the whole cell, and add a line break.
Shortcuts
Excel Zoom Shortcut: zoom in, out, and back to 100% from the keyboard
Zoom in Excel with Ctrl+scroll, the Alt-key sequence for exact zoom, zoom to a selection, reset to 100%, and set a default zoom for every new sheet.
Import, Export & Convert
How to Open a CSV in Excel Correctly (columns, zeros and dates intact)
Open a CSV file in Excel the safe way so columns split correctly, leading zeros survive and dates don't flip — and what to do when everything is in one column.
Showing 154–162 of 294 tutorials · Page 18 of 33
