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 “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. …
Are you attached??
For many, the pandemic and connectivity meant a sense of being more attached to our workplaces given our home life and work life became so intertwined. We adjusted as best we could to the situation we found ourselves in, but for many it created expectations that may not be in our best interests moving forward. Great to see this article from ABC News Australia about disconnecting from workday technology. When expectations aren’t clear, people make assumptions. It’s important moving forward that organisations and teams are clear about workplace boundaries. What are the expectations in your workplace? When working with an …
Stop sending, start talking
One of the challenges facing businesses today is the sheer volume of e-mail we send and receive and dealing with it. It’s easy to send an email asking a question to get something off our to do list and into someone else’s, but it does two things. It creates more work for you AND the receiver. They have to deal with your request in some way, even if it’s just reading it, and you have to ‘pick up’ the conversation when you get the reply. It stretches the response time. Unless the other person has their email open waiting for …