Office 365: Excel and Word BUNDLE - Beginner to expert

Master data entry in Excel by using enter and tab to move across and down, double-click to edit, and the formula bar for corrections, noting alignment to spot errors.

Learn to use autofill to enter data quickly, extend days of the week, quarters, and months, and recognize patterns and acronyms with the autofill handle.

Master entering and formatting dates and times in Excel using shortcuts, including slashes and dashes, four-digit years, and military time, plus autofill for sequences.

Learn how to efficiently use undo and redo in a workbook by typing data, using Ctrl+Z, the quick access undo button, and the drop-down to review and redo recent actions.

Insert a comment by selecting a cell, choosing insert comment, and typing your message. Show or hide comments, edit or delete them from the review tab, and navigate between comments.

Master creating simple formulas and functions in Excel by starting with equals, referencing cells, using sum and average, drag-to-select ranges, and exploring the function library.

Learn to use Autofill to copy formulas and functions across adjacent cells, understand relative references, and extend formulas across rows and columns.

Learn to compute year-to-date totals in Excel by building formulas that add the profits for the day to the previous total, using relative references and autofill to copy across cells.

Learn to create a percent change formula in Excel using cell references and parentheses to enforce order of operations. The lesson shows formatting results as percent and troubleshooting common errors.

Explore how to use relative and absolute references in Excel to create and copy formulas, lock specific cells with dollar signs, and leverage autofill for efficient data calculations.

Learn to use autosum and autos average, create sums and averages with selections on the home tab, and leverage keyboard shortcuts like alt plus equals for faster totals.

Explore essential Excel functions, including auto sum, auto average, count, median, large, small, standard deviation, and rank. Learn autofill and relative references to apply these formulas.

Explore font and alignment, applying bold, italics, underline, font color, and fill. Learn to use clear formats, format painter, and shortcuts like control one for superscript, subscript, and wrap text.

Adjust column width and row height by dragging with a two-way cursor, and apply best fit to auto-size to the widest item. Use select all to apply changes across worksheet.

Explore how to align and merge cells to create a centered title across a range, using merge and center, format with background color, and adjust font size and font type.

Explore how to create and customize borders in Excel, distinguish borders from grid lines, use the more borders dialog and border options, draw borders, and preview borders in print view.

Learn to apply numeric and special formatting in Excel without changing raw data. Format Social Security numbers, phone numbers, dates, and percentages using the number dialog box.

Master conditional formatting in Excel by creating rules to highlight values, apply top 10 percent and data bars, use color scales and icon sets, and manage rules.

Create and customize Excel tables with insert table or Ctrl+T, define headers, apply styles, and use filters, totals, and slicers to analyze data efficiently.

Learn to insert shapes, arrows, banners, and images in Excel, format fills and outlines, adjust layering and anchoring, and use smart art for clear data visuals.

Master inserting and deleting rows and columns in a workbook using right-click, then use the insert dialog to choose shift cells down or shift right.

Hide and unhide rows and columns in Excel, using left and right selections, unhide actions, best fit, and select all to reveal hidden data.

Master moving, copying, and inserting data in a worksheet using drag-and-drop, shift to insert, and copy-paste shortcuts. Explore right-click options, undo, and column and row insertion to reorganize data.

Learn to use find and replace in an Excel worksheet, including find all, replace all, match case, and formatting options to update data across the workbook.

Learn how to use page break preview in Excel to control printed page layout, adjust blue dotted page breaks, and preview print results, including resetting breaks when needed.

Explore how to print Excel worksheets using page layout view, adjust margins and print areas, set print titles, and customize headers and footers with page numbers and dates.

Explore Excel page setup to optimize printing: switch between page layout and page break preview, adjust orientation and margins, and use scaling to fit data on a page.

Create charts from data in Excel with a quick shortcut, generating a clustered column bar chart and updating chart elements like data labels, axis titles, and filters for clear insights.

Create and customize Excel charts by selecting data, using Alt+F1 or insert options, avoiding totals, switching row/column, and choosing the right chart type—line, column, bar, or pie.

Learn to create and format charts in Excel 365 by selecting data, removing grand totals with filters, and adjusting titles, grid lines, and quick layouts.

Learn to create spark lines in Excel, select data ranges, choose line, column, or win/loss types, place them in a cell, and customize axis and colors to show negatives.

Freeze panes in Excel from the view tab to keep the top row, the first column, or both visible while you scroll, and unfreeze panes to revert.

Use the split screen in Excel to view different parts of a worksheet based on your selection, with independent scrolls.

Learn to use excel's auto outlining to group rows and columns by formulas, collapsing and expanding quarters and categories, and control outline levels for clear data presentation.

Open multiple workbooks and worksheets, then use the view tab arrange all to tile windows for side-by-side comparison; create virtual windows to view multiple worksheets within one workbook.

Master managing multiple worksheets in a workbook by creating, renaming, coloring, moving, copying, deleting, and grouping sheets to apply consistent data across tabs.

Learn how to link data across multiple worksheets and workbooks in Excel using formulas, including summing across tabs, absolute and relative references, and formula auditing.

Learn to use if functions to create conditional shipping rules in Excel, including greater than or equal to thresholds, with nested ifs and autofill to apply across many rows.

Explore vlookup with approximate match to calculate discounts from a price table, learn absolute vs relative references, and explore hlookup and transpose for horizontal lookups.

Learn how to perform exact lookups with VLOOKUP, using one-to-one matching, absolute table arrays, column index, and false for exact match, with the insert function dialog for guided syntax.

Explore the if family of functions in Excel with countif, sumif, and averageif to calculate counts, totals, and averages for brands like Swin bikes, using range, criteria, and sum range.