EXCEL TIP OF THE MONTH

EXCEL TIP OF THE MONTH

“This is one of the most interesting ways to stay on your toes

and keep curent in the real world”

April 2014

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

April 2014

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
April 2014

June 2014

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

June 2014

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
June 2014

November 2014

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

November 2014

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
November 2014

May 2014

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

May 2014

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
May 2014

July 2014

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

July 2014

July 2014 tips:

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

September 2014

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

September 2014

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
september 2014

October 2014

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

October 2014

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
october 2014

August 2014

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

August 2014

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

 

August 2014

February 2014

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

February 2014


Feb 2014February 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 on 8:55 pm in tip of the month | 0 comments

January 2014
  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

 

Tip of the Month http://isaacgottlieb.com/wp-content/uploads/2014/11/Excel-Tip-of-the-Month-January-2014.xlsx

March 2013

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

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

Tip of the Month

 

February 2013

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

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 Month

January 2013

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

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 Month

December 2012

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

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 Month

November 2012

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

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

 

FacebookYouTubeTwitter