Advanced Microsoft Excel and Business Intelligence

Time Table

 

Lesson

Class A (BSc)

Class B (MSc)

Topic and Remark

1

7 March 2024 – Thursday

19:00 – 22:00 (M301)

 

16 March 2024 – Saturday

10:00 – 13:00 (M301)

Outline, Advanced Editing and Formatting

Exercise, Source File

 

2

8 March 2024 – Friday

19:00 – 22:00 (M301)

 

16 March 2024 – Saturday

14:00 – 17:00 (M301)

Data Manipulation

Exercise, Source File

 

3

14 March 2024 – Thursday

19:00 – 22:00 (M301)

 

23 March 2024 – Saturday

09:15 – 12:15 (M301)

Plotting Chart

Exercise, Source File

 

4

15 March 2024 – Friday

19:00 – 22:00 (M301)

 

23 March 2024 – Saturday

13:00 – 16:00 (M301)

Formula and Function

Exercise, Source File

 

5

21 March 2024 – Thursday

19:00 – 22:00 (M301)

 

1 June 2024 – Saturday

10:00 – 13:00 (M301)

Data Analysis and Problem Solving

Exercise, Source File

 

6

22 March 2024 – Friday

19:00 – 22:00 (M302)

 

1 June 2024 – Saturday

14:00 – 17:00 (M301)

Financial Analysis and Data Collaboration

Exercise, Source File

 

7

6 June 2024 – Thursday

19:00 – 22:00 (M301)

 

8 June 2024 – Saturday

10:00 – 13:00 (M301)

Macro and VBA

Exercise, Source File

 

8

7 June 2024 – Friday

19:00 – 22:00 (M301)

 

8 June 2024 – Saturday

14:00 – 17:00 (M301)

PowerQuery and Power BI - Part I

Source File

9

13 June 2024 – Thursday

19:00 – 22:00 (M301)

 

17 June 2024 – Saturday

10:00 – 13:00 (M301)

PowerQuery and Power BI - Part II

Source File

10

14 June 2024 – Friday

19:00 – 22:00 (M301)

 

17 June 2024 – Saturday

14:00 – 17:00 (M301)

From Excel to Tableau

Source File