excel

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. 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 Microsoft Office.

install excel

Install and Activate Tools for Analysis and Solver 

1-Click the File tab, choose Options, and then click the Add-ons category. 

2-In the Manage box, click Excel Add-Ins, and then click Go. The Add-Ins dialog box appears.

 3-In the Available add-ons box, select the Analysis tools and Solver add-in check boxes, and then click OK. 

4-If Excel displays a message that states that it can not start this add-on and prompts you to install it, click Yes to install the add-ins. Excel prompts you to install an add-in twice: once for Tools for analysis and another for Solver.

Excel belongs to Microsoft Office applications, it is a spreadsheet that can have many utilities. In this topic we learned to recognize Excel parts, such as rows and columns.

Book: It is the set of sheets in an Excel document.

 Sheet: It is made up of cells.

 Red = Name table: Contains the name that identifies each cell.

Celeste = Formula bar: Shows the complete formula of a cell.

Purple = Columns: They are ordered vertically and are identified by letters from A to XFD.

    Orange = Rows: They are ordered horizontally 

    and identified with numbers from 1 to 1,048,576.

Green = Cell: The intersection between a row and a column, where we work on each of the data and 

formulas Blue = Scrolling of leaves: It works by helping us move on Excel sheets.

Magenta = Tag Bar: Shows the leaves with their respective names and the option to add more sheets.

We learn about the operations that can be performed in Microsoft Excel, through formulas and operators, which are classified into the following groups: 

Arithmetic operators: 

Change the size of a cell: We must be in the home tab, look for the group "Cells" and select the "format" command, where we select among the options the row height or the column width.

Formulas:

 = SUM (range) 

= MAX (range)

 = MIN (range)

= COUNT (range) 

= COUNTIF (range, criteria); 

= COUNTIF (B2: B25, "Maria") 

= function yes; YES (true logic test, true logic value, false logic value)