How to make your own functions in Excel 2013, Excel 2010, and Excel 2007 - YouTube

How to make your own functions in Excel 2013, Excel 2010, and Excel 2007 For more great free PC training videos, go to http://www.freepcseminars.com
http://youtu.be/ogGU4OOjzZo

How to apply conditional formatting with a date range in Excel 2013, Excel 2010, Excel 2007 - YouTube

How to apply conditional formatting with a date range in Excel 2013, Excel 2010, Excel 2007 For more great Free PC training videos, go to http://www,freepcseminars.com
http://youtu.be/VksArazMRGY

How to use a data table in Excel for what if analysis - Excel 2013, Excel 2010 and Excel 2007 - YouTube

How to use a data table in Excel for what if analysis - Excel 2013, Excel 2010 and Excel 2007 To find more free PC training videos, go here: http://www.freepcseminars.com
http://youtu.be/WPLq-1-QqjE

How to run a powerpoint presentation and do something else at the same time using Multiple Monitors In PowerPoint 2013 - YouTube

This video will show you how to run a powerpoint presentation and do something else at the same time in PowerPoint 2013, PowerPoint 2010, PowerPoint 2007. You can find many more Free PC training videos at http://www.freepcseminars.com
http://youtu.be/IClWfGET2Dg

Making a Pivot Table from more than 1 table in Excel 2013 - YouTube

This video demonstrates the great new feature in Excel 2013 where you can make a pivot table from more than 1 sheet using table relationships. This is using the new data-modeling concept in Excel 2013, and its only available in Excel 2013, not in Excel 2010 or Excel 2007. For more great PC training videos, go to http://www.freepcseminars.com
http://youtu.be/9ORZWPw2Auw

how to run disk cleanup in windows8 - YouTube

This video will show you how to run disk cleanup in Windows 8 and Windows 8.1
http://youtu.be/bhNVJHwx2-E

Access switchboard manager - creating a menu in Access 2010 Tutorial

How to use the Access switchboard manager - Access 2010 Tutorial Access switchboard manager - creating a menu in Access 2010 Tutorial
http://youtu.be/zVm5W8h7HFk

Installing an odbc driver in Windows 8 and Windows 8.1 and Windows 7

This video will show you how to install an ODBC driver in Windows 8, Windows 8.1 and Windows 7. For More great PC training videos, please go to http://www.freepcseminars.com
http://youtu.be/yJWxwDBl8-Y

Pivot tables - How to generate a monthly or quarterly or yearly summary report with Excel

This video will show you how generate a daily, monthly, quarterly, or annual report from your data using a Pivot Table in Excel 2013, Excel 2010, and Excel 2007. For more great Free PC training videos, please visit http://www.freepcseminars.com
http://youtu.be/9k1KKbOwCEM

A quick way to create a dropdown list in Excel 2013, Excel 2010, and Excel 2007

This video will show you a quick way to create a dropdown list in Excel 2013, Excel 2010, and Excel 2007. For more free PC tips, check out www.freepcseminars.com
http://youtu.be/Lotm9bcf9bw

How to Use an Excel If Function with Multiple conditions - Excel 2010 Tutorial

This video will show you how to use the If function in Excel with Multiple conditions. This will work in Excel 2013, Excel 2010, Excel 2007 and Excel 2003. http://youtu.be/BoGQD35gAUc For more free PC training videos, go to www.freepcseminars.com
http://youtu.be/BoGQD35gAUc

How to Viewing 2 windows at the same time in Windows 8, Windows 8.1 and Windows 7 - YouTube

This video will show you how to view 2 windows side-by-side in Windows 8.1, Windows 8, and Windows 7. http://youtu.be/Od_RluQUpbM To see more great free PC training videos, go to http://www.freepcseminars.com
http://youtu.be/Od_RluQUpbM

How to Create Mailing Labels from Your Excel 2010 data using Mail Merge in Word 2010.

Learn how to Create Mailing Labels from Your Excel 2010 data using Mail Merge in Word 2010. Btw, It works the exact same way in Excel 2007, and Excel 2013. See many more free PC training tips at http://www.freepcseminars.com http://youtu.be/-dh1KutksMY
http://youtu.be/-dh1KutksMY

How to use the Vlookup Formula / Function in Microsoft Excel

How to use the Vlookup Formula / Function in Excel As a long-time computer consultant/trainer , I am often asked about the proper way to use the powerful Vlookup function in a formula in Excel.

The vlookup function has many purposes. It can be used to compare data between 2 sheets, or merge information from 2 or more sheets into one sheet. Another possible use of it would be to convert a number grade into the appropriate letter grade. You can use the Vlookup function to calculate the tax rate based on someone's salary. Perhaps you were filling out an order, and when you fill in the part number , you want the proper description and unit price for that part to fill in automatically. The vlookup formula can be used for all of these purposes and alot more.

The Excel vlookup formula can be a little complicated, but once you use it a few times, you will get used to it, and find many uses for it.


