Posts

Cell Reference in Excel and Types

-
Image
Microsoft Excel has widely used spreadsheet software which gives us an ability to work with small, medium or huge database. To work in this software we need to use its cells and how we are using this cell that method is called Cell Reference Type and the address of that cell is called Cell Reference. Cell Reference only can be used at the time of formula or function otherwise excel will not allow users to use a cell reference also we can use it for navigation purpose but most of the time it is used in a formula or a function. By default whenever we want to use a cell reference excel will automatically capture its address just by clicking on it. Though it's an automatic process if we want we can type it manually also. Let's see how; To Create a Cell Reference we need to combine two things one is Column Number and another one is Row Number, For Example, we need to create a cell reference which is situated in column no "D" and row no "15" the...
Post a Comment
Read more

Data Types in Excel

-
Image
Excel is a spreadsheet software widely issued across the globe. In this software, we can any kind of data related works like Manipulation, Editing, Management, Analyzing and Generation of Report. As far as Data is concerned, there are a total of 4 Types of Data available in Excel by which we can be done our jobs. Below are the types of data which we can use in Excel; Text Number Date Function or Formula Text - Text data types are the very first data type in excel. It can be any alphabetical data like someone's name, company name or anything which includes Text. Number - Numer Data means it consists of only numerical values. In excel we can type up to 15 digits of Numerical Data within a single cell. Post that all Data will be converted into Zero by default. Date - It's slightly like numerical data but it's in a date format. The format is based on your system format that means in excel whenever you want to type the date you have to type it as...
Post a Comment
Read more

Selectors and Management of Sheets in MS Excel

-
Image
In Microsoft Excel, there are various types of selectors available to control the excel sheet. 1. Formal Selector -   This Selector will help us to select a cell or a group of cells which is called a range. This selector can be found everywhere in the sheet area. 2. Drag Selector -  This selector is basically a dragging selector by which we can drag a cell content into other cells. This selector can be found at the bottom right corner of a selected cell or a range. 3. Cut and Move Selector -  This selector will help us to transfer a cell content permanently from one place to another place. This process is typically known as Cut and Paste. This selector will be found in the border area of a cell or a selected range except bottom right corner. Because that area is for drag selector. 4. Width Adjust Selector -  This selector is used for adjusting the width of a column. You will find this sele...
Post a Comment
Read more

Overview of a Excel Screen

-
Image
Runbox Screen Install MS Office Package downloaded from the internet. Don't have MS office? Don't worry. Click Here to download. As we know how to install excel let’s open excel from Run box (Windows key + R). Open Run box and type excel and hit the enter key. After opening excel let’s take a quick view of the screen. Let's take a quick overview of the Excel Screen. 1. Menu Bar - In this section the basic options to control Excel is available. Menu Items Section 2. Template Section - All the template files whether it is created custom or default will be shown up here. Template Section 3. Recent Files - A default number of recent files will show up here. We can change the no the how many recent files will be shown. Recent Files As we are going to learn from scratch so click on Blank Workbook to open a blank Workbook or a blank file. Blank Workbook Now after opening a blank file let's see the part names to...
Post a Comment
Read more

Introduce Microsoft Excel

-
Image
Microsoft Excel is a software of Microsoft Office Software Package. Let's explain what is Microsoft Office. Microsoft Office , or simply  Office , is a family of  client software ,  server software , and services developed by  Microsoft . It was first announced by  Bill Gates  on August 1, 1988, at  COMDEX  in Las Vegas. Initially, a marketing term for an  office suite  (bundled set of productivity  applications ), the first version of Office contained  Microsoft Word ,  Microsoft Excel , and  Microsoft PowerPoint . Over the years, Office applications have grown substantially closer with shared features such as a common spell checker,  OLE  data integration and  Visual Basic for Applications  scripting language. Microsoft also positions Office as a development platform for line-of-business software under the  Office Business Applications  brand. On July 10, 2012,  Softpedia ...
Post a Comment
Read more