| |
“After years of using many versions of MS Outlook, I would have said I was very good at the program, since using Master Your Inbox, and the 60 tips I found more control over my time, instead of the other way around! Using MYI is a must for any person using e-mail”
Brett Middleton - MRT Performance Sydney
|
|
|
Dear Leon,
How to get more done in less time?!
Welcome to our November newsletter where we supply you with useful information about your software and computer.
From the desk of Jurgen Schmechel - international MS-Office® expert and presenter.
|
|
|
This month topics:
|
1. Do you have your own blog?
Blogs are spreading like wildfire all over the planet - what does it cost to have your own?
I was always wanted to create my own blog - and stood in awe for all those who are communicating to the web community on a regular basis. Still I hold back and waited for … yes and that’s a good point… I was not waiting at all; I just choose to give it not enough priority. I wonder how many of you can relate to this.
Last weekend I went to a fantastic seminar and besides learning a lot about internet marketing someone mentioned the benefits of having a blog. And you know what that was exactly the “kick” I needed to get started. Please check out www.MasterYourBlog.com and see the results of my first blog for yourself.
After all it was not that complicated and I think it's cool too.
So my question to you Leon is, do you have a blog? And if not, do you want to start your own blog? Give me a call and I am more than happy to help you in creating and starting a blog for you. I look forward to hearing from you.
|
2. Analyse your data in Excel using the Autofilter-feature
Using AutoFilter To Search or Filter Your List Data
In case you have a large list of data in your Excel worksheet the Autofilter function is a very
efficient way to analyse your data totally flexible and quick.
The AutoFilter option helps you to show only the data matching your criteria in the Excel list.
It then hides the rows that you do not want without changing the order and sequence of your
data-list.
Please make sure that your list does not contain a blank column or row!
To use the AutoFilter option to filter data in an Excel sheet:
1. Select a cell in the list.
2. Select Data -> Filter -> AutoFilter
The AutoFilter arrow appears to the right of each column header in your data list.
Now you can use these small arrows to select or funnel your data...
...click here to read the full article...
|
3. Shortcuts of the month
Do you want to learn more and increase your productivity by up to 30%?
For this month we want to concentrate on keyboard shortcuts
to copy the format of a text or paragraph quick and effortless in Microsoft® Word.
|
Shift + F5 |
Brings your cursor back to the point in your document where you’ve edited last.
How often did you work in a larger document and then scrolled back to the top to reread one of the first paragraphs. After that you want to go back to the point where you’ve been editing. Shift + F5 will bring you there immediately – very powerful.
|
|
Ctrl + F |
Opens the find – dialog
|
|
Ctrl + H |
Opens the find & replace – dialog
|
|
|
On a special note: you can also search (and even replace) for special characters like the line-break or the paragraph-character.
To do so click on more… in the dialog and open the list of special characters.
|
Please try these out – we know how powerful these simple tricks are, because they can save you valuable time – each day. Have fun with it – it’s easy!
You might as well print these shortcuts and keep them close to your keyboard to learn one shortcut at a time. It is worth the effort.
|
What our clients say about us…
“Jurgen, Thank you for writing such a fantastic ebook!
I have just used tips No 2 and 13 which will save me hours every month. Also I agree with you in tip 35, I learned that lesson the hard way and lost a big client because I didn’t understand that rule! Not knowing that tip cost me $ thousands.
I love the way you’ve used pictures in the book it makes life very easy for non-techy people like me. It also means I can delegate much of this to my PA.
Great work Jurgen.”
Howard Tinker - Lifetools.com.au
“Just want to let you know Tip 4 has revolutionised my inbox!
Thanks Jurgen”
Paul Jones – Magneto P/L
“Jurgen, where were you 10 years ago?
Thanks for the Microsoft® Office® tip today. I could have literally saved hundreds of hours of time in the last 10 years while creating proposals. I can't get that wasted time back but at least I now have a true time saver.“
Damian Noonan - Vitecomm P/L
“I attended Jurgen’s workshop on how to save time using your computers including learning a better way to handle your emails.
As a Small Business Owner, time is money, and the more time spent working on the business rather than fiddling around with spread-sheets, computers and emails the better.”
Michelle Hudson - The Loan Lady
|
4. Speaking
In November I am going to give two presentations literally back to back.
If you want to see me live presenting my great keynote “5 Easy Steps To Email Excellence” come to the Hunter Business Swap meeting on the 13th November. It will be a fun morning and I make sure that everyone walks away with tips and techniques they haven’t heard of before.
Please check out their website: Hunter.BusinessSwap.com.au
As a part of speaking at Hunter Business Swap I will have the opportunity to have an radio interview beforehand and I am looking forward to spread the message of how to Master Your Inbox even further.
In the same week on the 12th I will again present at the "Executive Assistant & PA Congress" in Sydney.
Click on the link to find more information about this event.
And of course you can always refer to the e-book "Master Your Inbox".
|
“Jurgen, the Master Your Inbox course is brilliant! Tip 4 alone has justified the cost of the course…and Tip 53 has resolved a long term, time consuming problem. Everyone should use this stuff!”
Glen Rothquel - Capital 4 Business
5. Summary
To repeat the main points from this newsletter:
Did you enjoy this newsletter?
Why not forward it to a friend...
We are looking forward to hearing from you.
|
To your success.
Give yourself a top day!
Best regards,
P.S.: Check out:
computermaster.backupmybusiness.com
|
Thought of the Day ...
The best part of the journey is not the change of scenery, but the change of mind.
|
|
|
|