2. Formulas and Functions 3. Charts and Graphs to present the data. 4. PivotTables and Data Modeling 5. Power Query & Power Pivot for advanced data analysis Power Query: A data transformation and cleaning tool that helps you easily connect to and transform data from various sources. 6. Power Pivot: an advanced data modelling tool that helps you analyze large datasets and create complex relationships between data.