What is an Excel tutorial?

This is a short guide on how to create an Excel tutorial from scratch. The tutorial we will create in this guide will use a master spreadsheet. Master spreadsheets are essentially large standalone documents and the first step we will take is to create one for us. We will be using the Excel 2010 function “divide” which is a handy way to divide large pieces of work into manageable pieces. 

There are several ways we can create a master spreadsheet:

 Using separate master spreadsheets. For example, we could create two separate master spreadsheets, one for business information and one for programming terminology and figures. Creating a new master spreadsheet using the command panel. Alternatively, you can use the Excel function “excel pivot table concatenate” to create a master spreadsheet. Create an Excel project. To do this you need to create a project in Excel which is a link between one spreadsheet and another. Then you can create individual Excel documents based on the project and place them into the master spreadsheet.

 

1. Create a new master spreadsheet

 The first thing we need to do is to create a master spreadsheet. All of our master spreadsheets will have the same structure, so we will use a single master spreadsheet for all of the information we want to be included in our tutorial. The first step is to go to the Microsoft Excel home page and create a new folder on the left hand side of the screen. Next we will go to the folder we just created and right click on the folder and choose “Export to csv”. This will download the csv file to our computer where we will create our master spreadsheet. Finally we will click “OK” to save the csv file. If you are unsure how to use the “Export to csv” function, please see our previous article “Microsoft Excel – Everything You Need to Know”. 

2. Create a new master spreadsheet

 When the download is complete, open the downloaded csv file and you will find the spreadsheet you just created which is labelled “Microsoft Excel – Managingl? a Business”. Our master spreadsheet contains information for a business called “Alan Evans”. Select “Microsoft Excel – Managing a Business”. On the top right hand side of the spreadsheet you will find the options to “Add a cell”, “Edit the cell” and “Delete a cell”. Using these options we can add a new cell to our spreadsheet: Please enter the name of the business, its address and it’s business name. You will also be able to “Track changes” and “Edit the cell” using these options. You will notice on the spreadsheet there is a “Date range” of the first number of the year (2012, 2013 etc) and we will use these fields in our new master spreadsheet. For our tutorial we will need to separate our master spreadsheet into a business and programming language. Therefore, the date range should be 2013 onwards. The next field is the business name. Please enter your own name for the business. Please enter your own name for the business. Please enter a unique name for the business. Note: To get started with your Excel tutorials, we recommend that you download our free Excel Complete Workbook which is packed with the essential Excel and Word and PowerPoint Power Tools that we will be using. Please note: The Excel files you downloaded above will only work within Microsoft Excel 2010 or 2012. If you are working in Excel 2016, you should download the Excel 2017 trial version. 

3. Duplicate the master spreadsheet

 To create another copy of our “Microsoft Excel – Managing a Business” spreadsheet, we can select our master spreadsheet and then choose “delete copy”. When we have deleted our original copy, we can select “create copy”, select the new “Microsoft Excel – Managing a Business” csv file and then click “Create new copy”. Please note: The “Delete copy” action will delete your “Microsoft Excel – Managing a Business” csv file, and all the information within it. 

4. Split the master spreadsheet into two master spreadsheets

 We will now create two separate Excel master spreadsheets which we will refer to as “Alan” and “John”. As the name suggests, the first Excel master spreadsheet contains all the information on Alan, and the second Excel master spreadsheet contains all the information on John. Please make sure that you have both Excel 2013 and Excel 2017 installed on your computer. In order to save, we will simply select “save as” and then choose “Excel 2013” or “Excel 2017” from the menu. When you have opened the new Excel master spreadsheet for the first time you will see that it already has the same data fro the previous “Alan” Excel master spreadsheet. Now that we have our “Alan” spreadsheet open we can open the second Excel Excel master spreadsheet by clicking “New Excel Excel master spreadsheet”, selecting “Excel 2017” and then choosing “Create new Excel Excel master spreadsheet”. Please note: To create your first Excel spreadsheet, “Microsoft Excel – Managing a Business”, click the “Microsoft Excel” button on the menu. Once you have created your first spreadsheet you can either select the “Microsoft Excel – Managing a Business” folder that you downloaded earlier, or you can click the “New” button from the menu and choose a new folder.

 

5. Create a new business csv file

 Now that we have created our two Excel master spreadsheets we need to copy the new csv file from the new Excel Excel master spreadsheet into the “business” folder in the “Alan” Excel master spreadsheet. Please make sure that your “business” folder has enough space in it so that you can copy the file. You can also copy the “business” file into your “Alan” Excel master spreadsheet by selecting the “All Files” button, and then selecting “Add to New” from the menu. Please note: You can now select the “All Files” button and choose “Create New” from the menu and the “Alan” Excel master spreadsheet and the “business” file will be copied into your “Alan” Excel master spreadsheet. When you have opened the new Excel master spreadsheet for the first time you will see that it already has all the data from the previous “Alan” Excel master spreadsheet. Now we can double click on the “Alan” Excel master spreadsheet and we can then select “Go to File”. Please note: The “Go to File” will copy the file into your “Alan” Excel master spreadsheet. You can also select the “All Files” button and choose “Create New” from the menu and choose a new folder. When you have opened the new Excel master spreadsheet for the first time you will see that it already has all the data from the previous “Alan” Excel masterm spreadsheet. Now we can copy the new csv file from the new Excel Excel master spreadsheet into the “business” folder in the “Alan” Excel master spreadsheet. Please note: You can now select the “All Files” button and choose “Create New” from the menu and choose a new folder. When you have opened the new Excel master spreadsheet for the first time you will see that it already has all the data from the previous “Alan” Excel master spreadsheet. Please note: You can now select the “All Files” button and choose “Create New” from the menu and choose a new folder.

 

0