The Wayback Machine - https://web.archive.org/web/20240828110709/https://www.geeksforgeeks.org/introduction-to-ms-excel/
Open In App

Introduction to MS Excel

Last Updated : 26 Aug, 2024
Comments
Improve
Suggest changes
Like Article
Like
Save
Share
Report
News Follow

MS-EXCEL is a part of Microsoft Office suite software. It is an electronic spreadsheet with numerous rows and columns, used for organizing data, graphically representing data(s), and performing different calculations.  It consists of 1048576 rows and 16384 columns in Excel 2007 and later versions, a row and column together make a cell. Each cell has an address defined by column name and row number example A1, D2, etc. This is also known as a cell reference.

What is MS Excel

Microsoft Excel is a software application designed for creating tables to input and organize data. It provides a user-friendly way to analyze and work with data. The image below provides a visual representation of what an Excel spreadsheet typically appears like

Screenshot-(256)

Excel Interface

Excel-Home

What is a Cell

A spreadsheet takes the shape of a table, consisting of rows and columns. A cell is created at the intersection point where rows and columns meet, forming a rectangular box. Here’s an image illustrating what a cell looks like:

Screenshot-(256)

What is Cell Address or Cell Reference

The address or name of a cell or a range of cells is known as Cell reference. It helps the software to identify the cell from where the data/value is to be used in the formula. We can reference the cell of other worksheets and also of other programs.

  • Referencing the cell of other worksheets is known as External referencing.
  • Referencing the cell of other programs is known as Remote referencing.

There are three types of cell references in Excel:  

  1. Relative reference.
  2. Absolute reference.
  3. Mixed reference.

Image

Features of MS Excel

Ribbon

Th eRibbon in MS-Excel is the topmost row of tabs that provide the user with different facilities/functionalities. These tabs are:

Screenshot-(257)

Home Tab

It provides the basic facilities like changing the font, size of text, editing the cells in the spreadsheet, autosum, etc.

Insert Tab

It provides the facilities like inserting tables, pivot tables, images, clip art, charts, links, etc.

Page layout

It provides all the facilities related to the spreadsheet-like margins, orientation, height, width, background etc. The worksheet appearance will be the same in the hard copy as well.

Formulas

It is a package of different in-built formulas/functions which can be used by user just by selecting the cell or range of cells for values.

Data

The Data Tab helps to perform different operations on a vast set of data like analysis through what-if analysis tools and many other data analysis tools, removing duplicate data, transpose the row and column, etc. It also helps to access data(s) from different sources as well, such as from Ms-Access, from web, etc.

Review

This tab provides the facility of thesaurus, checking spellings, translating the text, and helps to protect and share the worksheet and workbook.

View

It contains the commands to manage the view of the workbook, show/hide ruler, gridlines, etc, freezing panes, and adding macros.

How to Create a New Spreadsheet

In Excel 3 sheets are already opened by default, now to add a new sheet :

  • In the lowermost pane in Excel, you can find a button.
  • Click on that button to add a new sheet.

Image

  • We can also achieve the same by Right-clicking on the sheet number before which you want to insert the sheet.
  • Click on Insert.

Image

  • Select Worksheet.
  • Click OK.

Image

How to Open an Existing Worksheet

On the lowermost pane in Excel, you can find the name of the current sheet you have opened.

On the left side of this sheet, the name of previous sheets are also available like Sheet 2, Sheet 3 will be available at the left of sheet4, click on the number/name of the sheet you want to open and the sheet will open in the same workbook.

For example, we are on Sheet 4, and we want to open Sheet 2 then simply just click on Sheet2 to open it.

Image

Managing the Spreadsheets

You can easily manage the spreadsheets in Excel simply by :

  • Simply navigating between the sheets.

Image

  • Right-clicking on the sheet name or number on the pane.
  • Choose among the various options available like, move, copy, rename, add, delete etc.
  • You can move/copy your sheet to other workbooks as well just by selecting the workbook in the To workbook and the sheet before you want to insert the sheet in Before sheet.

Image

How to Save the Workbook

  1. Click on the Office Button or the File tab.
  2. Click on Save As option.
  3. Write the desired name of your file.
  4. Click OK.

How to Share your Workbook

  1. Click on the Review tab on the Ribbon.
  2. Click on the share workbook (under Changes group).
  3. If you want to protect your workbook and then make it available for another user then click on Protect and Share Workbook option.
  4. Now check the option “Allow changes by more than one user at the same time. This also allows workbook merging” in the Share Workbook dialog box.
  5. Many other options are also available in the Advanced like track, update changes.
  6. Click OK.

Ms-Excel shortcuts

  1. Ctrl+N: To open a new workbook.
  2. Ctrl+O: To open a saved workbook.
  3. Ctrl+S: To save a workbook.
  4. Ctrl+C: To copy the selected cells.
  5. Ctrl+V: To paste the copied cells.
  6. Ctrl+X: To cut the selected cells.
  7. Ctrl+W: To close the workbook.
  8. Delete: To remove all the contents from the cell.
  9. Ctrl+P: To print the workbook.
  10. Ctrl+Z: To undo.

What is the Latest Versions of Excel

The most recent edition of Microsoft Excel is part of MS Office 2019, which is the latest version of the Microsoft Office suite. It comes packed with numerous new features introduced by Microsoft.

FAQs

What is Ms Excel and its Features?

Microsoft Excel is a spreadsheet program that helps you manage and analyze data. Its key features include:

  • Grid layout with cells for data.
  • Formulas and functions for calculations.
  • Charts and graphs for visualization.
  • Data analysis tools like sorting and filtering.
  • Collaboration and data protection options.
  • Compatibility with various platforms.

What is Ms Excel Definition?

Microsoft Excel is a computer program that lets you create tables to store and work with information, like numbers and words. It helps with tasks like calculations, making charts, and organizing data neatly.



D
deepika92
News
Improve
Previous Article
Introduction to Microsoft Word
Next Article
Introduction to Microsoft PowerPoint

Similar Reads

