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 …
Making Bigger Promises to Scarier People in Business – Jennifer Einolf
It’s easy to roll along in life and get by. Being productive and living a life that has meaning for you often means stepping outside our comfort zone and challenging ourselves to become the person we want to be. Often gaining the clarity to see what’s next can be hard when you are “sitting” in your life. In this episode I chat with Clarity Coach, Jennifer Einolf. Jennifer is a Newfield Network trained Ontological coach (listen in to find out EXACTLY what that is) who loves working with clients through her Prospects of Possibility transformation keys to help clients realise …
Trust in Turmolic Times – David Penglase
Trust in relationships is vital. Not having trust makes relationships, of any type, at best challenging, at worst impossible! With the change our world experienced in 2020 as a result of COVID-19 the need for trust in business and life relationships has skyrocketed. When our relationships lack trust, our productivity reduces in all areas of life as we evaluate what is happening around us and take time to consider the impact of choices and decisions. In this episode I chat with Behavioural Scientist, speaker, educator and author David Penglase about how we build trust in these turmolic times. Transcription Donna …
Dealing with Trauma & Stress in a Pandemic – Christi Garner
In March 2020 the world as we knew it changed forever when we were hit with the COVID-19 pandemic. The trauma of something unlike anything experienced in our lifetime and the stress of working about family, work and safety has weighed heavily on people’s minds. Whilst navigating our way out is a slow process, dealing with the trauma and stress is likely to be an ongoing issue. When we are stress or traumatised, we are generally no were near as productive as we would like to be in ANY part of our lives. In this episode I speak with Christi …
The Impact of Healthier Food Choices in Corporate Environments – Barbara Baron
You may not make the connection between food and productivity, but the link is important. Food is our body’s fuel and making the right choices has a HUGE impact on your energy and concentration throughout the day. Understanding how to make good food choices sets up your energy and maximum productivity and enables you to focus on getting important things done. Barbara Baron is a registered Dietitian Nutritionist who works with organizations to help educate employees on the benefits of healthier food choices. Barbara is a former president of the New York State Academy of Nutrition and Dietetics and a …
