Microsoft Excel

Cell Design

• Cell definition

• Design customization

• Conversion of dates displayed as text

• Text in columns

• Mastery of data management, including cell definition

• Data conversion tools for new templates

• Flash Files – automatic data population

Conditional Criteria Based Design

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

Data Verification to Prevent Duplications and Errors

• a box should not be opened

• a table should not be designed

• columns should not be deleted without data verification

Sorting and Filtering Table Data in a Fast and Efficient Manner

• Customized and advanced data sorting

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

Calculations and Formulas

• Simple formulas

• Cell fixing

Functions

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

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

• Information – vlookup, hookup, index, match

• Date – month, day, weekday, workday

• Text – extraction, find and replace

Two Methods of Data Cross-Checking

• Vlookup

• Conditional design

Two Methods of Table Data Merging

• Consolidate

• Power queries

Reports

• Pivot tables

• GetPivotData function Two Methods of Table Data Merging Module 08 ו Consolidate ו Power

Dashboards – Excel’s Control Center

• Creating interactive & efficient dashboards and indicators