techsupportoffice

Change Excel date formats with built-in and custom formats, use locale for non-US dates, create custom date codes, fix serial numbers and ##### dates, change regional defaults, and avoid date entry confusion.

Check Word word count in the status bar, count selected text, enable missing status bar word count, open the full Word Count dialog, include text boxes, footnotes, and endnotes, understand hyphen and punctuation counting, and track counts while writing.

Combine text in Excel with CONCATENATE, CONCAT, TEXTJOIN, and ampersand formulas, add spaces and punctuation, skip blanks, preserve date formatting with TEXT, fix #NAME errors, formulas showing as text, and use Flash Fill.

Change Word margins for a whole document or one section, use custom margin values, insert section breaks, add gutters and mirror margins for binding, switch inches and centimeters, set defaults, and handle printer margin warnings.

Change Word orientation for a whole document or one page, use section breaks before and after landscape pages, manage headers and footers with Link to Previous, keep page numbering continuous, and reveal section breaks.

Use Outlook color categories, rename and recolor category labels, apply categories to messages, create rules that auto-assign categories, search by category, sync categories across accounts, set Quick Click, and understand categories versus flags.

Change Word line spacing to single, 1.15, 1.5, double, or custom exact and multiple values, set paragraph before and after spacing, set defaults, meet MLA or APA spacing, fix pasted-text overrides, and use Show Hide paragraph marks.

Autofit Excel columns and rows by double-clicking borders or using the ribbon, resize selections or whole sheets, fix wrap text and merged-cell issues, set exact widths, fix ##### cells, understand print scaling, and avoid scientific notation surprises.

Calculate Excel running totals with expanding SUM ranges, absolute references, Excel Tables and structured references, category-reset totals with SUMIFS, visible-row totals with SUBTOTAL, fixed references, and sorting precautions.

Calculate percentage change in Excel and Google Sheets, format results as percentages, handle zero and negative starting values, add conditional formatting, build period-over-period formulas, distinguish percent change from percentage points, and preserve precision.