Who among us enjoys standing in line at the DMV every year to renew vehicle license plates? All that time to get a sticker and registration, oh, and write a check—the most important part.
Speaking for my own state, Ohio, it is now so easy to renew plates online that I cannot imagine anyone with a [...]
Archive of posts filed under the External Link category.
A no-brainer technology time-saver
Review of excellent, low-priced USB microphone
http://www.kk.org/cooltools/archives/004149.php Read the original article at the link!
I’ve been an audio engineer for more than 35 years, and I’m always on the lookout for useful new tools. Microphones are a particular obsession; I probably own a dozen high-quality models. For a long time I’d wanted a nice USB mic that delivers high-quality [...]
Intermediate Access 2007
TechCache Forms.accdb
TC Logo.jpg
Training videos – Excel 2007
The outline below corresponds to a 5 week introductory Excel 2007 course Walsh University.
The training videos track with the textbook used in the course which I do not name to ensure no copyright violations occur.
Nevertheless, a tremendous amount of FREE training is here for the taking–for whole the world to enjoy!
Excel 2007 [...]
Introduction to Access 2007 – Stark State College Continuing Education
Click here for the SoccerLeague.accdb database which forms the basis of the Introduction to Access 2007 course.
For additional Access 2007 training, check out my video training links below. They are not directly related to this course; the examples come from a different training series. However, every concept applies to Access 2007. Viewers interested in seeing [...]
Excellent list of online Excel resources
You can’t learn too much about Excel! Most so-called ‘experts’ at the office are barely knowledgeable compared to all there is to know. The reason they are ‘local experts’ is because no one else around them knows all that much either!
What a shame, however. There is a tremendous amount of FREE help available. Take [...]
Free 411 – Directory Service via your Cell Phone
Business road warriors frequently place calls to numbers they do not have in their cell phone contacts. Verizon 411 (aka ‘directory service’) calls are very handy, but also very expensive. Waste money no more! Try 1-800-GOOG-411 to get the same results entirely for free.
It’s very simple. Create an entry for Google (or whatever you wish [...]
Mr Excel Podcasts
If you have never visited the MrExcel.com web site then you don’t know what you’re missing! Bill Jelen is among the top Excel gurus, and at his web site you will find answers to many of your thorniest Excel challenges.
Also available are 600+ 2 minute video training podcasts in which Bill explains a narrow Excel [...]
Consolidated list of Excel combo-key shortcuts
If you are a shortcut key junkie like me (or if you seek to become more compuFicient!!) then visit this link to scan for Excel key combinations to speed up your work even more: [click here]
Firefox + Sxipper = say ‘goodbye’ to passwords
I mentioned in a previous post that RoboForm is a ‘must have’ product-especially if you check into and out of countless password protected web sites daily.
So when I stumbled upon the FREE look-alike ‘Sxipper’ recently I had to give it a try. The interface is not quite as flexible as RoboForm, but Sxipper definitely gets [...]
Create and calculate spreadsheets in 3D
For LARGER IMAGE, click the black square to the right of the video length.
This 11.5 minute video shows some awesome techniques within easy grasp of Excel rookies that could be put to use by nearly every business or family I can think of.
First, I show how you can simultaneously create an summary sheet along [...]
Solve a business problem–fast, accurately, and repetitively
If you are debating whether or it’s worth your time learn macros or delve a little deeper into the Visual Basic for Applications (VBA) programming language, perhaps it’s because you simply don’t understand how it could solve business problems for you, or perhaps you question whether the payback for your learning time is legitimately not [...]
2009 calendar on multiple worksheets – by Microsoft
Visit the Microsoft site [click here] to download an Excel workbook nicely preformatted as 2009 calendar, one page for each month.
It’s business office uses are many–even if the most simple argument is just saving money.
There are also other templates available, and I got this idea from the AutomateExcel.com web site. I like to give credit [...]
