EXCEL TIP OF THE MONTH

April 2014

Posted by isaacgottlieb on 11:54 pm in tip of the month | 0 comments

April 2014

1. Sheets Navigation
2. Pivot Table Classic View
3. Move between Excel Sheets & Files
4. View Two Parts of a Worksheet Simultaneously
5. Scroll Lock Problem
6. Time Stamp
7. IS Condition

June 2014

Posted by isaacgottlieb on 11:51 pm in tip of the month | 0 comments

June 2014 file:

1. MAC Quick menu Equivalent
2. Use Format Painter for the Entire Sheet
3. Comma Style Formatting
4. Change Status on Status Bar
5. Hide Columns on all (or many) Sheets
6. Remove Duplicates
7. Insert Sheet Shortcut
8. MAC Shortcuts Comprehensive List

November 2014

Posted by isaacgottlieb on 11:45 pm in tip of the month | 0 comments

November 2014 tips of the month:

1. Easiest way to remember Shortcuts
2. Flag Birthday
3. Secondary Axis
4. The Choose Function
5. Utilizing the Choose Function
6. Choose Function + Form Tool
7. Mark the Weekend

May 2014

Posted by isaacgottlieb on 11:41 pm in tip of the month | 0 comments

May 2014 – list of topics:

1. Four ways to Hide/Show the full ribbon Menu
2. Repeat the last action
3. Insert Headers and Footers
4. Quick access the Quick Access menu
5. Get the Functions Menu
6. Get the Functions Menu
7. Select All Objects

July 2014

Posted by isaacgottlieb on 11:38 pm in tip of the month | 0 comments

July 2014 tips:

1. Checking for Errors
2. Instant Chart Shortcut
3. Formula Easy to Read
4. New for Excel 2013

September 2014

Posted by isaacgottlieb on 11:37 pm in tip of the month | 0 comments

September 2014 tips:

1. Dynamic Row or Column number
2. Show or Hide Formulas
3. Fill Data from the cells above
4. Data Validation
5. Animate your Charts

October 2014

Posted by isaacgottlieb on 11:35 pm in tip of the month | 0 comments

October 2014:

1. Select a range – a different way
2. Word in Excel
3. Group and Outline
4. Remove apostrophes
5. Last Cell I worked

August 2014

Posted by isaacgottlieb on 11:31 pm in tip of the month | 0 comments

These are the August 2014 ideas:

1. Display or hide all zero values on a worksheet
2. Relative address NAME
3. Date Problem: Sort by birthday not by birth date
4. Hide cells information or contents
5. Filter by selected color
6. Make Your Spreadsheet Fit Your Screen

February 2014

Posted by isaacgottlieb on 10:35 pm in tip of the month | 0 comments

February 2014 Tips:

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

January 2014

Posted by isaacgottlieb on 8:55 pm in tip of the month | 0 comments

1. January 2014 files contains:
2. Browsing Efficiently
3. Conditional Formatting I
4. Conditional Formatting II
5. Link Textbox, Object to Cell
6. Calculate Dates
7. Sum Groups
8. Prefill a Cell

March 2013

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

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 last names only

February 2013

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

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

January 2013

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

 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

December 2012

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

These are the December 2012 Tips:

1. Separate Names

2. DELTA

3. EXACT

4. DETEDIF

5. BrushTools Add-in

6. Drop Down Options

November 2012

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

These are the December 2012 Tips:

1. Separate Names

2. DELTA

3. EXACT

4. DETEDIF

5. BrushTools Add-in

6. Drop Down Options