Excel Tip – 3 Different Count Functions

Have you ever wanted to know how many entries were in a list in Excel? You can use the Count functions to give you an accurate number. The first Count function only counts cells that contain numbers. Will ignore any cell that has text in it =COUNT(A2:A24) The second...

Word Tip – Show Multiple Pages on the Screen at Once

Open a multi-page document.   On the View tab, in the zoom group, click on Multiple Pages. Use the Zoom bar (bottom right) to zoom in or out to see as many or as few pages as you like. To return to seeing only one page click on One Page, which is in the same group on...

Excel Tip – Total Multiple Columns at Once

If you have columns similar to the example below there is an easy way to total them all at once. Select the empty cells beneath each column (where you want to see the answer). Click in the cell beneath the first column, hold down Ctrl and click on the cell underneath...

Virtual Training With a Live Instructor

The advent of virtual environments now makes possible live direct interactive training between a remotely located instructor and student(s) who remain at their office or home. Compared to non-interactive text or video based instruction, virtual instructor-led courses...

Excel Tip – Countdown to your Birthday Next Year

Open an Excel spreadsheet and in cell A1, type your birthday for next year, such as 7/7/2016 In B1 key in this function   =today()       (Computes the current date) In C1 type this formula      =A1-B1     and press Enter to finish Click in C1 and enlarge this cell,...