Email:      Pass:    Pass?
Featured Excel Content



Excel Tip
How to change the name of a chart in Excel. This allows you to use a more intuitive chart reference when organizing charts using the Selection Pane or within VBA and macros. Rename a Chart Select the chart.  This should cause three new tabs to appear: Design, Layout, and Format. Go to the Layout tab and look all the way to the right where it says ...
Added: Feb 12, 2016
 
Excel Tip
How to make a Chart transparent so that it blends in with its background and surroundings in Excel. Hover your mouse over the chart and it will tell you if you are over the Chart Area or the Plot Area etc. Right-click the background of the chart when you are over the Chart Area and click Format Chart Area... A window will open.  In the Fill section ...
Added: Feb 11, 2016
 
Excel Tip
How to add, manage, and remove trendlines in Excel Trendlines allow you to show trends in charts that might be otherwise difficult to notice.  Basically, this is mostly used as a visual aid to illustrate an upward, downward, or flat trend over varying data points in a chart. Sections: Add a Trendline to a Chart Manage a Trendline Remove a Trendlin ...
Added: Feb 10, 2016
 
Excel Tip
Easy step-by-step guide to creating a Gantt Chart in Excel. Following these steps, it should take no more than 5 minutes to make a Gantt Chart. Setup your data.  For a Gantt chart, you need to have one column of data that states when a task will begin and one column next to it that states how long that task will take or last. Go to the Insert tab ...
Added: Feb 9, 2016
 
Excel Tip
How to add, manage, and remove error bars in charts in Excel. Error bars allow you to show the potential variance of a data point in a chart.  Maybe the values on the chart are an estimate and are within a 5% margin of error, this technique allows you to show that. Sections: Add Error Bars to Charts in Excel Change the Error Bars Size/Calculation ...
Added: Feb 8, 2016
 
Excel Tip
Find the Min or Max value in a range and, based on that, return a value from another range. This is an advanced lookup tutorial that uses the INDEX and MATCH functions. This is a step-by-step tutorial but, if you want more information on INDEX/MATCH lookups and how to do them, check out our tutorial on that here: Index and Match Lookup in Excel St ...
Added: Feb 4, 2016
 
Excel Tip
How to use parentheses in Excel in order to create more powerful formulas and functions. Sections: Basics of Parentheses Using Parentheses with Logical Comparison Operators Using Parentheses with Functions Notes Basics of Parentheses When performing calculations or doing anything in a formula or function or operation in Excel, what is inside parent ...
Added: Feb 3, 2016
 
Excel Tip
Logical operators allow you to compare values in Excel to see if they are equal, not equal, greater than, or less than.  The result of one of these comparisons will either be TRUE or FALSE.  These operators allow you to make powerful spreadsheets in Excel and, here, I will tell you how to use these operators. List of Logical Operators ConditionOper ...
Added: Feb 2, 2016
 
Excel Tip
I'll explain how dates in Excel work and then point you to many useful tutorials on how to use dates and also times in Excel. What is a Date in Excel? Dates in Excel are actually just numbers that are formatted as dates. If you take a date and select the cell and then set that cell's formatting to "General" it will look like this: Cell A1 has the ...
Added: Feb 1, 2016
 
Excel Tip
The MOD function is very simple but it can be used to do wonderful things in Excel. It returns the remainder after you divide one number by another. Syntax =MOD(number, divisor) ArgumentDescriptionNumber The number that will be divided by another number. Divisor The number by which the first number will be divided. Example - Simple Type =MOD( Type ...
Added: Jan 29, 2016
 
Subscribe for Free Excel tips & more!
E-mail: