MrExcel

MrExcel смотреть последние обновления за сегодня на .

VLOOKUP 101 - 1120 - Learn Excel from MrExcel Podcast

6477
48
4
00:02:49
12.10.2009

VLOOKUP is my favorite function in Excel. In Episode 1120, we will take a look at the basics of VLOOKUP. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Learn Excel from MrExcel

20013
45
4
00:01:08
23.07.2006

Episode 101 of the MrExcel Podcast

Many VLOOKUP Columns - 1123 - Learn Excel from MrExcel

154956
723
55
00:04:18
15.10.2009

VLOOKUP week continues.... Today, you have to lookup an account number and return the results from four columns in the lookup table. Episode 1123 shows you four possible solutions. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Bill Jelen - MrExcel's Best Excel Tips (including a secret tip from FBI 😮)

40187
1411
164
00:25:12
23.06.2020

What can I say about this? This is seriously awesome. I am proud to present Bill Jelen's best Excel tips. This features the magic cell by Dan, Copy paste jiggle by Dave, filtering tricks from mystery dude in Fort Wayne and more filtering goodness from FBI!!! - Wow. Just watch it already. Visit Bill's channel - 🤍 Bill's website - 🤍 #MrExcel #BestExcelTips

Learn Excel 2010 - "Next Invoice Number": Podcast #1505

419482
2324
1040
00:06:06
10.01.2012

The Question: "How do I generate the next Invoice Number?" Microsoft Office Online offers a great number of Invoice Templates. However, none of those templates has a Macro to pull the next Invoice Number. Today, in Episode #1505, Bill shows us how to 'Macro Enable' our Workbook and then create a short VBA Code routine to automatically generate Invoice Numbers with the press of a mouse button. Note: A similar discussion happened in episodes 742-745. You might want to review those videos as well, as they go the extra step of creating an add-in. PLEASE - if you need to save as PDF or if you alphanumeric invoice numbers, read through the FAQ at 🤍 Your question has already been answered many times in the comments below. New on October 16 2013 - a follow-up video, episode 1808 shows how to add an automatic Invoice Register to this code. See 🤍 Table of Contents (0:00) Introduction & Welcome to Excel Next Invoice Number (0:15) Downloading an Invoice from Office Online (0:40) Remember where the invoice number cell is (1:00) Save as Macro-Enabled Workbook (1:25) Switch to the VBA Editor with Alt+F11 (1:45) NextInvoice Macro (2:20) Clearing out old data in invoice (2:45) Using .ClearContents (2:57) Running the macro from a Shape (3:34) Running the code the first time (3:42) Save each invoice before clearing (5:05) Make sure to save before filling in invoice (5:44) Wrap Up This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

MrExcel's Learn Excel #486 - Match & Index

11663
50
5
00:04:43
01.05.2009

In todays podcast, we have hundreds of rows of VLOOKUP functions. Learn some tricks to make the entry of the third argument easier using a hidden row or the COLUMN function. Ultimately, though, after several iterations of VLOOKUP solutions, Episode 486 finally gets to the point of replacing VLOOKUP with MATCH and INDEX functions. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

MrExcel's Favorite Excel Tricks & Tips - 2022 - Episode 2495

4799
206
20
00:14:21
04.08.2022

