EXCEL BASICS

MEAN OF EXCEL

                    Excel means the spreadsheet. Its work in the computer software in Microsoft Office.

            This image of the excel sheet (Preview only)

 Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). 

MICROSOFT EXCEL

                Microsoft Excel is a spreadsheet developed

 by Microsoft for Windows, macOS, Android and iOS. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

FORMULAS

           It s the major used & basics work on the spreadsheet:

This only see the image of the formula

 Basic Excel Formulas For Your Workflow

• =SUM(number1, [number2], …) ...
• =SUM(A2:A8) – A simple selection that sums the values of a column.
• =SUM(A2:A8)/20 – This shows you can also turn your function into a formula. ...
• =AVERAGE(number1, [number2], …) ...
• =AVERAGE(B2:B11) – Shows a simple average, also similar to (SUM(B2:B11)/10)

1. Formulas

In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.

2. Functions

Functions are predefined formulas in Excel. They eliminate laborious manual entry of formulas while giving them human-friendly names. For example: =SUM(A1:A3). The function sums all the values from A1 to A3.

        THANK YOU !!!