dmr450's channel

Derek "Deek" Diedricksen (from his new book "Humble Homes, Simple Shacks") builds a spin-off of his cabin design "Down At Big Lee's Swamp", for Mas...

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,...

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...

Download workbook: http://people.highline.edu/...

See Mr Excel and excelisfun use two methods to:

1. Check whether Numbers In Ce...

Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin compare data in columns to discern whether 'same' figures exist in both columns, by row.

Bill goe...

Illustrated, simple, math exercise that illustrates the problem of using Cartesian coordinates when plotting a circle.

Bridging algebra and geometry. What makes linear equations so linear.

If your fiscal year does not end on December 31, then all of the cool date grouping functions available in pivot tables will not work for you. In E...

Download workbook: http://people.highline.edu/...

See Mr Excel and excelisfun use two methods to create a formula that can take ...

Download from: http://people.highline.edu/...

Learn About

1. AVERAGEIFS Function w/ Not and Between Criteria

2. Learn comparativ...

Download from: http://people.highline.edu/...

Learn About

1. See how to use the AND function and Mixed Cell References to condit...

http://www.contextures.com/...

To show instructions to users in your Excel files, you can add comments or text boxes with notes.

Ano...

Download file: https://people.highline.edu...

Topics:

1. See how to calculate Standard Error and Probability for the Sampling D...

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...

Download from: http://people.highline.edu/...

Learn About:

1. Keyboard shortcuts to select columns of data

2. Clipboard to copy ...

Download from: http://people.highline.edu/...

Learn About

1. WEEKDAY Function to determine what day of the week it is

2. Formula...

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...

Charlie -who admits he is relatively new to Microsoft Excel- needs to rearrange the rows of his spreadsheet. Today, in Episode #1512, Bill shows u...

Download workbook: http://people.highline.edu/...

See Mr Excel and excelisfun use two methods to lookup a column of sales amount...

Today, in Episode #1511, Bill reviews Counting Between Ranges using a Pivot Table solution.

Due to a slight mix up, the follow-up to Learn Excel fr...

Download from: http://people.highline.edu/...

Create:

1. Helper column using AND function and the "not comparative operator" to ...

Richard has a Data Series Set up with Year, Female, Male; after moving from Excel 2003 to Excel 2007, Richard noticed that the Chart is giving thre...

Download from: http://people.highline.edu/...

See how to conditionally format end stock values that have increased or decresed ...

Today's Dueling Challenge: "Conditionally Format End Values that have Increased or Decreased by 15%"

Initially, it appears that there is only one ...

http://www.learntoprogram.tv

Follow me on Google+: http://www.MarkLassoff.com

Follow me on Twitter: @mlassoff

From Learn To Program dot TV (LearnT...

http://www.learntoprogram.tv

Follow me on Google+: http://www.MarkLassoff.com

Follow me on Twitter: @mlassoff

From Learn To Program dot TV (Learn...

The Question: "I have a =COUNTIF to count values less than 10 and another to count values less than 20; but how do I count the values that fall bet...

Download from: http://people.highline.edu/...

1. Convert Month As Text To 3 Letter Abbreviation Using LEFT Function

Download from: http://people.highline.edu/...

1. Calculate the MAX & MIN Across Multiple Sheets Using Rectangular Range 3-D Cell...

Download from: http://people.highline.edu/...

1. Use Month function and Ampersand to Convert Month As Text To Number January = 1...

Download from: http://people.highline.edu/...

1. Conditional Format 50 Columns Using Format Painter to apply Format to Above Bel...

See how to use the COUNTIF Function to Count How Many 1s or 2s or 3s There Are In Column . See how to use entire column for range argument in COUNT...

See how to change the Time Number Formatting for time values in Excel from Military Time To Non-Military Time. Keyboard for Format Cells Dialog box...

Today's Learn Excel Question: "Can you use Excel to generate Random Numbers that are centered around a mean using a Standard Deviation?" =RANDBETWE...

Bill Gurstelle shows you how to make a tuning fork from a piece of aluminum in this video complementing his column in MAKE Volume 29.

http://makez...

Simons gets an accounting file from the company system. When he opens the accounting file, some G/L [General Ledger] codes are converted from the N...

The Question: "How do I generate the next Invoice Number?" Microsoft Office Online offers a great number of Invoice Templates. However, none of tho...