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. …
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. …
How to “Flip” or Transpose Data in Microsoft Excel
Have you ever typed data into an Excel worksheet only to realise that rather than going across the sheet you should have gone down or vica versa? It’s easy to do, we are under so much time pressure to get things done. Rather than have to retype your data, Excel has a feature that enables you to quickly and easily flip or transpose your data to save you having to retype it! Watch this video to see how easy it is! If you found this tip useful why not subscribe to my YouTube channel by clicking the subscribe button below. …
Dependency Trap!
When looking for information most people want an easy fix or quick answer so they can move on with what’s next on their to-do list for the day. If you have ever been out of the office for a day sick or on leave, you may have returned to emails from colleagues asking questions. As you scroll up the list of emails, it is possible you may find an email back from them to say they found the answer they needed. For many if you can’t find the answers immediately, the approach has become, do one of three things: Physically …
Make it Simple & Easy
Starting a new role there is generally some sort of induction. A number of years ago as a contract trainer I worked with a global consultancy firm training graduates starting with the business and experienced new hires in the organization’s use of email and database management with Lotus Notes. Graduates were taken through a full day program and experienced new hires a half day. The investment of both money and time was made in ensuring these new staff members had a strong understanding of how the infrastructure was used in the organization. These days, when a new employee starts, they …
The grass isn’t greener on the other side.
A few years ago, I was lucky enough to be able to see Jerry Seinfeld perform a live set in a small theatre in the Upper West Side of Manhattan, New York City. He had so many wonderful stories, insights and anecdotes. Whilst I laughed loud at the time, and was blown away by his ability to observe and craft a story, I struggle to remember more than a couple of stories he mentioned. Cognitive Psychologist George A. Miller created what is known as Miller’s Law. Miller’s Law is commonly understood to mean that in our short term memory, on …
How are you viewing technology?
A recent insights podcast from McKinsey (In Conversation: The CEO’s new technology agenda) highlights the change in how organizations are or should be viewing IT right now. Technology enabled organizations to quickly shift gears as staff were sent home to work. A spotlight was shined on the adequacy, or inadequacy, of the business capability during this time. For some clients there was a mad scramble for funding to purchase laptops to enable desktop bound staff to work from home. For others it was a much easier transition, staff were already mobile with laptops or multipurpose devices such as Surface Pro’s. …
