All-in-One Microsoft Office Course: Excel, Word & PowerPoint

Explore how to apply left, center, right, and justify text alignment using the paragraph group in the home tab to improve layout and readability of Word documents.

Learn to create and customize bullet points and numbered lists in Microsoft Word, using bullet libraries, symbols, pictures, and font options to organize content clearly and professionally.

Learn to control line spacing and paragraph spacing in Microsoft Word using the Home tab paragraph options, adjusting single, 1.15, or double spacing and spacing before or after paragraphs.

Discover how to apply built-in Word styles—heading 1, heading 2, normal, title, subtitle—and customize and save your own style to create clean, organized, readable documents.

Learn to use Microsoft Word styles to keep documents clean and professional, and enhance navigation and structure with title, heading levels, introductions, purposes, and emphasis.

Insert images from your computer or online into Word, then resize and apply layout, picture styles, glow effects to create a more engaging, professional document.

Learn how to arrange and align images, shapes, and icons in Microsoft Word, adjust layouts, and align objects for a clean, balanced, and professional document.

Learn to insert tables in Microsoft Word, enter data, and customize with shading, borders, and headers. Create a sales report example with employee names, regions, and sales values in dollars.

Format a Word table using borders and shading to create a clean, professional look. Insert tables and apply borders and shading via the table design options for clarity.

Elevate table formatting in Microsoft Word by adjusting row height and column width, using auto fit options and table layout to distribute rows and columns for a polished data presentation.

Adjust page margins, switch orientation between portrait and landscape, and set page size in Microsoft Word to prepare professional documents.

Insert headers and footers in Word documents to create a clean, organized look, and add page numbers, time/date, and document properties to customize header and footer content across pages.

Learn how to use page breaks and section breaks in Microsoft Word to control document layout, apply different formatting, and manage page numbers, headers, and footers across sections.

Explore the Excel interface and learn the basic building blocks: cells, rows, and columns, along with the ribbon, formula bar, and sheet tab.

learn how to enter and edit data in excel cells, apply data types and formatting, use double-click to edit, delete or undo, and create simple formulas with the equals sign.

Format numbers, dates, and text in Excel to present data clearly using currency and accounting formats, short and long date options, and basic text styling like font and alignment.

Learn to change font style, size, and color in Excel to make data readable and appealing, using bold, underline, and color highlights for headers and department or status groups.

Apply borders and shading in Excel to separate and highlight data, especially headers and totals, and use fill color and font color to improve readability of itemized tables.

Learn basic excel formulas for add, subtract, multiply, and divide to calculate totals from quantity and unit price, using sum and the formula bar.

Learn essential Excel functions, sum, average, and count, to perform quick calculations on a sample data set of items, quantities, and prices for fast data analysis.

Master relative, absolute, and mixed cell references in Excel to build dynamic formulas that copy across cells and calculate final prices with tax.

Learn how to sort data in Excel by ascending and descending order, applying simple and multi-level sorts to a sample data set of names, ages, and scores.

Learn to filter an Excel data table to show only the information you need, using basic and advanced filters, including text, number, custom criteria, and top-N options.

Learn to use find and replace in Excel to search and replace text. Convert data to a table, then use find and replace to update active and inactive statuses.

Learn to manage a workbook with multiple worksheets by creating, renaming, deleting, and organizing monthly sales reports across January, February, and March.