Excel’s new AI functions, under the Copilot branding, have started to appear in some public releases. Here’s the full list with syntax of all six AI functions. The functions have started appearing in some Excel 365 for Windows, Insiders Beta (version 2308 build 16708.20004). Not all Insiders see the same
Add some extra flair to your plain Excel charts by inserting pictures or graphics within the chart. It’s remarkably easy and enhances charts a lot. You can simply enhance your graph by inserting a business logo in the chart area. Or you might want to add images to replace the text labels. You may want to insert an image of money to represent dollars spent,
Here are samples of the five new fonts available for Microsoft 365 and Office 2021 customers one of which has become the new default font, but under a different name – Aptos. Did we say five? … there are really 10 new sans-serif fonts. Each of the five newbies come
The Excel Stock data type lets you track the largest companies market capitalization in real-time. It’s strangely compelling to watch the market caps change by billions in the blink of an eye. Excel 365’s Stock data type has the essential information to calculate market capitalization with changing values in real-time.
Make your own Wordle grids in Microsoft Office, Word, PowerPoint or Excel. Choose the right font, colors (the exact green, yellow or grey) plus grid details including blank or unfilled boxes. Wordle was originally a standalone app, created by Josh Wardle . It’s now owned and run by The New
How to insert the Grinning Face 😀 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Grinning Face 😀 emoji is usually depicted as a yellow face, with open eyes and a wide smile. Conveys good cheer or humor, often to make
Some features have been dropped from Microsoft 365 Family, Personal and other plans. Wolfram data types in Excel and so-called ‘Partner Benefits‘. As usual the announcement was full of marketing euphemisms and didn’t tell the whole story because a third feature (Excel’s Money template) discontinued on the same date. Three Microsoft
Barbie (the doll, not the Aussie BBQ) is everywhere at the moment so we’ll explain how to select Barbie Pink in your Word documents, Excel sheets and PowerPoint slides. There’s no one Barbie Pink but a selection to choose from. We looked around various official sources for the toys and
Some more Microsoft Word Find tricks. Select and Find, finding blank lines, search for special characters/emoji, find a certain font or formatting plus wildcard options. This article follows on from our introduction Find pane search secrets in Word Select and Find If you select some text in a document then
There are many ways to visually explain a list of values with different types of Excel Charts and other trickery. We’ve already looked at the numerical or statistical ways to summarize a list of values. Now let’s visualize the data in various ways available easily in Excel. There are various
Everyone knows the SUM function in Excel but that’s just the start, there are eight SUM() functions (and more) for adding up numbers in different ways. SUM() SUM is one of the first functions taught to newcomers. It’s as old as Excel itself (older because SUM was in the first
With the sale of fonts via the Microsoft Store and cloud fonts there’s now a complication in the familiar way fonts are managed in Windows 11/Windows 10 and how Office for Windows handles new fonts. There are now three different locations that fonts can be saved. For as long as
At long last, there’s a way to insert an image into a single Excel cell called Place in Cell. No problems with floating images etc, just a cell with a picture which resizes with the cell size. Adding images to Excel sheets has always been confusing because they weren’t directly
Insert the Telephone receiver symbol 📞 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Telephone receiver or handset 📞 symbol can be used on a letterhead or sign where a phone number is shown. There’s an emoji in the Unicode standard plus
A comedy show that combines Excel with excess Coffee sounds perfect for Microsoft Office nerds and it’s happening this August as part of the Edinburgh Festivals. I run my professional and travel life on Excel. We’ve heard of sensible women who select and rate their dates on a spreadsheet. But
Microsoft has released some information about what you’ll need to get their AI tools (called Copilot) when they are eventually released. Copilot is Microsoft’s name for their upcoming AI tools integrated into Office apps (Word, Excel, PowerPoint and Outlook) plus other services like Teams. As with all Microsoft’s Copilot announcements,
Microsoft Designer now has an image editing tool that’s been missing from Microsoft Office. Erase in Designer lets you edit images in an important way that’s not possible in Word, Excel, PowerPoint or Outlook for Windows or Mac. Picture editing in Office has a lot of features but they mostly
Type the ‘pushing hands’ emoji, left 🫷 or right 🫸in Microsoft Word, PowerPoint and other Office apps. Officially the emoji are called Rightwards Pushing Hand 🫸 and Leftwards Pushing Hand 🫷 but can also be used as a ‘High Five’. These emoji can be used separately or together to great effect,
Microsoft is again changing the way Search works in Microsoft 365 and also (surprise!) Office 2021 to expand the results beyond the document or Office features. Now you can search for definitions, media and even web results from the top bar of Word, Excel and PowerPoint. The most recent announcement
Use Excel to figure out the percentage discount or increase, for example the difference between the original and sale prices. We’ll show you the Excel formula and some practical tricks beyond the official answer. Percentage discount formula The basic formula is: (Original – Sale) – to figure out the difference
Word and Office have several right “pointing hand” symbols available in some fonts. Here’s the Unicode options, index, backhand, sideways in white or black, all explained and shown. Want more arrows or pointers? Check out all 200+ Arrow or Hand pointing symbols and more in a searchable list. Index, Backhand
There are three main ways to run a macro in Microsoft Office (Word, Excel, PowerPoint or Outlook). From the Macros list, from a button on a ribbon or from the Quick Access toolbar. We previously spoke about how to install an Office VBA macro, here’s how a macro can appear
Any Office ribbon tab can be more useful for you. By trimming some of the buttons you don’t need, making room for the buttons you want. We’ll show you how to remove some of the less needed ribbon sections (likely from the Developer tab) to make more room for your
Insert any of the chess piece symbols available in Word, Excel, PowerPoint and other Office apps. King, Queen, Bishop, Knight. Rook and the lowly Pawn all with different looks, depending on the font plus three pieces available in Microsoft Office icons and the single chess piece emoji. Chess Pieces –
