Quick stock price analysis and charts with Excel StockHistory()
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 Currency data types but they […]
Useful tricks hide in the new look Office.com
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 a non-consumer Microsoft account. Choose […]
White Chess King ♔ symbol in Word, Excel, PowerPoint and Outlook
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 Black Chess King ♚ symbol […]
Four ways to split date into day month year in Excel
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 functions Using Text to Columns […]
Eye of Horus 𓂀 symbol in Word, Excel, PowerPoint, and Outlook
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 by Hathor, symbolizing the process […]
Google Sheets gets 10 million cells, not enough to beat Excel
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 17 million cells Since Excel […]
Free color selector in your browser
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 and RGB color codes are […]
Better ways to add date lists in Excel
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 bottom right corner and a […]
Fancy gridlines to make Excel look great or at least different.
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 in comparison to the default […]
Free and secure conversion of .doc .xls or .ppt to the newer Office formats
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 new document formats are much […]
Life Saving use for a collaborative spreadsheet
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 overwhelmed so it was left […]
More powerful Excel Autofill using Series
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 the reason, some people may […]
Pound £ symbol in Word, Excel, PowerPoint and Outlook
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 other ‘pound’ currencies like the […]
Latest Samsung phones degrade Microsoft Office
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 about anything labelled ‘Optimization’ because […]
Check Accessibility problems as you work in Word, Excel and PowerPoint
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 work Turning this on doesn’t […]
Redacting Excel worksheet
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, not just obscure it. Select […]
