When you use the New command, you have access to hundreds of free sample spreadsheets from Office Online. In Episode 588, we take a look at this feature in both Excel 2003 and Excel 2007.
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!
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!
Transcript of the video:
Hey Welcome back to the MrExcel NetCast. I'm Bill jelen.
Now today, here's a cool tip Let said your manager comes in and says you know hey, I need you to design an expense spreadsheet We're having some marketing event we need to create a new spreadsheet for this and so you generally start to sit down at a blank spreadsheet and start to design the thing which just takes a long time now.
How many times when you're creating a new worksheet you just hit the new worksheet icon, this icon right here. We get a new worksheet Well if you're doing that you might be missing out on the fact that microsoft provides hundreds of sample spreadsheets completely free available for you to use But you have to use file "New" when you use file "New" we have an option over here.
That's called "Templates on office online".
Click that You'll be taken to office online where they have many many categories.
There's agendas, budgets, calendars. expense reports, forms.
Let's go into budgets and you'll see there's a personal budget, family monthly budget, garden budget, personal monthly budget, event budget, wedding budget.
Let's try event budget.
click OK and you'll be able to download that Spreadsheet right into Excel.
Now this has been around in Excel 2003 for a long time.
It's become much much easier to use in Excel 2007.
In Excel 2007 when we use the office icon and choose "New".
You actually see a list of all the items right along the left-hand side so we click budget.
They'll show you a bit of a thumbnail for each one so we probably have the exact same list here.
There's the marketing budget and when I hit marketing budget and download It automatically opens it up right in Excel 2007.
Had to go through a little bit of validation there.
Make sure that your copy of Excel is genuine.
But then you have the worksheet.
Now rather than starting from scratch you can start with their budget worksheet.
Change things,However, you need to change it, but it's much easier to use this.
I'm always impressed on how much stuff they have on here even if we go to file "New" and go to the other "More Categories" at the bottom.
There are things as strange as fantasy football leagues, quizzes and tests.
All kinds of different spreadsheets available free from office online.
Right inside of Excel when you use file "New".
Hey , Thanks for stopping by. we'll see you next time for another netcast from MrExcel.
Now today, here's a cool tip Let said your manager comes in and says you know hey, I need you to design an expense spreadsheet We're having some marketing event we need to create a new spreadsheet for this and so you generally start to sit down at a blank spreadsheet and start to design the thing which just takes a long time now.
How many times when you're creating a new worksheet you just hit the new worksheet icon, this icon right here. We get a new worksheet Well if you're doing that you might be missing out on the fact that microsoft provides hundreds of sample spreadsheets completely free available for you to use But you have to use file "New" when you use file "New" we have an option over here.
That's called "Templates on office online".
Click that You'll be taken to office online where they have many many categories.
There's agendas, budgets, calendars. expense reports, forms.
Let's go into budgets and you'll see there's a personal budget, family monthly budget, garden budget, personal monthly budget, event budget, wedding budget.
Let's try event budget.
click OK and you'll be able to download that Spreadsheet right into Excel.
Now this has been around in Excel 2003 for a long time.
It's become much much easier to use in Excel 2007.
In Excel 2007 when we use the office icon and choose "New".
You actually see a list of all the items right along the left-hand side so we click budget.
They'll show you a bit of a thumbnail for each one so we probably have the exact same list here.
There's the marketing budget and when I hit marketing budget and download It automatically opens it up right in Excel 2007.
Had to go through a little bit of validation there.
Make sure that your copy of Excel is genuine.
But then you have the worksheet.
Now rather than starting from scratch you can start with their budget worksheet.
Change things,However, you need to change it, but it's much easier to use this.
I'm always impressed on how much stuff they have on here even if we go to file "New" and go to the other "More Categories" at the bottom.
There are things as strange as fantasy football leagues, quizzes and tests.
All kinds of different spreadsheets available free from office online.
Right inside of Excel when you use file "New".
Hey , Thanks for stopping by. we'll see you next time for another netcast from MrExcel.