Special ESPN Pricing: 🤍 The Excel All Star Battle will air on ESPN2 at: Friday August 5, 2022 at 5 AM Eastern. (2 AM Pacific. 10 AM in London.) Sunday August 7, 2022 at 9AM Eastern. (6 AM Pacific, Noon in London.) Monday August 8 (8/8!), 2022 at 11:30 PM Eastern. (8:30 PM Pacific - Prime Time, Baby! And 4:30 AM Tuesday in London). Bill's favorite Excel trick: Fast Formula Copy, as well as a lot of other items. Table of Contents (0:00) Historical re-enactment (0:20) Data description (1:00) Begins typing (1:38) Adding text is #VALUE error (1:57) & to Concatenate (2:10) FORMULATEXT function (2:36) Adding a space while joining text (3:09) Needs Proper Case (3:38) 500 functions in Excel (3:50) PROPER function (4:20) 5-Step way to copy (5:10) Hello YouTube viewers (6:00) Excel in Olympics Joke (6:33) Excel on ESPN (7:10) Dragging Fill Handle is a drag (8:24) Double-click Fill Handle (8:42) Blank cell in adjacent column (9:21) 3 Ways to Undo in Excel (9:35) Right-Drag to Paste Values (9:50) Alternate Drag and Drop (10:10) ESPN versus Olympics (10:29) I bought a commercial on ESPN8 (10:47) Ocho-themed deals (11:10) Promo Codes Woes (11:40) Buy from Amazon in USA (12:05) Buy e-Books (12:20) Liam Bastick Financial Models in Power BI (12:45) Wyn Hopkins Power BI for Excel Analyst (13:05) Mike Girvin Only App That Matters (13:25) Oz & Bill new Edition (14:05) Courses on Retrieve

100906
501
236
00:08:10
13.06.2013

Shana has a dashboard report with 50 worksheets. She has a menu with hyperlinks to the 50 different worksheets. Here's the catch - she wants to keep the 50 worksheets hidden until someone clicks on the hyperlink. Today's podcast covers hyperlinks, the FollowHyperlink event handler, an introduction to the Watch window while the macro is in break mode, and a counfounding problem where Excel VBA seemingly could not handle Range("A1").Select.

Learn Excel with MrExcel - "Chandoo Explains Structured Table Reference": Podcast #1708

10489
69
16
00:05:52
13.05.2013

