Sunday, 2 August 2009

Creating Bullets In Microsoft Word

Hi my lovely viewers

If you are new to this blog, I have been talking about the product that Microsoft have had out for many years now, that product is Microsoft Office. There are many features of use for this software program and there are actually many different programs in the Office suite, such as Outlook, Excel, PowerPoint etc.

Anyway, as I understand a few of you are very new to this I would like to let you all know about bullet points in Microsoft Word (one of those programs included in the Office suite).

If you want to get some data across on your document and don't think its a good idea to be in a sentence, there is a little button on the Microsoft Word toolbar that will automatically list the text in a bullet or numbered format. Its not just Microsoft Word that allows you to do this sort of formatting, but even the software that powers this blog allows you to do this also. Here is an example of what I mean with bullets.

Bullet List
  • Microsoft Outlook
  • Microsoft Excel
  • Microsoft PowerPoint
  • Microsoft Word
  • Microsoft Front Page
Numbered List
  1. Microsoft Outlook
  2. Microsoft Excel
  3. Microsoft PowerPoint
  4. Microsoft Word
  5. Microsoft Front Page
Its really easy to do and a fast way of creating lists like the above, you should start to use it in your document creation as it also makes the document more visually engaging to the reader.

I hope you enjoyed this tip, I will be taking a break soon but I hope to have a lot more information on Microsoft Office in the coming months.

Stay tuned and have a great weekend!

Jill

Saturday, 1 August 2009

A good tip with Microsoft Excel

Hi Guys

I just had to tell you about this little thing I learned over the weekend, its so simple I'm actually quite embarrassed to write about it but oh well. Its for you Microsoft Excel users, I hope you find some use in it.

Basically, I wasn't aware that you could use keyboard shortcuts to search for things in your excel spreadsheets! I had always used the menu functions, not any more though.

If you press control on your keyboard and hold it down along with pressing F, a little pop up box will appear where you can search for whatever piece of information you require. This will save me tons of time when I'm looking for specific data on my files!

This little shortcut will let you search almost anything you want and need from your data and its very quick too!

Not only that, I also learned that if you hold down control and press H, you can actually do a sort of search and replace of your data in the spreadsheet. Again, this will save me tons of time. Believe it or not, i actually manually searched for things in the passed, don't get me started on searching and replacing in the past, that would take me forever!

Its funny because I actually thought I was pretty good with Excel but with this revelation in my lack of skills, i think I may look into booking an Excel training course at some point. It may be something I regret doing because of the price, however if there are more things to learn like the one I just found out this weekend, i may give it a bash.

Anyway, I hope the rest of you are having a good time! I will be back soon!

Jill