MS Office With Canva Word Excel PowerPoint Canva All in One

Master Word, Excel, PowerPoint, and Canva to create professional content. Explore Word basics, Excel dashboards, PowerPoint design, and Canva graphics.

Navigate the Word interface, including ribbons, toolbars, status bar, and quick access toolbar, to access formatting, image insertion, and view options like print layout and zoom.

Master creating new Word documents, opening existing files, and saving work with meaningful names, templates, and save-as options across desktop, OneDrive, and recent documents.

Learn typing basics in Word, including entering text, word wrap behavior, and using the spacebar and enter key for new lines and paragraphs, with undo and redo editing.

Learn to copy, cut, and paste text in Word to move and duplicate content efficiently. Use the clipboard and keyboard shortcuts like Ctrl+C, Ctrl+X, and Ctrl+V, plus paste options.

Master text selection in Word using click-and-drag, double-click, triple-click, and shift-plus-arrow shortcuts, then automate edits with find and replace to update terms across long documents.

Learn to apply font style, size, color, and effects in Word using Calibri or Times New Roman to produce professional, visually appealing documents with appropriate headings.

Master paragraph formatting in Word, including left, center, right, and justify alignments; adjust line and paragraph spacing; and apply first-line, hanging, or left/right indentation to create professional, readable documents.

Master bullets and numbering in Word to structure content, choosing unordered lists or ordered steps, and customize formats, indentation, and symbols for clear, professional documents.

Master multi-level lists in Microsoft Word to structure headings, subpoints, and numbered or bulleted levels, using the Home tab and multilevel list options to customize numbering and styles.

Master borders around text, paragraphs, and pages and shading fills to emphasize content, customize styles for thickness and color, and combine borders and shading for a polished, professional document.

Master Word page setup by adjusting margins, orientation, and paper size to print professionally and look polished, using the layout tab to apply options like letter or A4.

Explore how headers and footers frame your Word documents, adding names, subjects, page numbers, dates, and logos; customize fonts, insert fields, and apply first-page options.

Learn to add, customize, and manage page numbers in Word, choosing top or bottom placement, formats like roman numerals, and restarting numbering with section breaks.

Insert tables in Word using the insert tab and grid to choose rows and columns, then use table options to resize, format, and add headers to weekly schedules or charts.

Format Word tables with built-in styles from the table design tab. Apply borders, adjust alignment, insert columns, merge or split cells, and use auto fit.

Learn to enhance Word documents by inserting images, using shapes, and creating SmartArt diagrams to produce visually engaging, professional layouts.

Master inserting, formatting, and customizing text boxes in Word to position text anywhere, create highlights, and design professional layouts with wrap, fill colors, borders, and shadows.

Apply and modify Word styles to ensure consistent formatting and professional-looking documents, then use heading styles to quickly update appearance and auto-generate tables of contents.

Apply themes in Word to instantly transform your documents with consistent fonts, colors, and effects, creating a polished, professional design for business reports, proposals, or academics.

Explore Word templates to save time, stay consistent, and create professional documents with predesigned layouts. Learn to choose, customize, and save templates for resumes, letters, and invoices.

Master sections breaks and columns in word to divide documents into parts with distinct formatting, create portrait and landscape layouts, multi-column text, headers and footers, and professional newsletters or brochures.

Enable track changes in Word to record every edit, colorfully highlight modifications, and display originals beside replacements, then review, accept or reject edits, and collaborate in one document.

Add comments in Word to annotate text, provide feedback, and leave reminders without altering the main content. View, reply, and resolve comments to support collaborative revisions.

Master mail merge in Microsoft Word to create personalized letters, emails, or labels by connecting to a data source, inserting merge fields, and generating personalized outputs.

Create a complete formatted Word report from start to finish, including a title page, A4 portrait layout, margins, headers and footers, and an automatically updating table of contents.

Explore the Excel interface by learning how workbooks contain worksheets made of cells, identified by column letters and row numbers, with data entered as numbers, text, or formulas.

Enter and edit data in Excel by typing text and numbers, moving between cells with enter or tab. Learn to correct mistakes via cell edits or the formula bars.

Master fonts, alignment, borders, and colors in Excel to make sales spreadsheets readable, balanced, and professional. Learn to apply wrap text, header emphasis, and color highlights for clear data presentation.