On Friday May 10, 2013, Chandoo (🤍 and Rob Collie (🤍 - PowerPivotPro - stopped by MrExcel's place for an evening of Microsoft Excel. So, what is on the agenda For Today's Podcast? Chandoo doing his First Guest Appearance on the Learn Excel Podcast and his topic: "The Benefits of Structured Table References". Follow along with Episode #1708 as Chandoo gives us an indepth analysis of Table References and why using Structured Table References are so beneficial. "Microsoft 2013 InDepth" by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013. (🤍 And "Pivot Table Data Crunching Excel 2013", by Bill Jelen. Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours... understand exactly what's going on in your business... take control, and stay in control! Even if you've never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. (🤍 "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

MrExcel's Learn Excel #741 - Compare Columns

17669
26
4
00:01:54
10.02.2009

Daniel from Quebec sends in a better way to compare columns using GoTo Special Column Differences. Episode 741 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Excel Reverse Text in Excel - 2508E

7133
17
1
00:01:06
02.09.2022

Back in episode 2444, I had Tommy Tutone singing a crazy formula to reverse text in Excel. Today, a less musical way, but a much easier way. Using the DOSE for Excel add-in, you can easily reverse text, making "ABCDEF" change to "FEDCBA". However, Dose does even better, offering an option to take "Jenny Jenny I've Got Your Number" and changing it to "Number Your Got I've Jenny Jenny". Save 25% on DOSE for Excel using Coupon Code MrExcel25 at 🤍

Lotto Probability - 454 - Learn Excel from MrExcel Podcast

75083
231
9
00:03:41
04.06.2009

Scott from Australia sent in what should have been a simple lotto question. However, I chose to solve the problem using an array formula. Now, as far as I know, no one has ever tried to explain an array formula in a 2 minute podcast. Episode 454 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Count Visible Rows - 1034 - Learn Excel from MrExcel

86855
427
37
00:02:14
11.06.2009

Isabel asks how to count only the visible entries in a range. =COUNTA() is returning all of the values. Episode 1034 will show you how to count or sum the visible rows in a range. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #736 - Index Match

4548
12
2
00:04:10
06.02.2009

Jon has a follow-up question about his baseball spreadsheet. After calculating the win and loss streaks, he would like to find the longest streak, including the start and end dates. This seemingly simple question requires two completely useless functions. Once these functions are used in conjunction, they become very powerful. Episode 736 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #728 - Table Formulas

1225
4
1
00:02:59
13.02.2009

Excel 2007's table functionality is cool, but viewer Jim is wondering why Excel is changing his formulas. In Episode 728, we will take a look at how to control this behavior, This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Easier VLOOKUP to the Left With XLOOKUP - 2302

3150
96
16
00:02:23
24.11.2019

Historically, using VLOOKUP to look for a value to the left is VLOOKUP's Kryptonite. While VLOOKUP is awesome, there is not an easy way to look to the left. While this episode briefly gives a nod to trickster methods like CHOOSE and INDEX/MATCH, the topic today is how easy it is to XLOOKUP to the left.

Blank Row for Missing Dates- 1103 -Learn Excel from MrExcel

25754
175
27
00:03:54
18.09.2009

Sam from Vienna sends in today's question. In a database of events, how can he add new blank rows to represent every missing day? Episode 1103 shows you one method. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Learn Excel from MrExcel - "OFFSET for a VLOOKUP Table": Podcast #1619

13560
69
8
00:03:57
17.12.2012

Today's question comes from Ron and he would like to know, "when would I use OFFSET in conjunction with the VLOOKUP Function?" In Episode #1619, Bill "MrExcel" Jelen explains the use of OFFSET and VLOOKUP together as well as provides us a great example. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! 🤍 "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

MrExcel's Learn Excel #949 - Grouping Ages

75062
329
21
00:02:45
12.02.2009

Steve asks how to group records into age ranges. In Episode 949, I show how to use the range version of VLOOKUP to solve this problem. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #768 - Multiple IF

6442
10
0
00:02:43
30.01.2009

How do you deal with many levels in an IF statement? Episode 768 discusses nesting IF statements. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #427 - Gantt Chart

1768
11
0
00:04:18
24.09.2009

This cool trick shows you how to create a Gantt chart right in the Excel cells by using Conditional Formatting. The chart is a live chart that colors cells based on several data values. Episode 427 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

MegaMillions Lottery - 453 - Learn Excel from MrExcel Podcast

12697
26
2
00:03:46
04.06.2009

After Scotts question for tomorrows podcast, I thought it would be cool to see how a pivot table could analyze the most popular lottery numbers. The MegaMillions jackpot in several US states is up to $216 million and today's podcast will select the most popular numbers. Episode 453 shows you how. UPDATE: the Mega Millions download site has changed. For a lengthy 2014 video showing more complete steps, watch: 🤍 This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

MrExcel's Learn Excel #744 - Auto-Increment

26455
47
10
00:04:11
10.02.2009

Continuing the information from podcasts 742 and 743, I record a simple macro today to open the Invoice.xlt file and then add a couple lines of code to update the invoice number and the date. Episode 744 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #481 - Leading CSV Zeroes

3612
11
2
00:03:27
01.05.2009

If you have a CSV file, you will always lose any leading zeroes when you open the file in Excel. This causes problems with zip codes and social security numbers. Episode 481 shows the non-Excel method for solving this problem. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Learn Excel from MrExcel - Create A Bell Curve in Excel - Podcast #1663

632791
1118
100
00:04:02
11.03.2013

Last January, in Episode #1507, Bill took a look at generating Random Numbers around a Standard Deviation using " =NORM.INV [Normal Inverse]. Today, in Episode #1663 the Question from Gary is: "How do we create a Bell Curve in Microsoft Excel?". Follow along with Bill as he shows us how to use "NORM.S.DIST" to create a Standard Bell Curve or NORM.DIST to create a Normal Distribution around any Mean with a particular Standard Deviation. Update: to plot your own data on a bell curve, see episode 2217: 🤍 Table of Contents (0:00) Welcome to Create a Bell Curve in Excel (0:24) Generate 61 numbers from -3 to +3 (0:55) Explanation of three standard deviations (1:18) Using NORM.S.DIST function (1:44) Creating the Line chart (2:05) Mean of zero and standard deviation of 1 (2:10) Changing the mean and standard deviation (2:49) Using NORM.DIST function (3:15) Creating a Scatter chart or X-Y chart ...This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! 🤍 "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel from MrExcel - "Dynamic Range Without OFFSET": Podcast #1632

12657
92
24
00:04:10
28.01.2013

Today, a new podcast series: "Things that I Learned at Trainertage", by Bill 'MrExcel' Jelen. I spent a week in Lucerne Switzerland at the 8th annual Trainer Days. This is a team of Microsoft Office Trainers who began getting together once a year to teach each other new tricks in Office. Today, they allow others to attend. I was their guest speaker for Trainertage 2013. Now, the obvious problem: I don't speak German. But they were patient. I spoke slowly, and everyone got along well. My friend Tony Dejonker helped with translation during my first session, but it was decided that my "Slow English" was good enough for the remaining three sessions. First observation: doing training for other trainers is tougher than my normal sessions. I always learn a new trick or two from the audience in a normal session; usually someone in row 2 shows me up. I expect it, and have a prize for it. At Trainertage, it was less than 1 minute and 30 seconds into my presentation when the first trick came from row 2, and more flooded in from row 2 all night. Some even from row 1 and row 3! Second observation: When I would watch another trainer's session in Deutsch, I would learn new stuff. I couldn't understand the language, but I would pick up things that I had not seen in the U.S. These new friends of mine all learned from books in German and attended their own sessions and had learned a whole new set of tricks. I joked that I was going to steal these for the podcast, and they were all cool with that. "It is not stealing, it is sharing". They learned from me, and I learned from them. In my first episode of Things That I Learned at Trainertage, I lead off with a trick from the mother of Trainertage; Tanja Kuhn. Yes, you might be smart enough to build a dynamic range using OFFSET and COUNTA, but you won't have to anymore with this clever twist on using Ctrl+T. Today, in Episode #1632, Bill shows us a new dimension in Dynamic Ranges. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! 🤍 "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

MrExcel's Learn Excel #570 - Random Quiz

11358
41
9
00:04:51
29.06.2009

Giovanni asks how he can create a random multiple choice question; present a definition and four answers, one of which is right and three are wrong. While this sounds simple, the solution requires a mix of VLOOKUP, RANK, RAND, RANDBETWEEN functions. Episode 570 walks through the solution. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Excel Habit Tracker Count Current Streak - 2517

892
65
9
00:05:52
25.09.2022

How to calculate the current streak in a habit tracker. Amreen is building a habit tracker in Excel. For each goal, he wants to report the current streak. I show how to use XMATCH to solve this problem. Table of Contents() (0:00) The goal (0:40) XMATCH formula for last 1 (1:08) Last zero (1:29) No streak? (1:45) How long is streak? (2:30) Episode 735 for longest streak (3:05) Converting to checkmarks (4:32) Colors in Excel number format

MrExcel's Learn Excel #763 - Protecting Cells

7460
16
0
00:02:18
05.02.2009

When you use Tools, Protect Worksheet, all of the cells become protected. How can you protect only a portion of the worksheet? In Episode 763, we take a look at this problem and protect only the formulas in a worksheet. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #875 - Conditional Pivot Formatting

5700
11
1
00:03:57
05.01.2009

Neville from Germany sends in a good suggestion for overcoming pivot formatting problems from Episode 865. By using conditional formatting on the underlying worksheet, Neville comes up with a way to make sure that the total rows are always highlighted in a pivot table. Episode 875 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #680 - Timestamp

11760
53
12
00:03:37
19.02.2009

Florian wants to time stamp a record every time someone types a new name in column A, but the NOW function is not working. In Episode 680, I will show you a few lines of VBA code to solve this problem. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

WIIW: Printable Background - 1023 - Learn Excel from MrExcel

41441
197
24
00:03:20
27.05.2009

Add a background picture to a worksheet that is printable and semi-transparent. Episode 1023 will show you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #873 - First Macro

14756
79
4
00:05:09
06.01.2009

Rick asks how to get started with VBA. In Episode 873, I show a horribly formatted file that someone in my Power Excel audience has to deal with daily. A macro seems like a good way to deal with the file. I will show you how to turn on the macro recorder, turn on relative reference, and record your first macro.

MrExcel's Learn Excel #624 - Multiple Regression

32147
31
8
00:03:54
26.03.2009

How much ice cream will Sally sell on any given day? Todays Episode 624 tries to figure out a relationship between temperature, rain and ice cream sales. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Slicers! - 1067 - Learn Excel from MrExcel Podcast

6569
22
2
00:03:25
28.07.2009

One of the great new features in Excel 2010 is the Slicer functionality. Slicers are a great visual way to filter your pivot table. Episode 1067 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Learn Excel from MrExcel - "Switch Window or Close All to The QAT": Podcast #1648

1746
3
1
00:01:32
19.02.2013

Another set of Microsoft Excel Tips from Bill's latest Seminar in Orlando, Florida this year. Do you know about the "Customize Quick Access Toolbar" dialog in Excel? If not, today is your lucky day because today, with Podcast Episode #1648, Bill shows us how to Customize The Quick Access Toolbar by adding 'Close All' and 'Switch Windows'. If you've never used this 'Customizing' ability, you may be interested to know that instead of going through multiple clicks to find a command, you can apply your choice Functions to the 'Quick Access Toolbar' to make them "One-Click-Ready"! ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! 🤍 "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

VLOOKUP External Workbook - 1082 - Learn Excel from MrExcel Podcast

1878
4
0
00:03:17
18.08.2009

Shaun asks how he can link values in one worksheet to a lookup table in an external workbook. Episode 1082 will show you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Learn Excel from MrExcel - "Assign A Unique Color Value": Podcast #1718

5542
26
14
00:08:44
28.05.2013

Bigger - Better - Brilliant! Update from 2022: There is a faster way to solve this using DOSE for Excel. Watch the newer video at 🤍 Mansoor asked an interesting question for today's New Widescreen Podcast. Can you assign a Color to each Unique Value in a Column, and then automatically re-use that Color when the same Value is entered. Bill understands that in order to perform the required spec, this operation will require a VBA Event Handler Macro to analyze each entry. However, the logic is similar to what you would use in Excel: use =MATCH() to figure out if the Value appears above. If the Value is found, then re-use the Color from the matching Cell. Otherwise, create a random Color using three =RANDBETWEEN() Functions. Follow Bill in Episode #1718 to see how the result is achieved and the Color Values are applied. Use Excel® 2013 VBA and Macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! You'll discover macro techniques you won't find anywhere else and learn how to create automated reports that are amazingly powerful and useful. 🤍 For more information on Excel 2010 VBA and Macros, check out... VBA and Macros: Microsoft Excel 2010 - The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve...Includes crucial information on making Excel 2010 VBA code work with older versions Using Microsoft Excel 2010 VBA scripting features, Excel users can save dozens or even hundreds of hours per year. But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. 🤍 "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

MrExcel's Learn Excel #501 - Data Entry

824
3
0
00:01:46
09.09.2009

Todays podcast shows a better way to do data entry. Rather than having to change the Move Selection After Enter Direction, you can use the Tab and Enter keys to quickly navigate through a data entry range. Episode 501 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

MrExcel's Learn Excel #975 - Excel Gemini

2379
7
2
00:04:11
20.03.2009

Awesome. There is a video on the 'net with Microsoft's Donald Farmer showing off a new add-in called Gemini. This is an amazing product. In Episode 975, I point out where you can get a sneak peak at Excel 2010 pivot tables in the Donald Farmer video. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Назад
Что ищут прямо сейчас на
MrExcel Canon m3 adin 2k Жизнь seren Cush core daily kolam Pokemon Plush Honda click goprohero4 из фильма huracan espana ross federman ninjaskyrim Hapuku low end pc games sasa kapor 3 zinnen mink