WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » How to Create an Excel Spreadsheet?

How to Create an Excel Spreadsheet?

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Overview of How to Create an Excel Spreadsheet

If you are a fresher, then it is important to know how you can create and start the spreadsheet with Excel. Over the years, spreadsheets are playing a vital role in maintaining a large database with excel. Data Analysis and Number Crunching are the main purposes we are using spreadsheet day in day out. In fact, many people use this spreadsheet to maintain their business needs and personal things as well.

Using spreadsheets, I have seen many people manage their family budgets, mortgage loans, and various other things for their fitting needs on a daily basis. In this article, we will show you how to create an excel spreadsheet, tools available with the spreadsheet, and many other things.

Create Excel Spreadsheet

Understanding Excel Workbook Screen

When we open the excel screen, we could see the below features in front of us.

#1 – Ribbon

These menu options are called “ribbon” in excel. In the ribbon, we have several tabs to work with. Going forward, we will explore each one of them in detail.

Create Excel Spreadsheet Example 0.1

#2 – Formula Bar

The formula bar in excel is the platform to view the formula or the value of the selected cell or active cell. For example, if we have 5 in the cell A1, if the A1 cell is selected, we can see the same value in the formula bar.

 Example 0.2.1

#3 – Column Header

As you can see, each column has its own heading with alphabet characters representing each column separately.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Create Excel Spreadsheet Example 0.3.0

#4 – Row Header

Column headers are represented by alphabets, and similarly, row headers are represented by numbers starting from 1. In recent versions of Excel, we have more than 1 million rows.

Create Excel Spreadsheet Example 0.4.0

#5 – Spreadsheet Area

This is where we do the work. As you can see in the above overview image, we have small rectangular boxes, which are plenty. The combination of column and row forms a cell, i.e., a rectangular box. Each cell was identified by a unique cell address consisting of a column header followed by a row header. For the first cell, the column header is A, and the row header is 1, so the first cell address is A1.

Create Excel Spreadsheet Example 0.5.1

This is the general overview of the excel spreadsheet. Now we will see how to work with this spreadsheet.

How to Work with Excel Spreadsheet?

Let’s look at the example given below.

To work with a spreadsheet, first, we need to select the cell we are looking to work with. For example, if you want the word “Name” in the cell A1, then select the cell and type “Name” in the cell.

 Example 2

Select the cell B1 and type Price.

Create Excel Spreadsheet Example 2.1

Now come back to cell A2 and type some fruit names.

Example 2.2

In the associated column, enter the price of each fruit.

Create Excel Spreadsheet Example 2.0.3

This is the simple table we have created with excel.’

Steps to Format Excel Spreadsheet

This looks a raw data, but by applying some excel formatting, we can make this look beautiful.

Step #1

Select the header and make the font, Bold. The excel shortcut key to apply bold formatting is Ctrl + B.

 Example 2.0.4

Step #2

Make center alignment.

Create Excel Spreadsheet Example 2.0.5

Step #3

Now fill the background color for the selected cells.

Example 2.0.6

Step #4

Change the font color to white.

Create Excel Spreadsheet Example 2.0.7

Step #5

Now apply borders to the data. Select the entire data range to apply borders.

 Example 2.0.8

Now the data looks like an organized one. Like this, we can create a spreadsheet and work with it.

This is the basic level introduction to excel spreadsheet. Excel has a wide variety of tools to work with. We will see each of the tool explanation in separate dedicated articles which expose you to the advanced features.

Recommended Articles

This has been a guide to Create an Excel Spreadsheet. Here we will show you how to create a spreadsheet through excel, general overview tools available along with examples, and a downloadable excel template. You may learn more about excel from the following articles –

  • Family Tree in Excel
  • Word Cloud in Excel
  • Basic Excel Training Course
  • Basic Formulas in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Create Spreadsheet in Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More