Nov
19'th

Data Validation Tutorial

Here’s a cool tutorial I found on YouTube, (but it’s a little hard to hear):

Jared Hawk teaches Excel Training Seminars in Boise, Idaho.

Oct
16'th

Excel 2007 Calculation Fix Available

David Gainer, of the Excel Team at Microsoft, wrote:

Two weeks ago, we posted about an issue involving the calculation of numbers around 65,535 and 65,536.  As of today, fixes for this issue in Excel 2007 and Excel Services 2007 are available for download from the following locations

Jared Hawk offers Excel Seminars in Boise, ID, and national onsite Excel training.

Sep
4'th

Using a Formula

Thanks to vhyndman for posting this video on YouTube. 

Jared Hawk is a professional Excel Seminar Trainer and Consultant in Boise, Idaho. He is also a contributing author to www.masterthebusiness.com.

Aug
8'th

Hands-Off Computer Classes?

I went to an Excel seminar from a national company yesterday- one without any computers to practice on. They all give the same reasons for not using computers- “Computers will just slow the class down”, “More material will be covered” and “You already know how to turn the computer on and hit enter.” And don’t forget to buy a book or cd from the back of the room.

My response? As someone who has taught both hands-on and hands-off Excel classes, I do not believe students will learn how to do nearly as much without a computer to practice on. What good is it to see a quick review of features if you can’t practice them to lock them into memory? In my opinion, the two real reasons companies don’t use computers are to keep costs low (for the company) and to sell books and training CDs that attendees wouldn’t necessarily need if the classes were more effective.

Jared Hawk is a professional Excel Seminar Trainer and Consultant in Boise, ID. He is also a contributing author to www.masterthebusiness.com and IdahoCLE.com

Jul
27'th

Before you train your team…

Before bringing in a trainer to teach your class, take a moment to assess your team’s differening levels of skill. I have taught companies in-house where 2-3 students dominate the discussion on basic skills while the rest of the class is ready to move on and follow the agenda. Maybe two classes are needed.

Jared Hawk is a Microsoft Excel Trainer and Consultant in Boise, Idaho. He is also a contributing author to www.masterthebusiness.com.

Jul
24'th

Microsoft Excel 2007 Transition

There wasn’t much change in the user-interface between versions of Microsoft Office until the latest release, Office 2007. It takes time to get to used to, I’ve seen a simple job of opening a file in Excel 2007 baffle office staff, let alone using advanced features. The best way to transition your team to ‘07 is to give them a warning that it is different in many ways, offer them specific training for version 2007, and have someone ready to answer questions. There is a lot of great new features, just be ready for the learning-curve.

Jared Hawk teaches professional Excel Courses in Boise, ID. He is also a contributing author to www.masterthebusiness.com.

Jul
22'nd

Get your Daily Dose of Excel

Daily Dose of Excel is a great Excel-focused blog with a lot of big-hitting contributors, including my hero, John Walkenbach.

Jared Hawk is a professional Excel Trainer and Consultant. He is also a contributing author to www.masterthebusiness.com 

Jul
20'th

Excel Shorcut Guide

Hawk Education’s New Excel Seminar Brochure includes a one-page, free Excel Shortcut Guide that has the most common Excel Shortcuts- something that can come in handy for Excel 2003 and especially for Excel 2007, as ’07 doesn’t clue you in to even the most common shortcuts.

Jared Hawk is a professional Excel Seminar Trainer and Consultant in Boise, Idaho. He is also a contributing author to www.masterthebusiness.com.

Jul
18'th

How to Make A Chart in Two Steps

Step 1: Highlight the table/data, including the column and row labels

Data

Step 2: Press F11

Excel automatically builds a chart for you- you can customize it by right-clicking and selecting different chart types and options. That’s it!

Chart

Jared Hawk is a professional Excel Class Instructor and Consultant in Boise, ID. He is also a contributing author to www.masterthebusiness.com.

Recent Comments