Here's a video I made to demonstrate how to use the vlookup formula / function in Excel :

If the video can't play in this forum , click the link below.
Excel Vlookup Formula

Hope this helps.

You can find over 300 Free PC training videos that I made at:
Free PC Training Videos

Please feel free to leave a comment, or to request a topic that you may want to see.
Thanks for watching!

How to make a dynamic chart tile in Excel 2007, Excel 2010, Excel 2013, and Excel 365

This video will show you how to make a dynamic chart title in Excel 2007, Excel 2010, Excel 2013, and Excel 365.

In Excel 2013/365 , you will click on the design menu, and then click on Add Chart Element, then Chart title. In Excel 2007 and Excel 2010, you will click on the Layout menu, then Chart title.

Once the chart title is there, click on it. Then type in = to start a formula, then click on the cell that you want to take the title from.

For more tips go to my Youtube channel at :

https://www.youtube.com/user/TomFragale

4 new free PC training videos this week, plus a switch to Office 2013

Hi all. Hope all is well. Thank you for your continued use and sharing of this forum. I have 4 new videos for you this week: The Access lookup wizard and how it may affect your table relationships: http://youtu.be/5QED0MSDNwc Driving a report's criteria from a Pulldown/Combo Box in Access: http://youtu.be/1F2I5-Q4FXw Opening a form as Read Only in Access: http://youtu.be/F8Q1Gyl2ITI Using the Slicer windows on an Excel Pivot Table: http://youtu.be/ngxwYyG7wgw Also, starting this week, I will be making all of my new videos in Office 2013. You will see the first ones for Office 2013 in next week's announcement. Very soon, I will start adding in videos for Sharepoint, Infopath, gmail, and other new technologies that I am starting to learn better. Your requests for certain video topics are always welcome. All of this weeks videos came as a result of people's requests. Thank you again for using and sharing these videos. I appreciate all of you . Enjoy! Tom Fragale (215)280-1073 www.freepcseminars.com tomfragale@gmail.com

Learn how to Use Google Drive to share your files between your PC and your Android Drive

Hi all. Here's a great video that will teach you how to use Google Drive to share your files between your PC and your Android Drive. This is a free service offered by Google.

I have over 300 PC and business training videos on my Youtube Channel.
https://www.youtube.com/user/TomFragale

I can be contacted at
http://www.freepcseminars.com

Enjoy, and please share!

Thanks,
Tom Fragale
(215)280-1073

How to do a date range filter in Microsoft Excel

Hi all. I just made a great video which will show you how to do a filter in Excel using a date range.
It will show you how to do a specific date range, but you will also see that Excel has many date ranges built right in that would show this week's records, this month, this quarter, this year, year to date, and many more.
















You can check out the rest of my videos at
https://www.youtube.com/user/TomFragale

You can also contact me at
http://www.freepcseminars.com
Enjoy and please share!
Thanks,
Tom

Tom Fragale - Celebrating 20 years as a Self - Employed Business Owner!

This month, I celebrate 20 years as a self-employed small business owner. 

Wow, what a ride its been! Many highs, many lows. Many triumphs, and many mistakes.

And I wouldn't trade those 20 years for anything!

There's 2 main sources of my income.

I am a computer professional and trainer. I spent many years as a programmer, but now I concentrate on training people how to use many of the popular software programs on their computer : Word, PowerPoint, Excel, Access, Crystal Reports, etc.

I have had the honor of teaching over 35,000 people in live classes in 46 states over the past 14 years!

To see many of my recorded training videos, please go to my youtube channel:
https://www.youtube.com/user/TomFragale

I have reorganized the channel, I am always adding new videos, and I think its a great place to learn a thing or about getting real results with your computer , and to improve your skills.

My computer business has always been , and will always be, My "Plan A".

As a self-employed person, I wanted to make sure that I also had a second source of income, or a "Plan B", to make up for the low times that occur occasionally.

After trying many things, I know that I have finally found the "Plan B" that I can hang my hat on, long-term.

For my "Plan B", I am building my own Solavei business, and I have been doing this since 9/12. Solavei is a social commerce company whose mission is help people save money on things they are already doing anyway, and maybe make some extra income if they chose to share it with others.

Solavei is a company that I really trust. They have excellent leadership with a proven track record and great vision for the future. Over 300,000 people have switched to the Solavei service since 9/2012 , and they have paid the members over $ 18 million in referral fees and bonuses just since 9/2012. I believe in the company and leadership completely, and I know they are poised to be here for the long haul.

For example, my own cell phone bill went from 129 a month, now its down to 39 a month, for the same great 4g service with voice data and text.

Last month, the company even paid me a few hundred dollars because of my sharing it with others, and that is ongoing income, month after month.

If you know anybody who would like to save money, or start to earn some extra income, or maybe both, please refer them to :

http://www.showmeplanb.com/

I wish everybody has a great 2014!