Analyzing data with Excel

- Acquire the syntax of the main logic and search functions
- Know how to construct formulas, nesting multiple functions that are passed parameters
- Optimize time by linking data among multiple tables/reports
- Present advanced analysis with new pivot table tools

All those who want to become more proficient in using Microsoft
Excel as an analysis and reporting tool.
Not suitable for those with minimal knowledge of formulas and calculations. Participation in the course will be subject to an initial assessment test to assess eligibility for participation

Nesting functions to realize dynamic tables
- Conditional statistical functions: SUM.PLUS.IF, COUNT.PLUS.IF.
- Logic functions: SE (simple and cascade), AND, OR, SE.ERROR
- Search functions: SEARCH.VERT, SEARCH.ORIZZ, COMPARE, INDICE
- Date and time functions: NOW, DATE, MONTH, YEAR, ...
- Text functions: CANCEL.SPACE, CONCATENA, RIGHT, LEFT,
STRING.EXTRACT,SEARCH. REPLACE
- Information functions: VAL.EMPTY, VAL.ERR, VAL.NON.DISP, VAL.TEXT, ...
- The SUBTOTAL function
- The nesting of multiple functions
Tools for customizing data
- Advanced sheet formatting to give particular visibility to portions of the
report
- Conditional formatting based on formulas
- Cell validation criteria
Linking data from multiple reports
- Define the flow of data through sheets and files
- Create formulas with cells that come from multiple sheets and files
Make reports by aggregating data from database query: pivot tables
- Grouping and structuring data
- Pivot and PowerPivot
- Totals and Subtotals for grouping and structuring data
- Formulas that can be inserted into the pivot table
- Graphs on the pivot table
Exercises
- The course is based on continuous exercises for direct experimentation of the
excel functionality covered by the program.