If you create workbooks with the same structure more than once or twice a year, you should consider creating a template, which is a workbook that contains existing formatting and headings.
- One of the realities of working with Excel…is that you often create files…that are similar to files you created before.…For example, if you create monthly sales reports…it's very likely those workbooks will be…almost the same except for the data they contain.…If you create workbooks with the same structure…more than once or twice a year,…you should consider creating a template,…which is a workbook that contains…existing formatting and headings.…All you need to do is plug in the data.…In this movie, I will show you how to work…with existing templates and to create your own.…
I've just started Excel and I see…the template gallery available.…At the top left is a blank workbook…which you can click and then click "Create" at…the bottom right corner to create a new workbook.…And yes, that is a template.…You can also use any of the other existing templates.…For example, if I were to click…the personal budget template and…click "Create", I would create a…workbook based on that template.…If I were to scroll down, then I can see other…
- Creating workbooks
- Manipulating cell data
- Using core functions and formulas
- Formatting worksheet elements
- Creating PivotTables
- Collaborating with others
- Working with charts
- Adding images and shapes
- Saving workbooks
- Printing files
Skill Level Beginner
1. Get Started with Excel
2. Manage Workbooks
3. Work with Worksheets, Cells, and Cell Data
4. Sort, Filter, and Manage Worksheets
5. Summarize Data Using Formulas and Functions
6. Format Worksheet Elements
7. Work with Charts
8. Work with External Data and Objects
9. Explore PivotTables
10. Review and Share Your Spreadsheets
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.