Microsoft Excel Window Componentsīefore you start using it, it’s really important to understand what’s where in its window. You can add or delete worksheets, hide them within the workbook without deleting them, and change the order of your worksheets within the workbook. You can also say that a workbook is a collection of multiple worksheets or can be a single worksheet. Each workbook contains one or more worksheets. WorkbookĪ workbook is a separate file just like every other application has.
In addition, a workbook can store chart sheets a chart sheet displays a single chart and is accessible by clicking a tab. It also has an invisible draw layer, which holds charts, images, and diagrams.Įach worksheet in a workbook is accessible by clicking the tab at the bottom of the workbook window. WorksheetĪ worksheet is made up of individual cells which can contain a value, a formula, or text. You can also customize it by changing its size, font color, background color, borders, etc.Įvery cell is identified by its cell address, cell address contains its column number and row number (If a cell is on the 11th row and on column AB, then its address will be AB11). You can enter your data into a cell either by typing or by copy-paste.ĭata can be a text, a number, or a date. The three most important components of Excel you need to understand first:Ī cell is a smallest but most powerful part of a spreadsheet. Following are the few things which it can do for you: The best part about Excel is, that it can apply to many business tasks, including statistics, finance, data management, forecasting, analysis, tracking inventory & billing, and business intelligence. People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features. There is a number of spreadsheet programs but of all of them, Excel is the most widely used. So, without further ado let’s get down to the business. And some of the most important beginner’s tutorials. This guide will help you to learn all those basics using some examples. To get a job, learning basic Excel tasks (at least some) is a must in today’s era, that’s a firm truth.Īnd, to help you with this I have compiled this guide. It is not only limited to large companies, small entrepreneurs and college students are using it for their day-to-day work. From an accountant to a receptionist, human resources to administration departments all are using Microsoft Excel. The truth is: before you go for a job interview, you must have basic knowledge of Microsoft Excel.
#MICROSOFT EXCEL TUTORIAL PDF 2016 HOW TO#
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 .From Excel Basics to Advanced with In-Depth Guides and Tutorials 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.
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).
0 kommentar(er)
