![tutorial on how to use microsoft excel tutorial on how to use microsoft excel](https://www.lifewire.com/thmb/51JGVf7tzhEUVQ-N4OI-ySxce80=/1043x633/filters:no_upscale():max_bytes(150000):strip_icc()/excel-2013-basic-tutorial-8-56a8f84d5f9b58b7d0f6d121.jpg)
Data Tab can be used to get external data, sort filter and group existing data, etc.Formula Tab in Excel can be used to insert, define the name, create the name range, review the formula, etc.Page Layout Tab can be used to prepare the Excel spreadsheet for printing and exporting data.Insert Tab can be used to insert the picture, charts, filter, hyperlink, etc.Home Tab can be used to copy, cut, or paste cells and work on the formatting of data.File Tab can be used to open a new or existing file, save, print, or share a file, etc.Each tab contains a specific set of commands.īy default, each Excel spreadsheet contains the following Tabs – File, Home, Insert, Page Layout, Formulas, Data, Review, and View. It comprises various tabs including Home, Insert, Page Layout, Formulas, Data, etc.
![tutorial on how to use microsoft excel tutorial on how to use microsoft excel](https://images.saymedia-content.com/.image/t_share/MTc0MjM5NTM3MDU1MTQ3NTE2/tutorial-ms-excel-how-to-insert-a-picture-in-a-microsoft-excel-worksheet.jpg)
The Excel Ribbon is located at the top of the Excel Spreadsheet and just below the title bar or name of the worksheet. It is a crucial step if you want to know how to use Excel efficiently. Now that you are clear about these two terms, let’s move forward and understand the layout of an Excel Spreadsheet. Worksheets appear as tabs along the bottom of the screen. An Excel Workbook is an Excel file with the extension “.xlsx” or “.xls” whereas an Excel Worksheet is a single sheet inside the Workbook. To explore the different ways on How to use Excel you should be familiar with the different elements of Excel first.Įxcel Workbook and Excel Worksheet are often used interchangeably, but they do have different meanings. Understanding the Different Elements of an Excel Spreadsheet Step 3: An Excel spreadsheet is now opened and you are ready to explore the wonderful world of Excel. To open an existing Excel spreadsheet, click on the “ Open Other Workbooks” and select the Excel sheet you want to work on. Step 2: You can either click on the “ Blank Workbook” button to open a blank Excel spreadsheet or select from the list of pre-existing templates provided by Excel. Step 1: Click on the Window icon on the left side of the Taskbar and then scroll below to find “Excel”. To open an Excel Spreadsheet, follow the steps of this Excel tutorial below: Let’s start this step by step Excel tutorial on – “How to use Excel” Opening an Excel Spreadsheet Basic Calculations in an Excel Spreadsheet.Understanding the Different Elements of an Excel Spreadsheet.This Excel for dummies guide will include tutorials on:
![tutorial on how to use microsoft excel tutorial on how to use microsoft excel](https://www.learningcomputer.com/images/adding-numbers-in-excel-formulas-tab.jpg)
In this Excel tutorial, I will cover the Basics of Excel that you need to know to get started with how to use Excel.
#Tutorial on how to use microsoft excel software#
In the Order list, select the order that you want to apply to the sort operation - alphabetically or numerically ascending or descending (that is, A to Z or Z to A for text or lower to higher or higher to lower for numbers).įor more information about how to sort data, see Sort data in a range or table .An Excel Spreadsheet is the go-to software to analyze, sort, or present a large amount of information and data in no time. In the Sort On list, select either Values, Cell Color, Font Color, or Cell Icon. In the Sort by list, select the first column on which you want to sort. On the Data tab, in the Sort & Filter group, choose Sort.
![tutorial on how to use microsoft excel tutorial on how to use microsoft excel](https://www.tutorialspoint.com/excel/images/excel-2010-mini-logo.jpg)
Select a single cell anywhere in the range that you want to sort. Select a single cell in the column on which you want to sort.Ĭlick to perform an ascending sort (A to Z or smallest number to largest).Ĭlick to perform a descending sort (Z to A or largest number to smallest). The range can include titles that you created to identify columns or rows. Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column).