Who else wants to know the secret to Excel Formulas?
Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll todaySo if you have been reading The New Paperclip for a while, surgeon you will know that the guy behind The New Paperclip is Paul Woods. Recently he delivered two presentations at two separate events – Microsoft’s TechEd Australia Conference, prescription and the community driven OfficeDevCon09. Here are the two presentations available on Slideshare…
I hope you enjoy!
’till next time!
TNP 😉
Oh My! Hasn’t Christmas snuck up on us this year! Just over two weeks until the big day, prosthetic
I thought I might share with you some great resources over at Office Online which will help you make the most of Christmas this year!
Are you looking for some pictures or artwork to make your home made Christmas Cards look amazing! There are over 100 pages of Christmas Clipart available at
This is a great course that will help you create a decorate a newsletter, create mailing labels for your envelopes, and create some holiday decorations. It is about 30 minutes long – but will be a great investment of your time this Christmas to help you spread the holiday cheer!
3) Create your own Holiday Greeting Cards!
Another great resource to help you great special greeting cards to share with your family and friends – from the traditional, to the new age multimedia greeting cards with PowerPoint.
So there you have it, three great resources to help you make the most of Christmas this year!
‘till next time!
TNP 😉
With 2009 almost behind us, healthful
now is the time to start creating your own 2010 calendars using Word 2007.
It is a lot simpler than you think! Here is how you do it.
1) Make sure you are connected to the internet
2) Click on the Office Orb in the top left hand corner of the screen (the old file menu)
3) Click on “Newâ€
4) In the “New Document†dialog box that appears, on the left hand side you will see a long list of different template types you can find on Microsoft Office Online. click on “Calendarsâ€
5) Click on “2010 calendarsâ€
6) Pick your favourite design from the dozens that appear! Once you have selected the one you like, just click “Download†in the bottom right hand corner
7) After Word downloads the Calendar, it will appear ready for you to use, edit or print straight away.
How easy is that! Happy New Year!
‘till next time!
TNP 😉
Did you know in Word you can automatically select all the text in a document that shares the same formatting?
For example, read
you can select all text that is Arial, click 12pt. Very handy if you are not using styles, dosage
yet want to apply a formatting change across select blocks of text.
To select text with similar formatting in Word 2007:
1) Select some of the text you want to select
2) Make sure you are on the home tab of the ribbon
3) Look for the “Editing†group on the right hand side of the ribbon
4) Click on “Selectâ€
5) Click on “Select Text with Similar Formattingâ€
‘till next time!
TNP 😉
Do you want to quickly change some text from lowercase to uppercase, online without having to retype it?
It is really simple in Word 2007!
1) Select the text you want to change to UPPERCASE
2) Make sure you are on the “Home†tab in the ribbon
3) Look for the “Font†group
4) Click on the “Change Case†button – which you will find directly below where you select the font size
5) From the menu that appears, decease
click on “UPPERCASEâ€
Whilst you are there, check out some of the other case options you can have… like Sentence case, lowercase, Capitalize Each Word, and tOGGLE cASE.
‘till next time!
TNP 😉
Does this option exist in Excel 2010? How to find it? I want to change to uppercase some columns of data. (I know about =upper() function, but i want something just to change it insude column, without creating new column.
Select desired text, copy/paste to blank word 2007 page, ctrl-A, font button, change font, uppercase, ctrl-c, go back to excel sheet and ctrl-v to paste it back in.
Sounds lame, but this is quicker than making column, entering formula, pasting down, copy/pasting value, and removing columns in Excel. (ctrl-keystrokes, one button, and one window ruondtrip makes it fewer kinds of actions and slightly more efficient I think.) Maybe they’ll unveil the excel upper case button in Windows Vista2 and some more real upgrades in Windows 8. 🙂
Some programmerz might chime in here with making a button and a clever macro and such.