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 …
How to get more done at work
As a speaker, trainer, and educator in Microsoft Office programs my clients regularly ask how to get more done at work. Whilst I can’t magically produce extra hours in a day, this simple tip, depending on how many meetings you have each week, could easily save you an hour or more! Change the length of your meetings. Sounds simple and it can be…here’s why. Meetings have generally been set at a default 60 minutes long.Parkinson’s Law states that the amount of work expands to fill the available time. So, if a face-to-face meeting is scheduled for 60 minutes, generally it …
5 reasons why people aren’t responding to your emails and what to do about it
As a Microsoft Office productivity speaker, trainer and course creator, I’ve worked with businesses in all industries, and I’m often asked, “Why don’t people respond to my emails?” Although there are many reasons, here are five of the most common reasons I have found as to why people may NOT respond to your emails and, more importantly, what to do about it! If you want to get more productive with Microsoft Outlook or any of the Microsoft 365 Core 4 (Excel, Word, Outlook or PowerPoint), subscribe to my regular eNewsletter and also a receive a copy of my 39 Microsoft …
How to Freeze Column or Row Headings in a Microsoft Excel Worksheet
How to freeze column or row headings in a Microsoft Excel worksheet. When preparing to work with a firm of accountants I conducted our standard pre-session survey which enables us to customize programs to focus on the ideas and strategies that will enable those attending to fast track their productivity. One of the questions I asked was “What is the 1 thing that if you knew it, understood it or felt it would make attending this session valuable to you?” The response surprised me. The attendee simply wanted to know to freeze column or row headings in a Microsoft Excel …
How to Change the Same Cell on Multiple Microsoft Excel Worksheets
How to change the same cell on multiple Microsoft Excel worksheet. Many of the executives and teams I work with have spreadsheets where data is the same across multiple worksheets. At times there are changes that need to be made on every single worksheet. If there is only one or two, that’s easy, but if you have 10, 12 or more it can be time consuming. The next tip enables you to make global changes in your worksheet to the same cell in every worksheet selected. This has proved extremely useful for clients who want to duplicate a file for …
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 …
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. …
