techsupportoffice

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.

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.