Office & Email

Create one-variable and two-variable Excel What-If data tables, test formulas against ranges of inputs, set row and column input cells, manage recalculation speed, edit test values, and know when to use Goal Seek instead.

Insert Word page numbers, skip numbering on the cover page, start page 2 as page 1, restart numbering by section, use roman numerals for front matter, refresh page-number fields, and fix Link to Previous problems.

Link cells between Excel workbooks with external references, create links by clicking open workbooks, update values, change source paths, break links into static values, respond to update prompts, avoid moved-file errors, use stable shared locations, and paste values for snapshots.

Insert automatic Word tables of contents from Heading styles, create custom TOCs, control heading levels and page numbers, fix missing headings, update tables with F9, remove TOCs, and modify TOC styles.

Create a Word table of figures by adding captions first, choosing Figure Table or Equation labels, inserting the table with page numbers, updating fields, making separate lists, modifying styles, renumbering captions, and refreshing before PDF export.

Insert Excel data into Word as editable tables, linked Excel objects, or embedded spreadsheets, choose paste options, update links, avoid broken source paths, manage wide tables, compress workflow, and understand Mac object limits.

Insert PDFs into Word as editable converted text or fixed embedded objects, understand Windows and Mac limitations, insert PDF pages as images, display as icon, handle scanned PDFs and OCR, and choose the right method.

Insert Word section breaks, choose Next Page Continuous Even Page and Odd Page breaks, use sections for margins orientation columns headers and footers, show and delete section breaks, unlink headers, and restart page numbering.

Insert signatures in Word as handwritten signature images, crop and make backgrounds transparent, save signatures to Quick Parts, add formal signature lines, use digital signatures with certificates, sign PDFs, and understand Mac limitations.

Insert a built-in Word cover page, replace placeholders, remove or swap cover pages, make a manual title page with section breaks, use themes, save custom cover pages to Quick Parts, and add automatically updating dates.