Excel Magic Tricks # 1: Formulas & Cell References
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm See Excel Magic! See how to build your spreadsheet smartly, so it updates automatically. See how to create formulas with cell references! |
Excel Magic Trick # 2: Chart Keyboard Trick
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm Excel 2007 Chart! See how when formula input data is changed the formulas in the Table and the Chart update!! Plus, cool "Create Chart" keyboard shortcut. |
Excel Magic Trick # 3: AVERAGE & Go To Blanks
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm Excel! Learn how to use the Ctrl + Enter keyboard Trick to enter formulas or data into many cells simultaneously. Also, learn how the AVERAGE function ignores Blanks, but not zeroes! And finally, learn about the amazing GoTo feature to select all Blanks in a range! |

Excel Magic Trick #4: SUM function Keyboard Trick
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm Excel! See how to add data or a formula to a range of cells by using Ctrl + Enter! Also, see the keyboard shortcut for the Auto SUM function and the Currency Format. Lightening fast keyboard short cuts to make work go faster and to show off to your boss! |
Excel Magic Trick #5: Data Validation List & VLOOKUP
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm Excel! See how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values. See how to do this lightening fast with keyboard short cuts! Excel Magic Trick 167p1 IF function formula: 12 Examples! Excel Magic Trick 167p2 IF function formula: 12 Examples! |
Excel Magic Trick #6: Conditional Formatting for a Row
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm Excel! See how to add Conditional Formatting to a whole row of data. See that the formula for this is a True/False formula. Then see how as you change the input, the conditional formatting magically updates! See how to do this lightening fast with keyboard short cuts! |

Excel Magic Trick #7: Clear Formatting Only!
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm Excel! See how to remove the formatting from the cell, but not the cell content! Then see how to remove Everything -- the formatting and the cell content. See how to do this lightening fast with keyboard short cuts! |
Excel Magic Trick #8: Text To Column
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm Excel! Need to separate first and last name into two cells? Need to take a column of text and break it apart into multiple columns? This is called "Text to Column"! See how easy it is to do in Excel! Also, see a cool keyboard shortcut to highlight a whole column of data quickly. |
Excel Magic Trick # 9: Join 2 Cells into 1
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm Excel! See how to take two columns of data and join them into one column! This process is called Concatenation. And we will use the join operator "&" to create a Text formula! Yes that is right, formulas are not just for numbers anymore! Also, see how to double click the fill handle to copy a formula down quickly. |

Excel Magic Trick # 10: 3 types of Averages!
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm Excel! 3 types of Averages! See how to use the AVERAGE, MEDIAN and MODE functions in Excel. Also see how to name a cell range and how to sort to verify that the functions worked correctly. |
Excel Magic Trick #11: How Good Is Your Average?
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm Excel! Learn 3 types of Variation measures including Standard Deviation. See how to determine whether your average fairly represents its data points and how spread out the data points are! See how to use the functions: STDEV, VAR and AVEDEV. Also, see how to name multiple ranges with just one keyboard shortcut! |
Excel Magic Trick #12: Date Math!
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm Excel! Learn how to calculate the time between 2 dates like invoices past due. Learn how to calculate a loan due date or how many days you have been alive! Also, learn the lightening fast keyboard shortcuts for removing Number format. |

Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functions
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm See how to use the SUMIF and COUNTIF functions to add and count given a certain condition. With this trick you can add only the sales for the salesperson Tina -- or count them! Also, see the super fast keyboard shortcut for naming multiple ranges. Count words text based on a Condition. Count words text based on criteria. SUM Values based on a Condition. SUM Values based on criteria. |
Excel Magic Trick #14: Amazing Find & Go To Trick!
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm See how to use the Find command to go to all cells with a certain formatting, or even a certain function! Then it is easy to make universal changes after you have all the cells with a certain condition highlighted! This trick can speed up work and help you find hidden items that would be hard to find otherwise! Find, Go To, GoTo, Replace. |
Excel Magic Trick #15: SUM or COUNT Above Some Limit!
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm See how to use the SUMIF and COUNTIF functions to add and count above some limit. You can add only the Sales above $5000, or any other number! See how to use the join symbol to list criteria efficiently in the SUMIF and COUNTIF functions. Also, see the new Excel 2007 AVERAGEIF function! Count values above Upper Value. Count values above Upper Bound. Count Values based on a Condition. Count Values based on criteria. Count values above Upper Limit. |

