Baskerville has been decreed the most persuasive font after an experiment by Errol Morris and the New York Times. Happily, a very similar font is available to all Microsoft Office for Windows users. In an interview in Fast Company, Errol Morris talks about the experiment where people were asked to
Get started and understand Microsoft’s Power BI using the free desktop app. Here’s how to setup Power BI and some of its nifty tricks to delve into and make sense of data. All without the hassle of a ‘free’ trial. With plenty of buzzwords such as data-driven culture, business intelligence,
Excel Mobile’s Data from Picture has one big problem, it can’t figure out what’s intended to be in one cell and puts text in many cells. Cell discernment is Data from Picture’s biggest weakness and the Review process makes it hard to fix those problems. For example, text using Excel’s
Microsoft will be removing Excel’s Money template from Microsoft 365 Personal and Family subscriptions on June 30, 2023. Here’s details on what’s happening to your data and an alternative with a free trial. Ending the Money template is just one of three features being dropped from Microsoft 365 in mid-2023.
Any Excel worksheet that has lists with headings on the top row can quickly get pull-down menus to filter or sort the data. For a regular Excel worksheet, go to the Data tab and click the Filter button. This adds extra pull-down menus to each of the headings. For an
You can translate a Pantone PMS code or name into something Microsoft Office; Word, Excel or PowerPoint understands? Sometimes you’re given a specific color using the Pantone color scheme. Most commonly this happens for a corporate logo. The Ford car company specifies ‘PMS 294C’ for their blue logo. McDonald’s uses
Thumbs Down or Dislike 👎 can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Thumbs Down symbol 👎 or emoji is used to suggest disapproval or dislike. Partnered against Thumbs Up / Like 👍 symbol. How Thumbs Down Sign 👎
All you need is a birth date or starting date and Excel can figure out the age, next birthday, days to next birthday or when you reach a milestone like 10,000 or 15,000 days. That’s just some clever tricks with DateDif(). How old is someone or something? To calculate the
Here’s a quick look at some of the modest Excel tricks we used to make the Schengen Visa Calculation worksheet. Table Making the itinerary list an Excel Table lets us make use of some features. Formatting It’s a lot easier to format as a table with banded rows. We’ve turned
Sometimes you need to convert a date from the Excel cell saved format to a particular format. There are at least five ways to do that. DateValue(), Date() or converting Unix dates to Excel. Simply typing dates into a cell also works but there are traps for the unwary. Excel’s
Another way to convert text to dates is by adding zero to the text. This is a trick which forces Excel to convert the text into an Excel value so it can then add the zero. Since adding zero doesn’t change the value, you end up with text converted to
Excel has some nifty and simple options for color highlights the extremes in a list of values. It’s called Conditional Formatting and you can do all sorts of clever things with it. First let’s look at the simple presets that Microsoft has given us, some of the obvious choices they’ve
An IF statement might sound like a complicated thing that programmers do, but it’s actually fairly easy to do in Excel. An IF statement basically puts something into a cell depending on certain conditions – if A is true, put X in this cell. You can even use what’s called a nested
It’s now possible to make an Excel PivotTable directly from PowerBI data in Excel 365 for Windows and Excel on the web. Microsoft PowerBI is a cloud-based data accumulation then reporting and visualization (dashboards etc). BI stands for “Business Intelligence”. PowerBI is a separately licensed product for businesses so it’s
Type the fun Otter 🦦 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Otter 🦦 emoji represents a light-brown otter (a member of the weasel family) on its back with its paws held together. But the emoji can just be used
Excel doesn’t automatically number lists but there are at least six ways to add numbering depending on your needs and how the list appears. Numbering is important but can be annoying when you’ve got a large dataset. If it’s small, it’s easy to number it manually or by an auto-filling
Add the Duck 🦆 emoji into Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Duck 🦆 emoji represents the quacky bird with webbed feet. The emoji is usually depicted as a Mallard. Sometimes used as a substitute for the f-word, because of iPhone’s tendency
Excel 365 for Windows is getting three performance boosts that you might not notice but speed up your work on less powerful computers. All these Excel 365 for Windows tweaks are designed for what Microsoft politely calls “resource-constrained devices”. That means: CPUs with two cores or less 8GB of RAM
Office apps in a browser have caught up with an important feature in Office 365 for Windows – quick account switching is now available. Almost three years ago, Microsoft added quick account switching to Office 365 for Windows. You can save logins to several Microsoft 365 accounts; work, school, home
Like Word, PowerPoint and Excel also have options to add borders to pictures to add that extra oomph to your work. Users can choose between fairly simple borders or add some further complex, fancy styles to their images. If all this seems very familiar, it’s because the same picture tools
Type the Grinning Cat with Smiling Eyes 😸 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Grinning Cat with Smiling Eyes 😸 emoji is a variant of the grinning face emoji or the cat face emoji, which is yellow on most
The Windows Emoji Panel has its problems which are amply demonstrated by a common symbol that’s hiding in the long symbol lists – the Pi symbol 𝜋 . We’ll explain where it’s hiding and generally grumble about this part of Windows 11 and 10. The Emoji Panel is in Windows
If Microsoft 365 (Word, Excel, PowerPoint, Outlook) is misbehaving, try the Repair option. If that’s also causing trouble, there’s a hidden command prompt option. For any ‘Click to Run’ installations of Office for Windows (mostly Microsoft 365, Office 2019) there are Repair options available to fix common problems. Among these
At long last, Excel v4 macros are being blocked from running in Excel 365 by default. A move that greatly reduces the security risk from infected attachments in Excel 365 and Excel 2021. Excel v4 macros are a very old form of programming, literally 30 years old. It allowed macros
