* Use of formulas to organize data and prepare it for analysis. * Use of tables and dynamic graphs for the analysis of sales revenue.
* Use of conditional formatting to identify duplicate values. * Sort data by different criteria. *Use of dynamic tables and graphs to present reports.
* Analysis of information in excel, performing database crossovers to detect errors in the processes. * Forms with macros that allowed to keep track of staff time, facilitate the recording of information and preparation of reports having standardized information. * Pivot tables to summarize and analyze process information.