Microsoft Excel : Complete Excel for Absolute Beginners

Learn how to enter data in Excel cells, move with the mouse, arrows, or tab, edit mistakes, and distinguish numbers (right aligned) from text (left aligned) for accurate data entry.

Master Excel's auto fill to generate month, day, and date sequences, from Jan to Dec and Mon to Sun, by entering a starter value and dragging the fill handle.

Learn how to enter and format dates and times in Excel using month, day, year formats, slashes or dashes, and 24-hour or am/pm formats, with tips on two-digit year interpretation.

Master date and time entry in Excel, using month/day/year with slashes or dashes; understand two-digit year interpretation and 24-hour or am/pm formats to avoid errors.

Learn to add and manage comments in Excel to annotate unusual numbers, using insert comment or Shift+F2, edit or delete, and show all comments for review.

Learn to save your Excel workbooks with save and save as, browse directories and set a file name, and choose formats like 97-2003 workbook or web formats for compatibility.

Learn how to build simple and powerful Excel formulas to compute net profit, subtract values, use the equals rule, reference cells, and apply functions like sum and average with auto-fill.

Master the year-to-date profit formula in Excel, using a sum across monthly values and dragging the formula to extend updates through the year.

Learn to calculate percentage change in Excel by comparing monthly figures such as net profit, expenses, or sales, using (current minus previous) divided by previous with parentheses.

Explore relative and absolute formulas in Excel, using fill-down for salaries and fixing cells with dollar signs, so a 2.3% or 1000 increase applies correctly across employees.

Master Excel's AutoSum to quickly total and average across May to July, apply calculations to rows and columns, and use max, min, and count for expenses, sales, and profits.

Explore Excel's formula tab and its categories, including financial, logical, text, and statistical functions. Practice median, variance, and standard deviation, and apply rank to monthly data.

Explore the font and size options in Excel's home tab, selecting from many fonts, adjusting sizes from 14 to 72, applying bold, italic, underline, and colorizing cells.

Learn to adjust row heights and column widths in Excel by selecting cells, using the Home tab format options, dragging boundaries, and applying best fit for auto sizing.

Explore Excel alignment tools to left, center, or right align text, adjust vertical alignment, wrap text, merge and center across columns, rotate, and resize row height.

Learn to apply and customize borders and lines in Excel, including bottom, outside, outline borders, draw borders, erase borders, and adjust style, color, and preview.

Format numbers in Excel using special formats for social security numbers, phone numbers, and zip codes, and adjust currency, decimals, and accounting styles for different regions.

Master date and time formats in Excel by using format cells, selecting short, long, and custom formats. Learn to calculate elapsed time with 24-hour or am/pm formats for practical tasks.

Master conditional formatting in Excel to highlight top salaries with data bars, color scales, and icon sets, while managing and clearing rules for clear data visuals.

Convert data into an Excel table, apply formats, and use header, total, and banded rows, then filter with slicers by department and city.

Create and edit shapes and arrows in Excel, resize and position them, add text, and highlight data with fill or borders. Use SmartArt for organizational charts and insert online pictures.

Learn to add or delete cells, rows, and columns in a worksheet using insert and delete tools, including right-click options and undoing actions, while preserving adjacent data.

Learn how to hide and unhide columns and rows in Excel, view results in print preview, and use boundary dragging or right-click menus to manage hidden data.

Learn how to move and shift data in Excel using drag, copy-paste, and shift-drag techniques, with tips on replacing rows and undoing actions.

Learn to locate and replace data in Excel using the find and select tools, with find next, find all, and replace options, including match case and match entire contents.

Learn how to control Excel page layout and printing by using print preview, setting margins and orientation, choosing page size, defining print areas, and repeating headers on every page.

Explore page break preview in Excel to adjust page boundaries, print selected data across pages, and preview layouts, while avoiding overcrowding and printing sensitive financial information.

Explore page setup in Excel to adjust margins, orientation, paper size, and scaling, preview prints, and control grid lines and titles on all pages.

Create and format charts in Excel by selecting data and choosing chart types such as clustered, stacked, or line charts; place charts beside data or on a separate worksheet.

Explore types of charts in excel, switch chart types, and compare line charts for time trends with pie, bar, area, scatter, radar, and histograms.

Learn to create and customize charts in Excel, adjust chart type, add titles and axis labels, and format fonts, colors, and chart areas for polished visuals.

Create and customize a chart by adding axes and adjusting axis scales and the plot area. Explore data labels, legend, trend lines, grid lines, and 3D effects.

Learn to create in-cell sparklines in Excel using line, column, or win/loss charts. Adjust color, thickness, and axis to reveal highs, lows, and negative points.

Master freeze panes to keep headers, names, and key columns visible while scrolling, with options for top row, first column, or multiple columns, and easily unfreeze when needed.

Learn how to split a worksheet into multiple panes to compare data across rows and columns, adjust pane sizes, revert splits, and view four panes for simultaneous analysis.

Learn how to collapse and expand data in Excel using the data tab outline group, collapse or show details with the plus sign, and use subtotal for automatic totals.

Explore how to view multiple workbooks and worksheets at once by using the view tab, arrange options (tile, horizontal, vertical), and creating a new window to copy a workbook.

Learn to rename, copy, delete, and hide sheets in Excel, add new sheets to the right or left with shortcuts, and understand that deleted sheets cannot be undone.

Learn how to group, move, and copy sheets in Excel, creating copies in the same or another workbook, and apply changes to grouped sheets using the control and shift keys.

Learn how to use if functions in Microsoft Excel to apply conditional tax rules on salaries, such as 10% for over 50,000 and zero otherwise.

Apply approximate vlookup in Excel to assign tax rates from salary ranges. See how to build a two-column table and derive rates, then use index and match as an alternative.

Learn how to use VLOOKUP with exact match to fetch an employee's department by name, select the second column and false for an exact result, then fill down.

Learn to use countif, sumif, and averageif in Excel to tally categories, sum sales, and compute average sales for cell phones, consoles, TVs, video games, and laptops.