Category Archives: Advanced Excel

Calculating Time with Excel Formulas

Default Image

How often have you looked at your watch and typed the current time into your worksheet? Or tried to convert from one time zone to another and produced an error? Or wondered why a time shows up looking like “0.9285”? Fortunately, these questions are easy to answer once you understand how Excel time formulas work….
Read More

Where is the Chart Wizard in Excel?

Default Image

Microsoft eliminated the Excel Chart Wizard in Excel 2007, and it has not returned in the successive versions. In fact, the company rebuilt the entire chart system, and the team decided it would not be worthwhile to update the wizard and all of its options.

Automatically Stop Duplicate Values on Input

Default Image

Preventing duplicate values from being entered in a range of cells may be a requirement in some of your worksheets. Although not obvious, enabling this capability in Excel is very easy. You can prevent duplicate values from being entered in a range of cells through Data Validation.


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.