EXCEL ADVANCE



Agenda:

1. Data analysis in Excel using classic tools: Exploring an data model based on MS Excel along with its content and its structure while using add-ins. Also create your own expressions for your calculations while you are at it.

2. Importing data: Learn how to import data and create a mashup of the data base.

3. Calculations: Learn how to create measures of each cell along with exploring several advanced functions.

4. Data presentation: Creating great visual representations of data such as hierarchies, year to year comparisons and many others.