Office & Email

Protect a Word document with a password to open, restrict editing while allowing reading, remove protection later, lock specific sections, choose strong passwords, and send protected files more safely.

Encrypt an Excel workbook with a password to open, remove or change the password later, understand Mac password limits, compare workbook sheet and cell protection, use password to modify, and share protected files safely.

Create newspaper-style columns in Word for a whole document or selected section, control section breaks, add column breaks, adjust column width and spacing, add a line between columns, and switch back to one column.

Build Excel timesheets and project timelines using templates or formulas, calculate total hours, handle breaks and overnight shifts, create Gantt-style bar timelines, save templates, track overtime, and share through OneDrive or SharePoint.

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.

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.

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.