Microsoft Office Essentials Collection

Learn foundational formatting in spreadsheets. Apply color, borders, bold fonts, and alignment to create professional, readable documents; use auto-fit column widths and merge and center for a polished layout.

Apply number formatting to display currency, percentages, decimals, and dates. Use the format cells dialog box and format painter to pre-format cells and copy formats across data.

Learn how to use cell styles to apply consistent formatting across worksheets. Create and modify custom styles to update multiple cells with a single change.

Format data quickly with tables, apply styles and headers, and use the total row and auto fill; learn formulas, functions, filters, freezing panes, and banded rows for large data.

Convert the data to a table, filter stores 100 through 110, apply a January filter greater than 13,000, then change the table color to green.

Explore formulas and functions in Excel, starting with the equal sign and cell references, then use autosum and functions like sum, average, and count for dynamic range calculations.

Master relative references as formulas autofill across columns with drag, adjusting to each cell. Lock constants with absolute references using $ signs so the exchange rate stays fixed when copied.

Practice absolute references and autofill in a budget-style expense report, using dollar signs to fix cell C2 and the F4 shortcut to fill across cells.

Master autofill in Excel by copying formatting with the format painter and extending formulas, dates, months, days, and custom lists, with options like fill formatting only and double-click for speed.

Create and apply your own custom lists in Excel to power autofill, using existing city data or building new lists from scratch, and preserve them across documents.

Create a custom list from this list of cities and reuse it repeatedly. Open File, Options, Advanced, and Edit Custom List to create, edit, or delete lists.

Apply conditional formatting to highlight cells by criteria, such as department text or pay over threshold, and manage rules to adjust formats across the worksheet.

Apply conditional formatting to highlight blank cells by creating a new rule that formats cells with blanks in red, and verify by entering values.

Explore conditional formatting with data bars, color scales, and icon sets; customize rules, adjust high/low values, and switch between showing numbers and icons.

Apply conditional formatting to highlight earnings over 80,000 with a green fill. Use a 'format only cells that contain' rule to color blanks purple.

Sort and filter data using text and numeric orders, from A to Z or largest to smallest, and apply custom sorts to group data within departments while preserving related columns.

Filter data in Excel to show only east and west regions, then sales and marketing salaries over 100,000 using number filters, with clear filters and sort options.

Learn how to use text to columns to split a single column into separate first and last name columns by a space delimiter, enabling sorting by last name.

Combine conditional formatting with sorting and filtering in Excel to color-code data, filter by color, and sort by the top 30% for clearer analysis.

Sort by department, then sort earnings within each department to display departments alphabetically with salaries from lowest to highest.

Learn how to freeze panes in Excel to keep top headers and left labels visible as you scroll, using the View tab and Freeze Panes options, then unfreeze when needed.

Learn how to use split panes to view four independent panels of a worksheet at once, and note that freeze panes and split panes cannot be used together.

Learn to print large workbooks by using print preview, orientation and page setup, and scale to fit to one page wide, ensuring content fits and titles remain visible.

Set print titles to repeat specific rows on every page, keeping headers visible. Use the page layout's sheet options to repeat rows or columns and preview the result.

Learn to control page breaks in a workbook with page break preview, drag dashed lines to end pages at precise positions, and verify results in print preview.

Center printed sheets by enabling center on page horizontally and vertically in page setup margins, then adjust top, left, right, and bottom margins for perfect centering.

Master inserting and formatting headers and footers in Excel, including page numbers, file info, dates, and sheet names, and view them in page layout with contextual header and footer tools.

Learn to fit a document on one page and keep headings consistent across pages by adjusting width, switching to landscape orientation, and enabling print titles for a stable header row.

Master the basics of charts in Excel: select data, use insert and recommended charts, explore column, line, pie, and donut options, and apply chart design and format tabs.

Learn to manually create and customize 2d/3d column and bar charts in Excel, filter data, transpose rows and columns, and move charts to a new sheet.

Customize charts by adding data labels, titles, and axis labels, choose chart elements, adjust legend placement, resize and bold fonts, and prepare data tables for clear visualization.

Learn to format charts using the format and design tabs, apply shape styles and fills, insert shapes and text boxes, and update the legend for clear data visualization.

Learn to create and customize pie charts in Excel, including 2D and 3D pies and donuts, add and format data labels and legends, and explode wedges to highlight data.

Copy charts from Excel to PowerPoint to present data visually, edit data on the fly, and link or embed data for live updates with destination theme or source formatting.

Learn to create a 3D pie chart, explode a slice, and change the default color by dragging the slice and using format to change the shape fill color.

Learn Excel basics: layout options, inserting and resizing rows and columns, formatting, tables with filters, formulas, autofill, conditional formatting, sorting, freeze panes, headers and footers, and charts.

Explore the basics of Microsoft Word. Navigate the interface, master the ribbon and quick access toolbar, and edit with spell check, styles, alignment, bullets, tables, images, and PDF exports.

Acquire essential information to maximize this video-based Microsoft Office essentials course, including downloadable exercise and instructor files, plus guidance on downloading, unzipping, and playing videos in high definition.

Master the Word ribbon, its tabs, groups, and dialog box launchers to navigate features. Use tooltips, contextual tabs, the file menu, and the search tool to access help and options.

Customize the quick access toolbar in Word to place bullets, numbering, images, and PDF options at your fingertips. Add, remove, and reorder tools, and share settings across documents.

Learn how to save new and existing documents, rename and relocate files, and open documents using keyboard shortcuts like Ctrl+N and Ctrl+S, Save As, recent folders, and pins.