Microsoft Office Essential Word Excel PowerPoint Course

Navigate the Word interface from the start screen to the ribbon and quick access toolbar, mastering text formatting tools and essential document commands.

Learn to create, open, and save Word documents using blank or template options, with keyboard shortcuts like Ctrl+N, Ctrl+O, and Ctrl+S.

Learn to access microsoft word templates, load and save them as reusable templates, and create custom templates with cover pages, styles, document properties, and table of contents, headers and footers.

Learn to navigate and select text in Word using scrollbar, Ctrl+End, Ctrl+Home, and click-and-drag techniques to jump through large documents efficiently.

Learn to modify text in Microsoft Word by copying, pasting, cutting, and using undo and redo with keyboard shortcuts, including Ctrl+C and Ctrl+P, in a practical workflow.

Find and replace teaches locating words or formats across a document and replacing them, using find with ctrl+f, the navigation pane, and replace with ctrl+h to update all occurrences.

Learn to format text in Word by changing font designs, size, color, and applying bold, italic, and underline, and format paragraphs with alignment, indents, spacing, and line breaks.

Apply character formatting in Microsoft Word by selecting fonts (such as Arial Black or Calibri), adjusting size, changing case, and applying bold, italic, underline, and color.

Learn to align text using tabs by setting tab stops in selected paragraphs, then using left, center, right, decimal, and bar tab stops with optional leaders.

Learn to display text as list items in Word using bullets, numbering, and multi-level lists, explore the bullet and numbering libraries, and customize symbols or pictures.

Master paragraph layout by aligning text left, center, right, or justified, and adjusting line spacing; sort text alphabetically and manage spacing before and after paragraphs.

Learn to apply borders and shading in Microsoft Office, using the borders tool for bottom, top, and outside borders, and shading from the paragraph and font tools.

Explore applying built-in styles to text and creating a custom style in Word. Build a blue bold italic underline style named 'Formatting Style' and apply it from the home tab.

Manage document formatting with the font tool in the Home ribbon, including font style, size, uppercase, lowercase, bold, italic, underline, strikethrough, subscript, superscript, text effects, highlight, and font color.

Learn to add tables in a document using the insert menu and table option, specify columns and rows (e.g., four by four), and use quick tables for built-in categories.

Learn to insert a table by using the insert tab or drawing one, specify rows and columns, and apply auto fit options and remember dimensions for future tables.

Learn to modify a table's style in Word by locating and editing the table style, then update the header row color from automatic to red via the table design options.

Learn to format a table in Word by inserting, resizing, and organizing cells; merge and split cells, delete or insert rows and columns, and apply borders, shading, and alignment.

Learn to convert text to a table in Microsoft Word by selecting text, using insert, converting text to table, and configuring columns, rows, Autofit, and separators like semicolons.

Learn how to insert graphical objects in Microsoft Word by using SmartArt and charts, selecting designs from categories like process and cycle, and applying them to your document.

Learn to insert symbols and special characters in a Word document by using the insert menu, symbols button, and symbol dialog box, with font options and shortcut key assignments.

Add images to a document using the insert menu and pictures, choosing from this device or online pictures, then apply picture styles and adjust alignment with the arrange feature.

Apply page color and borders in Word by using the design menu. Preview colors, select a color, then open borders and shading to choose a style and apply borders.

Learn to add and customize watermarks in Word using the design menu, choosing built-in or custom, and adjust text or picture watermark settings such as font size and layout.

discover how to add and edit headers and footers, insert page numbers, choose their positions, and apply designs across all pages.

Learn how to create and record macros in Microsoft Word to automate tasks and insert separators with a horizontal line. Discover assigning macros to keyboard shortcuts and macro security options.

Insert and position images in Word using the insert tab, choose from files or online pictures, and apply wrap text options to control text flow around the image.

Practice spelling and grammar with Word's proofing tools, using F7 and the spelling and grammar dialog, accept or ignore corrections, and explore word alternatives and word count for document accuracy.

