There are plenty of audio and music options available in PowerPoint if you want to give your audience a break from your voice. We’ll go beyond the simple ‘adding music’ help to give some practical advice for audio in presentations: You will find the audio basics at Insert | Media |
The BBC has a great collection of over 16,000 sound effects that you can add to your PowerPoint presentations. Use them as a trigger sound for a click on a presentation, as a novel background noise or even an alert sound on your computer or smartphone. Sound Effects Galore Exploring
While it lasts, check out some free classes about Python in Excel for better data analysis, DataFrames, charts & visualizations and machine learning. We’re a big fan of Python in Excel and these lessons should help those of us who haven’t yet caught the Python bug. Advance Your Python in
Excel 365 now has Python features included for all business and enterprise customers with a Microsoft 365 software licence Python is a powerful programming language with many great libraries of tools for analysis and charting. It’s a massive extension to Excel that we’ve already raved about. Python Editor for Excel
Add something special to the start of your Word document with a banner image with text. We’ll explain how to do that with free tools like Copilot or Designer. We were inspired by a Microsoft promotion which wrongly said that a Microsoft 365 subscription with Copilot Pro is required, when
All you need is a ‘strawberry’ to see both ChatGPT and Microsoft’s Copilot gets simple things wrong. Or ask which is larger of two numbers. Modern AI systems aren’t as great as the hype and why you definitely need to check anything Copilot, ChatGPT, Google Gemini or Meta etc tells
A new collection of Copilot features have been released under the banner “Wave 2” with inclusions for Excel, PowerPoint, Outlook, Word and Teams. Don’t get too excited because there’s ‘fine print’ that limits who can catch this wave. Before we explain a little of what’s in the new set of
Here’s the basics of Styles in Word for paragraph, character or both (Linked) plus Tables and Lists. I know talking about styles in Word makes eyes glaze over but they are a really useful part of Word (plus Excel, PowerPoint and Outlook). Today I watched an ‘experienced’ Word user reformatting
What to do if Excel’s columns have numbers across the top instead of letters. There’s a simple setting to switch between two different ways of labelling cells. You open an Excel workbook and the column headings look all wrong – instead of letters (A, B C …) there are numbers.
In-cell charts in Excel provide a powerful method to visualize data trends and patterns. They allow you to quickly derive insights within a worksheet, making information interpretation more straightforward without fussing about with full charts. We’ll explain how to make in-cell charts and then go further and show how to
How to lock your Excel worksheet from editing – the whole thing or some cells. Allow some people to edit a few cells, leaving the rest of the cells and formulas untouchable by others using the worksheet. Here’s a very simple example: Anyone opening the worksheet can enter a US
Microsoft’s promise of offline support in Outlook (new) is a lot LESS than it appears as the company continues to over-promise and under-deliver their Outlook replacement. We’ve said it before … Maybe someday new Outlook will really be ready for the public but it’s not there yet. See Outlook (new)
Discover how to adjust bullet point spacing in Microsoft Word with the two key settings to achieve precise bullet point alignment and formatting. Learning the techniques to perfect your bullet points can make a significant difference in readability and presentation. There are TWO places to change the position of the
The Workplace Discount Program (formerly Home Use Program) offers 30% discounts on Microsoft 365 to employees of many organizations and government agencies. Here’s how the Workplace Discount Program (WDP) works, the tricks and traps. What is the Workplace Discount Program – WDP? Organizations (companies, governments etc.) that have Microsoft 365
An often-repeated myth says that Word’s spelling or proofing language default is locked into the Windows language setting. Officially that’s not true and never has been since the first Word for Windows in 1989. In practice there’s a bug in Word which is why this persistent myth keeps being repeated.
How to stop Outlook grouping Inbox messages, most commonly by date. “Today”, “Yesterday” etc. which might suit some people but is a right nuisance to others. This is an option in Outlook (classic) for Windows which can appear, seemingly for no good reason. It’s not in Outlook (new). Some people
Excel is getting a new function TrimRange() which should solve a long-standing calculation performance problem. As well as speeding up workbooks, TrimRange() comes with some new range options that add to the well-known colon. Ever since Microsoft added dynamic arrays to Excel there’s been a problem … how to reference
Excel 365 has two new translation functions to identify language from text or translate text from one language to another. Let’s see how the work, some problems and unknowns. New in Excel 365 are: DetectLanguge() to identify the language of the text supplied, hopefully correctly (see below) Translate() converts text
Many people are moving away from Evernote due to the high prices. Here’s the simple way to migrate all Evernote notebooks to Microsoft OneNote. Why move from Evernote? Evernote’s pricing has risen to unrealistic levels. The cheapest paid plan “Personal” is now US$129.99 which is more expensive than Microsoft 365
Having trouble changing Microsoft Word defaults? The ultimate way to change defaults is sure to work. It’s has been around since the very early days of Word and works for Outlook too! We often hear from people having trouble changing Word’s opening (default) settings for a new document. Various places
Word can spell and grammar check in many languages, here are three ways to switch the language settings plus how to turn off the pesky automatic language switching. Microsoft Word has language settings that can apply to a whole document or just selected text. This is vital for multi-language documents
There’s a simple but not so obvious way for Excel to take a list of values and show them grouped into segments or groups. As an example, here’s the results of a class exam with their scores grouped into blocks of 20. It’s done with a tricky use of PivotTables
We went hunting for koalas in Microsoft Office. Found more than 18 of the cuddly marsupials for Word, PowerPoint or Outlook. There are emoji, Office icons, SVG, online images and more making a colony or cling of koala (either can be the collective noun for koala). None of the endangered
Paid Copilot plans have some innovations in the Word 365 interface with a better way to Make Changes to text plus more paste options too. These changes are in Word 365 public releases linked to a paid Copilot plan. We found them in v2407 build 17830.20138 with Copilot Pro. Auto