Editing Excel Macros in Excel
Excel Macro is a set of actions that can be recorded, saved, used multiple times. This feature saves us a lot of time when dealing with repetitive tasks and huge data sets. We can always make changes to an existing Macro in Excel. There are two ways to record and run macros: Excel Commands Excel Visual Basic for Applications(VBA).1. Copying a Macro
1 min read
Scenario Manager in Excel
A Scenario Manager is a tool in Excel that works on a set of values that Excel saves and can be change up to 32 cells simultaneously. In this article, we will look at how we can use Scenario Manager in Excel. To do so follow the steps below: Step 1: Formatting data. Step 2: Highlight the data in which we want to change by Scenario Manager. Step 3:
1 min read
Excel VBA | count() functions
Visual Basic for Applications (VBA) is the programming language of Excel and other offices. It is an event-driven programming language from Microsoft. With Excel VBA one can automate many tasks in excel and all other office software. It helps in generating reports, preparing various charts, graphs and moreover, it performs calculation using its var
2 min read
How to Sum Diagonal Cells in a range in Excel?
The calculation of matrices is one of the most difficult numerical computation tasks. You may need to add values diagonally in a table when performing mathematical computations. Excel allows you to sum diagonal numbers without having to add the values one by one. We'll go through how to sum cells diagonally down or diagonally up. Example: The image
6 min read
How to Group Adjacent Columns or Rows Separately or Independently in Excel?
Excel comes with a range of tools and functions to work with complex spreadsheets easily. There are various options to organize content so that it makes more sense and lets one work effectively. Grouping adjacent rows and columns are one such feature that we can use to organize data effectively in Excel. But there is a catch. What if we want to mak
3 min read
Advanced Excel - Chart Design
The charts are the visual representation of data in both rows and columns. They are used to analyze the trends and patterns in the datasets. For example, If we want to analyze the sales of different courses for a specific period of time we can easily do this with the help of charts and get the result of queries such as months having a maximum numbe
4 min read
How to Use for Each Loop in Excel VBA?
A For Each loop is used to execute a statement or a set of statements for each element in an array or collection. Syntax: For Each element In group [ statements ] [ Exit For ] [ statements ] Next [ element ] The For...Each...Next statement syntax has the following three parts: PartDescriptionelement Required (Must be mentioned). Variable is used to
3 min read
How to Hide Zero Values in Excel
Microsoft Excel enables us to format, organize and calculate data in a spreadsheet. It's a great tool for preparing datasets and it makes those datasets easier for users and analysts to analyze the data. Sometimes these datasets contain zero values that are not required to be seen. Excel provides an easy way to hide those zero values without affect
6 min read
How to Create Dynamic Excel Dashboards Using Picklists?
Dashboards are a report technique that visually presents critical metrics or a data summary to allow for quick and effective business decisions. Excel is capable of handling complex statistical calculations, many of which are built-in as Functions and can be easily displayed on a dashboard. Excel dashboards allow for quick overviews of data reports
3 min read
Excel VBA | sum() functions
Visual Basic for Applications (VBA) is the programming language of Excel and other offices. It is an event-driven programming language from Microsoft. With Excel VBA one can automate many tasks in excel and all other office software. It helps in generating reports, preparing various charts, graphs and moreover, it performs calculation using its var
2 min read
Excel VBA | Average() Functions
VBA (Visual Basic for Applications) is the programming language of Excel and other offices. It is an event-driven programming language from Microsoft. With Excel VBA, one can automate many tasks in excel and all other office softwares. It helps in generating reports, preparing various charts, graphs and moreover, it performs calculation using its v
2 min read
How to Declare and Initialize String Array in Excel VBA?
A string array is an array where we can store only string values in the array, with the help of a string array, we can store more than one string value. We can declare the string array in many ways like declaring a static string array, declaring a variant size array of string using the Array function, and a string array using the split function whi
2 min read
Trapping Dynamic Ranges in Excel VBA
Dynamic Ranges give the flexibility to work with more range of cells as compared to a specific range of cells which usually limits us to work with a particular range of cells. As the size of the data may change in an excel sheet so it is also necessary to change the range in the code dynamically for that dynamic ranges are used. We can trap dynamic
3 min read
Excel Formula to Get Next Day of Week
MS-Excel is a program that is part of the Microsoft Office suite. It is a multi-row and multi-column electronic spreadsheet that is used to organize data, graphically portray data(s), and conduct various calculations. It has 1048576 rows and 16383 columns, with each row and column forming a cell. Each cell has an address that is determined by the c
3 min read
Array Formulas in Excel
Excel is among the most powerful and widely used spreadsheet tools which eases organizing numbers and data within the sheets with pre-built formulas and functions. In this article, we are going to study Array Formulas. Arrays are one of them. Using Excel Array Formulas, make it super easy to handle a lot of data. Before understanding and using the
8 min read
Power View in Excel
In today's data-driven world, the ability to turn raw data into meaningful insights is a skill that can unlock countless opportunities. Enter Power View, a remarkable data visualization technology that empowers users to transform their data into interactive and engaging charts, graphs, maps, and more. Whether you're working with Excel, SharePoint,
8 min read
Actual vs Target Chart in Excel
Actual vs Target values are used to check whether the target value has been met or not. These types of charts are used in various organizations and companies where some type of target is to be achieved. Like these can be used to see whether actual sales value met the target sales values or not. There are various ways to create actual VS target char
3 min read
Format Reports in Excel
Excel 2013 introduces the Format pane. It offers advanced formatting choices in clean, bright new task windows, and it is also highly useful. When you alter the theme, it is applied to all Power View Views in the Report and Sheets in the Workbook. You may also modify the size of the text in all of your Report Elements. You can add Background Images
4 min read
How to Add Lines In An Excel Clustered Stacked Column Chart?
In Excel, a chart is a tool you may use to visually convey data. Charts are used in Microsoft Excel to provide a graphical representation of any set of data. Scientific, statistical, and technical data are frequently represented and compared using scatter plots. There are two Value Axes in a Scatter chart: a Vertical (y) Value Axis and a Horizontal
2 min read
How to perform T-tests in MS Excel?
The T-Test function in Excel calculates the chance of a significant difference between two data sets, regardless of whether one or both are from the same population and have the same mean T-Test, which also includes whether the data sets we're utilizing for computation are a one-tail or two-tail distribution with a variance that might be equal or u
4 min read
Intersection of Two Linear Straight Lines in Excel
Intersection points can be beneficial in finding insights into the data, As intersections give the same values for different data sets. Excel can help to automate the task of finding the intersection point of two lines by using the =slope() and =intersection() function and replacing their values with the given equations. In this article, we will le
4 min read
How to Create a Line Chart for Comparing Data in Excel?
Excel is powerful data visualization and data management tool which can be used to store, analyze, and create reports on large data. It can be used to visualize data using a graph plot. In excel, we can plot different kinds of graphs like line graphs, bar graphs, etc., to visualize or analyze the trend. Line Chart for Comparing Data in Excel The li
2 min read
How to Create a Power PivotTable in Excel?
When we have to compare the data (such as name/product/items, etc.) between any of the columns in excel then we can easily do with the help of Pivot table and pivot charts. But it fails when it comes to comparing those data which are in two different datasets, at that time Power Pivot comes into role. So, Basically, Power Pivot is useful for compar
4 min read
How to Generate All Prime Numbers Between Two Given Numbers in Excel?
A number greater than 1 with no positive divisors besides 1 and the number itself is referred to as a prime number. In this article, we will be discussing two approaches for generating all prime numbers between two given numbers in excel. In the first approach, we are creating formulas for generating prime numbers between two numbers, and in the se
3 min read
How to Create Automatically Extended Plot Ranges in Excel?
We can easily create charts with the help of data points and data sources. But, If we have more data points added to our data source we need our chart will get updated depending upon our data source. For example, if we want to plot a sales chart on monthly basis, we need to update our chart every time we will need to add a new month's data. To over
2 min read
How to Automatically Insert Date and Timestamp in Excel?
The Date and Timestamp is a type of data type that determines the date and time of a particular region. It contains some characters along with some encoded data. This format may vary from language to language. Keeping track of date and time helps in managing records of our work as well as segregate the information day-wise. In this article, we will
4 min read
Named Range in Excel
We can use the name for the cell Ranges instead of the cell reference (such as A1 or A1:A10). We can create a named range for a range of cells and use then use that name directly in the Excel formulas. When we have huge data sets, Excel-named ranges make it easy to refer (by directly using a name to that data set). Creating an Excel Named Range : T
7 min read
How to Find the Antilog of Values in Excel?
Logarithmic functions are mostly used when we deal with exponents. So, while dealing with a logarithmic function many times we need to calculate the antilog value. Antilog is simply the reverse of the logarithm. In Excel, we have a direct formula to calculate the log of any values. The functions available in Excel are : 1. LOG10: It is used to calc
3 min read
Multiple Series in One Excel Chart
Excel gives many built-in features related to graphs and dataset representations, which help to visualize and analyze data easily. One of these features is the secondary axis, which allows the drawing of multiple series of data on a single graph. A secondary axis is required to represent and easily visualize multiple data series without the use of
2 min read
Reading Data From Microsoft-Excel using Automation Anywhere
Automation Anywhere Enterprise, caters to organizations that are looking to deploy a digital workforce composed of software bots that complete business processes end-to-end. Automation Anywhere Enterprise combines traditional Robotic Process Automation (RPA) with cognitive elements such as natural language processing and reading unstructured data.
3 min read
Article Tags :
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy
Lightbox