Learn MS-Office from scratch - Office 365

Explore the Microsoft Word overview: templates, blank documents, autosave with cloud storage, ribbons, formatting, insert and design features, references, mail merge, review, view modes, and equation tools.

Learn to edit a Word document using the Home tab: create a new file, dictate or type, format headings and fonts, apply alignment, and use the paintbrush to copy formatting.

Explore the Word home tab features, including font size, text case, highlighting, colors, bullets, numbering, outline, and paste options. Also covers borders, tables, spacing, ruler, and editor tools.

Explore the Word insert tab, inserting cover pages, blank pages, and page breaks, then design and format tables with borders, shading, and layout options.

Insert and format images in Word using file, stock, and online pictures; manage copyright with Creative Commons; adjust crop, borders, transparency, wrap text, alt text, and shapes for polished documents.

Demonstrates advanced insert options in Word, from stock icons and 3D models to smart art and charts, screenshots, screen clipping, media, add-ins, and hyperlinking for digital sharing.

Explore the insert tab to create bookmarks, cross referencing, and links; add comments; design headers and footers, page numbers, and wrap text for images.

Explore the draw and design tabs in Word: write freehand with mouse or trackpad, use a pen tablet, and apply themes, fonts, spacing, watermark, and page border.

Master the layout tab to adjust margins, orientation, size, columns, breaks, and line numbers, then use the references tab to build a table of contents and manage headings and citations.

Explore the review tools in Word, including editor, spelling and grammar, read aloud, accessibility checks, translate, comments, and track changes.

Explore how to view Word documents using print layout, web layout, outline, draft, focus, and immersive reader, then master navigation, zoom, split, arrange, and macros.

Explore the basics of Excel by opening a blank workbook, using templates, creating tables and charts, applying formulas and filters, managing the print area, grid lines, and the formula bar.

Learn to enter data in a simple Excel table, auto-fill rows, format cells for leading zeros, adjust alignment, wrap text, apply borders and shading, and customize fonts.

Learn to merge cells, format data, and perform calculations in Excel using sum and average, along with copy-paste, formulas, and decimal precision for student marks.

Learn to print and export a table from Excel to Word using print options, orientation, scale to fit, print area, and PDF export.

Learn to filter data in Excel to view the records you need and use dropdowns. Master freezing panes to keep headers visible while scrolling and sort data ascending or descending.

Explore creating and customizing charts in Excel, including histogram, pie, line, scatter, and more; learn data preparation, chart design, axis titles, data labels, legends, and trend forecasting.

Create PowerPoint presentations from slides or templates, add slides, and insert text and images. Explore designer themes, transitions, animations, and presenter view to export your presentation as a video file.

Create compelling title slides for a PowerPoint presentation using designer ideas, themes, and formatting options. Customize text, backgrounds, fonts, and images (Creative Commons) to enhance clarity and impact.

Learn how to insert images and objects in PowerPoint, remove backgrounds, adjust brightness and transparency, crop and style images with quick styles, and embed Excel, Word content, video, and more.

Learn to design dynamic PowerPoint presentations with full-screen slides, apply transitions and animations, and control timing—from on-click to with previous and after previous across all slides.

Learn to prepare and deliver PowerPoint presentations with presenter view, notes, laser pointer, and pen tools, then record and export the slides as mp4 video.

Learn to write and format complex equations in Word with the built-in equation writer and MathType, insert symbols and Greek letters, and manage fractions, integrals, and matrices.

Learn to perform mail merge in Word by linking an Excel data source, inserting merge fields like name and amount, preview results, and print or generate personalized PDFs for recipients.

Learn how to manage references in Word with built-in citations and bibliographies, from Google Scholar to EndNote and Mendeley, in MLA, APA, Chicago, Harvard, and Vancouver.