How to make an Excel chart that changes as you add more cells or rows is really simple these days. Forget all the old stuff about named ranges or changing the Chart data. Setup your Excel list correctly and any linked charts will update automaticall. In a recent article we
The secret to a timeline chart in Excel is the data. Emily writes asking “How can I make an Excel chart with dates on the X axis with a proper time scale – even if the dates aren’t regular? “ We could not understand Emily’s question until we asked for
Microsoft is making an important step towards cloud storage security with the public preview of Double Key Encryption. That means, for the first time, Microsoft customers can secure their data from access, even by Microsoft itself. All the ‘secure’ cloud storage from Microsoft can be accessed by Microsoft. For all
With all the subscription offerings available (Netflix, HBO, Disney, CBS, Apple, Google, Amazon, Office 365 etc), here’s a way to manage them all from Excel. Along the way we’ll show you some interesting Excel features. We were inspired by Brian X Chen in The New York Times, writing about how
We’re happy to release a new version of our Subscriptions Manager that’s compatible with Excel 2007-2016. Subscriptions Manager is a way to list and manage the many online plans we sign up for; HBO, Netflix, Amazon, Spotify and so many more. You can track who pays (in a family) and
The names of genes are being changed just to stop Excel confusing them with dates during the import process. We’ll explain two ways Excel already works to avoid the geneticist’s problem. Genes named like MARCH1 and SEPT1 which Excel converts into dates when imported the wrong way, usually directly via
Why does Excel change what people type or import, sometimes in ways they don’t want? It’s the General cell format that messes with what you type or import. It’s the default cell format ‘General’. It’s top of the Formats list and most of us haven’t given it a second thought.
Microsoft Office 2010 ends support later this year but there’s no need to panic. Here’s what to do, when to change from Office 2010 and what to replace it. Office 2010 countdown [ycd_countdown id=”31774″][/ycd_countdown] Office 2010 ends support on Tuesday, 13 October 2020 All the Office 2010 programs will keep
Excel can speak the numbers, dates and text in cells. It’s a feature that’s been hiding in Excel since Office 2007 through to the latest Excel 365 for Windows. Speak in Excel is like Word’s Speak but with a few useful spreadsheet options. The audio options are mostly intended for
The Excel team has joined the current ‘Cake’ meme with a new Cake() function in Excel. Hilarity ensues … Source: Twitter Ho ho, very funny, it is to laugh. Most people took the message in good spirit with one person implementing it in VBA That code really works. ChrW() returns
2020 will be remembered for many things (big sigh) but from a design viewpoint, it could be the Year of the Icon. Many of those graphics are available either in Office directly or imported from elsewhere – we’ll show you both. Everywhere you go there are signs reminding us of
Despite fair warnings, Microsoft has allowed an old Excel format .SLK to get past their email security and infect Excel for Windows computers. As reported by Avanan, criminals have found a way to bypass the email security for Office 365 hosted mailboxes (possibly Outlook.com as well), allowing an infected email
How to quickly fix display problems in Microsoft Office. When Word, Excel, PowerPoint or Outlook don’t show up on the screen correctly. It doesn’t happen often but occasionally Word, Excel, PowerPoint or Outlook open but as all grey. Clicking around the screen displays just a ribbon or menu but not
Excel for iPhone and Android smartphones have a useful extension of Excel Tables called Cards. It’s a better way to view tables on a smaller screen with larger text and easier editing. Instead of scrolling right/left on the small screen, all the info for a single table row can be
Microsoft’s Money in Excel is worth looking at even if you don’t want to use it. There are some useful features and formula tricks you can use in your own workbooks. Group Columns Grouping columns or rows is normally for bringing together lists rows or columns. Grouping days into a
Animated GIF support is coming (finally!) to Microsoft Word, Excel and PowerPoint. We discovered the new feature in a new Insiders build, Microsoft hasn’t announced anything. Here’s an animated GIF playing in Word 365. Paste or Insert an animated GIF now has play/pause buttons included (bottom left corner). The animation
Money in Excel shows up on the Home tab once you’ve opened the Microsoft template. Here’s how to remove its button from the ribbon or completely remove the add-in from Excel. As soon as you open and use Money in Excel, it adds itself to the Home tab on the
Microsoft has gone public with their Money Excel template to import and manage financial transactions from bank accounts. There are some undocumented tricks available and an important security recommendation that Microsoft overlooks. Money in Excel can import transaction details (US bank accounts only) and show current balances. And convert that
The latest global exchange rates can go directly into Excel 365 for Windows and Mac. No plugins or extras are necessary because it’s in Excel 365 though it’s hiding away. Foreign exchange rates are part of the Stock data type. They weren’t part of the original Stocks data feed but
Some useful new features have now been rolled out to the public versions of Microsoft 365 (Office 365) for May 2020. Word, Excel, PowerPoint and Outlook all have improvements. Two we’ve already told you about, the other is new. Stock Images, Cutout People and Stickers Or what Microsoft calls “New
If you’ve lost or accidently deleted a Word for Mac document (or Excel or PowerPoint) there are various places to look for it some might not occur to you. This article is also helpful if you’re trying to find and delete any files or documents that must be removed for
‘Tell me’ help box is now in Microsoft/Office 365 for Mac as a way to find features on the ribbon. However it continues to have the same limitations that are in the Windows version. Look for the lightbulb and ‘Tell me’ box beside the ribbon tabs. Type in a phrase
Microsoft Excel is the perfect tool to analyze and rank your fantasy football ranking. This article explains how to import players, other rankings and add your own opinion. How to Build Your Own Fantasy Football Rankings “There is no reason to re-invent the wheel by typing out all of the
Word, Excel and PowerPoint 365 for Windows are getting better control over what appears on the new-style Save dialog. Folders can be ‘pinned’ to always be show up in the list and a quick way to share a document. But a major annoyance remains unchanged. On the ‘Save this file’
