Microsoft Excel

• Cell definition: number, text, date, currency, thousands separator, percentage

• Design customization (data display, such as date format, can be changed)

• Conversion of dates displayed as text (with periods) via the search and replace method

• Text in columns: Dividing a column into two or more columns (for example, one column for a private name, one for a family name), or merging several columns into a single column

• Mastery of data management, including cell definition

• Data conversion tools for new templates

• Flash Files – automatic data population

• Data display using colors & symbols in accordance with criteria defined by formulas

• As examples, a box should not be opened, a table should not be designed and columns should not be deleted without data verification

• Customized and advanced data sorting

• Filtering data into a new table without modifying the original table

• Simple formulas - Sigma

• Cell fixing

• Logical – IF, nested IF, IFERROR, combining AND, OR and IF

• Calculation – subtotal, sumif, sumifs, countif, averageif

• Information – vlookup, hookup, index, match (alternative for vlookup), combinations of those functions, how to add an IFNA function for cases in which N/A error messages are generated

• Date – month, day, weekday, workday

• Text – extraction, find and replace (to remove ### for example), merging texts

• Vlookup

• Conditional design

• Consolidate

• Power queries

• Pivot tables

• GetPivotData function

• Creating interactive & efficient dashboards and indicators, with tables, data, functions & charts that will be updated automatically