When Was Excel Created

The DATE function creates a valid Excel date using individual year, month, and day components. For example, you can use the DATE function to create the dates January 1, 1999, and June 1, 2010 like this. Excel Queries created this way can be refreshed and rerun making them a comfortable and efficient tool in Excel. Microsoft Query allows you use SQL directly in Microsoft Excel, treating Sheets as tables against which you can run Select statements with JOINs, UNIONs and more. The information in this article applies to Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Excel for Mac. Creating Basic Charts and Tables for an Excel Report Creating reports usually means collecting information and presenting it all in a single sheet that serves as the report sheet for all of the information.

1. When Was Microsoft Excel Created
2. Excel Formula Symbols Chart
3. Who Created Microsoft Excel
4. Excel Formulas Cheat Sheet
5. Microsoft Excel Forms Templates

How long have you been using Microsoft Excel?

When Was Microsoft Excel Created

Microsoft Excel is an electronic spreadsheet program used for storing, organizing, and manipulating data. It can create charts and other data visuals. Create a new workbook or open the workbook in which you want to use your newly created User.

Have you ever thought how Excel or the other electronic spreadsheet softwares came to existence?

In today's post, we will go back in time to trace the origin of Excel. So, here we go:

Excel Formula Symbols Chart

While the origin of electronic spreadsheets can be traced back to 1978, but it wasn't until 1982 when Microsoft jumped into the arena of Electronic spreadsheets with a product known as MultiPlan.

Muliplan was Microsoft's first electronic spreadsheet program. It was introduced in 1982 as a competitor for VisiCalc (the first ever electronic spreadsheet program). The key difference between Multiplan and its competitors was Microsoft's decision to use R1C1 addressing instead of the A1 addressing which was introduced by VisiCalc.

Muliplan was very popular on CP/M systems, but on MS-DOS systems it lost fame to Lotus 1-2-3. This thing motivated Microsoft to develop another spreadsheet product Excel.The first version of Excel was released in 1985 for Mac. Later in November 1987, the first Windows version was released.

It all started with VisiCalc:

In 1978, Harvard Business School student Dan Bricklin developed a program called VisiCalc. It was a relatively small program with few basic capabilities. It could only calculate data within a matrix of 5 columns by 20 rows.
To make VisiCalc more powerful Bricklin hired Bob Frankston, who is also known as the co-creator of VisiCalc. Frankston made the program fast and with better arithmetic. VisiCalc was an instant success and the duo were able to sell around 1 million copies of the program.

Note: You can still download an original copy of Visicalc from Dan Bricklin's website: http://www.bricklin.com/history/vcexecutable.htm [size: 27 K]

What followed VisiCalc?

After the phenomenal success of VisiCalc, a team headed by Mitch Kapor in 1983, developed a new spreadsheet program called Lotus 1-2-3. Mitch and his team power packed Lotus 1-2-3 with charting, graphing and rudimentary database capabilities along with the basic arithmetic. This made Lotus 1-2-3 a new favourite in the industry.

Although, before this in 1982 Microsoft had already launched Muliplan but it was outshined by Lotus 1-2-3. And this thing provoked Microsoft to come up with Microsoft Excel and rest is history.

The Infographic on History of Microsoft Excel:

This infographic takes a closer look at the history of Excel, circa 1978-2013.

How to create sheet template and apply it in Excel?

A worksheet template is very useful for our Excel users which can help us to save a lot of time when we need to create the same worksheet formatting over and over. After creating a worksheet template, we can quickly insert it into any workbooks repeatedly. In this article, I will talk about how to create and use a sheet template in Excel.

Who Created Microsoft Excel

A worksheet template is very useful for our Excel users which can help us to save a lot of time when we need to create the same worksheet formatting over and over. After creating a worksheet template, we can quickly insert it into any workbooks repeatedly. In this article, I will talk about how to create and use a sheet template in Excel.

Who Created Microsoft Excel

• Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
• More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
• Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
• Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
• Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
• Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
• More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

Create a sheet template and apply it in Excel

Excel Formulas Cheat Sheet

Please do with following steps to create a worksheet template:

1. Create a new Excel file, and remove other worksheets but leave only one worksheet.

2. Edit and format the worksheet to your need. See screenshot:

3. Then click File > Save As in Excel2007/2010, and in Excel 2013, click File > Save As > Browse. And then in the Save As dialog box, type a name for your template worksheet in the File name field, and then click drop down list from Save as type field and choose Excel Template option, see screenshot:

Tip: In the Save As dialog box, you needn't change the file path, the new file will be saved to the Template folder by default.

4. And click Save button to save this template worksheet.

5. After creating the worksheet template, and now, open an Excel file, right click the worksheet tab and select Insert, see screenshot:

6. And in the pop out Insert dialog box, select the sheet template that you are created under General tab, see screenshot:

7. Finally, click OK button, and your worksheet template is inserted into the workbook quickly.

Microsoft Excel Forms Templates

Note: If you want to remove the worksheet template, you just need to select the template sheet in the Insert dialog, and right click, then choose Delete, see screenshot:

• Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
• Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
• Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
• Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
• Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
• Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
• Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
• Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
• More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

• To post as a guest, your comment is unpublished.
  Simply stated. The new template in the customs file does not show up when the insert sheet tab is selected
  
• To post as a guest, your comment is unpublished.
  When I create and save a template it does not appear in the Insert box

  • To post as a guest, your comment is unpublished.
    It works for me, but only if I let the template be saved to C:Users[my name]AppDataRoamingMicrosoftTemplates, which isn't terribly helpful if creating company templates
    
  • To post as a guest, your comment is unpublished.
    Same here, I followed the instructions for saving it but only see Worksheet, Chart, MS Excel 4.0 Macro and MS Excel 5.0 Dialog in the Insert dialog