Short, focused explanations for converting files, fixing formatting issues, and choosing the right spreadsheet format.
Master the Excel CLEAN function: how to use CLEAN in Excel to strip non-printable characters from imports, with TRIM, SUBSTITUTE and Power Query examples.
Learn how to clean text data in Excel: TRIM to remove extra spaces, CLEAN for hidden characters, SUBSTITUTE for replacements, PROPER for case fixes.
Learn how to concatenate in Excel with 4 methods: the & operator, CONCATENATE, CONCAT, and TEXTJOIN. Add spaces, commas, and line breaks between joined cells.
Learn how to use conditional formatting in Excel: heatmaps, data bars, icon sets, highlight duplicates, and formula rules based on another cell. Full tutorial.
Learn how to convert text to numbers in Excel with 6 proven methods: the green-triangle fix, the VALUE function, Paste Special, Text to Columns and Power Query.
Excel CSV Chinese characters garbled into question marks or gibberish? Learn why it happens (UTF-8, GBK, BOM issues) and the exact fix in Excel, Python and Notepad++.
Excel data entry tips for speed and accuracy: data entry shortcuts, Flash Fill, data validation tips, the hidden data entry form, and batch workflows that prevent errors.
Learn how to use date functions in Excel: TODAY, DATEDIF for age calculations, EOMONTH for deadlines, NETWORKDAYS for working days, with real recipes.
Excel desktop vs Excel online compared: features, macros, Power Query, performance, and pricing. Learn what the free web version drops and when you need desktop.
Learn how to create a dropdown list in Excel: data validation lists, dropdowns from another sheet, dependent dropdowns, and error alerts. Step-by-step tutorial.