How to make text cells all lower case or upper case in Excel

Title:
How to make text cells all lower case or upper case in Excel


Video:


Description:www.TeachMsOffice.com How to make text cells in excel upper case, lower case, and in the proper case. Basically, just how to use formulas to capitalize entire words or make them all lower case or to capitalize just the first letter of every word. Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website www.TeachMsOffice.com

Published:
14/Aug/2008

What-if Analysis in Excel with a 2-input data table

Title:
What-if Analysis in Excel with a 2-input data table


Video:


Description:Create as many "what-if" analysis scenarios as you wish - with just one formula! In this video lesson, you will learn how to set up a 2-input data table to find multple possible monthly loan payments. We are basing this on the =PMT() function. To see all of my video lessons I invite you to visit my website - thecompanyrocks.com

Published:
13/Aug/2008

How to link two (multiple) workbooks and cells in Excel

Title:
How to link two (multiple) workbooks and cells in Excel


Video:


Description:www.TeachMsOffice.com How to link two or more workbooks and cells in Excel. Basically just cell linking between workbooks explained. Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website www.TeachMsOffice.com

Published:
13/Aug/2008

Make a Dynamic Gantt Chart in Excel - Dates Update Daily (Part 1 of 2)

Title:
Make a Dynamic Gantt Chart in Excel - Dates Update Daily (Part 1 of 2)


Video:


Description:www.TeachMsOffice.com Tutorial showing you how to make a Dynamic Gantt Chart and Frequency Distribution Chart which will update every day. Each day, the bars on the chart will change in size and color to show how many days left you have for a task or project. Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website www.TeachMsOffice.com

Published:
12/Aug/2008

Microsoft Excel 2007 VBA training courses and free online tutorials

Title:
Microsoft Excel 2007 VBA training courses and free online tutorials


Video:


Description:www.macresource.co.uk Microsoft Excel 2007 VBA training courses in London and throughout the UK.

Published:
10/Aug/2008

How to read and write binary code - 8 bit example

Title:
How to read and write binary code - 8 bit exampleVideo:


Description:This is a tutorial if you will on how to read and write binary code. I looked all across youtube and the net and found almost no help on this subject, but when I found out how to read and write, I decided to make this video. Hope it helps those who want help learning to read and write it. Youtube logo created by: danthemango

Published:
10/Aug/2008

Excel Calendar Tutorial

Title:
Excel Calendar Tutorial


Video:


Description:Just a simple way to make a calendar using Microsoft Excel. This is not the Mac Office Version obviously. This is just a basic tutorial. If you're interested in me making more tutorials on very popular software programs, lead feedback so I can help you out. Thanks for watching!

Published:
07/Aug/2008