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 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. …
Why don’t we….
Binge watching means watching multiple programs, usually TV or a streaming service, in rapid succession. Something many might do if you are home sick, staying indoors in the winter or more recently when in lockdown as a result of COVID-19. Find the right show and you can whittle away hours of time in the story arc of the various characters. When it comes to professional development, we do not tend to do a lot of binge watching or learning, other than the traditional two- or three-day style conference with multiple keynote speakers and breakout rooms. However, things could change as …
Time Out
I often get my best ideas when I am out walking, exercising or just relaxing. Sometimes this irritates me, because I often want the idea when I need it and get frustrated when it doesn’t come to me straight away. I know that when I take time to step away from what I am doing to do something else, then come back, I often see it with fresh eyes. In 2012, Jason Fried, Co-Founder of what was then 37signals, but is now known as Basecamp Project Management & Team Communication software in an INC article, shared the idea of giving …
Why do we over use technology?
Is it because it’s easy? We tick a metaphorical box and move onto the next thing making actioning or responding to what we’ve just sent now someone else’s problem. The electronic equivalent of ‘passing the buck’ I think it’s time to challenge the way we do things because that’s the way we’ve always done them. We used to fax things now we email them it’s faster, more cost effective and provided the ability to send one to many. But just because we have the technology doesn’t mean we HAVE to use it for everything. When was the last time you …
Drowning in Data?
According to Harvard Business Review’s The Workplace Evolution Pulse Survey1 “Employees are often either drowning in data and content or don’t know where to find it. In a large organization, knowledge may be hidden in hundreds of different systems or emails or documents.” Whilst enterprise collaboration tools such as Microsoft Teams, Slack or Asana help containerise content, unless staff know, and are regularly reminded, where to look, they will continue to lose hundreds of hours looking for the information they need. When one of our clients first purchased access to our on-line knowledge bank of resources, their intent was …
Productivity Bahamas Style
I joke in my presentations about Productivity, Bahamas style. I use it in the context of the volume of work we deal with in today’s business world and what happens when we have a pleasurable deadline looming. Productivity Bahamas style is the ability we miraculously acquire prior to going on a holiday. It is the ability to easily determine the MUST be done before you leave tasks and activities and isolate those that can wait until your return. But what if we applied it every day? When working with clients I often hear of processes that staff do a certain …
The Power of Internal Knowledge
After completing an in-house workshop for a client, I conducted a number of one on one and small group trouble shooting sessions. In one session, a manager and his two team members came along with a spreadsheet they were working on. Currently, to calculate the priority of various works based on dates and a grading criterion, they did manual calculations. Although they knew there must be a more efficient way, they were hamstrung by lack of time and lack of availability to sit down together and consider and explore ideas. Having a metaphorical “line in the sand” in the form …
Respect
It’s natural walking on the street or driving a car to be respectful of those around us. We keep left or right, depending on what part of the world we are in. This respect ensures that most of the time we know what to expect. When working with teams, I often meet staff who express frustration when their everyday programs change or don’t do what they expect them. For better or worse technology is here to stay. Realistically our everyday technology is simply hardware or software designed to fast track tasks in our lives and increase our efficiency so we …
