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 …
Are you effective?
I’m often asked by clients why people don’t respond to their email messages. There are many things we do in haste that mean we aren’t as effective as we could be with email communications. Here are my top 3 tips to get a response to your emails. Minimise the use of email. – Tones and body language, you normally experience in face to face conversations are lost in emails. This can result in miscommunication, frustration and delays in responses. One of the best tips I learnt when I spent 18 months delivering an email management program to Microsoft staff in …
Circle of Trust
When I ask audiences what they do when they don’t know how to do something in Excel, Word or PowerPoint, the answer I hear 99.99999% of the time is “I just Google it!” Whilst one of the benefits of technology is the volume of information available to us to answer our questions with a few keystrokes, it’s also one of its downfalls. Amongst all the data, finding the answer you need in a context that is relevant to you, can produce slim pickings. An alternative I ask my audiences to consider is the Circle of Trust concept. The Circle of …
The 4-Hour Work Week’s Concepts
Whilst Tim Ferris’ The 4 Hour Workweek book got people talking about building a business in which you work only 4 hours a week, the four steps in the book can easily be applied to help improve productivity and workflow in any business. Step 1 of the 4 Hour Work Week is D for Definition. In the context of an owner, manager or team member in any business, defining where we are going and what we need to do is important. Lewis Carroll’s, Alice in Wonderland quote of “if you don’t know where you are going, any road will get …
Holding ourselves accountable
I’m am regularly surprised by comments from staff in organisations I work with when it comes to learning and development. For some, the opportunity to learn new skills that may benefit them and make life easier is something they grab with both hands. For others it is an opportunity to complain. Complain about how the organisation never provides opportunities to learn the things they want to learn, or changes processes or technology without consulting them. Those who recognise the opportunity for what it is, AN OPPORTUNITY are prepared to hold themselves accountable. They are generally excited about the learning and …
You may already have what you need you just don’t realise it.
I work a lot inside organisations with their teams and one thing I’ve observed a lot lately is the fact that they don’t realise how much knowledge is sitting in a room and instead choose to go Google to look for answers. I was recently working with a client and we had 13 people from within organisation in one room they had all invested three hours of their time and we were working out what were the things that they needed to know, or wanted to know to make their life easier. As we had conversations and discussed different ideas, …
I wish I’d known….
I recently shared a graphic from business management platform solution provider Domo.com that visually presented the results from it’s Data Never Sleeps 2017 findings which Forbes.com quoted as being 2.5 quintillion bites of data. One of the challenges facing anyone in a leadership role is understanding and interpreting the “big data” that technology can produce. Whilst having more information at our fingertips is often presumed to be better than less, reality is if you can’t, or don’t know how to, analyse it, it really doesn’t matter. I was doing some one on one coaching with an executive in an organisation …
Making reports easy!
With so much reporting needed today, one of the challenges can be taking data in Excel and putting it into a Word report. Using a simple copy and paste is one of the most common things we see users do. But what if you need to insert larger sections of data that are landscape mode instead of Word’s traditional format, portrait?? Section breaks in Word enable you to change the layout of the page from portrait to landscape and back to portrait again. You can potentially save yourself hours of frustration in report preparation knowing this one element of Word. …
Per-fect vs Perfect
Many teams spend a lot of time crafting their client presentations or marketing materials. Liaising with the marketing and communications department, to ensuring the organisational logo is displayed in the appropriate location for brand consistency. However, rather than make our presentations perfect, I believe we should be perfecting our presentations instead. Recently I took time out to watch a documentary that has been around for awhile but I hadn’t had a chance to watch, The Comedian. It is a documentary on Netflix that follows Jerry Seinfeld and his step back into stand up comedy after the end of the successful …
Kairos and Chronos – How are you spending your time?
We often us the term quality time when talking about family and friends, but realistically, shouldn’t all our time be quality time? I recently read the book, Igniting your true purpose and passion by Robert Michael Fried. A specific paragraph got me thinking about two words in Greek that represent time. Not time in the traditional sense of a ticking clock, or quantitative time, referred to as Chronos, but Kairos, the Greek word for qualitive time. When working with managers and their teams, I regularly hear, we don’t have time for training/meetings/professional development [insert reason or excuse here]. In business, …
