Templates in Excel

Excel Tutorials for beginners, Intermediates and experts.

Excel Default Templates

Book.xltx and Sheet.xltx are two special templates you can create and add to the XLStart folder. As a result, Excel uses Book.xltx as the basis for new workbooks and Sheet.xltx as the basis for new worksheets. Book.xltx To create Book.xltx, execute the following steps. 1. Create a workbook. For example, change the row height of all rows on the… read more »

How to Create Calendar in Excel

This example describes how to create a calendar in Excel (2019 calendar, 2020 calendar, etc). If you are in a hurry. Note: the instructions below do not teach you how to format the worksheet. We assume that you know how to change font sizes, font styles, insert rows and columns, add borders, change background colors, etc. This is what… read more »

How To Create Budget in Excel

This chapter shows you one of the many powerful features Excel has to offer. The example below illustrates how to create a budget in Excel. 1. Enter the different type of income and expenses in column A. Note: On the Home tab, in the Font group, you can use the different commands to change the font size and font… read more »

Using Existing Templates in Excel

Microsoft office Excel comes with in built Templates. Templates are predefined layouts, patterns, structures built that can be reused. If you often use the same layout or data, instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used. Existing Templates To… read more »