How to create Multi-level Numbering in Word
Numbering in Word is a bit of a nightmare at times and if you need multi-level numbering this could cause you much stress if you rely on the mouse alone. Using...
Tips – How to use Flash fill in Excel
Over the past 25 years I have constantly been asked how to easily extract single words out of multiple words in a cell in Excel. This is normally because people receive...
Tips – using range lookup in the Vlookup function in Excel.
In my last tip, Using Vlookup in ExceI, I explained how to create a Vlookup function. I only showed you how to use the first three lines of this function and...
What is and how to use the Outline View in MS Word
When you first go into Word the default view is Print Layout. This shows you the size of the paper, margins and an indication of the font and size of text...
Shortcut keys in Excel for Data, Functions and Formula Bar (5 of 8)
This is the fifth list of shortcuts to use in Excel that deal with data, functions and the formula bar. I have highlighted for you some that I find very useful...
Repeated Header rows in a Word Table
Microsoft Word is a great place to create a table for lists and the like. Sometimes my students have such long lists that they flow over to the next page and...
Indentation explained for MS Word
When you create a word document the default settings for a paragraph are to have a left aligning paragraph and no indentation for the second and subsequent lines within that paragraph.
I...
Tip – Drawing Tables in Word
I often see people struggling with tables in Word. They create a table by inserting it. There is nothing wrong with that. But what they then need is different sized cells...
Tips – Fill Series in Excel Spreadsheets
In an earlier tip I explained how to use the Autofill feature in Excel. It is a wonderful time saving tool. Now I will explain the Fill Series feature where numbers and dates...
Tips – Change case in MS Word 365
I’m sure many of you get so very frustrated when you have typed a lot of text then look up at the screen to see that it's been typed in the...