Demo Blog Post
May 12th, 2011 by Brian MickleyPosted in Excel | No Comments »
The material in this article supplements Introduction to Excel training conducted by Brian T Mickley, aka bTechSharp. You are free to use it, copy it, share it, and benefit from it.
Note: An single, momentary warning will occur with the bTechsharp if you are not using a SCORM Learning Management System.
Budget Worksheet (199) – Download spreadsheet training file here.
| Material |
bTechSharp Video
(higher quality)
|
YouTube Video
(lower quality)
|
| Introduction to spreadsheets | Part 1 | Part 1 |
| Formatting spreadsheet | Part 2 | Part 2 |
| Absolute reference, ‘what if’ scenario | Part 3 | Part 3 |
| Suppress #DIV/0! with ‘IF’ function | Part 4 | Part 4 |
| Protection and ‘Save as’ template | Part 5 | Part 5 |
| Budget spreadsheet |
Posted in Excel, Microsoft Office, Training, Training Video | No Comments »
FREE – 5 videos for Excel rookies – all under 10 minutes. Create a perfect home budget in an hour and change your life!!
This is the same material Brian Mickley presents at two colleges, and you get them for FREE. Do yourself a favor and take control of your finances today while you learn how to use THE most powerful business tool on the planet. Excel has the potential to change your life if you let it. It did for me, which is why I give this away for FREE.
Visit my YouTube channel here.
Posted in Excel, Microsoft Office, Training | No Comments »
Google Voice provides a great, free solution that enables me to leave Jott-like messages for myself, receive an SMS with the transcription, and receive the transcription via email. And the original audio is available if I need it.
All it takes is a little bit of configuration.
I didn’t want all my destination phones (work, home, etc) ringing when I called myself to leave a Jott-like message (I frequently leave myself messages for transcription on my way to the office, when my wife is still sleeping at home). So, here’s what I did:
In Google Voice: [article here]

Posted in Communications, Outlook | No Comments »
When Google announced an upgrade to their Google Docs service earlier this month, a company blog post also mentioned several third-party applications which can help make the transition to the online service easier. With these apps, you can transfer and synchronize your local files to Google Docs without having to upload them one-by-one. But which application is right for you?
We took a look at the options Google suggested and have summarized the features, drawbacks and pricing information below. In addition, we also reviewed one other application not specifically mentioned in the Google blog post that may be of use to those moving to the cloud-based service.
Posted in Excel, Internet, Microsoft Office, Word | No Comments »