Excel Magic Trick #16: Randomly Generate Numbers (0-1)
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm See how to use the RAND() function to randomly generate numbers between 0 and 1. See how to use the RAND() function to randomly sort a list of data. |
Excel Magic Trick #17: Randomly Generate Whole Numbers
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm See how to use the RANDBETWEEN function to randomly generate whole numbers. See how to randomly assign numbers to employees. |
Excel Magic Trick #18: Randomly Generate Letters
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm See how to use the ROW, CHAR and RANDBETWEEN functions to randomly generate letters. See how to randomly create letter sequences. |

Excel Magic Trick #19: Randomly Generate Words
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm See how to use the CHOOSE and RANDBETWEEN functions to randomly generate words. See how to randomly select a Region from all your sales regions. |
Excel Magic Trick #20: Lightening Fast Copy Trick!
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm See how to use the fill handle to copy a whole table or column with formatting, numbers and formulas to many other areas instantly! The trick is to leave one row of blanks below your table! |
Excel Magic Trick #21: BINOMDIST function for Probability
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm See how to use the BINOMDIST function to calculate probabilities for a binomial experiment - binomial distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation to help with the concept! Excel Statistics. |

Excel Magic Trick #22: NORMDIST function for Probability
Add to EJ Playlist Download Excel workbook: http://people.h ighline.edu/mgi rvin/excelisfun .htm See how to use the NORMDIST function to calculate probabilities for a population with a normal (bell) distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation to help with the concept! |
Excel Magic Trick 99 Instead of IF function use MAX and MIN!
Add to EJ Playlist See how to use the IF and the MAX and the MIN functions to solve a basic problem in three different ways! See how to calculate the excess amount over a hurdle in three different ways! Amazing use for the MAX and MIN functions instead of the IF function! Formula and functions |
Excel Magic Trick #98: Conditional Formatting for Calendar
Add to EJ Playlist See how to use a TRUE/FALSE formula and the TODAY function to format a calendar within a two-week period. Formula and functions |

Excel Magic Trick #97: AVEDEV function
Add to EJ Playlist Basic Statistics. See how to use the AVEDEV function to measure the spread (variation) in a data set. Also see the STDEV function. Measure whether a mean represents its data points fairly. Formula and functions |
Excel Magic Trick #96: EXACT function
Add to EJ Playlist See how to use the EXACT function to check to see whether two text strings are equivalent and whether or not they have the same case. TRUE FALSE Formula and EXACT function |
Excel Magic Trick #95: DOLLAR function
Add to EJ Playlist See how to use the DOLLAR function to convert a number to a text string formatted with the Currency Format. See how to create a label for a Monthly Payment table (PMT). See how to create a text formula and use the ampersand to concatenate. Text Formula and DOLLAR function |

Excel Magic Trick #94: VLOOKUP Into Web Query
Add to EJ Playlist See how to use a currency web query, and then link it to a data validation cell drop down list and a VLOOKUP formula that transforms a Balance Sheet from One Currency To Another. VLOOKUP and Web Query and Data Validation Formula and functions |
Excel Magic Trick #93: Gantt Cell Chart Conditional Formatti
Add to EJ Playlist See how to use Conditional Formatting to create a Gantt Cell Chart. See how to use Conditional Formatting to highlight a range of cells that space a certain Time Frame. Formula and functions |
Excel Magic Trick #92: Two Chart Types In One Chart!
Add to EJ Playlist See how to: Add Data Series To Chart, Change the Chart Type for just one Data Series and see an excellent copy data to chart trick. Charts and Formula and functions |

NEWS Top Videos Music Classical Listen Funny Fails Artist List Aww Gaming Minisode Science Technology TED TWiT Trailers M.M. PBS WSJ AP CSPAN CNN RT TMZ E! ABC CBS Politics Sports ESPN WTF Conspiracy