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
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
Type the Pound Sterling £ currency symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. £ symbol is easy on a UK keyboard but for other keyboards there’s no specific key for Pound. Pound is used for British Pounds Sterling and also
Samsung phones have a hidden service which is slowing down Microsoft Office apps including the mobile apps for Word, Excel, PowerPoint, Outlook and the Office ‘all in one’ app. Inside some of the new S22 Galaxy smartphones is a Games Optimization Service, or GOS. Cynical techies know to be wary
Now you can see on the status bar if there’s accessibility problems as you work with your Word, Excel or Powerpoint documents. Tucked away on the Accessibility Pane is a option to run the accessibility checker as you work, instead of only on request. Keep accessibility checker running while I
Here’s a simple way to redact cells in an Excel worksheet. There’s no direct redaction tool for Excel to match the Microsoft derived Word Redaction Tool. What are the alternatives? Editing the worksheet Copy the worksheet then carefully edit it to remove the private content. Make sure you remove data,
Find and add the Ukraine flag or national colors into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. Ukraine Flag Image There are many, many copies of the Ukraine flag available. We’ve opted for the Wikipedia site because it has an SVG scalable version (preferred)
Excel is getting even more help to write formulas, look out for Argument Assistance coming to Excel on the web and hopefully beyond that. Argument Assistance won’t solve loud disputes with your partner, boss or that annoying guy on the bus. It’s a larger panel to guide people through completing
Excel has an Accessibility Ribbon to help you make changes to ensure that worksheets are easier for people with disabilities to read and edit. For some time, there’s been a Check Accessibility feature on the Excel Review tab. That opens a side-pane with suggestions for improving the worksheet. Go to
Insert the Black Chess King ♚ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Black Chess King ♚symbol is useful for users that want to represent the chess piece as a symbol, rather than an image. Or perhaps as general symbol of
