Next Generation Excel - Tip of the Month

Dr. Isaac Gottlieb, best selling author of "Next Generation Excel: Modeling in Excel for Analysts and MBAs", shares tips on how to unleash the power of Excel. The tips are gathered from his extensive experience training over 25,000 analysts and professionals from leading multinational companies and from small private business corporations on the use of computer tools for risk analysis and decision making. Over 1,000 Executive and regular MBA students attend his excel workshops at Columbia, NYU, Temple and other universities every year.  Help us spread the word about the Isaac's Next Generation Excel - Tip of the Month by clicking on the Google+, LinkedIn or Facebook icons at the bottom of the page.

 May 1, 2013

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

1. Customize a Ribbon
2. Easy to remember “CTRL + number” –Shortcuts
3. Ctrl + Shift – Shortcuts
4. Hide/Reveal Ribbons
5. Median or other functions not found on the Subtotal menu
6. Find a String (functions)
7. Week Long Formula

Download the May 2013 Excel Tip of the Month.

April 1, 2013

This April Excel Tip of the Month workbook contains the following topics:

1.  Select Precedents
2.  Create Hyperlinks
3.  Copy Chart Format
4.  Multi Column Statistics
5.  Picture Effect
6.  Angle & Border

Download the April 2013 Excel Tip of the Month.

March 1, 2013

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

1.  Add Time in Excel
2.  Due Date Notice
3.  Understanding Bubble Charts
4.  Formatting Bubble Charts
5.  Unhide A Single Hidden Row Or Column
6.  Ungroup Chart Parts
7.  Leave the last names only

Download the March 2013 Excel Tip of the Month.

February 1, 2013

This February Excel Tip of the Month workbook contains the following topics:

1.  Center Across Selection
2.  Sort Left to Right
3.  INDIRECT Function referring to other sheets
4.  Delete Blank Rows
5.  The GETSTEP function
6.  Pictures in Charts video clip
7.  MAC Shortcuts Keyboard Cover

Download the February 2013 Excel Tip of the Month.

January 1, 2013

This January Excel Tip of the Month workbook contains the following topics:

1.  Fancy Bullets in Excel
2.  Remove Duplicates using Excel 2010
3.  Lunch Break Time Calculation
4.  COUNTIF - Complete Column
5.  Hide the rest of the sheet
6.  Training Clip

Download the January 2013 Excel Tip of the Month.

December 1, 2012

This December Excel Tip of the Month workbook contains the following topics:

1.     Separate Names (not text to columns)
2.     DELTA (an engineering function handy for other purposes)
3.     EXACT
4.     DETEDIF (not documented anywhere in the Excel menus)
5.     BrushTools Add-in
6.     Drop Down Options

Download the December 2012 Excel Tip of the Month.

November 1, 2012

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

1.     Count Empty Cells
2.     How to Protect Parts of a Sheet
3.     How to Wrap Text
4.     Comparison Formulas
5.     Group Box and Open Buttons
6.     Forms Toolbar
7.     Using the Info Function

Download the November 2012 Excel Tip of the Month.

October 1, 2012

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

1.     A better was to calculate Cumulative Frequency
2.     Show Positive and Negative values with the +/- sign
3.     Convert Text to Column – but keep the original text
4.     TEXT & Time or Date Displayed
5.     Drop Down List (Shortcut)
6.     A Grouping Shortcut for Subtotals

Download the October 2012 Excel Tip of the Month.

September 1, 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

Download the September 2012 Excel Tip of the Month.

August 1, 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

Download the August 2012 Excel Tip of the Month.

June 1, 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

Download the June 2012 Excel Tip of the Month.

May 1, 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

Download the May 2012 Excel Tip of the Month.

April 1, 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)

Download the April 2012 Excel Tip of the Month.

March 1, 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

Click here to download the March 2012 tip.

For 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

Click here to download the February 2012 tip.

January 1, 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

Click here to download the January 2012 tip.

December 1,  2011

1.     Find Demand and Supply Curves
2.     Supply and Demand Equilibrium
3.     Split a Workbook
4.     Format Cells with Formulas
5.     Surface Charts Again

Click here to download the December 2011 tip.

November 1,  2011

1.     Format Subtotals only
2.     Eliminate Duplicates
3.     Shortcut to merge cells
4.     Concatenate Many Values
5.     X Axis Plot Problem

Click here to download the November 2011 tip.

October 1, 2011

1.     Chart with Outliers
2.     Secondary Axis
3.     Visual Magnitude without a Chart
4.     Excel Shortcut
5.     MAC Special Shortcuts
6.     Count Words in a Cell

Click here to download the October 2011 tip.

September 1, 2011

1.     Compare lists - shortcut
2.     Pivot Table - Calculated Filed
3.     Counting with pivot Tables
4.     Macro Problem
5.     Surface Charts

Click here to download the September 2011 tip.

Check back regularly for new Next Generation Excel - Tip of the Month.