Excel: Beginning to Expert - Complete Course (updated)

Enter data efficiently in Excel by using enter to move down and tab to move right, then edit with double-click or the formula bar and delete as needed.

Discover how Excel handles dates and times with shortcuts for entering dates and times, powerful autofill, and formatting rules, including military time, am/pm, and two-digit year interpretation.

Learn to efficiently use undo and redo in Excel, master control Z and control Y shortcuts, and navigate the Quick Access Toolbar to manage data entry and edits.

Insert and manage comments in Excel by adding notes to cells, navigating between them, and toggling show or hide, editing, deleting, or showing all comments.

Calculate year-to-date totals in excel by creating a simple formula that adds today's profits to the previous year-to-date total, then use autofill to apply it.

Create a percent change formula in Excel by subtracting the prior amount from the current amount and dividing by the prior amount, using parentheses to enforce order of operations.

Master relative and absolute references in Excel to build and copy formulas across cells using dollar signs, autofill, and F4, with base salaries, bonuses, and percent raises.

Learn to create sum and average formulas in Excel using auto sum, selecting ranges, and the dropdown to switch functions, with shortcuts like equals and enter.

Explore essential excel functions in the beginning to expert course, including sum, count, counta, median, large, small, standard deviation, and rank, with autofill and relative references.

Explore font styles and alignment in Excel, applying bold, italics, underline, color, and fill, then master clear formats, the format painter, and subscript and superscript for polished cells.

Learn to adjust column widths and row heights by dragging, double-click for best fit, and use select all to apply auto‑size across the sheet.

Learn to align and merge across cells to create a centered title bar that spans columns, center subtitles, while adjusting font size, font type, and applying light background colors.

Explore how to create, customize, and remove borders in Excel to distinguish data, compare borders with grid lines, and preview results in print view and page layout.

Format numbers in Excel using the dialog box to apply social security, phone, percent, and date formats, including custom date patterns. Explore best fit, zoom, and currency or negative-number formats.

Master Excel conditional formatting to highlight cells, apply top 10 percent rules, and visualize data with data bars, color scales, and icon sets. Learn to manage and clear rules.

Discover how to create and customize tables in Excel, convert ranges to tables, apply styles, add header and total rows, filter, sort, and use slicers as a dashboard-style filter system.

Insert and format shapes in Excel to visualize data with circles, arrows, banners, and SmartArt, then arrange layers, add pictures, and use text panes.

Learn to insert and delete rows and columns in Excel, using right-click on headers or cells, and the insert dialog to shift cells down or right.

Hide and unhide rows and columns with right-click on column headers, select left and right of the hidden range, and use best fit and double-click for quick adjustments in Excel.

Move, copy, and insert data in Excel using drag, Ctrl, and Shift to rearrange cells and formulas, with right-click options, and undo to manage changes.

Master find and replace in Excel by using the Home tab to search for terms, replace with new text, and apply formats such as yellow highlights.

Explore how to use page layout view to preview the print, adjust margins, set print areas, repeat header rows, and configure headers and footers for Excel worksheets.

Explore page break preview in Excel to control how data prints, using the blue dotted lines and drag handles to include or exclude columns and rows.

Learn how to prepare Excel worksheets for printing using page setup, orientation, margins, and scaling in print preview, with header and footer customization for professional reports.

Learn to create and customize charts in Excel using the alt+f1 shortcut, producing a clustered column chart that visualizes data and highlights trends.

Create and customize Excel charts from data, avoiding totals to improve clarity. Use Insert or Alt+F1 shortcuts, switch row/column, and explore change chart type options for line, pie, and more.

Learn to create and format Excel charts, remove totals, adjust chart elements and titles, and apply quick layouts using the format and design tabs.

Create spark lines in Excel by selecting data, inserting a spark line (line, column, or win/loss) in a cell, and customizing color and markers, including negatives, to reveal trends.

Learn how to freeze panes in Excel to keep the top row or first column visible while scrolling, then unfreeze and combine freezes for flexible data navigation.

Split screen in Excel lets you view different parts of a worksheet at the same time. It uses your selection to determine the split and scrolls independently.

Master outlining in Excel by using auto outlining to group rows and columns based on formulas, collapse and expand quarters and totals, and toggle levels with keyboard shortcuts.

Learn to view multiple Excel workbooks and worksheets simultaneously by opening multiple windows and using the view tab to tile or cascade for data comparison.

Link and sum data across multiple worksheets and workbooks using formulas, switching windows, and managing absolute and relative references for regional totals in retail, wholesale, and internet.

Explore the if function for conditional logic, using a logical test like G-2 greater than 4500 to grant free shipping, otherwise 4 percent, and nested ifs for complex rules.

Apply vlookup approximate to assign discounts by price, using a table array and column index, with true for approximate matches, and manage absolute and relative references to fill formulas.

Master VLOOKUP exact match in Excel with one-to-one lookups, absolute table arrays, and column index numbers, using the insert function dialog for guided formula building.

Explore how the if family functions: countif, sumif, and averageif, to tally Swinn bikes by brand, compute total sales, and determine average sale per Swinn bike using range and criteria.