How to Easily Create a Graph or Chart in Microsoft Excel
How to easily create a graph or chart in Microsoft Excel. They say a picture is worth a thousand words. Graphs can be particularly challenging, but with a few little tips, a visual representation of your Excel data can totally change how your reader understands and analyzes the information you are presenting. When I work with executives and their teams, this simple tip can save them hours of stress and frustration, particularly when they need to create a graph minutes before going into a client pitch or board meeting. Whilst this tip will cover creating a simple graph, for one …
How to Send an Individual Microsoft Excel Worksheet
How to send an individual Microsoft Excel worksheet. Whilst working with an executive, he told me that when he needed to send one of his team an individual worksheet of their monthly sales, he saved the existing file with a new name, deleted all the tabs he didn’t want them to see, saved it, then sent it. When I showed him how to send an individual Microsoft Excel worksheet, without having to save it, it was a D’oh moment! Sometimes we get so caught up in what we are doing that we make things harder than they need to be …
How to Copy Worksheets in Microsoft Excel
How to copy worksheets in Microsoft Excel. Firstly, let’s provide some context around how you might use this in a real life environment. For example, you have the same data on multiple worksheets that represents a week or a month. When I mention copying and pasting I metaphorically see those perceiving themselves as “more advanced” with Excel rolling their eyes expecting a lecture reminiscent of a school teacher telling students to click here, then there, but never actually understanding what or why they are doing something. Reality is, sometimes with Excel we expect things to be complicated not simple. I’ve …
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 …
How to easily separate a single worksheet in Excel to email.
Don’t laugh, but I’ve worked with a client where they want to send a single worksheet in a file to a colleague. They would do a “Save As” and delete what they didn’t want their colleague to see. Whilst it does the trick, it’s not the most efficient or effective way to do it. In this video I share how to separate a SINGLE worksheet from an Excel file so you can easily send just that one worksheet to someone rather than ALL the data in the file. Take a look…. Like this tip? Get more by signing up for …
How to calculate the number of days between two dates
For some reason, many Microsoft Excel users think calculating the difference between two dates is difficult. It’s not when you understand a couple of tricks. Take a look at how to quickly and easily calculate the difference between two dates in Excel. Like this tip? Subscribe to my channel by clicking the link below or check out short course on How to Simplify Data Analysis in Microsoft Excel. Click here to find out more. …
How to save time and frustration with Microsoft Word tables
If you’ve ever inserted a table only to find you waste ages trying to resize the column widths, get the exact size you need or get the headings onto the next page? It can be so frustrating right? When I present at a conference or internal workshop, when I show people how easy it can be to work with tables they get so excited and so do I! Take a look at how easy it is to do when you know how! Sometimes it is simple things that can make all working with programs such as Microsoft Word easier. If …
How to automatically insert text in multiple parts of a Word document
As a corporate workplace trainer, I am often asked how to insert the same text in multiple parts of a document. So often we create a document inserting a piece of text, only to find we have to type it in again somewhere else. Wouldn’t it be so much easier if you typed it in in ONE place and it automatically populated elsewhere??? Watch this video to see how. Like this tip? Take a look at my short course on How to Create Professional Documents in Microsoft Word. Click here for more information. …
