Look Who it Was Random video

Excel - Hundreds of Free Sample Spreadsheets Built into Excel New - Episode 588

590 views · Published 22 June 2009 · 2:45 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Hundreds of Free Sample Spreadsheets Built into Excel New.

Welcome back to the MrExcel NetCast! In today's video, I have a cool tip for you. Have you ever been asked by your manager to design an expense spreadsheet for a marketing event? It can be a time-consuming task to start from scratch, but did you know that Microsoft provides hundreds of sample spreadsheets for free? Yes, you heard that right! And in this video, I'll show you how to access them.

Instead of clicking on the new worksheet icon, which many of us do, you can use the "New" option under the File tab. This will take you to the "Templates on office online" section, where you can find a wide range of categories such as agendas, budgets, calendars, and more. Let's say we want to create an event budget spreadsheet. We can simply click on the "Budgets" category and choose the "Event Budget" template. This will automatically download the spreadsheet into Excel.

This feature has been available since Excel 2003, but it has become even easier to use in Excel 2007. When you click on the Office icon and choose "New", you will see a list of all the available templates on the left-hand side. You can even see a thumbnail preview of each template, making it easier to choose the one you need. And the best part is, you can customize the template according to your needs, saving you a lot of time and effort.

But that's not all! Did you know that there are even more categories available if you click on "More Categories" at the bottom? You can find templates for things like fantasy football leagues, quizzes, and tests. It's amazing how much variety there is, and all of it is completely free to use. So next time you need to create a spreadsheet, don't start from scratch. Use the "New" option and explore the endless possibilities of sample spreadsheets available on office online. Thanks for watching, and I'll see you in the next netcast from MrExcel!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


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!

Table of Contents:
(00:00) Tip for designing an expense spreadsheet
(00:24) Using the "New" option for templates
(00:51) Using the "Templates on office online" option
(01:01) Categories of templates available
(01:14) Downloading a specific template
(01:44) Opening the downloaded template in Excel 2007
(01:58) Customizing the template for personal use
(02:12) Accessing more categories of templates
(02:22) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Budget categories
Design spreadsheet
Expense spreadsheet
Free spreadsheets from office online
Marketing budget
Microsoft sample spreadsheets
New worksheet
Office icon
Templates on office online
Validation for Excel

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152477/

More from this channel