MS EXCEL Basics

Hello Dear Readers

I have come up with sharing some MS Excel Fundamentals, hope it will prove helpful for my readers,

Excel is the world's most used spreadsheet program

Excel is a powerful tool to use for mathematical functions

Excel is the world's most used spreadsheet program.

Example use areas:

1. Data Analytics
2. Project management
3. Finance and accounting
   
   

   <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-1349259147465486"
        crossorigin="anonymous"></script>

   Excel is typically used for:

• Analysis
• Data entry
• Data management
• Accounting
• Budgeting
• Data analysis
• Visuals and graphs
• Programming
• Financial modeling
• And much, much more!
  
  
  
• It is the most popular spreadsheet program in the world
• It is easy to learn and to get started.
• The skill ceiling is high, which means that you can do more advanced things as you become better
• It can be used with both work and in everyday life, such as to create a family budget
• It has a huge community support
• It is continuously supported by Microsoft
• Templates and frameworks can be reused by yourself and others, lowering creation costs
  

  <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-1349259147465486"
       crossorigin="anonymous"></script>

  
  

  Office 365

  The easiest way to get started with Excel, is to use Office 365.

  Office 365 does not require downloading and installation of the program. It simply runs in your browser.

  In our tutorial we will use Office 365, which can be accessed from www.office.com.
  

  Install

  Once you have successfully logged into Office through www.office.com, click on the Excel icon on the left side to enter the application
  Then Enter a name for your workbook, and hit the enter button
  The Excel view has columns and rows, similar to a squared math exercise book.
  

  For now focus on the rows, columns, and the cells.

  Ok. Let's make a function!

  • First, double click the cell A1, the one that is marked with the green rectangle in the picture.
  • Second, type =1+1.
  • Third, hit the enter button
    
    

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-1349259147465486"
     crossorigin="anonymous"></script>

Tabs

The tab is a menu with sub-divisions sorted into groups. The tabs allow users to quickly navigate between options of menus which display different groups of functionality.

Groups

The groups are sets of related commands. The groups are separated by the thin vertical line break.

Commands

The commands are the buttons that you use to do actions.

Now, let's have a look at the Sheet. Soon you will be able to understand the relationship between the Ribbon and the Sheet, and you can make things happen.

---

Sheet

The Sheet is a set of rows and columns. It forms the same pattern as we have in math exercise books, the rectangle boxes formed by the pattern are called cells.

Values can be typed into cells.

Values can be both numbers and letters

Excel Syntax

A formula in Excel is used to do mathematical calculations. Formulas always start with the equal sign = typed in the cell, followed by your calculation.

Creating formulas, step by step

• Select a cell
• Type the equal sign (=)
• Select a cell or type value
• Enter an arithmetic operator
• Select another cell or type value
• Press enter

For example =1+1 is the formula to calculate 1+1=2

Using Formulas with Cells

You can type values to cells and use them in your formulas.

Lets type some dummy values to get started. Double click the cells to type values into them. Go ahead and type:

• A1(309)
• A2(320)
• B1(39)
• B2(35)
  Type values by selecting a cell, claim it by entering the equal sign (=) and then type your value. For example =309.
  
  

  Here is how to do it, step by step.

  1. Select the cell C1
  2. Type the equal sign (=)
  3. Left click on A1, the cell that has the (309) value
  4. Type the minus sign (-)
  5. Left click on B2, the cell that has the (35) value
  6. Hit enter
     
     Tip: The formula can be typed directly without clicking the cells. The typed formula would be the same as the value in C1 (=A1-B2).
     
     The result after hitting the enter button is C1(274). Did you make it?
     
     

     Another Example

     Let's try one more example, this time let's make the formula =A2-B1.

     Here is how to do it, step by step.

     1. Select the cell C2
     2. Type the equal sign (=)
     3. Left click A2, the cell that has the (320) value
     4. Type the minus sign (-)
     5. Left click B1, the cell that has the (39) value
     6. Hit the enter button
        
        You got the result C2(281), right? Way to go!
        

        Here are some examples:

        • =2+4 gives you 6
        • =4-2 gives you 2
        • =2*4 gives you 8
        • =2/4 gives you 0.5
In the next Blog you will learn about Ranges and how data can be moved in the Sheet.
        Till then Keep Practicing Excel for better learning :)
        
        
        #google_responsive_slot_preview