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...
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...
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...
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...
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...
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...
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...
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...
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...
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...