PowerPoint offers compression embedded video and audio files, reducing the overall file size. But these options aren’t where you might expect to find them, aren’t selective and need to be used with care. There is compression option for media files (video or audio) to a suitable quality level and make
Microsoft has released a preview version of Office 2024 LTSC. Here’s how to get it, what’s in the preview and why not to bother with the preview software. Office 2024 is the next fixed price or perpetual license version of Microsoft Office that will be released later this year. The
Here’s what Microsoft has confirmed for the new version of Office. Strictly speaking two new Microsoft Office, a consumer version Office 2024 and Office LTSC 2024. The next single payment “perpetual licence” version of Office will be Office 2024 (for consumers) or the very similar Office LTSC 2024 (for volume
Grouping in Excel lets you collapse or expand sections of a sheet so you can see the ‘big picture’ but still drill-down to how totals were made. Another use for grouping is hiding rows or columns from view. You can organize and manage data more effectively by grouping together rows
Switch from the new Aptos default font in Outlook to another font that you prefer and is has better readability in Outlook desktop (Windows or Mac) and Outlook (new). Personally I’ve tried to like Aptos fonts but after a few months they still offend my eyes, especially in emails. It’s
Here’s a combined ‘one-click’ way to force an update to both Windows and Microsoft Office at the same time. Normally Windows and Office both update themselves automatically and in the background so you don’t have to worry about it. But there are times when you need to ensure both are
You can do incredible things in Excel but here’s something truly amazing. Someone has made a 16-bit computer chip (CPU) emulation entirely in Excel. We have links to the source code and fascinating video that explains it all. @Inkbox has recreated the basic logic of a CPU to make a
GroupBy is a new and genuinely great function coming to Excel. It’s one of two new ‘aggregation functions’ but we prefer to call them fast summary powers. The more we use Groupby() , the more we like it. So we decided to focus on it with detail. Both Groupby() and
Excel 365 and Excel 2024 have better text conversion options for importing text files with more conversion options. Automatic Data Conversion is now available in Excel for Windows and Mac. Opening .csv files directly in Excel is done a lot. Microsoft encourages it by associating .csv so those files are
Remove words from the main Microsoft Word dictionary – how to do it and why. The Office Exclusion List ensures there’s a red squiggly underline to warn you about an unwanted word. Sometimes the supplied Office dictionary has words you don’t want or you’d like a warning about. Here’s how
Change Case options in Word, like many Word features goes beyond the obvious choices from the basic shortcut. There’s up to five choices on the ribbon with a keyboard shortcut to reach it. Alter the upper/lower case of words, phrases or more. ‘change case’ can become ‘Change Case’ or ‘CHANGE
