Excel Training Boise

If you do, read about a way to use a great userform- a free add-in I have used and recommended many times. Data forms increase speed of adding, editing and finding items in a list.

Jared Hawk teaches Excel Training Seminars in Boise, Idaho. He is also a contributing author to the Master the Business blog and the Idaho CLE blawg.

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

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.

Jared Hawk teaches computer classes in Boise, Idaho. He is also a contributing author to www.masterthebusiness.com.

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.

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 

AutoFill is one of Microsoft Excel’s most convenient features, but there are times when you want to copy an item in a list without filling the series. Simply select the first item, “January”, for example, then just hold down the control (CTRL) button while dragging the fill handle. January will fill to the cells, instead of the sequence of months (February, March, etc.) that normally would.

Jared Hawk teaches Boise, ID Excel Classes. He is also a contributing author to www.masterthebusiness.com, and is more of a cat person than a dog person, although he likes dogs, too.

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.

This question actually comes up frequently, and it can be hard to find the answer in Excel Help. The answer is no.

The reason is because each cell has to have a valid reference of a Column Letter and a Row Number. There is no such thing as column A-and-a-half.

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

Jared Hawk is a professional Excel trainer and consultant in the Boise Area. He is also a contributing author to www.masterthebusiness.com.