Next Generation Excel - Tip of the Month

Next Generation Excel Second EditionDr. 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.

Watch Dr. Gottleib's video on using Excel for logistics.

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

1.       Format Cells with Specific Information

2.      Counts

a.     Count Duplicates COUNTIF

b.     Count Duplicates Pivot Table

c.      Count Duplicates Subtotal

3.      Print Visible Cells Only

4.      Split Screen

5.      Delete all the Blank Rows

6.      Review Office Writer

Download the March 2014 Excel Tip of the Month.

 
February 1, 2014
 
The February 2014 Excel Tip of the Month workbook contains the following topics:

1.      Change Case

2.      Move ONLY between Excel files

3.      Browser Tips

4.      Formatting Dates

5.      Calculate Date Difference without Holidays

6.      Data Cleansing

7.       Hyperlink

Download the February 2014 Excel Tip of the Month.

 
January 1, 2014
 
The January 2014 Excel Tip of the Month workbook contains the following topics:
1. Browsing Efficiently
2. Conditional Formatting I
3. Conditional Formatting II
4. Link Textbox, Object to Cell
5. Calculate Dates
6. Sum Groups
7. Prefill a Cell
 
 
December 1, 2013
 
The December Excel Tip of the Month workbook contains the following topics:
1. Dates Format Shortcut
2. Lock Desktop
3. Align Decimals
4. Leading Zeros
5. Bold Specific Rows
6. Browsing Efficiency
7. Print Row and Column Heading
 
 
November 1, 2013
 
The November Excel Tip of the Month workbook contains the following topics:
1. Rolling Dice in Excel
2. Delete all Comments
3. MS Word Tip: Count Words and everything else
4. Minimize and Maximize the Workbook
5. Help in Entering a Formula Shortcut
 

October 1, 2013
 
The October Excel Tip of the Month workbook contains the following topics:
1.   Calculating Elapsed Time
2.   Sorting Shortcuts
3.   Link Cells
4.   Paste Special Shortcut
5.   Date & Time Shortcuts (Excel and Word)
6.   Open Excel Files Problem

Download the October 2013 Excel Tip of the Month.

 
August 1, 2013

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

1.    Animate any Chart in Excel
2.    Show /Hide Formulas
3.    Right Click Keyboard Shortcuts for Windows
4.    Right Click Keyboard Shortcuts for MAC
5.    Align Cells shortcuts in Excel
6.    Align Text shortcuts: (Word, PowerPoint, Outlook etc.)
7.    Validating Text Cell Length

Download the August 2013 Excel Tip of the Month.

July 1, 2013

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

1.    Day Number of the Year Calculator
2.    Calculate Remaining Days in the Year
3.    Border On - Border Off  (shortcuts)
4.    Split first name and last name into separate cells USING A FORMULA (not Text to Columns)
5.    Hide and Unhide rows and columns (shortcuts)
6.    Number Formats (shortcuts)
7.    Two Ways for an Entire Book Searchs play

Download the July 2013 Excel Tip of the Month.

June 1, 2013

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

1.    Print Preview Keyboard Shortcut
2.    Turn on & off Filter Keyboard Shortcut
3.    Old Style Menus Button
4.    Clipboard
5.    Time Display Format
6.    Day of the Week Display
7.    Excel's Capacity

Download the June 2013 Excel Tip of the Month.

 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.
 

 

Discover the Power