Word
Find your way around Word and save a draft
Save a working copy, use the main tabs and start a document from a template.
The learning library
Find the next thing
you need to do.
Clear steps, realistic examples and a result you can check. Search a task, choose an app, or work through a path from the beginning.
Your progress
— / 68 lessons complete
Stored on this browser and device. Completion is your own checklist, not a certification.
68 lessons found
Word
Find, replace and paste text
Make a wording change while keeping project names and paragraph formatting intact.
Word
Paragraph spacing and page breaks
Use paragraph settings instead of blank lines and spaces to arrange a memo.
Word
Styles and headings
Build an outline that readers can use in the Navigation pane and table of contents.
Word
Number sections with heading styles
Let Word renumber sections when you add or move them.
Word
Sections, headers and page numbers
Use an unnumbered cover, Roman front matter and a body starting at page 1.
Word
Build and sort a comparison table
Keep vendor details together in rows and make prices easy to compare.
Word
Pictures, captions and cross-references
Place two images, number their captions and link to a figure from the text.
Word
Contents, sources and a report template
Build navigation and references that you can update after editing.
Word
Review tracked changes and comments
Accept a wording edit, reject a date change and prepare a clean copy.
Word
Mail merge four invitation letters
Connect recipient data, check all four previews and preserve postal codes.
Word
Make an equipment request form
Add text, date and choice controls, then test a protected copy.
Word
Build a report and record a small macro
Bring the course skills together and record one heading-formatting action.
Word
Review a document and export PDF
Remove review leftovers, check accessibility and add heading bookmarks.
Excel
Choose the right Excel file and edition
Save an editable workbook and a separate CSV, then see what each file keeps.
Excel
Navigate the worksheet without losing your place
Jump to cells, read the formula bar and move between sheets.
Excel
Manage worksheets and cross-sheet references
Build a monthly summary and keep original and scenario sheets separate.
Excel
Recognize numbers, text and dates
Keep identifier zeros, convert text amounts and build dates with DATE.
Excel
Design a table that analysis can trust
Turn a month-by-month matrix into a table you can filter and extend.
Excel
Keep headers visible and organize rows safely
Keep headers and item codes visible while scrolling.
Excel
Format numbers without changing their meaning
Format a budget and see why displayed decimals differ from stored values.
Excel
Copy formulas and paste values
Fill line totals down and make a fixed upload copy.
Excel
Build formulas with reliable references
Use relative, absolute and mixed references in an order sheet and a price grid.
Excel
Add up sales with SUMIFS
Total sales by region, reuse the formula and add a minimum-sale condition.
Excel
Look up products and build a dynamic result list
Find a product price and return a list of products above a price threshold.
Excel
Diagnose formula errors before hiding them
Find the cause of a formula error and handle a zero plan separately.
Excel
Sort complete records using multiple keys
Sort by team and amount while keeping each request row together.
Excel
Filter a list and calculate visible totals
Show a subset of requests and calculate the visible total.
Excel
Control inputs with validation and audit checks
Add region and quantity rules, then check pasted records with a formula.
Excel
Split and clean a delimited import
Split a pipe-delimited list without breaking names or losing identifier zeros.
Excel
Remove true duplicates and build separate subtotals
Remove a repeated request while keeping legitimate requests with equal amounts.
Excel
Tables and basic data cleaning
Clean a weekly sales export and explain the change in its total.
Excel
Highlight exceptions with a clear rule
Highlight overdue tasks and add a text label for the same condition.
Excel
Summarize sales with a PivotTable
Compare regional sales and break the totals down by month.
Excel
Connect a PivotChart to a focused sales question
Chart monthly totals and show which region is selected.
Excel
Choose a chart that answers one question
Choose a simple chart, label the units and keep its scale honest.
Excel
Clean sales with Power Query and add model measures
Refresh a cleaning query, then calculate DAX measures in Windows Power Pivot.
Excel
Test scenarios with Goal Seek and Solver
Find a target input, compare prices and solve a small product mix.
Excel
Build a small report with VBA
Read a recorded action, run a report macro and test its cleanup path.
Excel
Protect formulas and prepare a clear handover
Leave quantity inputs editable and protect the calculation cells.
Excel
Prepare a workbook for print and PDF
Set the print area and inspect the PDF the recipient will read.
Excel
Compare formula designs without losing records
Check source coverage and use a fair calculation comparison.
Excel
Find why a total is wrong
Separate a text amount from a missing row and fix them one at a time.
Excel
Build a small shortcut routine that preserves accuracy
Practice five keyboard actions and check their effect on the sheet.
Excel
Make a calculation readable with LET and LAMBDA
Make a row calculation easier to read with LET and reuse it with LAMBDA.
Excel
Build a checked sales dashboard from source to handover
Build a dashboard and check every summary against its source.
Excel
Choose your next Excel task
Compare a formula and a PivotTable, then choose what to learn next.
Excel
Choose functions and check their assumptions
Compare counts, averages, workdays and repayment signs with small examples.
PowerPoint
Create, save and inspect a presentation
Find the main editing controls and keep a working file separate from a practice copy.
PowerPoint
Use layouts and sections
Put the story into Outline view, then organise slides with layouts and sections.
PowerPoint
Make text fit the slide
Turn a long paragraph into short bullets, keeping the detail in notes.
PowerPoint
Make a picture and process diagram
Crop a picture and build a process with labels people can follow.
PowerPoint
Build a readable chart
Insert an editable chart, label the values and highlight the peak.
PowerPoint
Line up cards and keep their labels together
Use alignment, spacing and grouping to arrange a row of owner cards.
PowerPoint
Use a theme to show what matters
Keep colours and fonts consistent, with words that explain each status.
PowerPoint
Make a reusable slide template
Keep shared branding on the master and leave slide content editable.
PowerPoint
Add a short video with captions
Record a practice clip and add captions that match its speech.
PowerPoint
Reveal text with animation and a button
Show the ticket value first, then reveal the investigation when its button is clicked.
PowerPoint
Show a change with Morph and navigate with Zoom
Enlarge a process stage across two slides, then make an agenda with a link-based alternative.
PowerPoint
Link a menu to detail slides
Build a help menu with clear labels and a return link on every detail.
PowerPoint
Use speaker notes and share the right PDF
Rehearse with notes, then make separate audience and presenter PDFs.
PowerPoint
Review a shared deck and control access
Use one shared file, comments and version history, then try an open password on a separate copy.
PowerPoint
Share a PDF and presentation video
Check titles, reading order, links and notes in the files your audience will receive.
PowerPoint
Make a smaller delivery copy
Reduce file size while checking picture quality, captions and editable objects.
PowerPoint
Adapt the story for three audiences
Use the ticket figures in a decision deck, a teaching exercise and a proposed launch.
PowerPoint
Draft with Copilot and check the facts
Give Copilot the brief, then compare its slides with the source figures.
PowerPoint
Use shortcuts with the right selection
Practise adding and copying slides without accidentally changing a word or shape.
PowerPoint
Build a complete support-review deck
Bring the story, chart, notes and handout together in one presentation.