Microsoft Office Mastery Learn Word Excel and PowerPoint

Explore the ms word interface, mastering text formatting, alignment, bullets and numbering, tables with merging and splitting cells, images, shapes, watermarks, page design, margins, page setup, and printing.

Explore the power of MS Word for professional document creation. Learn fonts, colors, shapes, templates, plus inserting tables, images, and charts, with collaboration features and saving or sharing options.

Master the Microsoft Word interface and workspace, learn to start blank documents with templates, manage pinned and recent files, and use autosave, save, open, and share features.

Explore MS Word text formatting in this lesson, mastering font size and style, bold, italics, underline, subscript, superscript, case changes, highlighting, colors, and text effects.

Learn how to align text in Microsoft Word with left, center, right, and justify options, adjust line spacing and indentation, and apply borders and shading.

Master bullets, numbering, and multi-level lists in MS Word by creating and formatting bullet styles, customizing numbering formats, and adjusting indentation.

Learn to create and manipulate tables in Microsoft Word, including inserting tables, drawing custom tables, using Excel spreadsheets inside Word, and applying table design, layout, borders, and shading.

Master merge and split techniques in tables within ms word, including inserting and deleting cells, rows, columns, and tables, plus auto fit, alignment, and sorting features.

Learn to insert and edit images in Word using stock images, online pictures, and built-in tools, including cropping, change picture, text wrap, alt text, and picture effects.

Master how to add a watermark in Word by using the design tab, choosing presets or creating a custom text or picture watermark, and removing it when needed.

Learn to insert and edit shapes in MS Word, using shape formats, fills, outlines, gradients, text boxes, WordArt, text direction, wrap options, and basic layout tools.

Learn to use Word's ruler and layout tools to set margins, page size, and orientation, adjust indents and tabs, apply columns, and manage grid lines for precise document formatting.

Learn pad design in MS Word by creating headers and footers, inserting tables and logos, applying watermarks and page numbers, and crafting a professional letterhead.

Master printing and page setup in Word by adjusting margins, orientation, and paper size, selecting pages, copies, and duplex options, and exporting to PDF.

Create a Word document, open the design tab, and apply a watermark by selecting image or text in the watermark menu. Save as CP1 and upload to the project panel.

In this class project, manipulate a shape in a Word document by creating a file, inserting and editing a shape, moving points, and saving to upload to the project panel.

Master Ms. Excel by organizing, formatting, and calculating data in a spreadsheet, exploring the workspace and interface, fonts, alignment, basic formulas, tables, images and shapes, and the sub if function.

Navigate the Excel workspace and interface, learn to create and save workbooks, manage sheets, cells, and ribbons, and use templates, search, and sharing features.

Explore font and alignment in Excel with practical steps for applying font styles, sizes, colors, and alignment; merge and center, borders, and wrap text.

Master basic Excel formulas to calculate totals, maximums, and minimums, discounts, using sum, max, min, and cell ranges; learn practical formula building, auto-fill, and tips.

Create a student result card in a new workbook, detailing serial numbers, names, and subjects. Apply sum, average, max, min, and large formulas to compute totals and top scores accurately.

Create a student result sheet in Excel using the if function to assign grades (A+, A, B+, B) from scores, format borders, center data, and save or print.

Master number formatting in Excel by applying general, numbers, currency, accounting, and date and time formats with custom options to present data clearly.

Learn to insert and customize tables in Excel, add headers and totals, apply table styles, sort and filter data, and manage multiple tables with table design.

Discover a data-entry trick in Excel using the form tool from the quick access toolbar to enter records into a table with headers (name, mobile number, address, country, designation) quickly.

Master Excel image and shape basics by inserting pictures from device, stock, or online sources, then edit with crop, color, borders, transparency, and shape formatting for clean visuals.

Learn to use the sumif function in Excel to total expenses by category, such as rent, salary, and food, and create tables with totals.

Create a visually appealing title box in an Excel worksheet by inserting shapes, adding text, and formatting with shape options to organize data and prepare for project submission.

Master the Sumif formula in Excel with a step-by-step class project, from creating a data table to applying the function and formatting results for project totals.