Click in the Search for online templates box.Let’s start by searching for a Travel Expense Report. In the Search for online templates box shown above, you can type a description for the template you want to use. If you have opened templates previously, these may show in this screen as well.įigure 6.9 New Template Screen in Backstage View The top of your screen should look similar to Figure 6.9.
Mac Users: Click the File menu option and choose New from Template To access the templates in Excel, do the following: In this chapter we will explore using existing Microsoft templates. Depending on your version of Excel or Office 365, template categories may include: Business, Personal, Planners and Trackers, Lists, Budgets, Charts, and Calendars. Predefined Microsoft templates include everything from billing statements to blood pressure trackers to business cards. needed in a professional Excel spreadsheet.
Templates do a lot of the work for you! Templates include all the formulas, formatting, etc. These templates are very helpful if you have limited time to get a new task done in Excel, and you don’t know where to start. Hundreds of templates, already created by Microsoft, are available for you to use in Excel.
