Lecture Video Tutorials - Main View | Week 1 Content | NCC012 01 - Intermediate Health Care Spreadsheets | NMC Student Portal

Week 1 Content

Lecture Video Tutorials

1 Charts and Graphs - Video Tutorial

I encourage you to carry out the steps in the lectures while following the notes and pausing the video as needed.

Note: If you were in the first course, this is a repeat of the lesson over charts and graphs. You need not repeat

the lesson.

1 Quick Review - MOV Format (Mac) - Right click here to download the MOV file
1 Quick Review - WMV Format (Windows) - Right click here to download the WMV file

2 Inserting a Scatter-Plot - MOV Format (Mac) - Right click here to download the MOV file
2 Inserting a Scatter-Plot - WMV Format (Windows) - Right click here to download the WMV file

3 Labeling and Switching Data - MOV Format (Mac) - Right click here to download the MOV file
3 Labeling and Switching Data - WMV Format (Windows) - Right click here to download the WMV file

4 Formatting a Scatter-Plot - MOV Format (Mac) - Right click here to download the MOV file
4 Formatting a Scatter Plot - WMV Format (Windows) - Right click here to download the WMV file

5 Quick Review Number Two - MOV Format (Mac) - Right click here to download the MOV file
5 Quick Review Number Two - WMV Format (Windows) - Right click here to download the WMV file

6 Inserting a Pie Chart - MOV Format (Mac) - Right click here to download the MOV file
6 Inserting a Pie Chart - WMV Format (Windows) - Right click here to download the WMV file

7 Formatting a Pie Chart - MOV Format (Mac) - Right click here to download the MOV file
7 Formatting a Pie Chart - WMV Format (Windows) - Right click here to download the WMV file

8 Inserting and Formatting Bar Graphs - MOV Format (Mac) - Right click here to download the MOV file
8 Inserting and Formatting Bar Graphs - WMV Format (Windows) - Right click here to download the WMV file

9 Line Graphs - MOV Format (Mac) - Right click here to download the MOV file
9 Line Graphs - WMV Format (Windows) - Right click here to download the WMV file

2 Sparklines, Filter, and Linking - Video Tutorials

I encourage you to carry out the steps in the lectures while following the notes and pausing the video as needed.

1 Insert Column and Sparklines - MOV Format (Mac) - Right click here to download the MOV file
1 Insert Column and Sparklines - WMV Format (Windows) - Right click here to download the WMV file

2 Formatting Sparklines - MOV Format (Mac) - Right click here to download the MOV file

2 Formatting Sparklines - WMV Format (Windows) - Right click here to download the WMV file

3 Filtering Data - MOV Format (Mac) - Right click here to download the MOV file
3 Filtering Data - WMV Format (Windows) - Right click here to download the WMV file

4 Inserting a Worksheet - MOV Format (Mac) - Right click here to download the MOV file
4 Inserting a Worksheet - WMV Format (Windows) - Right click here to download the WMV file