September 2026

Create a two-column resume in Word using a borderless table, resize a sidebar and main column, compare Word Columns with table layouts, manage ATS concerns, add shading, convert existing resumes, and use gridlines while editing.

Create Excel waterfall charts from starting values increases decreases and totals, set totals correctly, format increase decrease and total bars, add data labels, and understand older Excel stacked-column workarounds.

Create Excel pivot tables from raw lists, use Recommended PivotTables or manual field placement, summarize by rows columns values and filters, refresh source data, change value calculations, group dates, and fix text numbers.

Change PowerPoint slides from landscape to portrait, choose Maximize or Ensure Fit, understand why orientation applies to the whole presentation, create poster sizes, work around mixed portrait and landscape needs, and switch back.

Turn an Excel table into a chart, choose the right chart type, add titles and labels, change chart styles, extend the source range, export charts as pictures, and understand Windows Mac and web differences.

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.

Create Excel drop-down lists that grow automatically using Tables or dynamic named ranges, use Data Validation, sort or filter source lists, remove blank choices, and troubleshoot list sources that do not update.

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.

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.