FC2Video

A YouTube viewer asks if there is a way to add the current date to the right of any 'Yes' entries in a spreadsheet. Using a simple 'Event Handler' macro, Bill creates a means to answer the question.

Today in Episode #1473, Dueling Excel looks at Scores and Tie Breaking. In this example, When there is a tie, we want to award the Highest Rank to the Largest Weight. Quite simply, after ranking a column with ties, we want to break the tie.

Herbie has a Calendar spreadsheet being populated by a huge concatination formula. He asks if there is a way to combine Wrap Cells and Shrink to Fit as he works in the calendar. In Episode #1472 Bill shows us one way to accomplish this.

Choose random weeks from the Data Set, but do it without repeating a week. In a revisiting #1469, how will Bill assure that there are no repeats? Follow along with Episode #1471 today to learn the answer and solve the challenge.

http://www.TablasDinamicasExcel.com/ - Vídeo que muestra cómo Mover, Copiar, Seleccionar o Borrar una Tabla Dinámica en Excel 2010.

Cornerstone Design and Remodel is a full service Kitchen and Bath remodeling company. We offer in-home design services and sales. You will get incredible results from our team of skilled craftsmen who excel in all areas of Kitchen and Bath remodeling. Please Call Us at 619-838-1687 or Visit Our Website at www.kitchensd.com

Wherever you are in your walk with the Lord, as good as you may be doing, halleluiah, we can all still press on to a higher place where we 'excel still more' - the calling of God is an upward calling

Patrick has a weekly Expense Ledger Spreadsheet set up; he wants to create a Macro to copy the Totals from Report 1 to a corresponding Week Number Row on the Summary worksheet. This Macro has to use the FIND command in VBA to...

A YouTube viewer wants to find a way to generate random weeks over the next 6 months. In Episode #1469, Bill – using TODAY, WEEKDAY, and RANDBETWEEN Functions – shows us a Formula to calculate random weeks for the next 6 months or year.

Shaun has a beautiful spreadsheet to calculate staffing levels and expense.He needs to multiply shift length by the number of staff and the answer that he is getting is . . . immaterial to the task at hand.

Formulas are ‘changed’ and that the Alpha Columns of the worksheet have been changed to Numbers. What happened? “R1C1″ is the answer. Learn Excel 2010 from MrExcel!

Cornerstone Kitchen Design and Bath Remodeling is a full service Kitchen and Bath remodeling company. We offer in-home design services and sales. You will get incredible results from our team of skilled craftsmen who excel in all areas of Kitchen and Bath remodeling.

Cornerstone Kitchen Design and Bath Remodeling is a full service Kitchen and Bath remodeling company. We offer in-home design services and sales. You will get incredible results from our team of skilled craftsmen who excel in all areas of Kitchen and Bath remodeling.

Can you embed a PDF in a worksheet? Yes - Using the 'Insert Object' Menu Tab. Follow along with Bill, in Episode #1466, as he shows us how to embed a PDF in our Worksheet.

The Excel Solution for TruePlanning 2012 takes advantage of the newly enhanced distributed COM interface.

Gary points out that the TRIM Function in VBA isn't working like =TRIM() Function in the worksheet; the spaces in the middle remain after a Macro run. Bill shows us, In episode #1465, how to solve this issue with the 'Application.WorksheetFunction'.

Tony needs to keep the last duplicate record and throw out the earlier ones. In Episode #1464 Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen demonstrate competing methods to get this issue solved. Duel #90 - Learn Excel 2010 from MrExcel!

Shrikant needs to join the left 26 characters of column A with column B. But...even if A2 only has 10 characters, he needs it to fill with spaces each and every time. In Episode #1463, Bill shows us how to maintain this positioning of data.

