Small Business financial Excel templates
If you’re running a small business and want to explore your finances better, there’s a site with Excel templates to try. http://bizexceltemplates.com/shop/ some are free and others have a charge. Among the free Excel templates are: Checkbook register Markup Calculator Buy or replace Business Growth Potential Internal valuation of business strength Profitability versus Liquidity Project […]
Office 2016 for Windows updates for July 2018
Here’s a list of the non-security aka bug fix updates to Office 2016 for Windows, released for July 2018. These updates should come to you automatically via Microsoft Update or you can patch individually from the links provided. Here’s Microsoft’s list with their explanation of each update. Office 2016 Excel 2016 KB4022229 “Assume that you […]
Office 2013 and Office 2010 updates for July 2018
Just a few non-security or bug fix updates for Office 2013 for Windows and Office 2010 for Windows. These updates should come to you automatically via Microsoft Update or you can patch individually from the links provided. Here’s Microsoft’s list with their explanation of each update. Office 2013 Excel 2013 KB4022244 “Assume that you copy […]
Tracking attendance with QR codes and Excel
A clever use of Excel is at the end of a paperless class attendance system used by a Filipino teacher. Michael Angelo posted on Facebook how he’s switched to a paperless system for his classes. The same system can be used for classes, one-off events or even to track physical items on loan. All the […]
Degree symbol in Word, Excel and PowerPoint
How to type the degree symbol (Fahrenheit, Celsius, Kelvin, latitude, longitude) into Microsoft Word, Excel or PowerPoint. Degree Symbol codes Decimal: 176 Hex: 00B0 Web: ° ° ° Word The degree symbol ° has an inbuilt shortcut in Word. Ctrl + @ or Ctrl + Shift + 2 followed by a space will enter a […]
14 year old is US National Excel Champion
Think you know Excel? A 14 year old high school student from Florida has beaten 350,000 contestants and 147 finalists to be become the 2018 US National Excel Champion. Kevin Dimaculangan from Dunbar High School is now going to the World Championships in Orlando, Florida at the end of July. His win is even more impressive for […]
Single line ribbon in Microsoft Office for students only
A new Office ‘Garage’ option is ‘Student Tools’ an extra ribbon featuring the tools Microsoft thinks are most appropriate for students. It’s only available to students in USA, Australia or New Zealand for Office 365 for Windows or Office 2016 ProPlus. Word Student Tool Garage is where Microsoft tries out plug-ins and features. Dictation started […]
Office Online: The main ribbon and other tricks
Office Online is a slimmed down version of Word for Windows or Mac. What’s possible in a browser interface is impressive from a technical point of view but it will never compete with Word for Windows or even Word for Mac. Anyone familiar with Office for Mac or Windows should be able to use the […]
Your free and standby Microsoft Office alternative: Office Online
Word, Excel, PowerPoint and OneNote are always available for you, even if the main Office for Window/Mac are broken or missing. Office Online is the alternative that you have as a standby when regular Office fails or isn’t available. As long as you have a browser and decent Internet connection, you can use Word Online, […]
Access: Persistence of Reference Problems
Back in 2002 I wrote an Access Archon article dealing with reference issues, among them the problem of certain references being upgraded when a database is opened in a higher version of Access, but not downgraded when it is again opened in a lower version. You might think that over the last 16 years Microsoft […]
Why Javascript support in Excel is both a big deal and little concerning
The news that Microsoft is adding Javascript support to Excel is important for developers and regular Excel user, but also a security concern. Javascript is a programming language that’s used on many web pages to provide the fast interaction we’re used to. Javascript is able to get data from external sources and display in Excel […]
Fixing dates in Excel’s Stock data type
Here’s how to convert the Last Trade time in Excel’s Stock data type into an Excel date/time that’s usable in other parts of Excel. UPDATE: near the end of September 2018, the Last Trade Time date format changed to an Excel serial date. No conversion or text parsing necessary. So this tip isn’t necessary any […]
Check out the new look ribbon coming to Office for Windows
For the first time in a decade, Microsoft is making substantial changes to the Office ribbon interface. But not to worry, the changes don’t appear to be enough to put anyone off Word, Excel, PowerPoint or Outlook. The existing ribbon is retained, that’s an important point that’s not emphasized enough in the leaked Microsoft video. […]
Get historical stock price data into Excel
Modern Excel can grab information from multiple files in a single folder. Just open the worksheet, refresh the query and it’s up to date! This article is a condensed version of just one chapter in Real Time Excel – the new 2nd edition has a lot more detail and example files ready to use. […]
June 2018 updates for Microsoft Office 2016 and Office 2013
As usual, Microsoft has released non-security updates and bug fixes for Office 2016 and Office 2013 on the first Tuesday of the month. A few caught our eye: Late last year, Microsoft was caught out leaving a horribly vulnerable Equation Editor in Office for 17 years. A new patch restores the MT Extra font so […]
Indian Banks drop Microsoft Office, revert to calculators
Two Indian banks clamped down use of unlicensed Microsoft Office, leaving staff to use calculators or open-source alternative spreadsheets. Mid-Day.com reported that Bank of India and Saraswat Bank had some licenses for Microsoft Office but not enough for all the computers the bank had allocated to staff. Branches were instructed to uninstall Office from many […]