Master currency, percentage, and date formatting in Excel to transform raw numbers into readable, meaningful data, enhancing financial reports, timelines, and records.

Master Excel basics by practicing addition, subtraction, multiplication, and division using plus signs, minus signs, asterisks, and forward slash to calculate totals, costs, and per-day rates.

Explore how the Excel formula bar displays cell content, enables entering or editing text, numbers, and formulas, and helps review and adjust complex calculations efficiently.

Master the Excel sum function to add numbers across a range or multiple ranges, producing quick totals with straightforward syntax.

Discover how to use Excel's average function to compute the mean of a range with a formula, ignoring empty cells, while zeros are counted, for finance, sales, and reporting.

Learn how to use Excel min and max functions to identify the smallest and largest values in a data set, with practical sales, grades, and hours examples.

Explore the Excel count function to quickly count numerical cells across single or multiple ranges, ignoring blanks. Compare with count A; count only numbers for efficient data analysis.

Explore how Excel uses relative references by default and how absolute references lock values. Master mixed references to lock either rows or columns for accurate calculations on many data sets.

Learn to sort data in Excel by name, sales, and region—alphabetically, largest to smallest, and by region then sales to group east, west, north, and south.

Learn to filter data in Excel to narrow large datasets by criteria, view only matching records, and apply numeric or multiple conditions to extract insights for reports and dashboards.

Learn to boost data power and manageability by using Excel tables and named ranges, enabling automatic formatting, dynamic references, and easier formulas that expand with data.

Learn how Excel conditional formatting automatically highlights cells that meet rules, revealing trends, errors, and key values. Use highlight cells rules for greater than, less than, between, and duplicates.

Learn to create and customize column, bar, and pie charts in Excel using sales data. Insert charts, resize visuals, and apply titles, labels, legends, and styles to highlight category comparisons.

Format charts in Excel to communicate insights clearly by adjusting colors, adding labels, and customizing titles and axes. Create a professional column chart with axis labels and data labels.

Learn how vlookup performs vertical lookups to fetch first-column data. Syntax: lookup value, table array, column index, and range lookup (false for exact, true for approximate) with absolute references.

Learn how to perform a horizontal lookup in Excel with the HLOOKUP function, searching the top row and returning values from a specified row below using exact or approximate matches.

Master the Excel if function to perform logical tests and return true or false values, enabling automated pass/fail decisions from scores such as 60.

Learn how to use Excel data validation with drop-down lists to control data entry, reduce errors, and manage departments and statuses with named ranges.

Learn to protect worksheets and workbooks in Excel by locking specific cells, applying sheet protection and workbook structure, and setting passwords to safeguard formulas and monthly sales data.

Create, format, and use pivot tables in Excel to quickly summarize, analyze, and explore large data sets, turning raw data into actionable insights.

Excel pivot charts link to pivot tables to visualize data, update automatically with filters, and enable interactive dashboards with slicers for quick visual analysis.

Create a dynamic report dashboard through an Excel project, showcasing hands-on skills in building comprehensive reports.

Explore the PowerPoint interface, including slides, ribbons, pens, and the slide workspace, to navigate efficiently and create impactful presentations with charts, images, and notes.

Create new PowerPoint presentations from blank slides or templates, add slides and title slides. Save frequently using Save As or OneDrive, and open existing presentations when needed.

Explore PowerPoint slide layouts and templates to save time and maintain a professional, consistent look across presentations, using built-in placeholders, title slides, and custom templates.

Add slides in PowerPoint using the new slide button and select layouts such as title, title and content, or blank. Use Ctrl+M or Cmd+M for fast inserts.

Learn to delete slides in PowerPoint by selecting slide thumbnails on the left and pressing the delete key, or right-clicking and choosing delete slide, and undo with Ctrl plus G.

Rearrange slides in PowerPoint with ease by dragging in normal view or slide sorter view, improving flow and audience engagement through quick reordering of key points.

Format text in PowerPoint by adjusting font styles, colors, and sizes to create clear, professional, and engaging slides, while maintaining consistency and readability.

Format shapes, images, and icons in PowerPoint to create engaging slides. Use fills, outlines, and effects from the shape format tab, and customize images and icons to strengthen visual storytelling.

Learn to use PowerPoint SmartArt to transform plain text into engaging diagrams, including processes, cycles, and relationships, and customize layouts, colors, and steps like research, planning, development, and launch.

