Excel 2016  / 2003 / 2007 / 2010 / 2013

• 

  Creating a chart with critical zones

  Periodical processes like volume of support service calls often have critical zones that indicate a serious problem that need to be investigated and mitigated. This tips shows how to reveal and emphasis those critical zones for analysis.
• 

  Saving Changes to Existing Workbooks

  Saving your document in the same location with the same name is easy.
• 

  6 ways to open an Excel workbook

  The Open dialog box, is your key to finding and retrieving Excel workbooks.
• 

  Adding Commands to the Quick Access Toolbar

  Suppose you'd like to add a couple more commands to the Quick Access toolbar. Also, say you're a big fan of AutoSum. You can add the AutoSum button to the Quick Access toolbar, so you can quickly create and use AutoSum entries.
• 

  Creating Your Own Menu

  Creating custom menus in Excel is a funny feature you can use to create groups of the options that you use most often, and then plug them into the menu you name and use yourself.
• 

  How to generate Series of Dates

  Often you'll want to insert a series of dates into a worksheet. The most efficient way to enter a series of dates doesn't require any formulas - just use Excel's AutoFill feature.
• 

  Splitting text strings without using formulas

  If you want to paste text in your worksheet, you can use Excel's Convert Text to Columns Wizard.
• 

  Using Solver

  Solver tool allows you to specify multiple adjustable cells and constraints on the values that the adjustable cells can have, generate a solution that maximizes or minimizes a particular worksheet cell, generate multiple solutions to a problem.
• 

  Goal Seeking

  Goal seeking is a useful feature that works in conjunction with your formulas. If you know what a formula result should be, Excel can tell you which values of one or more input cells you need to produce that result.
• 

  Calculating the difference between two time stamps

  Because time stamps are represented as serial numbers, you can subtract the earlier time from the later time to get the difference.