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
How to insert the Rainbow 🌈 into Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Rainbow 🌈 emoji depicts a colorful arc of a rainbow, usually used to express positivity, hope, good fortune. The rainbow flag was designed and has been adopted by
If you thought dividing one number by another was simple, think again. Excel has five different ways to divide numbers and we’ll explain them all. Basic Division Obviously, there is the basic concept of division in Excel using / in a formula. Like in Excel we can use the formula
Type the OK Hand sign 👌 into Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. OK Hand sign 👌 emoji is mostly used to symbolize approval, agreement, all that is well but there are other meanings. Scuba Divers use 👌 hand sign to
Excel Sheet View is Microsoft’s fix for a problem when sharing an Excel list or table among many people. We’ll explain how it works and what’s happening behind the scenes. A shared Excel list can be sorted or filtered in many different ways. It’s quite possible that two people can
LucidChart is a very nice diagramming and flowchart tool which is integrated with Microsoft Office for Windows or Mac. Office has diagram tools via Insert | Shapes but they aren’t very elegant. They serve for simple uses but not a lot more. LucidChart is better than the inbuilt Office diagram
How to insert the Cat Face 🐱 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Cat Face 🐱 emoji is a variant of the grinning face emoji, usually depicted as yellow on all platforms. How Cat Face 🐱 looks in different fonts.
There’s a simple way to copy a screen image into Word, PowerPoint, Excel, Outlook or OneNote. Word, PowerPoint and other Office apps for Windows (Office 2010 and later) has a Screenshot option to paste an image from any open program window into a document or email. Go to the Insert tab of
Excel 365 makes it incredibly easy to get past price and volume info for stock, fund and currency exchange data, then convert that into a professional-looking chart. Some may remember the days when stock prices were added manually from a newspaper. Now a single Excel cell formula can grab the
How to insert the Dog Face 🐶 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Aside from the obvious the Dog Face 🐶 emoji can used as a variant of the Grinning smiley face emoji. How Dog Face 🐶 looks in
How to compare caffeine levels in coffee, tea, soda and other drinks from an Excel spreadsheet. The Guardian’s Datablog has interesting analysis of caffeine levels in different foods. Sounds boring until you read that: reduced sugar colas have almost double the caffeine of a regular, sugared, cola. 1 cup of
Replacing images in Word, PowerPoint, Excel and Outlook is a lot easier using the ‘Change Picture’ option, especially now you can change to insert an image on your clipboard. We’ll show you a step by step on how to do it. There might not be one simple keyboard shortcut, but
StockHistory() is an Excel function that can add historical stock price info, as well as currency exchange rates at monthly, weekly or daily intervals. Date and Closing Price plus optionally Open, High, Low and Volume. All ready to make a chart for stock price analysis. Excel 365 has Stock and
The main Office.com page has an updated look for Business and Enterprise customers. There’s a Create pane, My Content section and Quick Access buttons plus some more useful features hiding away under obscure buttons that are easy to overlook. This is the overall Home https://office.com look if you’re logged into
