Thursday, May 17, 2018

Excel Print Preview Video

I have posted a short video on my YouTube channel on printing in Excel. View it here: Excel Print Preview
I discuss 4 quick things you can do to make sure your worksheet prints correctly:
Page Orientation
Printing Titles

Check it out.

Monday, May 14, 2018

Playing with PowerPoint

Did you know that PowerPoint has some pretty cool picture editing and effects tools? 
Here a just a few basic examples: (Can you tell I like cycling?)

Tuesday, February 6, 2018

Every moment...

Double-click to type anywhere

Guess what? You can double-click anywhere in a Word document and start typing. 
Just double-click in any position on the page where you want text and start typing.

Wednesday, December 7, 2016

Excel Vlookup explained

I just posted a new video to my Youtube channel - Excel Vlookup explained. Check it out.

(all versions of Excel)

Wednesday, November 30, 2016

Excel Tip - Viewing a Worksheet

I have worked as an IT trainer for over 12 years. During those years I conducted a lot of classroom training, but I also did a lot of one-on-one. Here is one of my stories.

I often had what I would call “open project days.” My office had a conference table that could seat 4 people comfortably. Anyone could come in on those days and work on their Excel project and I was there to answer any questions. Sometimes people just used this to get away from their desks, but I never went through one of those days without being of some assistance. It usually did not happen in the form of a question, but rather an exclamation of frustration.
Jeanie mumbled “There are so many date columns, I can’t remember what goes where.”
“Do you not have headings?” I questioned, misunderstanding.
“Of course, I have headings, but when I scroll down to enter data, I can’t see my heading,” she responded in a frustrated tone.
“I have a cure for that,” I said as I walked over.

Here is what I showed Jeanie to make her data entry a little easier - Freeze Panes

Freeze panes allows you to lock specific rows and columns so that they will always be visible on screen no matter how far you scroll to the right or down.

Go to the View tab - Freeze Panes.