Skip to content
ArumSoft Learning
KO

    Everyday Excel Skills

    Fourteen short guides to the features that save the most time in daily work: saving and undo, filling series, Flash Fill, pasting values, finding and replacing, quick totals, freezing and hiding rows, copying formats, splitting and de-duplicating lists, comments, printing and saving as PDF.

    Beginner14 tutorialsabout 2 hoursStart the path →

    What's in this path

    1. Step 1: How to Save, AutoSave and Undo in ExcelSave a workbook, let AutoSave keep cloud files up to date, undo and redo mistakes, and get back work after Excel closes unexpectedly.9 min read
    2. Step 2: How to Use AutoFill and the Fill Handle in ExcelFill days, months, numbers, dates and numbered labels by dragging the fill handle, and control the result with Auto Fill Options and the Series dialog.9 min read
    3. Step 3: How to Use Flash Fill in ExcelSplit, combine and reformat text by typing one example and letting Flash Fill complete the column, and know when a formula is the better choice.9 min read
    4. Step 4: Paste Special in Excel: Paste Values, Transpose and MorePaste only the part of a copy you need: values instead of formulas, formats, a transposed copy, or a calculation applied to a whole range.10 min read
    5. Step 5: How to Use Find and Replace in ExcelFind any value on a sheet or in a whole workbook, change every copy of it at once, and use options and wildcards so you replace only what you mean to.9 min read
    6. Step 6: Quick Totals from the Excel Status BarGet the sum, average, count, minimum and maximum of any selection from the status bar, without writing a formula, and copy the result in one click.7 min read
    7. Step 7: How to Freeze Panes in ExcelKeep headings and labels on screen while you scroll: freeze the top row, the first column, or any rows and columns, and unfreeze them again.8 min read
    8. Step 8: How to Hide and Unhide Rows, Columns and Sheets in ExcelHide rows, columns and sheets you don't need to see, bring them back, and know how hidden cells affect formulas, copying and charts.8 min read
    9. Step 9: How to Use Format Painter in ExcelCopy the look of one cell to other cells with Format Painter: number formats, fonts, fills, borders and highlight rules, once or many times.8 min read
    10. Step 10: How to Split Data with Text to Columns in ExcelSplit one column into several at a comma, a dash or a fixed position, keep leading zeros, and turn text dates into real dates with Text to Columns.9 min read
    11. Step 11: How to Remove Duplicates in ExcelDelete repeated rows from a list with Remove Duplicates, choose which columns decide what counts as a duplicate, and check for duplicates before you delete.8 min read
    12. Step 12: Comments and Notes in ExcelAsk questions with threaded comments, mention and reply to colleagues, resolve finished threads, and explain cells with notes.9 min read
    13. Step 13: How to Print in Excel: Print Area, Titles and Fit to PagePrint exactly the cells you want, repeat the heading row on every page, fit a sheet to one page wide, and add page numbers.11 min read
    14. Step 14: How to Save Excel as PDF or CSVTurn a sheet into a PDF that looks right for anyone, or a CSV file that other apps can import, and know what each format keeps and loses.10 min read