In Excel there are various ways to either protect sheets or cells from access, make a them read-only or totally encrypt the workbook with a strong password. It’s important to understand the difference in Excel between Protect and the stronger Encrypt feature. Excel’s password protection is more complicated than in Word or PowerPoint because there […]
Keep a close eye on the increase/decrease decimals buttons on the Excel ribbon because Microsoft has changed them for one version of Excel. Increase / decrease decimals is a very common Excel feature to change the visible accuracy of a number. For example, choosing Currency or Accounting style (which defaults to two decimal places / […]
Protecting an important Excel worksheet from careless editing, or allowing only specific cells to be modified is all part of a powerful and highly flexible feature in Microsoft Excel known collectively as “Protect”. It’s been there for a long time but is little understood, so we’ll do our humble best to fix that. The idea […]
The new Copilot() function can be great for taking disorganized data like feedback from people and grouping it quickly. We’ll explain the best ways to do that and the pitfalls of relying on AI. One of Microsoft’s examples for Excel 365’s Copilot(() caught our eye and we were pleasantly surprised when we extended their example. […]
Last Monday into Tuesday there was a serious outage that affected Outlook for Windows users. It shows how a failure on Microsoft’s server can stop new Outlook software from working at all. About 5% of global Outlook for Windows customers were unable to open the new Outlook desktop client on Windows devices for up to […]