Seven ways to paste values in Excel. While I talk about many ways to convert formulas to values, Don from Orrville has come up with a method shorter than the other 6 methods I usually discuss. So...drumroll please... Episode 877 with method #7 for doing Paste Values!!!
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!
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!
Transcript of the video:
Hey, alright, welcome back to the MrExcel netcast, I'm Bill Jelen.
This is Episode 877 and a half-- yeah, that's right.
I'm back here in Akron, Ohio, this weekm and for the first time in several months, not on the road.
So I figured it's a great time to test out our webinar system, and I want to invite you on Thursday to attend a free 30 minute webinar.
I'm trying to get as many people there as we can to test out the system.
We're going to spend about 30 minutes going through formula auditing and "What if" analysis.
This is part of my Power Excel seminar, and we'll go through and you'll learn a bunch of cool things.
Now, it starts at 11 o'clock Eastern in the United States-- so that's right at 8 o'clock on the west coast and towards the end of the day in England.
If you happen to be in one of those spots, I want to invite you to come along, actually anywhere but it'll be at least during your workday from England to the West coast.
So MrExcel.com/webinar.html.
There's a link down here to register-- I want you to register so we can reserve a spot and get in.
The other thing we have going on is, soon November 21st is the 10th Anniversary of MrExcel, and I've been thinking a lot about where we've been over the last 10 years, and where we want to go over the next 10 years; and I want to invite you to be a part of that process so we put together a simple one-page survey-- and that went live today if you go to MrExcel.com/survey.html.
It's pretty simple, I just want to know, you know, how you interact with MrExcel.
So, for you, that's going to be that you watch the MrExcel podcast-- check anything else-- and then just a few simple questions, you know?
What are we doing right?
What can we improve?
What are we doing wrong?
And what new features would you like to see?
So if you could answer those, it'll probably take two to three minutes of your time.
I'm sure that from the community we can get lots of great ideas of where we need to go in the next ten years.
Alright, so there you have it.
Kind of a midday podcast; sorry to spring this on you.
A couple of cool things though, if you get this before Thursday, come along and see the webinar and then, also, I invite you to take a few minutes of your time to help us out at survey.html.
Thanks for stopping by, we'll see you next time for another netcast from MrExcel.
This is Episode 877 and a half-- yeah, that's right.
I'm back here in Akron, Ohio, this weekm and for the first time in several months, not on the road.
So I figured it's a great time to test out our webinar system, and I want to invite you on Thursday to attend a free 30 minute webinar.
I'm trying to get as many people there as we can to test out the system.
We're going to spend about 30 minutes going through formula auditing and "What if" analysis.
This is part of my Power Excel seminar, and we'll go through and you'll learn a bunch of cool things.
Now, it starts at 11 o'clock Eastern in the United States-- so that's right at 8 o'clock on the west coast and towards the end of the day in England.
If you happen to be in one of those spots, I want to invite you to come along, actually anywhere but it'll be at least during your workday from England to the West coast.
So MrExcel.com/webinar.html.
There's a link down here to register-- I want you to register so we can reserve a spot and get in.
The other thing we have going on is, soon November 21st is the 10th Anniversary of MrExcel, and I've been thinking a lot about where we've been over the last 10 years, and where we want to go over the next 10 years; and I want to invite you to be a part of that process so we put together a simple one-page survey-- and that went live today if you go to MrExcel.com/survey.html.
It's pretty simple, I just want to know, you know, how you interact with MrExcel.
So, for you, that's going to be that you watch the MrExcel podcast-- check anything else-- and then just a few simple questions, you know?
What are we doing right?
What can we improve?
What are we doing wrong?
And what new features would you like to see?
So if you could answer those, it'll probably take two to three minutes of your time.
I'm sure that from the community we can get lots of great ideas of where we need to go in the next ten years.
Alright, so there you have it.
Kind of a midday podcast; sorry to spring this on you.
A couple of cool things though, if you get this before Thursday, come along and see the webinar and then, also, I invite you to take a few minutes of your time to help us out at survey.html.
Thanks for stopping by, we'll see you next time for another netcast from MrExcel.
