Posted by isaacgottlieb on 11:54 pm in tip of the month | 0 comments
April 2014
- Sheets Navigation
- Pivot Table Classic View
- Move between Excel Sheets & Files
- View Two Parts of a Worksheet Simultaneously
- Scroll Lock Problem
- Time Stamp
- IS Condition
April 2014
Posted by isaacgottlieb on 11:51 pm in tip of the month | 0 comments
June 2014 file:
- MAC Quick menu Equivalent
- Use Format Painter for the Entire Sheet
- Comma Style Formatting
- Change Status on Status Bar
- Hide Columns on all (or many) Sheets
- Remove Duplicates
- Insert Sheet Shortcut
- MAC Shortcuts Comprehensive List
June 2014
Posted by isaacgottlieb on 11:45 pm in tip of the month | 0 comments
November 2014 tips of the month:
- Easiest way to remember Shortcuts
- Flag Birthday
- Secondary Axis
- The Choose Function
- Utilizing the Choose Function
- Choose Function + Form Tool
- Mark the Weekend
November 2014
Posted by isaacgottlieb on 11:41 pm in tip of the month | 0 comments
May 2014 – list of topics:
- Four ways to Hide/Show the full ribbon Menu
- Repeat the last action
- Insert Headers and Footers
- Quick access the Quick Access menu
- Get the Functions Menu
- Get the Functions Menu
- Select All Objects
May 2014
Posted by isaacgottlieb on 11:38 pm in tip of the month | 0 comments
July 2014 tips:
- Checking for Errors
- Instant Chart Shortcut
- Formula Easy to Read
- New for Excel 2013
July 2014
Posted by isaacgottlieb on 11:37 pm in tip of the month | 0 comments
September 2014 tips:
- Dynamic Row or Column number
- Show or Hide Formulas
- Fill Data from the cells above
- Data Validation
- Animate your Charts
september 2014
Posted by isaacgottlieb on 11:35 pm in tip of the month | 0 comments
October 2014:
- Select a range – a different way
- Word in Excel
- Group and Outline
- Remove apostrophes
- Last Cell I worked
october 2014
Posted by isaacgottlieb on 11:31 pm in tip of the month | 0 comments
These are the August 2014 ideas:
- Display or hide all zero values on a worksheet
- Relative address NAME
- Date Problem: Sort by birthday not by birth date
- Hide cells information or contents
- Filter by selected color
- Make Your Spreadsheet Fit Your Screen
August 2014
Posted by isaacgottlieb on 10:35 pm in tip of the month | 0 comments
February 2014 Tips:
- Change Case
- Move ONLY between Excel files
- Browser Tips
- Formatting Dates
- Calculate Date Difference without Holidays
- Data Cleansing
- Hyperlink
Posted by isaacgottlieb on 8:55 pm in tip of the month | 0 comments
- January 2014 files contains:
- Browsing Efficiently
- Conditional Formatting I
- Conditional Formatting II
- Link Textbox, Object to Cell
- Calculate Dates
- Sum Groups
- Prefill a Cell
Tip of the Month http://isaacgottlieb.com/wp-content/uploads/2014/11/Excel-Tip-of-the-Month-January-2014.xlsx
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
Tip of the Month
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
Tip of the Month
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
Tip of the Month
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
Tip of the Month
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
Tip of the Month