How to rename worksheet tabs in Microsoft Excel
It may sound crazy, but renaming worksheet tabs in Microsoft Excel can be a game changer. Especially if you share your worksheets with others. It makes it easier to find information and simplifies the process of finding the right data quick and easy for users who may not be as experienced as you with Microsoft Excel. To see how easy it is to do and why you would do it, check out this video I put together. Get more free Microsoft 365 core four (Word, Excel, PowerPoint and Outlook) tips and shortcuts.Subscribe to my free monthly eNewsletter here. …
5 Must Know Excel Hacks
In business today we don’t have enough time to do all the things we want or need to get done, as a result we are always looking for hacks or shortcuts to fast track common tasks. Here are 5 of my favourite must know Excel hacks that are so simple you may be overlooking them and their ability to immediately improve your productivity and reduce your stress with Microsoft Excel. 1. Duplicating a Worksheet So many people copy and paste data from one excel worksheet to another only to find they lose column widths, along with any formatting such as …
Pivot Tables: Your Secret Weapon in Microsoft Excel
So many clients I work with want to know how to create complex formulas or functions to analyze large data sets in Microsoft Excel. Reality is, you don’t need to be a math genius to do this, you just need to understand a powerful tool in Microsoft Excel called Pivot Tables. When I mention pivot tables I often see eyes glaze over! Like macros, pivot tables can seem overwhelming and complex. However, when you understand what they do and Excel’s tools to make creating them EASY, enormous amounts of time can be released to do other tasks. The bonus is, …
How to Find a Previous Version of a Word Document.
Ever worked on a document only to realize that the previous version of it was much better? Most people think if you edit a document, it changes the document for good. Well it does, but if your document is saved to either OneDrive or a SharePoint library, Microsoft 365 enables you to access various versions of the document based on time and date autosave. This is a handy feature if you are working on a document but decided that you want to go back to a previous version to review it, or to simply go back to it to start …
How to Change the Color of a Worksheet Tab
Firstly, why should you change the colour of your worksheet tabs? Primarily, worksheet tab colors provide a visual cue that worksheets in an Excel file relate to each other, for example, team worksheets relating to a single department, data relating to a geographical location. Like anything in Excel, changing the color of a worksheet tab is easy when you know how. 1/ Right click on the worksheet tab you want to change the color of. 2/ Choose Tab Color 3/ Click the desired colour and the tab will change NOTE: To change multiple tabs to the same color at once, …
Comment and review Microsoft Word documents with Ease!
In older versions of Microsoft Word, collaborating on a document with colleagues was cumbersome! It required both the user and anyone contributing or editing the document an understanding of Microsoft Word’s track changes. How to switch track changes on and off and how to remove any mark ups after the collaboration process was completed. For those less experienced, it often felt easier to simply print out the document, make physical changes and pass it back to the owner, or to simply provide changes in the form of an email. With the evolution of Microsoft’s Office suite, today there are multiple …
4 Common Reasons Why Staff Training Doesn’t Work
Ever been to a computer training program only to find you learn eight topics, with generic exercises, have a great lunch but walk away none the wiser about what to do with your newfound knowledge? You aren’t alone! As a professional speaker, trainer and educator in the corporate computer productivity space for over twenty-five years, I used to facilitate those programs. Participants would arrive filled with hope that the program could be the missing piece that would make them more productive or skilled with a computer software program. The course they attended was based upon their own or their organization’s …
How to get more work done in less time
Stop Doing Things When I present Microsoft Office productivity sessions to clients staff always ask how to get more work done in less time. Everyone THINKS the way to get more done is to add more, but that often makes things worse! One more thing, to learn, manage, do or remember. Think about the start of every new year. So many people make resolutions to DO or ADD something, like lose weight or get fit. But I’m suggesting if you want to get more work done in less time, don’t ADD to your workload of tasks, try SUBTRACTING! Consider what …
How to easily create surveys or gather feedback.
I’m often asked if it is possible to create a Google Forms style form within the Microsoft suite of products. The answer is yes! It’s called, wait for it….Microsoft Forms and it is free if you have a Microsoft 365 account. You might be wondering how you might use Forms…. If you have ever wanted to survey clients or customers for their insights or gather feedback or testimonials then Microsoft Forms could be just what you need. What you need to know about Microsoft Forms Microsoft Forms isn’t a desktop program. The only way to access it is though logging …
How do I get more productive?
As a Microsoft Office productivity speaker, trainer and educator I am regularly asked how do I get more productive? One simple way is to change your email program to open in Calendar View instead of your inbox! Ever finished your workday only to feel like you haven’t got anything done? Or perhaps you have opened your email, started reading and responding only to find an hour later you are late for a meeting? If that’s the case, it’s likely you are allowing other people’s priorities, rather than your own, to drive your working day. Research on The Cost of Interrrupted …
