Every Excel error code tells you what went wrong: #DIV/0! is a division by zero, #N/A is a value that wasn’t found, #REF! is a reference that no longer exists. Here is what each error means, a typical cause, and how to fix it. Most common#N/A, #DIV/0!, #VALUE!, #REF! Newer errors#SPILL!, #CALC!, #FIELD!, #BUSY! Find … Read more
Excel has no built-in function that reads cell colour, but you can get the sum of coloured cells in three ways: filter by colour and use =SUBTOTAL(109, range), select the coloured cells with Find & Select and read the sum from the status bar, or write a small VBA function. If the colour comes from … Read more
Excel switches to scientific notation, such as 8.79E+12, when a number is longer than 11 digits in the General format. To show the full number, select the cells and apply the Number format with 0 decimal places, or a Custom format of 0. For numbers longer than 15 digits, such as card or reference numbers, … Read more
Make a large PowerPoint file smaller: compress pictures, delete cropped areas, compress media, stop embedding fonts, remove unused layouts and save as .pptx.
Turn a PowerPoint presentation into an MP4 video: set quality and seconds per slide, record narration and timings, and export with File › Export › Create a Video.
Turn a Word outline into PowerPoint slides with Slides from Outline: use Heading 1 for slide titles and Heading 2 for bullets, then apply a design. Plus Word for the web Export.
Paste an Excel chart into PowerPoint as a linked chart that updates when the Excel data changes. Refresh the data, update all links and fix broken links when files move.
Use Presenter View in PowerPoint to see your notes, the next slide and a timer on your laptop while the audience sees only the slides. Set it up, test it and fix swapped screens.
Use Slide Master in PowerPoint to change fonts, colours, logos and layouts on every slide at once, create custom layouts with placeholders, and keep presentations consistent.
Use the Morph transition in PowerPoint to animate objects smoothly between two slides: duplicate a slide, move or resize objects, apply Morph and set Effect Options.
Insert a checkbox in Microsoft Word: a clickable checkbox content control from the Developer tab for forms, or a printable box symbol for checklists on paper.