Learn to insert and format tables in PowerPoint slides, adjust rows and columns, customize style with table design and layout tabs, and present data clearly.

Insert and customize charts in PowerPoint slides by using the insert tab, charts button, and Excel data sheet; adjust chart types, styles, and data labels to visualize sales data clearly.

Learn to add audio to PowerPoint presentations by inserting audio files or recording narrations, and customize playback with start options, across slides, or looping for engaging, self-running presentations.

Explore PowerPoint slide transitions to move between slides with animated effects like fade and morph. Apply transitions to all slides and set timing.

Master PowerPoint text animations to bring slides to life with entrance, emphasis, exit, and motion graphics. Apply and fine-tune them using the animations tab, effect options, and timing.

PowerPoint animations turn static slides into dynamic experiences by applying entrance emphasis exit and motion effects to text shapes images and charts, with animation pans controlling timing.

Master slides in PowerPoint let you apply global design across all slides, controlling fonts, colors, backgrounds, and logos for consistent, branded templates and presentations.

PowerPoint templates provide predesigned slide layouts for professional, consistent presentations. Browse and apply templates, use slide masters, replace placeholders, and tailor fonts, colors, and logos.

Learn to add hyperlinks in PowerPoint by linking text, images, or logos to websites, other slides, files, or email addresses, and navigate between slides using place in this document.

Learn to add action buttons in PowerPoint to create interactive, nonlinear presentations by linking clickable shapes or icons to slides, files, or media, and building quizzes and navigational guides.

Learn to share PowerPoint presentations via email or OneDrive, set permissions, and export as PDFs, XPS, or video for collaborators, clients, or class presentations.

Review PowerPoint presentations using the review tab and add comments for feedback and suggestions to enable collaboration without altering slides.

Create a professional PowerPoint presentation from scratch by defining purpose and audience, designing a clear slide structure with visuals, charts, and concise bullet points, and exporting polished pdfs or slides.

Navigate the Canva dashboard, explore templates, and add elements to quickly create professional designs with customizable text, colors, and images.

Create a Canva account via Google, Facebook, Apple ID, or email, access the dashboard, and start your first design on a blank canvas.

Explore Canva templates versus blank designs to balance speed, structure, and brand customization. Learn when to use templates for quick, polished results and when to start from scratch for originality, with a hybrid approach often delivering the best of both worlds.

Import Microsoft Word content into Canva to quickly convert text and headings into slides. Transform headings into main slide titles and body text into paragraphs, then customize fonts and colors.

Import Excel data into Canva to create dynamic tables and charts, including bar, line, and pie charts, with automatic updates for presentations.

Import PowerPoint slides into Canva by uploading your PowerPoint file. Canva converts them to editable slides with preserved fonts and images, enabling brand color changes and animations across all slides.

Master Canva text formatting by selecting fonts, adjusting sizes, and applying colors to create readable, visually appealing designs for business presentations and Instagram posts.

Explore Canva's elements—shapes, icons, and illustrations—to add structure, color, and personality to social media posts, presentations, and website mockups, using layers, transparency, and color customization.

Upload your own images, crop to fit your designs, and apply filters to create polished visuals that align with your Canva designs.

Learn to create professional charts and graphs in Canva using data from Excel, including bar and pie charts with instant updates, brand kit customization, and visuals for reports and presentations.

Learn to add videos and audio clips to Canva designs, using uploads or Canva Stocks, drag-and-drop into frames, and adjust trim, fade, balance, and tones for dynamic, promotional results.

Harness Canva for professional presentations by using templates, drag-and-drop assets, and customize slides with text, images, and charts. Reorder slides and export as pdf or powerpoint or share easily.

Explore Canva animations and transitions to make slides engaging and professional by animating text, shapes, and icons, applying fades and staggered reveals, and using smooth slide transitions.

Turn your Word and Excel content into stunning posters and flyers with Canva. Design eye-catching visuals using Canva templates, charts, bold headings, and space for dates and locations.

collaborate in canva by sharing designs via links or email, enable real-time team editing, manage permissions, and organize work with team folders and version history.

Learn to export Canva designs as PDF, PNG, JPEG, or PPTX, choosing the right format for online sharing, printing, and PowerPoint presentations, including transparent backgrounds.

Learn to create professional Canva presentations by integrating Word text, Excel charts, and multimedia elements, using templates, charts as images, and animations and transitions for engaging slides.