Skip to content

Creating a business page in facebook in 30 minutes or less

Many businesses now have a facebook page where they can share information such as promotions, helpful information (how to use product) with their customers or those who “like” them. If you have a personal page, you can set one up in about a half hour. The friends on the personal page are totally different than the likes on your business page. Of course, invite your friends to go to the business page.

This video tutorial will explain the core basics of setting one up.

Excel – combination vlookup & hlookup

Done in Excel 2013, (should work with previous versions), this shows how to do a look up of data stored in a grid. The example shows days of the week and seminars offered with #s of attendees.

In addition, learn a shortcut to name ranges and data validation using predetermined lists.  The example shown is a small one yet can be used for large grids of data.


Adding rounded values with a “correct” total in Excel

In this demo, learn how to add rounded values.  This way when #s have less decimal pts, the #s will add up to the value of these #s.

Access 2013 – creating a database

This shows you how to create a database table in Access 2013.  There are some slight changes in the updated version which are mentioned in this tutorial.


Excel – Trim function – get rid of excess spaces

Done in version 2013, this will work with previous versions.  This is a great way to deal with a data dump where you have a lot of text with too many spaces in between.  A few other tips are also shown on how to sort it with the text to columns feature, copy/paste as only values.


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.


Get every new post delivered to your Inbox.