Complete Microsoft Word Excel PowerPoint Course

Discover basics of Microsoft Word as a word processing program for creating documents and using tools like spell check and word count, and learn its planning, organizing, leading, and controlling.

Explore the Microsoft Word interface and core tools, including the file and home tabs, templates, recent and pinned documents, cloud access via OneDrive, and essential save, print, and export options.

Learn to navigate in Microsoft Word and select text using the scroll bar, arrow keys, End, and Page Down, then master drag-to-select and Ctrl+A.

Learn the basics of modifying text in Microsoft Word, including copy, cut, paste, undo, redo, and format painter, using keyboard shortcuts and paste options.

Master finding and replacing text in Microsoft Word using the home tab and both keyboard and mouse methods, with find and replace, advanced find, and replace all (Ctrl+F).

Learn to format text and paragraphs in Microsoft Word by changing font, size, color, highlight, and case, and apply bold, italic, underline, subscript, and superscript.

Explore the additional font and paragraph tools in Microsoft Word, including clear formatting, text effects, superscript and subscript, underline styles, alignment, spacing, borders, and bullets.

Align text efficiently in Word using tabs and the ruler by choosing left, center, right, and decimal tab stops to line up headers like name, roll, and class.

Learn how to convert text into bulleted or numbered lists in Microsoft Word, apply bullets, numbering, and multilevel lists, and customize list formats and levels.

Add and modify tables in Word using insert table, draw table, convert text to table, and apply borders, shading, and layout options.

Learn to insert and customize graphic objects in Word, including pictures, stock and online images, shapes, icons, smart art, charts, screenshots, and 3D models with formatting options.

Explore advanced insert tools in Word, including add-ins, media links, header and footer, text boxes, quick parts, auto text, word art, drop caps, equations, and symbols.

Explore themes in Word by applying design tab styles, customizing colors, fonts, and paragraph spacing, and adding watermarks, page color, and borders to enhance documents.

Discover what Microsoft Excel is, its interface, and how to start organizing data, using tools like sorting and pivot tables for business, education, and daily life.

Save your data in Microsoft Excel using the save icon or Ctrl+S, then save as to store on PC or OneDrive and select formats like PDF or XPS.

Learn to use Excel's logical functions, including and, or, not, and switch, to evaluate true or false results with cell references and logical tests.

Learn to use the if and ifs functions in Excel to perform logical tests, return true or false results, and apply across data with the fill handle.

Master the date and now functions in Excel to display current date and time and to extract day, month, and year. Learn date formatting and custom formats.

Build on date function from the previous lesson by using the time function to add hours, minutes, and seconds in a formula, then use the fill header to extend results.

Learn to convert numbers into words in Excel with the currency to English function, turning numbers like 3435 into words, and explore version differences and macros.

Master page settings in the page layout of Excel, adjusting margins, orientation, size, print area, breaks, background, print tiles, grid lines, and scale to fit for clean, print-ready spreadsheets.

Master printing in Excel by configuring page setup, previewing layouts, and using print selection to print specific data ranges, margins, orientation, headers, footers, and methods to print.

Protect your worksheet and workbook by setting passwords, restricting edits, protecting sheet and workbook structure, and renaming or coloring sheets.

Learn how to share and collaborate in Excel by staying connected to your Microsoft account and internet, saving work to the cloud, and assigning editors or viewers for real-time teamwork.

Master the basics of Microsoft PowerPoint, a powerful slideshow program, creating presentations from scratch or templates with text, images, and videos, and collaborating in real time.

Learn to create and organize slides in PowerPoint: add new slides, choose from nine layouts, insert tables and images, and manage sections with collapse, reset, and renaming.

Explore font tools in Word and PowerPoint: select text, change font type and size, adjust case and spacing, apply colors, and clear formatting using shortcuts.

Learn to use the drawing section in PowerPoint, creating blank slides, adding and deleting slides, and inserting text boxes, then shape, align, group, color, and apply effects.

Learn to insert tables and images in PowerPoint using insert table and draw table options, Excel spreadsheet features, and stock or online pictures.

Explore how to use the illustration tools in PowerPoint: add and format shapes, insert icons and 3D models, create smart art, and build charts with Excel data.

Explore add-ins for PowerPoint and learn how to download them from the store or via my add-ins. Apply graphics, emoji keyboards, draw io, or Wikipedia add-ins to enhance your presentation.

Learn to add zooms and hyperlinks in slides, including summary zoom and section zoom, and configure on-click or mouse-over actions, run macros, play sounds, and use comments.

Explore the design tab in PowerPoint to apply themes and variants, customize slide size and background, and format backgrounds with solid fills, pictures, or textures.

Explore how to apply transitions and animations in slides, preview effects, control timing and sound, and use morph features to create dynamic, interactive presentations.