Dec
27'th

A3 Storyboards in Excel

Do you need Visio to do a simple A3 Storyboard? Not necessarily. Excel can create formatted blocks, insert pictures and handle the text.

One thing I do recommend is to create a storyboard template, by selecting “Template” in the Save As Type drop-down box in the Save As dialog box. You can then add different content from the template at will.

Jared Hawk offers Onsite Excel Training in Idaho.

Dec
13'th

Excel Construction Estimating Software Class?

Construction Estimating Software is an incredible time-saving tool, and did you know that Excel can be a very cost-effective way of calculating your construction estimates?

I am considering holding a seminar in the Boise Area or an online webinar on Excel Estimating. I would like to get an idea of how many people would be interested- if you are, please post a comment on this post and specify if you would prefer a webinar or a live seminar.

Jared Hawk offers Excel Training in the Boise Area, and distance webinar Excel training.

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.

Nov
19'th

Is Visual Basic for Applications (VBA) disappearing from Excel?

Listen to the grapevine.

Jared Hawk teaches Microsoft Excel Computer Classes in Boise, ID.

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.

Oct
3'rd

Tracing Formulas in Excel 2007

Here’s a handy tutorial I found on YouTube, right next to Britney Spears’ newest Excel Tutorial… oh.

Jared Hawk teaches Excel Computer Classes in Boise, ID.

Sep
28'th

Microsoft Excel 2007 Math Errors Discovered

What do you get when you multiply 6,425 by 10.2? Excel 2007 can’t tell you correctly- and Microsoft is racing to fix the problem. Imagine the financial risk if you ask 2007 to calculate these known errors.

Using a previous version of Excel? Excel is infamous for statistical errors throughout it’s history.

It’s a good idea to estimate results to compare with your formula results- that will keep you sharp and help you spot any glaring errors.

Jared Hawk is a Microsoft Office Specialist, Expert-Level, and teaches Computer Classes in Boise, ID.

Sep
7'th

Dividing Contents of Excel Cells

Have you ever wanted to split the contents of an Excel cell? For example, you get a list of names with both the first and last name in the same column, and you want them in their own cells? Text-to-Columns is your answer for dividing the contents of an Excel cell. 

This is not the same thing as dividing an Excel cell- which you can’t do. (No soup for you!)

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

Sep
7'th

Formula Brainteaser

Try this formula challenge from Daily Dose of Excel.

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

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.

Recent Comments