-
1 day ago
Learn Excel 2010 - "Comparative Histogram": Podcast #1522
JB asks, "How can I create a Comparative Histogram?" Today, in Episode #1522, Bill shows us how to set up our Data, create Data Lables, and Formatt...
bjele123 • 277 views
krn14242
liked
-
3 days ago
Excel Magic Trick 872: Calculate Quarters From Date:3 Methods
Download workbook: http://people.highline.edu/...
2nd Version Mr Excel & excelisfun Trick 97
1. Mr Excel CHOOSE and MONTH functi...
ExcelIsFun • 350 views
krn14242
liked
-
3 days ago
Excel Magic Trick 871: Lookup Last Line In A Cell: Formula w LEN, SUBSTITUTE, SEARCH, CHAR, MID
Download workbook: http://people.highline.edu/...
Learn how to:
1. Formula To Lookup Last Line In A Cell using LEN, SUBSTITUTE, ...
ExcelIsFun • 951 views
krn14242
liked
-
3 days ago
Excel Magic Trick 870: VLOOKUP A Date and Pattern To Simplify Formula
Download workbook: http://people.highline.edu/...
Learn how to:
1. : VLOOKUP A Date and Pattern To Simplify Formula
ExcelIsFun • 695 views
krn14242
liked
-
3 days ago
Excel Magic Trick 869: Formula Calculate First Day of Week 2010 & 2003 Formula WEEKDAY Function
Download workbook: http://people.highline.edu/...
Learn how to:
1. Create a column that contains First Day Of Week for each date...
ExcelIsFun • 815 views
krn14242
liked
-
4 days ago
Excel 2010 Statistics 77: Determine Sample Size
Download file: https://people.highline.edu...
Topics:
1. Determine Sample size
This is for the Highline Community College Busn ...
ExcelIsFun • 197 views
krn14242
liked
-
4 days ago
Excel 2010 Statistics 76: Confidence Interval To Estimate Population Proportion: NORM.S.INV Function
Download file: https://people.highline.edu...
Two Examples for building Confidence Interval To Estimate Population Proportion:
...
ExcelIsFun • 224 views
krn14242
liked
-
4 days ago
Excel 2010 Statistics 75 Confidence Intervals Sigma NOT Known T.INV, CONFIDENCE.T & Analysis Add-in
Download file: https://people.highline.edu...
Two Examples for building Confidence Intervals Sigma NOT Known:
1. T.INV Function...
ExcelIsFun • 414 views
krn14242
liked
-
4 days ago
Excel 2010 Statistics 74: Confidence Intervals Sigma Known: NORM.S.INV, CONFIDENCE.NORM Functions
Download file: https://people.highline.edu...
Three Excel methods to calculate when Confidence Intervals Sigma Known:
1. NORM.I...
ExcelIsFun • 290 views
krn14242
liked
-
4 days ago
Excel 2010 Statistics 73: Introduction To Confidence Intervals
Download file: https://people.highline.edu...
Compare and contrast:
Chapter 7:
1. Where we KNOW Population Mean, Mew.
2. We cal...
ExcelIsFun • 663 views
krn14242
liked
-
4 days ago
Learn Excel 2010 - "Paste Values with VBA": Podcast #1521
Bill looks at pasting Values today, in Episode #1521. Using one line of VBA code, Bill shows us how to convert Formulas to Values. Learn how to qui...
bjele123 • 510 views
krn14242
liked
-
4 days ago
Learn Excel 2010 - "Separate Dates from Text": Podcast #1520
Today's episode is a reversal of Episode #1517. In Episode #1520, Bill looks at two ways to solve the problem where you have text and a date in the...
bjele123 • 441 views
krn14242
liked
-
4 days ago
Learn Excel 2010 - "Record Fill Down": Podcast #1519
Today Bill shows us how to use the Macro Recorder to record the action of Double-clicking the Fill Handle. It isn't as straight-forward as you migh...
bjele123 • 366 views
krn14242
liked
-
4 days ago
Learn Excel 2010 - "MAXIF": Podcast #1518
With a list of Products and a list of Dates, Bill's mission is to find the last order date for each product in the Dataset. Learn the use of MAXIF,...
bjele123 • 549 views
krn14242
liked
-
1 week ago
Learn Excel 2010 - "Words With Dates": Podcast #1517
From a YouTube Viewer, Bill looks how to have text and actual dates reside in the same Cell. Follow along with Episode #1517 to learn how to add Cu...
bjele123 • 496 views
krn14242
liked
-
1 week ago
Mr Excel & excelisfun Trick 98: Extract & Lookup Number When Table Of Numbers Is In A Single Cell
Download workbook: http://people.highline.edu/...
See Mr Excel and excelisfun use two methods to:
1. Check whether Numbers In Ce...
ExcelIsFun • 1,922 views
krn14242
liked
-
1 week ago
Dueling Excel - "Any of These in Those?": Podcast #1516
Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin compare data in columns to discern whether 'same' figures exist in both columns, by row.
Bill goe...
bjele123 • 674 views
krn14242
favorited
-
1 week ago
krn14242
liked
-
-
2 weeks ago
Dueling Excel - "Quarters": Podcast #1515
We have a series of Dates. We want to show quarters for the year 2012. Bill 'MrExcel' Jelen goes Old School on this one while Mike 'ExcelisFun' Gir...
bjele123 • 832 views
krn14242
liked
-
2 weeks ago
Excel Magic Trick 868 Conditional Format Row Not & Between Criteria: Excel Conditional Formatting
Download from: http://people.highline.edu/...
Learn About
1. See how to use the AND function and Mixed Cell References to condit...
ExcelIsFun • 1,378 views
krn14242
liked
-
2 weeks ago
Excel Magic Trick 867 AVERAGEIFS Function w/ Not and Between Criteria
Download from: http://people.highline.edu/...
Learn About
1. AVERAGEIFS Function w/ Not and Between Criteria
2. Learn comparativ...
ExcelIsFun • 1,727 views
krn14242
liked
-
2 weeks ago
Excel Magic Trick 866: Four Lookup Values In VLOOKUP Formula? 6 Examples
Download from: http://people.highline.edu/...
See how to do lookup when there are Four Lookup Values
1. SUMIFS function to looku...
ExcelIsFun • 2,810 views
krn14242
liked
-
2 weeks ago
Show Specific Info in Excel UserForm
http://www.contextures.com/...
To show instructions to users in your Excel files, you can add comments or text boxes with notes.
Ano...
contextures • 732 views
krn14242
favorited
-
2 weeks ago
Show Specific Info in Excel UserForm
http://www.contextures.com/...
To show instructions to users in your Excel files, you can add comments or text boxes with notes.
An...
contextures • 219 views
krn14242
liked
-
3 weeks ago
Blueprint CSS Part 1 - Content Based Grid Layouts
Learn how anyone can create web pages using a grid based approach and content editing tools that produce Blueprint CSS compliant code
jittrium • 5,077 views
krn14242
liked
-
3 weeks ago
How to Make CSS Layouts With Blueprint, a CSS Framework
For more web development tutorials check out http://webhole.net/
BlueprintCSS is a framework that makes cross-browser CSS. Making layouts can't get...
webholevids • 24,411 views
krn14242
liked
-
3 weeks ago
Excel 2010 Statistics 66: Simple Random Sample Using RAND Function, Sort and Copy Paste
Download file: https://people.highline.edu...
Topics:
1. Simple Random Sample Using RAND Function, Sort and Copy Paste
This is ...
ExcelIsFun • 958 views
krn14242
liked
-
3 weeks ago
Excel 2010 Statistics 67: Formula To Extract Simple Random Sample
Download file: https://people.highline.edu...
Formula To Extract Simple Random Sample with No Repeats:
1. Two step process usin...
ExcelIsFun • 864 views
krn14242
liked
-
3 weeks ago
Excel 2010 Statistics 68: Construct Sampling Distribution Of Samples Means (Xbar)
Download file: https://people.highline.edu...
Topics:
1. Construct Sampling Distribution Of Samples Means (Xbar) using COUNT, C...
ExcelIsFun • 870 views
krn14242
liked
-
3 weeks ago
Excel 2010 Statistics 68.5: Sparklines to Compare Population and Sampling Distributions
Download file: https://people.highline.edu...
Topics:
1. Sparklines to Compare Population and Sampling Distributions
This is fo...
ExcelIsFun • 425 views
krn14242
liked
-
3 weeks ago
Excel 2010 Statistics 70: Standard Error and Correction Factor For Finite Populations
Download file: https://people.highline.edu...
Topics:
1. See calculations that show why the correction factor is not needed whe...
ExcelIsFun • 227 views
krn14242
liked
-
3 weeks ago
Excel 2010 Statistics 71: Sampling Distrib. Of X Bar As Sample Size Increase Probability Increase
Download file: https://people.highline.edu...
Relationship Between Sample Size & Probability In Sampling Distribution of Xbar:
...
ExcelIsFun • 627 views
krn14242
liked
-
3 weeks ago
Excel 2010 Statistics 72: Sampling Distribution of Sample Proportion
Download file: https://people.highline.edu...
Topics:
1. See how to calculate Standard Error and Probability for the Sampling D...
ExcelIsFun • 280 views
krn14242
liked
-
3 weeks ago
-
3 weeks ago
Excel Magic Trick 865: Data From Many Columns Into One: Recorded Macro & Paste All Clipboard
Download from: http://people.highline.edu/...
Learn About:
1. Keyboard shortcuts to select columns of data
2. Clipboard to copy ...
ExcelIsFun • 2,854 views
krn14242
liked
-
3 weeks ago
Excel Magic Trick 864: Getting Data From Internet Into Excel -- Paste Special Text
Download from: http://people.highline.edu/...
1. Copy data from the internet and then try to paste in Excel and it shows up in 1...
ExcelIsFun • 1,952 views
krn14242
liked
-
3 weeks ago
Excel Magic Trick 863: If Sat or Sun, Multiply by 15, Any Other Day Use 14 WEEKDAY & IF Functions
Download from: http://people.highline.edu/...
Learn About
1. WEEKDAY Function to determine what day of the week it is
2. Formula...
ExcelIsFun • 1,865 views
krn14242
liked
-
3 weeks ago
Learn Excel 2010 - "Stop Speak On Enter!": Podcast #1514
VJ types a value into his spreadsheet and Excel speaks the entry; but VJ doesn't want Excel to speak the entry and the 'Stop Speaking Cells' on the...
bjele123 • 903 views
krn14242
liked
-
4 weeks ago
Ruby Programming Tutorial - 5 - Creating Objects
Visit my website at http://thenewboston.com for all of my videos!
My Google+ - https://plus.google.com/108...
My Second YouTu...
thenewboston • 3,757 views
krn14242
liked
-
4 weeks ago
Ruby Programming Tutorial - 4 - Classes
Visit my website at http://thenewboston.com for all of my videos!
My Google+ - https://plus.google.com/108...
My Second YouTu...
thenewboston • 4,353 views
krn14242
liked
-
4 weeks ago
Ruby Programming Tutorial - 3 - Math and Variables
Visit my website at http://thenewboston.com for all of my videos!
My Google+ - https://plus.google.com/108...
My Second YouTu...
thenewboston • 4,253 views
krn14242
liked
-
4 weeks ago
Ruby Programming Tutorial - 2 - Writing a Simple Program
Visit my website at http://thenewboston.com for all of my videos!
My Google+ - https://plus.google.com/108...
My Second YouTu...
thenewboston • 9,559 views
krn14242
liked
-
4 weeks ago
Ruby Programming Tutorial - 1 - Installing Ruby
Visit my website at http://thenewboston.com for all of my videos!
My Google+ - https://plus.google.com/108...
My Second YouTu...
thenewboston • 67,662 views
krn14242
liked
-
1 month ago
XHTML and CSS Tutorial - 46 - How to Publish Your Website!
For all of my tutorials, go to http://www.thenewboston.com/
thenewboston • 35,327 views
krn14242
liked
-
1 month ago
XHTML and CSS Tutorial - 45 - Submitting Forms
For all of my tutorials, go to http://www.thenewboston.com/
thenewboston • 16,901 views
krn14242
liked
-
1 month ago
XHTML and CSS Tutorial - 44 - Passwords & Upload Buttons
For all of my tutorials, go to http://www.thenewboston.com/
thenewboston • 14,901 views
krn14242
liked
-
1 month ago
XHTML and CSS Tutorial - 41 - Check Boxes & Radio Buttons
For all of my tutorials, go to http://www.thenewboston.com/
thenewboston • 14,038 views
krn14242
liked
-
1 month ago
XHTML and CSS Tutorial - 39 - Max Width & Height
For all of my tutorials, go to http://www.thenewboston.com/
thenewboston • 13,896 views
krn14242
liked
-
1 month ago
XHTML and CSS Tutorial - 38 - Fixed Positioning
For all of my tutorials, go to http://www.thenewboston.com/
thenewboston • 14,185 views
krn14242
liked