See these 10 Sorting Examples: 1. Sort 1 column with buttons 2. Add an order column to you can return to original sort order 3. Sort 2 columns with buttons 4. Sort 2 column with Sort dialog box 5. Keyboard shortcut Alt + D + S 6. Right-clicking to sort 7. Sort Left To Right [...]
examples
Excel Magic Trick 501: Excel Time Format & Calculations (10 Examples)
Learn about: 1.What time is in Excel 2.Time in Excel is a decimal between 0 and 1, and the decimal represents the proportion of one 24 hour day that has elapsed 3.Time Number Format sits on top of the decimal 4.The decimal is used in time calculation formulas, not the formatted number 5.Payroll time Calculation [...]
Excel Formula Efficiency 1: SUMPRODUCT function 12 Examples
Learn about the basics of SUMPRODUCT function and why some people use double negative and why other use times one. Learn theses important points: 1.When using the SUMPRODUCT function and multiple criteria, see how multiplying by one is more flexible than the double negative 2.When using the SUMPRODUCT function and multiple criteria, see how using [...]
Excel Magic Trick #180: COUNTIF function formula 21 Examples
See methods for counting: specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values than are NOT equal to an amount, words that end in es, all words, all numbers, all content, all blanks, not words, and more! Learn about the syntax that the COUNTIF function uses and see different methods [...]
Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)
Download files at: people.highline.edu The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. PivotTables are easy: Just envision the table in advance 2. Field list has fields and areas that you can drag fields to 3. Column Labels — Column Headers [...]
Highline Excel Class 21: Conditional Formatting 12 Examples
See how to add conditional formatting for: 1)Data Bars to show relative size 2)Icons to show relative size 3)Highlight values within 1 standard deviation 4)Highlight MIN in column with a TRUE FALSE formula 5)Highlight MAX in column with a TRUE FALSE formula 6)Highlight two largest values with a TRUE FALSE formula 7)Highlight a of values [...]
Web Site Cookbook: Solutions & Examples for Building and Administering Your Web Site
ISBN13: 9780596101091 Condition: New Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold! Product DescriptionThe total number of web pages today has been estimated at over 3 billion, spanning millions of individual websites. Not surprisingly, there is tremendous pressure on web developers and designers [...]
Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)
Download files at: people.highline.edu The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Use IF function to put one of two things into a cell or formulas 2. Logical Formula comes out to be TRUE or FALSE 3. Logical Test is [...]
Excel Magic Trick 167p1 IF function formula: 12 Examples!
Part 1. See 12 different examples of how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see these functions: AND, OR, SUM, AVEARAGE, STDEVP, and VLOOKUP. See how to use the IF function to [...]