Stefan from Sweden checks in with a much better way to do a word count of all the sentences [referring to the "Word Count from Sentences" Podcast, Episode #1460]. How? Using… a tiny little Add-In that most Excel Users already have! Learn Excel 2010!

1. Why can't we do a Pivot Table Template? 2. Why can't we turn off the annoying Compact Layout? 3. Why do I keep asking these questions when it is so easy to override them with a tiny add-in? MrExcel Labs is coming out with a tiny add-in to...

Today on Learn Excel from MrExcel, Zac has 5000 phrases in column A. He wants to figure out which words are most popular in those phrases. With Episode #1460, Bill shows us a number of steps that will solve the problem in about six minutes.

“Can you get the pivot table grand total column to appear on the left side of the pivot table?” In Episode #1459, Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen come up with differing strategies for solving this problem.

Jil used to be able to edit a Formula and use the Wheel Mouse to scroll the Spreadsheet while editing the formula. This apparently doesn’t work any more, starting in Excel 2007. In Episode #1458, Bill shows us a workaround.

Bob Umlas’ new book just arrived from the printer – “Excel Outside the Box: Unbelievable Excel Techniques”. Bill takes a look at the new book, tells you where you can buy an advanced copy, and shows you a trick from the book.

Two Pivot Table questions from my Power Excel Seminar in Detroit, MI. First, when I drill down on a pivot table in Excel 2007, I'm getting the Table Format, not just a Range. How can I get the Range? Second, when I convert a Pivot Table to Values...

Frank asks if there is a way to rewrite a formula using a scrollbar. While we can't do it with a scrollbar, I do have a way to rewrite formula with a dragging technique. Following along with Bill in Episode #1455 to see how it's done.

Today, Bill “MrExcel” Jelen and Mike “ExcelisFun” Girvin look at a question that asks: “How can I audit 70% of the book value, with samples based on the value?” Watch the Duel, learn the method, get the result with Episode #1454. Learn Excel!

Kevin wants to clear out data for yesterday’s shift worksheet any time someone opens the Workbook. Using the formula from Episode #1452, plus four tiny macros added he has added, Bill shows us the solution today in Episode #1453. "Learn Excel 2010".

“Did a new shift start between Time 1 and Time 2? It sounds like an easy formula, and it probably is, but I sure had a tough time with this formula out. Do you have a solution?” In Episode #1452, MrExcel looks at working with time and day changes.

http://www.cadtoprint.co.uk A3 Printing in Excel for A3 Poster Printing or A3 Chart Printing. Video tutorial, shows you how to scale your excel document to fit an A3 Page in PDF format then print. See our A0 Poster Printing, A1 Poster Printing and A2 Poster Printing videos.

http://www.cadtoprint.co.uk A2 Printing in Excel for A2 Poster Printing or A2 Chart Printing. Video tutorial, shows you how to scale your excel document to fit an A2 Page in PDF format then print. See our A0 Poster Printing, A1 Poster Printing and A3 Poster Printing videos.

http://www.cadtoprint.co.uk A1 Printing in Excel for A1 Poster Printing or A1 Chart Printing. Video tutorial, shows you how to scale your excel document to fit an A1 Page in PDF format then print. See our A0 Poster Printing, A2 Poster Printing and A3 Poster Printing videos.

http://www.cadtoprint.co.uk A0 Printing in Excel for A0 Poster Printing or A0 Chart Printing. Video tutorial, shows you how to scale your excel document to fit an A0 Page in PDF format then print. See our A1 Poster Printing, A2 Poster Printing and A3 Poster Printing videos.

Joe has Excel 2011 for Mac. He has found that the Excel Mac Macro Recorder uses ‘xlAutomatic’ for all colors instead of the actual color. In my first-ever podcast focusing on Excel for Mac, I will show you how to use the ‘RGB Function’ to fix the VBA

This video shows you how to use macros in Excel.

Range Names in Excel Macros are very useful functions and having an Excel Expert to support you can really help get the value out of your data. Visit us for more help with Excel consulting.

Today, in Episode #1450, Christopher and Sheila both wrote in with different problems that required the same solution. Both happened to have numbers or dates stored as text. The Alt+DEF shortcut came worked - And Bill shows us how!

Today, in Episode #1449, Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen address different methods to answer the question: “Is there a way that the Grand Totals and Subtotals would omit the Negative Subtotals?” "Learn Excel 2007 through Excel 2010"

Today, in Episode #1448, Bill re-addresses a few past podcasts with alternate solutions. Follow along, make note and improve your effectiveness with Microsoft Excel! "Learn Excel 2007 through Excel 2010 from MrExcel" by Bill Jelen. Visit MrExcel.com

Want to see immediate results? Set an area to the bottom and right of a massive spreadsheet where you can add totals and see them at a glance. In Episode #1447 Bill shows us how to do this with only a few keystrokes.

In today’s Dueling Excel Podcast, with Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen, Mike and Bill look at methods to calculate the MODE and MEDIAN from data that is arranged in a Frequency Table. Episode #1446 shows us how its done.

No.6 nasce come adattamento animato dell'omonima serie dei racconti della scrittrice Atsuko Asano la cui pubblicazione è iniziata per opera della Kodansha nel 2003 e continuata fino al 2009. Prodotta da Studio Bones affidata alla regia dell'esordiente Kenji Nagasaki, l character design è di Satoshi Ishino (Excel Saga, Nogizaka Haruka no Himitsu), mentre le musiche sono affidate a Keiichi Suzuki [La descrizione è stata presa dal video di Debris65 su Dailymotion - PV No.6] La canzone è tratta dalla colonna sonora del film Arrietty - Il mondo segreto sotto il pavimento, cantata dalla bellissima Cecile Corbel. -------------------------------------------------

In a spreadsheet that keeps track of expenses, we want to mark the cell in one color if the expenses are within 25% of the budget and in another color if they are within 10% of the budget. Today, Bill shows us how to do this. Learn Excel Podcasts!

Is it possible to flag a cell if the time in the cell is more than an hour late? Today, in Episode #1444, Bill shows us a Conditional Formatting Formula to answer this question. "Learn Excel 2007 through Excel 2010 from MrExcel" by Bill Jelen.

Jack asked about centering titles above a report. I suggested “Center Across Selection”, and Jack’s coworker suggested “Merge and Center”. While it is a lot easier to find Merge and Center, there are reasons why you don’t want to use this to method.

I want to Hide some Settings right in plain view on the spreadsheet, but the person using the spreadsheet keeps inadvertently deleting those settings! In Episode #1442, Bill shows us one solution to keeping those settings from being deleted.

Amal wants to highlight an entire record in red when the date falls within two weeks and then, leave the ‘Done’ column not marked as True. In Episode #1441, Bill shows us the tricky Conditional Formatting method to get the results we want.

“Last week, I needed one Chart to use the colors from one Theme and a second Chart to use the colors from another Theme. The Chart Fill Dropdown wasn’t helping, but I found a workaround. In Episode #1440, Bill gives us the details.

Video: AniMix - Full project (Preview) Category: Action, Comedy, Other, etc. (+3) Anime: Vampire Hunter D: Bloodlust, Excel Saga, Steel Angel Kurumi, etc. (+147) Song: Get Ready For This!, Fire, Where Do You Go, etc. (+242) Artist: 2 Unlimited, Scooter, No Mercy, etc. Creator: AniMix and others (+92) (AniMix)

Mike's son Dennis has a baseball problem from his algebra class. Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin differ over whether the problem actually requires Algebra, Goal Seek, or simply a visit with Bob Barker.