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
Type the White or outline Chess King ā into Microsoft Word, Excel, PowerPoint or Outlook.Ā Both in Office for Windows and Office for Mac. White Chess King ā symbol is useful for users that want to represent the chess piece as a symbol, rather than an image.Ā There’s also a
If youāve ever needed to split dates in Excel into separate day, month, and year, there are several options to choose from. Excel has different functions, Text to Columns or Flash Fill which can do the job. Hereās a quick guide on several methods: Using the DAY, MONTH and YEAR
Insert the Eye of Horus š into Microsoft Word, Excel, PowerPoint or Outlook.Ā Both in Office for Windows and Office for Mac. Eye of Horus š is an Egyptian Hieroglyph symbolizing protection. According to Egyptian myth, Horus lost his left eye during his struggle with Seth, and it was restored
Google has just doubled the cells available in their Sheets spreadsheet, taking it to 10 million cells. Still well short of Excelās 17 million cells. Sheets can now stretch to 18,278 columns (column ZZZ) for all Google Workspace customers, as well as legacy G Suite Basic and Business customers. Excel has
Google has a color selector among the many features in their home page. It’s free, works in any browser and it’s easy to copy color codes into Office. Search for ‘Color picker’ or https://www.google.com/?q=color+picker then move the two circles to choose the exact color and shade you want. The HEX
Excel has ways to add a list of dates by day, weekday, month or year either by the fill handle or the Series command. Date Series with Fill Handle You probably know about the Fill handle tool to fill the remaining cells. Once highlighted, just hover your mouse in the
Gridlines are on every spreadsheet in Microsoft Excel workbooks. Did you know those grey lines can be colored to make them fancy, more obvious or more discreet? Let’s look at two ways you can make colored gridlines in Excel. Hereās what it looks like with the pink, black and red
Here’s how to convert an older .doc .xls or .ppt into a safer and smaller .docx .xlsx .pptx even if you don’t have Microsoft Office. Any smart computer user is wary of documents received in the old .doc .xls .ppt formats because they are regularly used to transmit viruses. The
Spreadsheets arenāt just for numbers and money, they can also be used to save lives when saved online and collaborating with other people. Lismore is northern NSW, Australia has been struck with massive floods leaving many people stranded in their homes, some trapped against rising waters. The emergency services were
Flash Fill is a simple way to split and join text automatically in Excel for Windows or Mac. Flash Fill was added in Excel 2013 for Windows. It’s both useful and looks good in the demonstrations. In Excel there’s often need to join, separate or reformat strings of text. Flash
Microsoft Excel Series allows users to automatically insert a list or series of values. You probably know the easy ādrag and dropā method but thereās a lot more possible with linear, growth, dates and autofill. All possible with the fill handle or with more control via the Series dialog. Whatever
