We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Skills Directory
  2. Excel

Excel

Excel tools for business intelligence support data munging, visualization, filtering, and advanced analytics. The competency includes string manipulation, filtering, and normalization of data.  For presentation and analysis, the competency includes creation of pivot tables, charts and graphs for visualization.

Key Competencies: 

  1. Filters - Ability to apply filters based on conditions eliminating any irrelevant data.

  2. Built-in Excel Functions - Knowledge of using IF statements, COUNTA, COUNTIF, AVG, etc. Knowledge of text functions such as joining strings, finding the length, finding substring, substitute etc. 

  3. Data Lookup Functions - Knowledge of functions such as LOOKUP, HLOOKUP, and VLOOKUP, MATCH and INDEX.

  4. Pivot Charts and Data Visualizations - Ability to create pivot tables and plots to analyze and visualize data.