

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 dropdown 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 #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 #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



