Tutorials
Every published guide, searchable and filterable.
168 tutorials
Excel 97 tutorials
Browse by topic →Excel
Excel Basics: Workbooks, Cells and Ranges
Learn what workbooks, worksheets, cells and ranges are, then select, enter, edit and save data with confidence.
Beginner10 min readExcel
Excel Navigation and Keyboard Shortcuts
Jump to the edges of your data, select whole columns of numbers, insert totals and run everyday commands from the keyboard.
Beginner10 min readExcel
Paste Special in Excel: Paste Values, Transpose and More
Paste only the part of a copy you need: values instead of formulas, formats, a transposed copy, or a calculation applied to a whole range.
Beginner10 min readExcel
How to Use AutoFill and the Fill Handle in Excel
Fill days, months, numbers, dates and numbered labels by dragging the fill handle, and control the result with Auto Fill Options and the Series dialog.
Beginner9 min readExcel
How to Save, AutoSave and Undo in Excel
Save a workbook, let AutoSave keep cloud files up to date, undo and redo mistakes, and get back work after Excel closes unexpectedly.
Beginner9 min readExcel
How to Freeze Panes in Excel
Keep headings and labels on screen while you scroll: freeze the top row, the first column, or any rows and columns, and unfreeze them again.
Beginner8 min readExcel
Quick Totals from the Excel Status Bar
Get the sum, average, count, minimum and maximum of any selection from the status bar, without writing a formula, and copy the result in one click.
Beginner7 min readExcel
Customize the Ribbon and Quick Access Toolbar in Excel
Put the commands you use most one click away: add them to the Quick Access Toolbar, build your own ribbon tab, show the Developer tab and reset everything.
Beginner8 min readExcel
Zoom, Split and New Window: Viewing Large Sheets in Excel
See more of a big sheet, or two parts of it at once: zoom in and out, zoom to a selection, split the window, and open a second window side by side.
Beginner9 min readExcel
How to Hide and Unhide Rows, Columns and Sheets in Excel
Hide rows, columns and sheets you don't need to see, bring them back, and know how hidden cells affect formulas, copying and charts.
Beginner8 min readExcel
How to Use and Create Excel Templates
Start a workbook from a ready-made Excel template, save your own workbook as an .xltx template, and reuse it every month without overwriting the original.
Beginner9 min readExcel
How to Format Cells in Excel
Make a plain table easy to read with bold headings, fill colors, borders, alignment, wrapped text and the right column widths.
Beginner10 min readExcel
Number and Date Formats in Excel
Show prices as currency, discounts as percentages and dates as real dates, and control decimal places without changing the stored values.
Beginner9 min readExcel
How to Use Conditional Formatting in Excel
Color cells automatically by rule: flag values over a limit, catch duplicates, highlight top values, add data bars and write your own formula rules.
Intermediate13 min readExcel
How to Use Format Painter in Excel
Copy the look of one cell to other cells with Format Painter: number formats, fonts, fills, borders and highlight rules, once or many times.
Beginner8 min readExcel
Merge & Center and Wrap Text in Excel
Center a title over a table, fit long text inside a cell with Wrap Text and line breaks, and avoid the problems merged cells cause.
Beginner9 min readExcel
Cell Styles and Themes in Excel
Format cells with named cell styles you can change in one place, create your own styles, and switch a workbook's colors and fonts with a theme.
Intermediate10 min readExcel
Checkboxes and Pictures in Cells in Excel
Add tick boxes that count themselves, strike through finished tasks, and place pictures inside cells so they sort and filter with their rows.
Beginner10 min readExcel
How to Write Basic Formulas in Excel
Add, subtract, multiply and divide with formulas that use cell references, so your results update by themselves when the numbers change.
Beginner10 min readExcel
Essential Excel Functions: SUM, AVERAGE, COUNT, MIN and MAX
Summarize any column of numbers with five functions: total it, average it, count it and find its lowest and highest values.
Beginner10 min readExcel
Copying Formulas and Cell References in Excel
Write a formula once and copy it down a whole column with the fill handle, and understand how Excel adjusts each copy's cell references.
Beginner9 min readExcel
How to Write IF Statements in Excel
Turn a comparison into a clear answer with IF, then count and total the rows that meet a condition with COUNTIF and SUMIF.
Beginner11 min readExcel
Relative, Absolute and Mixed References in Excel
Control what changes when you copy a formula: keep row references moving, lock a shared rate with $, and build a grid with mixed references.
Intermediate12 min readExcel
Logic Formulas in Excel: IF with AND, OR and IFS
Turn business rules into formulas: sort values into tiers with IFS, test several conditions with AND and OR, and catch errors with IFERROR.
Intermediate13 min readExcel
Lookup Formulas in Excel: XLOOKUP, VLOOKUP and INDEX/MATCH
Pull a price or category from a reference table with XLOOKUP, read and write VLOOKUP and INDEX/MATCH, and handle values that aren't in the list.
Intermediate14 min readExcel
Text and Date Functions in Excel
Clean up names with TRIM, pull parts out of codes, join values into labels, and count the working days left before a deadline.
Intermediate14 min readExcel
Dynamic Array Formulas in Excel: FILTER, SORT and UNIQUE
Write one formula that spills a whole list: unique values, sorted results, filtered rows, numbered sequences and top-N lists that update with the data.
Advanced14 min readExcel
Cleaner Formulas with LET in Excel
Name the pieces of a long formula with LET so each is calculated once, the formula reads like a sentence, and errors are caught on purpose with IFNA.
Advanced12 min readExcel
Advanced Lookups in Excel: Multiple Criteria and Approximate Match
Look up a value that depends on two columns, read a row-and-column grid, and place numbers into tiers with approximate match.
Advanced16 min readExcel
Reusable Formulas with LAMBDA and Dynamic Arrays
Write a rule once as a named LAMBDA, apply it to a whole column with MAP, fold values with SCAN and REDUCE, and test it before you rely on it.
Expert17 min readExcel
How to Use Named Ranges in Excel
Give cells and ranges names like Sales or BonusRate, use them in formulas, and edit, fix or delete them in Name Manager.
Intermediate11 min readExcel
How to Use the SUM Function in Excel
Add up a column, a row or scattered cells with SUM, and get a total in one keystroke with AutoSum.
Beginner11 min readExcel
How to Use the AVERAGE Function in Excel
Find the average of a column, a row or several ranges with AVERAGE, and know how it treats blank cells, zeros and text.
Beginner12 min readExcel
COUNT and COUNTA in Excel: Count Numbers and Non-Blank Cells
Count the cells that hold numbers with COUNT, count every filled cell with COUNTA, and know which one to use.
Beginner12 min readExcel
How to Use MIN and MAX in Excel
Find the smallest and largest numbers in a range with MIN and MAX, within a group with MINIFS and MAXIFS, and use them to cap a value.
Beginner13 min readExcel
How to Use the IF Function in Excel
Make a formula return one result when a condition is true and another when it's false, with text, numbers or calculations.
Beginner13 min readExcel
How to Use SUMIF and SUMIFS in Excel
Add up only the numbers that meet a condition with SUMIF, or several conditions at once with SUMIFS.
Intermediate14 min readExcel
How to Use COUNTIF and COUNTIFS in Excel
Count the cells that meet a condition with COUNTIF, or several conditions at once with COUNTIFS, using operators, cell references and wildcards.
Intermediate14 min readExcel
How to Use VLOOKUP in Excel
Look up a value in a table and return a matching value from the same row with VLOOKUP, and fix the #N/A and #REF! errors it can return.
Intermediate15 min readExcel
How to Use XLOOKUP in Excel
Find a value in one column and return the matching value from another with XLOOKUP, including a fallback for missing values, nearest matches and wildcards.
Intermediate15 min readExcel
How to Use IFERROR in Excel
Replace error values such as #DIV/0! and #N/A with a value or message of your own using IFERROR and IFNA, without hiding real mistakes.
Intermediate14 min readExcel
How to Use INDEX and MATCH in Excel
Combine INDEX and MATCH to look up a value in any column, including one to the left, and to find the value where a row and a column meet.
Intermediate13 min readExcel
How to Use AND and OR in Excel
Test several conditions at once with AND and OR, reverse a test with NOT, and use them inside IF to label, flag and calculate rows.
Beginner12 min readExcel
How to Use the IFS Function in Excel
Sort values into grades, tiers and price bands with IFS instead of nested IFs, and know when SWITCH or a lookup table is the better choice.
Intermediate13 min readExcel
How to Use AVERAGEIF and AVERAGEIFS in Excel
Average only the numbers that meet a condition with AVERAGEIF, or several conditions at once with AVERAGEIFS, including date ranges and wildcards.
Intermediate12 min readExcel
How to Round Numbers in Excel: ROUND, ROUNDUP and ROUNDDOWN
Round prices to the cent, sales to the nearest thousand and box counts up to whole numbers with ROUND, ROUNDUP and ROUNDDOWN.
Beginner11 min readExcel
How to Use TODAY and NOW in Excel
Use TODAY and NOW to count days to a deadline, flag overdue items, work out ages and years of service, and enter dates that don't change.
Beginner11 min readExcel
How to Use the TEXT Function in Excel
Use TEXT to format numbers, percentages and dates inside a formula, so they read properly when you join them into labels and sentences.
Intermediate11 min readExcel
How to Join Text in Excel: CONCAT, TEXTJOIN and &
Combine names, codes and lists into one cell with the & operator, CONCAT and TEXTJOIN, with spaces, separators, line breaks and number formats where you want them.
Beginner11 min readExcel
How to Use LEFT, RIGHT and MID in Excel
Pull characters from the start, end or middle of a code, ID or email address with LEFT, RIGHT and MID, and handle parts of varying length with FIND and LEN.
Beginner11 min readExcel
How to Use the TRIM Function in Excel
Remove the extra spaces that break lookups and counts with TRIM, and clean up non-breaking spaces and line breaks from web and exported data.
Beginner10 min readExcel
How to Sort and Filter Data in Excel
Put a list in order by one or more columns, and show only the rows you need with text and number filters.
Beginner9 min readExcel
How to Use Excel Tables
Turn a plain range into an Excel table with Ctrl+T, then let it filter, band, total and extend formulas to new rows for you.
Beginner9 min readExcel
How to Clean Up Data in Excel
Fix a messy list: trim stray spaces, swap values with Find and Replace, split names into columns, remove duplicate rows and find blank cells.
Beginner12 min readExcel
Turn Messy Data into a Clean Excel Table
Get a range table-ready, convert it to a named Excel Table, add a calculated column and switch on a Total Row.
Intermediate12 min readExcel
How to Use Data Validation in Excel
Add drop-down lists, number and date rules, input messages and error alerts, then protect formula cells so only the inputs can change.
Intermediate13 min readExcel
Importing and Cleaning Data in Excel
Import a CSV file without losing data, check that numbers are really numbers, then split, fill, standardize and de-duplicate an export.
Intermediate13 min readExcel
How to Use Flash Fill in Excel
Split, combine and reformat text by typing one example and letting Flash Fill complete the column, and know when a formula is the better choice.
Beginner9 min readExcel
How to Use Find and Replace in Excel
Find any value on a sheet or in a whole workbook, change every copy of it at once, and use options and wildcards so you replace only what you mean to.
Beginner9 min readExcel
How to Use Go To Special in Excel
Select every blank, formula, constant, error or visible cell in a range in one step, then fill, check, fix or copy them all at once.
Intermediate10 min readExcel
How to Use Advanced Filter in Excel
Filter a list with conditions typed in cells, combine AND and OR across columns, copy the matching rows elsewhere and pull out a unique list.
Intermediate10 min readExcel
How to Remove Duplicates in Excel
Delete repeated rows from a list with Remove Duplicates, choose which columns decide what counts as a duplicate, and check for duplicates before you delete.
Beginner8 min readExcel
How to Split Data with Text to Columns in Excel
Split one column into several at a comma, a dash or a fixed position, keep leading zeros, and turn text dates into real dates with Text to Columns.
Beginner9 min readExcel
Group, Outline and Subtotal in Excel
Add a total under each group of a sorted list with Subtotal, collapse rows and columns with an outline, and group detail rows or columns yourself.
Intermediate10 min readExcel
How to Consolidate Data from Several Sheets in Excel
Combine lists from several sheets or workbooks into one summary with the Consolidate command, matching rows by their labels or by position.
Intermediate10 min readExcel
How to Create a Chart in Excel
Turn a column of numbers into a column, line or pie chart, add a clear title and axis titles, and pick the right chart for your question.
Beginner9 min readExcel
PivotCharts, Slicers and Simple Dashboards in Excel
Turn a PivotTable into a PivotChart, add slicers and a timeline anyone can click to filter, and arrange them into a clean one-page dashboard.
Intermediate13 min readExcel
Designing an Excel Dashboard
Plan a dashboard around one audience and one decision, pick three to five KPIs, match each chart to its question and remove everything that doesn't help.
Advanced13 min readExcel
Building Interactive Dashboards in Excel
Build one dashboard with an executive view and an analyst view, clear controls, exceptions first, drill paths and a clean print layout.
Expert14 min readExcel
How to Add Sparklines in Excel
Draw a tiny line, column or win/loss chart inside a cell next to each row of numbers, mark the high and low points, and compare rows on the same scale.
Beginner8 min readExcel
How to Use the Quick Analysis Tool in Excel
Select some data and press Ctrl+Q to preview and add conditional formatting, a chart, totals, a table or sparklines in one or two clicks.
Beginner8 min readExcel
How to Create a PivotTable in Excel
Summarize a list by category, month or region in a few clicks with a PivotTable, then change the calculation, format the numbers and refresh it.
Intermediate13 min readExcel
Advanced PivotTables in Excel
Group dates into quarters, show values as a percent of the total, add calculated fields, filter to the top N and keep a PivotTable's cache up to date.
Advanced13 min readExcel
Power Query Basics: Combine and Clean Data in Excel
Import a folder of monthly files with Power Query, clean them with applied steps, and refresh the result whenever a new file arrives.
Advanced15 min readExcel
Excel Data Model and Power Pivot Basics
Relate a sales table to a product table in the Data Model, build one PivotTable from both, and write your first DAX measures.
Advanced14 min readExcel
Power Query Engineering: Parameters, Staging and Refresh
Build a folder import that survives change: a path parameter, a custom function, a connection-only staging query, a Rejected Rows table and checks you run after every refresh.
Expert18 min readExcel
Data Modeling and DAX Measures in Excel
Design a star schema in the Data Model, keep measures in their own table, and write DAX with CALCULATE, DIVIDE and SAMEPERIODLASTYEAR.
Expert17 min readExcel
What-If Analysis in Excel: Goal Seek, Scenarios and Data Tables
Work backward from a target with Goal Seek, save best and worst cases with Scenario Manager, and compare many inputs at once with data tables.
Advanced15 min readExcel
Solver, Forecasting and Statistics Tools in Excel
Find the best product mix with Solver, test how sensitive it is, project a time series with Forecast Sheet and handle outliers in a trend honestly.
Expert18 min readExcel
Ask Questions About Your Data: Analyze Data and Copilot in Excel
Get your data ready, ask Analyze Data or Copilot questions in plain language, and check every answer with a formula before you rely on it.
Beginner11 min readExcel
Organize and Protect an Excel Workbook
Give each sheet a clear job, freeze headers, name ranges, add notes and comments, and protect formulas while inputs stay editable.
Intermediate12 min readExcel
Productivity and Formula Auditing in Excel
Select blanks and formulas in one step, paste values and formats, copy styles, and trace and evaluate formulas to find out why a number is wrong.
Intermediate13 min readExcel
Workbook Architecture: Structuring Excel Models
Split a workbook into input, data, calculation and output sheets, name your assumption cells and document it so someone else can run it.
Advanced11 min readExcel
Error Checking and Controls in Excel
Trace and evaluate suspicious formulas, add reconciliation checks and an error summary, handle filtered rows correctly and protect a report before you send it.
Advanced14 min readExcel
Making Excel Workbooks Faster and Easier to Maintain
Find what makes a workbook slow, replace volatile functions and oversized ranges, use manual calculation safely and leave notes so the next person can maintain it.
Advanced13 min readExcel
Planning an Excel Solution: Requirements and Design
Turn a vague request into a design brief: the decision, the refresh cadence, a workbook map, an assumptions register, an owner and testable acceptance criteria.
Expert13 min readExcel
Testing Excel Models and Keeping Audit Trails
Add a QA sheet that proves no rows were lost, totals tie back to the source and problems are listed, and keep a change log for every release.
Expert15 min readExcel
Excel Performance at Scale
Find out why a large workbook is slow, fix the costliest causes first, and recognize when the job has outgrown Excel.
Expert16 min readExcel
Securing and Deploying Excel Workbooks
Protect formulas while inputs stay open, know what Excel passwords really protect, handle macros and external links safely, and release each version with a checklist and a rollback plan.
Expert14 min readExcel
Excel Capstone Project: Build a Complete Solution
A guided project brief: build a refreshable operations model from five sources, with queries, a star schema, measures, a two-audience dashboard, QA checks, automation and a handoff.
Expert15 min readExcel
Comments and Notes in Excel
Ask questions with threaded comments, mention and reply to colleagues, resolve finished threads, and explain cells with notes.
Beginner9 min readExcel
Share, Co-author and Restore Versions in Excel
Share a workbook from OneDrive or SharePoint with the right permissions, edit it with others at the same time, and bring back an earlier version.
Beginner10 min readExcel
How to Print in Excel: Print Area, Titles and Fit to Page
Print exactly the cells you want, repeat the heading row on every page, fit a sheet to one page wide, and add page numbers.
Beginner11 min readExcel
How to Save Excel as PDF or CSV
Turn a sheet into a PDF that looks right for anyone, or a CSV file that other apps can import, and know what each format keeps and loses.
Beginner10 min readExcel
How to Record a Macro in Excel
Record a repeated formatting job as a macro, read the VBA Excel writes, choose relative or absolute references and save and open macro files safely.
Advanced13 min readExcel
Automating Excel with VBA
Write VBA macros by hand: loop over ranges without Select, handle errors, respond to events, and log every run.
Expert20 min readExcel
Office Scripts and Power Automate for Excel
Record and write Office Scripts, run them on a schedule with Power Automate, and choose the simplest automation that solves the job.
Expert16 min read
PowerPoint 36 tutorials
Browse by topic →PowerPoint
Which PowerPoint Level Should You Start At?
Do a 45-minute fix-the-deck test on 7 messy slides, then use clear placement rules to pick Basics, Intermediate, Advanced or Expert PowerPoint.
Beginner12 min readPowerPoint
How to Get Started with PowerPoint: Workspace, Views, and Saving
Learn what each part of the PowerPoint window does, switch between views, and create, save, and export your first file without losing work.
Beginner13 min readPowerPoint
How to Build Your First Presentation in PowerPoint
Plan a deck around your audience and purpose, pick the right slide layouts, and put your slides in an order that makes sense to listeners.
Beginner14 min readPowerPoint
How to Write Slide Text People Can Read in PowerPoint
Write slide titles that state the point, use placeholders, and format text, bullets, and alignment so people can read your slides from the back row.
Beginner14 min readPowerPoint
How to Add Pictures, Shapes, Icons, and Screenshots in PowerPoint
Insert pictures without stretching them, crop them to the point, and add shapes, icons, and annotated screenshots that make a slide clearer.
Beginner15 min readPowerPoint
How to Use Themes and Templates in PowerPoint for a Consistent Deck
Apply a theme, start from a template without letting it run your message, and keep titles, colors and backgrounds consistent across every slide.
Beginner14 min readPowerPoint
How to Add Simple Tables and Charts in PowerPoint
Decide when a table or a chart fits your data, insert one in PowerPoint, and clean it up so your audience can read it in seconds.
Beginner15 min readPowerPoint
How to Present a Slide Show, Use Speaker Notes and Export to PDF in PowerPoint
Start and control a slide show, write speaker notes that help you instead of repeating the slide, use Presenter View, and print or export the right PDF.
Beginner15 min readPowerPoint
Beginner Project: Build an 8-Slide Mini Lesson in PowerPoint
Put every beginner skill together: plan, build, present and export an 8-slide lesson that teaches a useful skill, then score it with a simple rubric.
Beginner13 min readPowerPoint
How to Use Slide Master and Custom Layouts in PowerPoint
Edit the Slide Master, build reusable custom layouts with placeholders, and organize long decks into sections so you stop fixing slides one by one.
Intermediate15 min readPowerPoint
How to Align, Group, and Layer Objects in PowerPoint
Line up, space, group, layer, and name objects precisely with Align, guides, the Selection Pane, and Format Painter so slides look clean.
Intermediate15 min readPowerPoint
How to Design Clear Slides in PowerPoint: Hierarchy, Color, Type, and Whitespace
Make slides easy to scan with one message per slide, clear emphasis, a small color palette, a simple type scale, and enough whitespace.
Intermediate15 min readPowerPoint
How to Make Clear, Honest Charts and Data Slides in PowerPoint
Write the data takeaway first, pick the right chart, clean up defaults, bring charts in from Excel safely, and avoid misleading visuals.
Intermediate16 min readPowerPoint
How to Use SmartArt, Diagrams, and Icons in PowerPoint
Pick the right diagram for an idea, turn bullets into SmartArt, build cleaner diagrams with shapes and connectors, and make them accessible.
Intermediate15 min readPowerPoint
How to Add Audio, Video, and Narration in PowerPoint
Insert video and audio, set playback, compress media, record narration, and add captions so your media plays reliably and every learner can follow it.
Intermediate15 min readPowerPoint
How to Use Animations and Transitions in PowerPoint (Without Distracting People)
Use entrance, emphasis, and exit effects, the Animation Pane, and simple transitions to reveal ideas in order and focus attention, then test every click.
Intermediate15 min readPowerPoint
How to Review, Check Accessibility, and Share a PowerPoint Presentation
Use comments, a final preflight check, the Accessibility Checker, and Document Inspector, then export the right format: PPTX, PDF, video, or a share link.
Intermediate16 min readPowerPoint
PowerPoint Intermediate Capstone: Build a 12-Slide Tutoring Lesson Deck
Plan, build, and share a 12-slide tutoring lesson using a custom Slide Master, sections, clean data, a diagram, media, purposeful animation, and an accessibility pass.
Intermediate13 min readPowerPoint
How to Plan a Presentation Story: Audience, Message and Narrative in PowerPoint
Plan a deck before you design it: profile the audience, write a one-sentence job, pick a narrative pattern and storyboard titles that make the case.
Advanced14 min readPowerPoint
How to Build a Custom PowerPoint Template and Design System
Turn your design decisions into a reusable PowerPoint template: theme colors and fonts, a grid, a named layout library, clean masters and a .potx file.
Advanced15 min readPowerPoint
How to Crop, Mask and Overlay Images and Use Merge Shapes in PowerPoint
Choose strong images, crop to a ratio and focus point, keep text readable over photos, build custom graphics with Merge Shapes and make images look like a set.
Advanced15 min readPowerPoint
How to Use Morph, Animation Triggers and Advanced Timing in PowerPoint
Use motion to explain: build smooth Morph sequences, name objects so they match, make clickable trigger reveals and polish timing that holds up live.
Advanced15 min readPowerPoint
How to Build Interactive PowerPoint Presentations With Links, Zoom and Branching Quizzes
Build non-linear decks: menus with hyperlinks, action buttons and Zoom, branching quiz feedback and navigation tested so nobody hits a dead end.
Advanced15 min readPowerPoint
How to Link Excel Charts to PowerPoint Without Breaking Your Deck
Choose between linking, embedding and pasting Excel charts as pictures, manage and repair links, document sources, and ship stable decks.
Advanced14 min readPowerPoint
How to Record a PowerPoint Lesson and Build Self-Paced Decks
Redesign slides for learners without a presenter, record narration slide by slide, export to video, and package a lesson for a website or LMS.
Advanced13 min readPowerPoint
How to QA and Rehearse a PowerPoint Deck Before You Present
Review a deck in content, visual, technical, and accessibility passes, rehearse with timings and Speaker Coach, and turn findings into a revision plan.
Advanced13 min readPowerPoint
Advanced Project: Build an 18-Slide Interactive Tutoring Module in PowerPoint
Plan, design, and QA an 18-slide interactive module with a menu, branching quiz, Morph, and narration that works live or self-paced.
Advanced11 min readPowerPoint
How to Build a PowerPoint Template Kit and Layout Library Your Team Can Use
Turn a good-looking deck into a template kit: a tested layout library, placeholder rules, sample slides and a one-page guide others can follow.
Expert15 min readPowerPoint
How to Automate PowerPoint With VBA, Office Add-ins and Python
Decide which PowerPoint chores are worth automating, then pick the right tool: a VBA macro, an Office JavaScript add-in or a python-pptx script.
Expert15 min readPowerPoint
How to Run a PowerPoint Deck Production Workflow for a Team
Run decks through a repeatable pipeline: clear stages, clean version names, the right reviewers, controlled feedback and a folder anyone can pick up.
Expert12 min readPowerPoint
How to Set Up PowerPoint Accessibility Standards and Deck Governance for a Team
Build accessibility into templates, alt text standards and a one-page governance policy, then run a repeatable review that catches what the checker misses.
Expert14 min readPowerPoint
How to Structure High-Stakes PowerPoint Decks: Training, Pitch, Executive and Data Reports
Match deck structure to the genre: training, pitch, executive update, data report or case study, so each deck asks its audience for the right response.
Expert13 min readPowerPoint
How to Design Interactive Assessments and Feedback Slides in PowerPoint
Write measurable objectives, build practice ladders and feedback slides that teach, and assess real judgment with scenarios, rubrics and portfolios.
Expert15 min readPowerPoint
How to Publish a PowerPoint Deck as PDF, Video, Images and Web Content
Pick the right output for each audience, export clean PDFs, videos and images, turn slides into web lessons, and keep every published version in sync.
Expert15 min readPowerPoint
How to Teach PowerPoint and Give Slide Critique That Improves Decks
Diagnose what a learner really needs, demonstrate one skill at a time, give specific feedback, and coach revisions without taking over the deck.
Expert14 min readPowerPoint
Expert PowerPoint Capstone: Build a Template Kit, Automation and Coaching System
Package a reusable template kit, prove one automation, document governance and publishing, and coach a learner through a mentor-reviewed revision.
Expert13 min read
Word 35 tutorials
Browse by topic →Word
How to Get Started with Word: Workspace, Views, and Saving
Learn what each part of the Word window does, switch between views, and create, save, and reopen documents without losing work.
Beginner13 min readWord
How to Type, Select, and Edit Text in Word
Select text with the mouse and keyboard, cut, copy and paste cleanly, undo mistakes, and use Find to jump straight to any word.
Beginner14 min readWord
How to Format Text and Paragraphs in Word: Fonts, Spacing, and Alignment
Choose readable fonts and sizes, set line and paragraph spacing instead of pressing Enter twice, align text, and copy formatting with Format Painter.
Beginner15 min readWord
How to Use Bullets, Numbered Lists, and Tabs in Word
Make bulleted and numbered lists that renumber themselves, nest sub-points, and line up text with tab stops instead of spaces.
Beginner14 min readWord
How to Set Up Pages in Word: Margins, Breaks, Headers, Footers, and Page Numbers
Set margins, orientation and paper size, insert page breaks, and add headers, footers and page numbers that stay put as the document grows.
Beginner15 min readWord
How to Add Pictures, Shapes, and Simple Tables in Word
Insert and resize pictures, choose a simple text wrap, add shapes and icons, and build a basic table for schedules or lists.
Beginner15 min readWord
How to Proofread, Print, and Save a Word Document as PDF
Use Editor to catch spelling and grammar issues, check the word count, preview pages before printing, and save a clean PDF to share.
Beginner14 min readWord
Beginner Project: Make a 3-Page Study Guide in Word
Put every beginner skill together: write, format, lay out and export a 3-page study guide with lists, a picture, a table and page numbers, then score it with a simple rubric.
Beginner13 min readWord
How to Use Styles and the Navigation Pane in Word
Format headings and body text with styles instead of by hand, change a whole document at once, and move sections around in the Navigation Pane.
Intermediate15 min readWord
How to Add a Table of Contents, Captions, and Cross-References in Word
Build a table of contents that updates itself, number figures and tables with captions, and point to them with cross-references that never go stale.
Intermediate15 min readWord
How to Use Section Breaks, Columns, and Different Headers in Word
Split a document into sections so one part can be landscape, use columns, restart page numbers, and give each section its own header.
Intermediate15 min readWord
How to Build and Format Tables That Read Well in Word
Merge and split cells, repeat header rows across pages, control column widths, sort rows, and apply table styles that stay readable.
Intermediate15 min readWord
How to Position Pictures and Wrap Text in Word Without Things Jumping Around
Understand in-line versus wrapped pictures, anchor images where they belong, and lay out pictures, text boxes and captions that hold their place.
Intermediate15 min readWord
How to Use Track Changes, Comments, and Compare in Word
Suggest edits with Track Changes, reply to and resolve comments, accept or reject changes cleanly, and compare two versions of a document.
Intermediate15 min readWord
How to Use Templates, Quick Parts, and AutoText in Word
Start from a template, save reusable blocks like signatures and notices as Quick Parts, and set up AutoCorrect entries that save typing.
Intermediate14 min readWord
How to Check Accessibility and Share a Word Document
Add alt text and real headings, run the Accessibility Checker and Document Inspector, then share with the right permissions or as a PDF.
Intermediate15 min readWord
Word Intermediate Capstone: Build a 12-Page Tutoring Handbook
Plan, build and share a 12-page handbook with styles, an automatic table of contents, sections, captioned tables and pictures, a tracked review and an accessibility pass.
Intermediate13 min readWord
How to Plan and Structure Long Documents in Word: Outline View and Multilevel Numbering
Outline a long document before you write, link multilevel numbering to heading styles, and reorganize chapters in Outline view without breaking anything.
Advanced15 min readWord
How to Build a Custom Word Template and Style System
Turn your formatting decisions into a .dotx template: theme fonts and colors, a named style set, page layouts, and placeholder text people can't easily break.
Advanced15 min readWord
How to Add Footnotes, Citations, and a Bibliography in Word
Insert footnotes and endnotes, manage sources, cite in APA or MLA style, and generate a bibliography that updates as you write.
Advanced15 min readWord
How to Build an Index, Table of Figures, and Bookmarks in Word
Mark index entries, generate an index and a table of figures, and use bookmarks and hyperlinks so readers can move around a long document.
Advanced14 min readWord
How to Use Mail Merge and Fields for Letters, Labels, and Certificates in Word
Connect Word to an Excel list, merge personalized letters, labels and certificates, add rules and fields, and check every record before you print.
Advanced16 min readWord
How to Create Fillable Forms with Content Controls in Word
Build sign-up sheets and worksheets with text fields, checkboxes, drop-downs and date pickers, then restrict editing so only the fields can change.
Advanced15 min readWord
How to Link Excel Tables and Charts to Word Without Breaking Your Document
Choose between pasting, linking and embedding Excel data, update and repair links, and keep reports in sync with their source workbook.
Advanced14 min readWord
How to Clean Up Documents with Advanced Find and Replace and Wildcards in Word
Find and replace formatting, styles and special characters, match patterns with wildcards, and clean up pasted text in minutes instead of hours.
Advanced14 min readWord
Advanced Project: Build a 25-Page Course Workbook in Word
Plan, template and produce a 25-page workbook with multilevel headings, citations, an index, a fillable worksheet, linked Excel data and merged name certificates.
Advanced12 min readWord
How to Build a Word Template Kit Your Team Can Use
Turn a good template into a kit: tested styles, building blocks, sample documents and a one-page guide, deployed so everyone starts from the same file.
Expert15 min readWord
How to Automate Word with VBA Macros, Office Add-ins and Python
Decide which Word chores are worth automating, then pick the right tool: a VBA macro, an Office JavaScript add-in or a python-docx script.
Expert15 min readWord
How to Run a Document Review and Version Workflow for a Team in Word
Move documents through clear stages, name versions so nobody edits the wrong file, assign reviewers, and merge feedback without losing changes.
Expert13 min readWord
How to Co-Author in Word with OneDrive, SharePoint, and Copilot
Edit the same document at once without conflicts, recover work with version history, and use Copilot for drafts and summaries while checking every claim.
Expert14 min readWord
How to Set Accessibility, Protection, and Governance Standards for Word Documents
Build accessibility into templates, set rules for metadata, document protection and sensitivity labels, and run a repeatable review that catches what the checker misses.
Expert14 min readWord
How to Structure Professional Documents in Word: Reports, Proposals, Policies and Manuals
Match structure to the genre so each document gets the response it needs: executive summaries, decision-ready proposals, clear policies and manuals people can follow.
Expert13 min readWord
How to Publish Word Documents as Tagged PDF, Web Pages and Print-Ready Files
Pick the right output for each reader, export accessible tagged PDFs, prepare print-ready files, turn documents into web pages, and keep every version in sync.
Expert14 min readWord
How to Teach Word and Give Document Feedback That Improves Writing
Diagnose what a learner really needs, demonstrate one skill at a time, comment specifically on structure and formatting, and coach revisions without rewriting their work.
Expert14 min readWord
Expert Word Capstone: Build a Template Kit, Automation and Review System
Package a team template kit, prove one automation, document governance and publishing rules, and coach a learner through a mentor-reviewed revision.
Expert13 min read