EXCEL TIP OF THE MONTH

EXCEL TIP OF THE MONTH

“This is one of the most interesting ways to stay on your toes

and keep curent in the real world”

October 2012

Posted by on 5:50 pm in tip of the month | 0 comments

October 2012

The following are the October 2012 tips:

1. Cumulative Frequency
2. Show Positive & Negative
3. Text to Column – Keep Original
4. Text & Time or Date Displayed
5. Drop Down List (Shortcut)
6. Grouping Shortcut

 

Tip of the Month

 

September 2012

Posted by on 7:46 pm in tip of the month | 0 comments

September 2012

The September Excel Tip of the Month workbook contains the following topics:

1.     Elapsed number of hours
2.     Add or subtract hours
3.     Important MAC Shortcuts
4.     All MAC Shortcuts
5.     Hide Contents
6.     Show Units

Tip of the Month

August 2012

Posted by on 1:33 pm in tip of the month | 0 comments

August 2012

The August Excel Tip of the Month workbook contains the following topics:

1.     Frequently used Financial Ratios
2.     Functions and Formulas- Exact Copy
3.     Eliminate Links
4.     GANT Chart in Excel
5.     Delete all Errors together
6.     Use a Text Function to Create a  Chart

 

Tip Of The Month

June 2012

Posted by on 1:19 am in tip of the month | 0 comments

June 2012

The June Excel Tip of the Month workbook contains the following topics:

1.     Vlookup Exact Match
2.     Vlookup Range Lookup
3.     Create and Use a name in Excel
4.     Count Rows or Columns
5.     Change a matrix to a database

 

Tip Of The Month

May 2012

Posted by on 3:52 pm in tip of the month | 0 comments

May 2012

The May Excel Tip of the Month tips workbook contains the following tips:

1.     Sparklines in Excel (Excel 2010 and 2011 only)
2.     The N function and  Descriptive Text in Formula
3.     Three  Equall Values
4.     Eliminate Blanks
5.     Copy as Picture

 

TIP OF THE MONTH

April 2012

Posted by on 3:26 pm in tip of the month | 0 comments

April 2012

The April Excel Tip of the Month workbook contains the following tips:

1.    Quickly Filter by Cell’s Value, color or font
2.    A Quick Way to Find Duplicate Values    
3.    Calculate the Correlation Coefficients for a Number of Variables   
4.    MROUND    
5.    UNION and INTERSECTION  (Venn Diagram) 

 

Tip Of The Month

 

March 2012

Posted by on 6:23 pm in tip of the month | 0 comments

March 2012

The March Excel Tip of the Month worksheet contains the following tips:

1.     Reverse Scale or Values
2.     Transpose
3.     Template
4.     Compare 3 Values
5.     Alternatives to Paint Brush

February 2012

Posted by on 5:53 pm in tip of the month | 0 comments

February 2012

The February Excel Tip of the Month worksheet contains the following tips:

1.    Chart Shortcuts
2.    Split Screen – the fast way
3.    Fast Row & Column Insert
4.    Countif revisited
5.    High Contrast

January, 2012

Posted by on 5:46 pm in tip of the month | 0 comments

January, 2012

The January Excel Tip of the Month worksheet contains the following tips:

The first three sheets are for Break Even Point (BEP) Analysis

1.     Profit - BEP Analysis:  Table & Chart
2.     Profit - BEP Analysis:  Show the BEP on a Chart
3.     Animate the BEP Chart
4.     The X Axis Gap Problem Again
5.     Copy here as Values only instead of Copy + Edit Paste Special as Values

 

FacebookYouTubeTwitter