Class 8 - Working with large data

13 Outubro 2017, 08:00 • DANIELA ALEXANDRA DINIS PATEIRO

Importing data

Using Excel as a Database: sorting, filtering, Excel tables, DFunctions, Data Validation and Data Consolidation

Exercises on Statistical Analysis

---

Class 7 - Statistical Analysis with Excel

11 Outubro 2017, 08:30 • DANIELA ALEXANDRA DINIS PATEIRO

Using Excel Solver

'What-if' analysis tool: Data Tables, Scenario Manager and Goal-seek

---

Class 6 - Statistical Analysis with Excel

6 Outubro 2017, 08:00 • DANIELA ALEXANDRA DINIS PATEIRO

Exercises

Discussion on some exercises from Excel Essentials

---

Class 5 - Statistical Analysiswith Excel

4 Outubro 2017, 08:30 • DANIELA ALEXANDRA DINIS PATEIRO

1 - Understanding and analysing data (using Data Analysis ToolPak add-in)

2 - Relationships in data (trendlines, Excel functions and linear regressions)

3 - Distributions in Excel

---

Class 4 - Exercises

29 Setembro 2017, 08:00 • DANIELA ALEXANDRA DINIS PATEIRO

- Excel Essentials - Exercises and examples

 

 

 

 

 

---