Enable track changes and comments, view markup in balloons, compare original and revised versions, and accept or reject edits to finalize the document.

Learn to create personalized letters with mail merge in Word using an Excel recipient list. Build the letter from a template, insert placeholders, preview results, and print.

Learn how to use page setup in Microsoft Word to adjust margins, gutter, orientation, and page size, with previews and options for back-to-back printing.

Master Microsoft Word basics: navigate the home, insert, design, and layout ribbons, format text and paragraphs, insert tables, headers, footers, page numbers, explore styles, references, mailings, and view options.

Explore Microsoft Excel’s core tools for data entry, data management, accounting, financial analysis, and charting, including pivot tables and macros, plus basic functions and formatting.

Explore how to store, organize, and manipulate data in an electronic spreadsheet program with Excel, using 256 columns and 65,536 rows, plus search, sort, and filter features.

Open a new workbook or worksheet in Excel, choose blank or templates, and use OneDrive to upload, share, and access your files from anywhere.

Explore microsoft excel’s user interface, including the file and home ribbons, insert tools, and data functions, to build professional worksheets with formulas, charts, and pivot tables.

Save your workbook to the PC or OneDrive by signing in to your Microsoft account, then use Ctrl+S or Save As and choose formats like Excel workbook or PDF.

Explore Excel's logical functions, testing true or false across conditions to drive calculations and display results, including and, or, not, xor, switch, and practical examples.

Explore the if function in Excel, its true/false results, and practical uses, including the IFS function and nested IF, with step-by-step examples and grade calculations.

Learn to calculate letter grades in Excel using if and ifs functions, building a data set of scores and applying nested ifs to output grades A through F.

Explore how to use the filter function in Excel to filter data by criteria, including dates, regions, and items, and to sort by oldest to newest or by color.

Master date functions in Excel by using the date function to return a serial date, format outputs as short or long, and apply datedif, edate, and eomonth for calculations.

Use the now and today functions to display date and time on worksheet, updating when you open it. Learn to calculate intervals and ages with formulas like =now() and =today().

Explore how the time function yields a decimal between 0 and 0.999..., representing 12 a.m. to 11:59:59 p.m., and convert it to hours, minutes, and seconds using time related methods.

Explore essential Excel mathematical functions such as count, round, sum, average, subtotal, power, mod, trunc, int, min, and max with practical, data-driven examples.

Explore Excel text functions—Len and Len B, Mid, Rept, Split, text to columns, and trim—and learn to manage characters, substrings, and grid lines in worksheets.

Explore how to use Excel lookup functions, including index, vlookup, hlookup, xlookup, and match, to retrieve values from tables, explain array and reference forms, and handle exact and approximate matches.

Create and manage hyperlinks in Excel to web pages, documents, emails, or other sheets, using insert or Ctrl+K, and import HTML hyperlinks or web data.

Explore Google spreadsheet in your web browser, collaborate in real time, and detect language in data using the detect language function.

learn to convert numbers into words in excel using the currency to English function, enable the developer tab, paste vba code in a module, and save as a macro-enabled workbook.

Explore how to create drop down lists in Excel, including dynamic and dependent lists, using data validation, the name manager, and the indirect function to link countries and cities.

Compare graphs and charts, then learn to insert, customize, and format charts in Excel with column, bar, line, pie and other types.

Learn to create and use pivot tables to calculate, summarize, and analyze data, using regional and sales figures with filters, rows, and columns.

Learn to add, rename, color, delete, and hide worksheets, and to move or copy and group sheets within and across workbooks.

Learn to protect worksheet and workbook structures with passwords, and share an Excel workbook with multiple users via cloud, emails, or Google Sheets for seamless collaboration.

Explore how to set page size and orientation, add headers and footers, adjust margins, and define print areas in Excel for polished worksheets.

Learn how to print in Microsoft Excel, adjust page setup, margins, orientation, scaling, and print options, and print selection or entire workbook to fit data on one page.