Skip to content
ArumSoft Learning
KO

    Excel Basics

    Start from a blank workbook and finish able to enter and format data, write formulas with the everyday functions, sort and filter lists, build tables and charts, and work quickly with the keyboard.

    Beginner12 tutorialsabout 2 hoursStart the path →

    What's in this path

    1. Step 1: Excel Basics: Workbooks, Cells and RangesLearn what workbooks, worksheets, cells and ranges are, then select, enter, edit and save data with confidence.10 min read
    2. Step 2: How to Format Cells in ExcelMake a plain table easy to read with bold headings, fill colors, borders, alignment, wrapped text and the right column widths.10 min read
    3. Step 3: Number and Date Formats in ExcelShow prices as currency, discounts as percentages and dates as real dates, and control decimal places without changing the stored values.9 min read
    4. Step 4: How to Write Basic Formulas in ExcelAdd, subtract, multiply and divide with formulas that use cell references, so your results update by themselves when the numbers change.10 min read
    5. Step 5: Essential Excel Functions: SUM, AVERAGE, COUNT, MIN and MAXSummarize any column of numbers with five functions: total it, average it, count it and find its lowest and highest values.10 min read
    6. Step 6: Copying Formulas and Cell References in ExcelWrite a formula once and copy it down a whole column with the fill handle, and understand how Excel adjusts each copy's cell references.9 min read
    7. Step 7: How to Sort and Filter Data in ExcelPut a list in order by one or more columns, and show only the rows you need with text and number filters.9 min read
    8. Step 8: How to Use Excel TablesTurn a plain range into an Excel table with Ctrl+T, then let it filter, band, total and extend formulas to new rows for you.9 min read
    9. Step 9: How to Create a Chart in ExcelTurn a column of numbers into a column, line or pie chart, add a clear title and axis titles, and pick the right chart for your question.9 min read
    10. Step 10: How to Write IF Statements in ExcelTurn a comparison into a clear answer with IF, then count and total the rows that meet a condition with COUNTIF and SUMIF.11 min read
    11. Step 11: How to Clean Up Data in ExcelFix a messy list: trim stray spaces, swap values with Find and Replace, split names into columns, remove duplicate rows and find blank cells.12 min read
    12. Step 12: Excel Navigation and Keyboard ShortcutsJump to the edges of your data, select whole columns of numbers, insert totals and run everyday commands from the keyboard.10 min read