Posts by isaacgottlieb

March 2013 0

March 2013

This month’s file contains: 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. Keep the...

Learn More
February 2013 0

February 2013

February 2013 Tips: 1. Center Across Selection 2. Sort Left to Right 3. Indirect to other sheets 4. Delete Blank Rows 5. The GETSTEP function 6. Pictures in Charts video clip 7. MAC Shortcuts Tip of the...

Learn More
January 2013 0

January 2013

 1. Fancy Bullets in Excel 2. Remove Duplicates Excel 2010 3. Lunch Break Calculation 4. COUNTIF – Column 5. Hide the rest of the sheet 6. Video Clip Tip of the...

Learn More
December 2012 0

December 2012

These are the December 2012 Tips: 1. Separate Names 2. DELTA 3. EXACT 4. DETEDIF 5. BrushTools Add-in 6. Drop Down Options Tip of the...

Learn More
November 2012 0

November 2012

These are the December 2012 Tips: 1. Separate Names 2. DELTA 3. EXACT 4. DETEDIF 5. BrushTools Add-in 6. Drop Down Options Tip of the Month...

Learn More
October 2012 0

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....

Learn More
September 2012 0

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...

Learn More
August 2012 0

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...

Learn More
June 2012 0

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...

Learn More
FacebookYouTubeTwitter