Skip to content

Creating a macro in Excel and adding a button to quick access toolbar

This tutorial works with Excel 2013 (works with previous versions) and shows how to create a simple macro (this one will make a sheet landscape, create custom footers) and a demonstration of creating a button to put in the quick access toolbar.


Excel 2013 – circular references, PMT, IF, VLOOKUP

This 11 minutes video covers a lot of territory…make sure you hit the pause button.  This also works with earlier versions of Excel.

Set “Save” default location in Office 2013

By default, Office 2013 goes to the cloud…that’s great if you want to share with others. However, if you want files to go to your hard drive such as My Documents, this quick tutorial shows you how….this works with Excel, Word, PowerPoint 2013

Excel – filter data and create subtotals

This video is very useful when working with large spreadsheets (lots and lots of data!).   You can filter it down to any category or date.  In addition, learn how to do subtotals….this is great if you need to know how much each sales rep earned.


100 Amazing Computer Tips

I wish I wrote this book, but I didn’t.  Anyhow, it’s great for the novice, slightly experienced or even someone like me who teaches and is always looking for something new.

You can buy the book in print or as an ebook.  100amazing

If you live in Sarasota, FL, you may wish to check out the classes that she teaches there.


make Word work for you

A few tips to help with Word – works with all versions!  Highlighting/selecting text can sometimes be a pain, these shortcuts will make life easier…stuff I thought EVERYONE knew!  I’ve taught basic and intermediate classes…very often the intermediate students are thrilled to learn them:

highlight a word:  double click on it

highlight a paragraph:  triple click in it

highlight a sentence:  put your mouse inside the sentence, hold down control key and left click.

highlight entire document to adjust spacing, font size, color, etc:  CTRL + A (selects all).  (command A on the Mac)

highlight a single line in a paragraph:  put mouse to the left of the line, you get a right pointing arrow.  click once.

highlight multiple ranges in a document:  select first range of text.  Hold down CTRL key and highlight second range.  Repeat this step.

Excel Essentials to keep (or get promoted at) your job!

This link is very helpful for those who know the basics of Excel.  There are so many additional features that you need to know that this link will help you.

Some of the many topics include the basics like sum, average.  etc.  However, it includes some functions that I forgot about which include LEN, TRIM, RIGHT, LEFT, MID, VLOOKUP, IF, SUMIF, COUNTIF, AVERAGEIF, CONCATENATE.  If you don’t know what they mean, check this out…instructions are very well written!


Get every new post delivered to your Inbox.