Excel Training Boise

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.

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.

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.

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.

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.

If you need to generate a time-stamp automatically in a spreadsheet (to tell when the last time a macro was run, for example) and you don’t know VBA or are intimidated by it, you can use the macro recorder. Keep in mind that if you use the standard functions:

=today() or =now()

as you record, they will be accurate- temporarily, but the formulas will update as the time changes, giving the wrong time stamps. 

A solution is simple: creat a macro that copies the date/time and then use paste special to paste the value only. The pasted value will not update.

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

Want to learn the basics of Excel formulas in less than an hour? Take this free course from Microsoft.

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

VLOOKUP allows you to type one bit of information into a cell, then have all the related information from a list or database populate next to it. For example, if you type in someone’s name and hit enter, Excel will search the list or database and pull up their address, SS#, Telephone number or any other related information. It’s a lifesaver if you use Excel for data storage. 

For some free Excel VLOOKUP Tutorials click here.