I completed the “Microsoft Excel: From Basic to Advanced” course held on the Udemy online platform.
The course allowed me to refine some skills previously acquired in Excel, to acquire the methodology for implementing well-known mathematical operators in Excel and to improve in the use of the application in general.
Spreadsheet
A spreadsheet is productivity software that allows you to operate on different data with math, macro and graph functions.
The software is based on a table made up of a cell in which you can enter numbers and / or formulas which can therefore be defined manually or taken from libraries. That is, each cell is identified by a coordinate that indicates its position.
Excel
Microsoft Excel is a software produced by Microsoft dedicated to the production and management of spreadsheets. It is the most used program for producing and managing spreadsheets.
So the operations that we can implement immediately, using symbolic characters are:
- Sum, operator
+: used to sum two or more numbers. Es.:=A1+B1 - Subtraction, operator
-: used to subtract two numbers. Es.:=A1-B1 - Multiplication, operator
*: used to multiply numbers. Es.:=A1*B1 - Division, operator
/: used to divide two numbers. Es.:=A1/B1 - Comparison operators:
>,<,>=,<=: They return a Boolean value (TRUE or FALSE) and are often used in the IF formula. - Exponent, operator
^ - Module, operator
%
Added to these are a host of more complex functions.
In particular, the course focuses on:
- Spreadsheets
- Data Management
- IF Functions
- Vertical Search
- Sum, Sum If, Sum Plus If
- Count, Count If, Count Plus If
- Pivot Tables
- Other useful features