If you thought the modern world could not get any stranger, we’ve got bad news. Microsoft Office and Oreos (the chocolate cookie) have combined for a marketing stunt with online events (sorry “snack breaks”), special packs, tchotchke and emoji. Poor old Clippy has been dragged in as well. On the
Combine or divide adjacent Microsoft Word or PowerPoint table cells into a merged single cell or split a cell in two. Welcome to ‘Merge Cells’ where you can combine adjacent cells into a single cell. It’s very handy for table formatting tricks and other unusual situations like a longer than
The simple and easiest way to convert text dates to Excel dates is using Text to Columns on the Data tab. It’s a simple ‘one off’ method that works well and takes you through the steps. If you need something more automated, for new text dates entered from time-to-time use
Footnote marks aren’t limited to numbers. Microsoft Word has many choices for listing footnotes or endnotes including the standard symbol order for notes or even your choice of custom symbols or emoji. Just one possibility for a footnote mark is a right-pointing hand like this: In-built Footnote/Endnote number choices Go
Today, 17 October, is Spreadsheet Day and Microsoft has joined the event with a fun example of what Excel is capable of. #spreadsheetday #spreadsheets #excel Microsoft Excel at Office-Watch.com The hidden trap in Excel’s DateDif()Better Excel formula converts days into Years, Months, DaysFour ways to make text fit in an
Office for Mac has keyboard shortcuts to speed up work but they are a lot hard to find than they should be. There’s no direct mapping of Office for Windows shortcuts into Office for Mac. Partly because the Mac has keys that aren’t on a regular Windows keyboard ( ⌘/Command
Microsoft has announced that “Microsoft Office” is now “Microsoft 365” – big deal. That already happened back in 2019 and the Office name will still be used. Is it really a name change or a bit of hype? What’s really changed? There’s a new logo – that’s all. As I
Type the Yen ¥ currency symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Yen is used for Japanese currency and the Chinese Renminbi / Yuan. Microsoft Excel also offers the Yen symbol for Mongolia even though the tögrög currency uses another
More ideas and a wish list for ending a PowerPoint presentation with a different slide. After our article on the ending slide options for PowerPoint, Vivian from the UK writes: “… it’s really very easy to do what I always do at the end of PPT presentations. Just add a
The blank black slide which appears usually at the end of a slideshow is a default setting in PowerPoint. But it can be changed. The blank black slide which appears usually at the end of a slideshow is a default setting in PowerPoint. But it can be changed. Open PowerPoint
Recreate the Murphy Brown TV show’s look as a design inspiration for Word and PowerPoint – the fonts, colors and lines. You may not want to use the exact look of the Murphy Brown title card, but it’s a starting point for design variations of your own. We’ll show how
How to change the PowerPoint slide numbering to a different start number. In PowerPoint, slides are numbered by default from 1 but that’s not always what you need. For example, you’re working on some slides which are just part of a set of slides eg. working on slides from number
In PowerPoint you can record narration and comments during or after a slideshow. This makes the presentation more interesting and interactive. This feature is especially useful when you convert presentation to video. With narration the video would seem complete and the process of doing this is quite simple and easy.
One of the eye-catching features since PowerPoint 2010 right up to PowerPoint 365 is turning your mouse into a virtual laser pointer. A ‘laser pointer’ transforms the boring mouse pointer to something striking and easier to see on the screen. This is especially useful while delivering presentations as it eliminates
Excel Array formulas are useful for getting the result from a filtered list quickly with a single, simple formula. Continuing our series on Excel array formulas. Here’s a list of stocks with industries aka Table3. How many stocks are in the ‘Shop’ industry? The array formula in G5 has the
Array formulas are an important part of Excel and they are a lot more important now that dynamic array formulas are around. Don’t ignore arrays because they’re an unavoidable part of Excel for everyone. This is the start of a series to help you understand arrays in Excel. At the
Word can generate a list of all the tables in a document. Like a Table of Contents, this list of tables or Table of tables can include page references or links to each table. A Table of tables can be useful for creating a proper appendix or reference within more
Outlook can handle more than one calendar and has three options for easily viewing them, either individually or combined. Calendars can be displayed side-by-side or the more useful Overlay option. There’s also the ‘New Window’ option. Choosing the Outlook calendars to view In Outlook calendar view, use the check boxes
Outlook can link to external, shared, calendars and copy any updates to that calendar using either a .ics tile or a webcal link. An Internet calendar can be for public events, holidays, sporting fixtures etc. They can be a one-time copy of event details or you can setup Outlook
Type the Pilcrow Sign ¶ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Pilcrow Sign ¶ is a typographical symbol sometimes called a paraph, or blind P In typography ¶ marks the start of a paragraph but in Microsoft Word the Pilcrow Sign ¶ marks
Here’s a better Excel formula for converting a number of days into text for year, months and days. This formula leaves out zero values and proper singular/plural (e.g. not “1 Year 0 Months 27 Days” but “1 Year 27 Days”). And we’ll show an even better way to write the
Anyone can view a Microsoft Visio file, once you know at least one of two tricks available. One is free software, the other is a workaround via OneDrive. “I’ve been sent a .vsdx file to view and I’ve figured out it’s a Visio file – but how can I view
A Word document and a floppy disk caught a serial killer back in 2010. There are still lessons for anyone wanting to keep their personal or business data confidential. Known as the ‘BTK killer’, he murdered 10 people in Kansas between 1974 and 1991. The murderer was finally caught in
After the report of pirated / illegal Microsoft Office from an Amazon retailer (and Amazon’s initial refusal to act) how can you protect yourself from a similar problem on Amazon or other sites? Your entitlement to a refund or redress for a illegal product is different depending on whether you
