Australian data nerds rejoice! The first load of data from the 2021 Census has been released in a format ready for Excel. Here’s how to get it and look at the detailed statistics for yourself. The Australian Bureau of Statistics has just released the first block of data from the
Microsoft 365 Business and Business Premium customers are getting hit with 10-20% price rises. There are a few things you can do to reduce your Microsoft bill, but not a lot. The price of Microsoft 365 Business and Business Premium rose in March 2022. As the renewal time gets close,
Insert the Triangular Flag 🚩 emoji into Microsoft Word, Excel, PowerPoint or Outlook. There are two different looks and plenty of colors to choose from, not just the Red Flag default. Triangular Flag 🚩 emoji is usually used to warn people of bad ideas or problems or refer to unsafe/dangerous
A welcome sight for Microsoft Office 365 users is the return of an offline installation method. Microsoft pushes their standard ‘Click to Run’ install. The first download is a very small installer. When you run that program, the rest of Office is downloaded for you. Microsoft pushed the virtues of
Reasons why a Word document or email can look different on one computer than another device and what you can do get ‘fidelity’ or the same look across many machines. In short – you can’t assume that what you see is the same as someone else. You get a document
Here’s another example of a seemingly simple Office feature that has hidden depths – Highlighting. For a long time, there’s been a highlight option in Office: Word, Excel, Outlook and even PowerPoint (albeit in a different form). They vary a little in each program so this article will go through
Empty or unwanted pages just after a Word table are especially annoying. Trying to select anything after the table can be difficult unless you know the tricks. Here’s the common problem in Word. A table goes to the end of a document or section but another empty page is added.
Let’s take a moment to see where customers stand with Dark Mode options in Microsoft Office in Windows, Mac, iPhone, iPad, Android and web. It’s easy to get confused about Microsoft 365 and Office 2021 dark mode or theme options. Microsoft has announced ‘dark’ developments so many times it’s hard
Dictate has yet another addition in Microsoft Word. You can now dictate comments when reviewing a document in Word as well as dictating into the document itself. Look for a little microphone icon in the comment entry box. Some people may find it particularly handy. Others might not use it
More details on the image insert or linked options in Office, Word documents and Outlook emails. We’ve already talked about the three options available for documents; Insert, ‘Link to File’ and ‘Insert and Link’. Insert adds a copy of the image into the document Link displays the current external picture
There are three different ways to add an image into a Word document or Outlook email. Insert is the most common but there’s also Link or Insert and Link ” When I make a web page I can link to any image on the Internet. In Word, it’s different. You
Here’s how to make Outlook Contact Groups work with both CC and BCC’s as well. Outlook Contact Groups are a way to combine a list of contacts under a single name. They are often used in business but are also useful for individuals or families. For example groups like: ‘Regional
There are at least eight ways to share an entire calendar or individual appointment in Outlook software. Sharing can be ‘live’ and connected. Any changes or updates to the event or calendar are automatically sent to everyone sharing. Or it can be a ‘one-off’ item. A special attachment which is
How to type the Cent symbol ¢ into Microsoft Word, Excel, PowerPoint or Outlook plus any Windows program. Cent ¢ shortcut Word and Outlook The Cent ¢ symbol has an inbuilt shortcut in Word and Outlook: Ctrl + /, C Hold down the Ctrl key while pressing / then type
Adding comments to Microsoft Word documents isn’t just for groups, use them yourself for your own reminders and side-comments while you’re working on a doc. Word has a feature to let you add ‘side’ comments to documents – comments that don’t show up in the final document, don’t effect the
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,
What causes blank spaces in the Word navigation pane and how to fix them. The Navigation Pane in Word shows the Headings in a document but sometimes has the unexpected. Blank lines or text not in a heading. But sometimes blank spaces appear, like between London and Paris above. Why
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
Here’s the full and searchable list of Word 365 Dictation special phrases, in English. Saying any of these phrases converts the words spoken into the symbol or does a Word command. For example, say “Full Stop” and . appears in the document. Say “Dollar sign” and get $ . Say
Insert the Checkered Flag 🏁 into Microsoft Word, Excel, PowerPoint or Outlook. Plus other alternatives available in modern Microsoft Office like icons or stock images. As its name suggests, the Checkered Flag emoji 🏁 shows a flag with a black-and-white checkerboard pattern. It’s often used to represent vehicle racing, challenges,
How to run administration commands via PowerShell for Microsoft 365 hosting and especially Microsoft 365 Exchange Server or mailbox hosting. Microsoft 365 customers will often see instructions like this to configure their Exchange Server mailboxes using PowerShell. Set-OrganizationConfig -AllowPlusAddressInRecipients $true Looks simple, but that command alone won’t work in PowerShell
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
