Data Analysis in MS ...

Global search
Log in

Section outline

Select section Data Analysis in MS Excel

Collapse Expand
Data Analysis in MS Excel

Collapse all Expand all
Professor: Vitezslav Novak
Email: vitezslav.novak@vsb.cz
- Select activity Welcome to the course Data Analysis in MS Excel
  
  Welcome to the course Data Analysis in MS Excel File
  
  Students must
  
  Mark as done
- Select activity Presentation of Students
  
  Presentation of Students URL
  
  Students must
  
  Mark as done
- Select activity Course Information
  
  Course Information File
  
  Students must
  
  Mark as done
- Select activity Entrance Test of Basic Knowledge of Excel
  
  Entrance Test of Basic Knowledge of Excel Quiz
  
  Students must
  
  Mark as done
- Select activity --------------------------------------------------...
  
  Students must
  
  Mark as done
  
  -------------------------------------------------------------
- Select activity News Forum / Questions
  
  News Forum / Questions
  
  Students must
  
  Mark as done
- Select activity Announcements
  
  Announcements Forum
Select section Week 1

Collapse Expand
Week 1
Data Analysis in MS Excel - Introduction
- Select activity Content of the Week
  
  Content of the Week Page
  
  Students must
  
  Mark as done
- Select activity Data Analysis in MS Excel - Introduction
  
  Data Analysis in MS Excel - Introduction File
  
  Students must
  
  Mark as done
Select section Week 2

Collapse Expand
Week 2
Data Analysis Using Lists - Sorting and Filtering
- Select activity Content of the Week
  
  Content of the Week Page
  
  Students must
  
  Mark as done
- Select activity Data Analysis Using Lists - Sorting and Filtering
  
  Data Analysis Using Lists - Sorting and Filtering File
  
  Students must
  
  Mark as done
- Select activity --------------------------------------------------...
  
  Students must
  
  Mark as done
  
  -------------------------------------------------------------
- Select activity Exercises
  
  Exercises File
  
  Students must
  
  Mark as done
- Select activity Exercise Workbook
  
  Exercise Workbook File
  
  Students must
  
  Mark as done
- Select activity Insert the Completed Exercises Here
  
  Insert the Completed Exercises Here Assignment
  
  Opened: Tuesday, 24 January 2023, 11:00 PM
  
  Due: Tuesday, 31 January 2023, 11:00 PM
  
  Students must
  
  Mark as done
Select section Week 3

Collapse Expand
Week 3
Data Analysis Using Formulas - Statistical Functions
- Select activity Content of the Week
  
  Content of the Week Page
  
  Students must
  
  Mark as done
- Select activity Data Analysis Using Formulas - Statistical Functions
  
  Data Analysis Using Formulas - Statistical Functions File
  
  Students must
  
  Mark as done
- Select activity --------------------------------------------------...
  
  Students must
  
  Mark as done
  
  -------------------------------------------------------------
- Select activity Exercises
  
  Exercises File
  
  Students must
  
  Mark as done
- Select activity Exercise Workbook
  
  Exercise Workbook File
  
  Students must
  
  Mark as done
- Select activity Insert the Completed Exercises Here
  
  Insert the Completed Exercises Here Assignment
  
  Opened: Tuesday, 24 January 2023, 11:00 PM
  
  Due: Tuesday, 31 January 2023, 11:00 PM
  
  Students must
  
  Mark as done
Select section Week 4

Collapse Expand
Week 4
Data Analysis Using Formulas - Relative and Absolute Addressing
- Select activity Content of the Week
  
  Content of the Week Page
  
  Students must
  
  Mark as done
- Select activity Data Analysis Using Formulas - Relative and Absolute Addressing
  
  Data Analysis Using Formulas - Relative and Absolute Addressing File
  
  Students must
  
  Mark as done
- Select activity --------------------------------------------------...
  
  Students must
  
  Mark as done
  
  -------------------------------------------------------------
- Select activity Exercises
  
  Exercises File
  
  Students must
  
  Mark as done
- Select activity Exercise Workbook
  
  Exercise Workbook File
  
  Students must
  
  Mark as done
- Select activity Insert the Completed Exercises Here
  
  Insert the Completed Exercises Here Assignment
  
  Opened: Tuesday, 24 January 2023, 11:00 PM
  
  Due: Tuesday, 31 January 2023, 11:00 PM
  
  Students must
  
  Mark as done
Select section Week 5

Collapse Expand
Week 5
Data Analysis Using Formulas - Array Formulas
- Select activity Content of the Week
  
  Content of the Week Page
  
  Students must
  
  Mark as done
- Select activity Data Analysis Using Formulas - Array Formulas
  
  Data Analysis Using Formulas - Array Formulas File
  
  Students must
  
  Mark as done
- Select activity --------------------------------------------------...
  
  Students must
  
  Mark as done
  
  -------------------------------------------------------------
- Select activity Exercises
  
  Exercises File
  
  Students must
  
  Mark as done
- Select activity Exercise Workbook
  
  Exercise Workbook File
  
  Students must
  
  Mark as done
- Select activity Insert the Completed Exercises Here
  
  Insert the Completed Exercises Here Assignment
  
  Opened: Tuesday, 24 January 2023, 11:00 PM
  
  Due: Tuesday, 31 January 2023, 11:00 PM
  
  Students must
  
  Mark as done
Select section Week 6

Collapse Expand
Week 6
Data Analysis Using Formulas - Using Defined Names
- Select activity Content of the Week
  
  Content of the Week Page
  
  Students must
  
  Mark as done
- Select activity Data Analysis Using Formulas - Using Defined Names
  
  Data Analysis Using Formulas - Using Defined Names File
  
  Students must
  
  Mark as done
- Select activity --------------------------------------------------...
  
  Students must
  
  Mark as done
  
  -------------------------------------------------------------
- Select activity Exercises
  
  Exercises File
  
  Students must
  
  Mark as done
- Select activity Exercise Workbook
  
  Exercise Workbook File
  
  Students must
  
  Mark as done
- Select activity Insert the Completed Exercises Here
  
  Insert the Completed Exercises Here Assignment
  
  Opened: Tuesday, 24 January 2023, 11:00 PM
  
  Due: Tuesday, 31 January 2023, 11:00 PM
  
  Students must
  
  Mark as done
Select section Week 7

Collapse Expand
Week 7
Data Analysis Using Structured Tables
- Select activity Content of the Week
  
  Content of the Week Page
  
  Students must
  
  Mark as done
- Select activity Data Analysis Using Structured Tables
  
  Data Analysis Using Structured Tables File
  
  Students must
  
  Mark as done
- Select activity --------------------------------------------------...
  
  Students must
  
  Mark as done
  
  -------------------------------------------------------------
- Select activity Exercises
  
  Exercises File
  
  Students must
  
  Mark as done
- Select activity Exercise Workbook
  
  Exercise Workbook File
  
  Students must
  
  Mark as done
- Select activity Insert the Completed Exercises Here
  
  Insert the Completed Exercises Here Assignment
  
  Opened: Tuesday, 24 January 2023, 11:00 PM
  
  Due: Tuesday, 31 January 2023, 11:00 PM
  
  Students must
  
  Mark as done
Select section Week 8

Collapse Expand
Week 8
Data Analysis Using Pivot Tables - Introduction to Pivot Tables
- Select activity Content of the Week
  
  Content of the Week Page
  
  Students must
  
  Mark as done
- Select activity Data Analysis Using Pivot Tables - Introduction to Pivot Tables
  
  Data Analysis Using Pivot Tables - Introduction to Pivot Tables File
  
  Students must
  
  Mark as done
- Select activity --------------------------------------------------...
  
  Students must
  
  Mark as done
  
  -------------------------------------------------------------
- Select activity Exercises
  
  Exercises File
  
  Students must
  
  Mark as done
- Select activity Exercise Workbook
  
  Exercise Workbook File
  
  Students must
  
  Mark as done
- Select activity Insert the Completed Exercises Here
  
  Insert the Completed Exercises Here Assignment
  
  Opened: Tuesday, 24 January 2023, 11:00 PM
  
  Due: Tuesday, 31 January 2023, 11:00 PM
  
  Students must
  
  Mark as done
Select section Week 9

Collapse Expand
Week 9
Data Analysis Using Pivot Tables - Calculations
- Select activity Content of the Week
  
  Content of the Week Page
  
  Students must
  
  Mark as done
- Select activity Data Analysis Using Pivot Tables - Calculations
  
  Data Analysis Using Pivot Tables - Calculations File
  
  Students must
  
  Mark as done
- Select activity --------------------------------------------------...
  
  Students must
  
  Mark as done
  
  -------------------------------------------------------------
- Select activity Exercises
  
  Exercises File
  
  Students must
  
  Mark as done
- Select activity Exercise Workbook
  
  Exercise Workbook File
  
  Students must
  
  Mark as done
- Select activity Insert the Completed Exercises Here
  
  Insert the Completed Exercises Here Assignment
  
  Opened: Tuesday, 24 January 2023, 11:00 PM
  
  Due: Tuesday, 31 January 2023, 11:00 PM
  
  Students must
  
  Mark as done
Select section Week 10

Collapse Expand
Week 10
Data Analysis Using Pivot Tables - Sorting and Filtering
- Select activity Content of the Week
  
  Content of the Week Page
  
  Students must
  
  Mark as done
- Select activity Data Analysis Using Pivot Tables - Sorting and Filtering
  
  Data Analysis Using Pivot Tables - Sorting and Filtering File
  
  Students must
  
  Mark as done
- Select activity --------------------------------------------------...
  
  Students must
  
  Mark as done
  
  -------------------------------------------------------------
- Select activity Exercises
  
  Exercises File
  
  Students must
  
  Mark as done
- Select activity Exercise Workbook
  
  Exercise Workbook File
  
  Students must
  
  Mark as done
- Select activity Insert the Completed Exercises Here
  
  Insert the Completed Exercises Here Assignment
  
  Opened: Tuesday, 24 January 2023, 11:00 PM
  
  Due: Tuesday, 31 January 2023, 11:00 PM
  
  Students must
  
  Mark as done
Select section Week 11

Collapse Expand
Week 11
Data Analysis Using Pivot Tables - Grouping
- Select activity Content of the Week
  
  Content of the Week Page
  
  Students must
  
  Mark as done
- Select activity Data Analysis Using Pivot Tables - Grouping
  
  Data Analysis Using Pivot Tables - Grouping File
  
  Students must
  
  Mark as done
- Select activity --------------------------------------------------...
  
  Students must
  
  Mark as done
  
  -------------------------------------------------------------
- Select activity Exercises
  
  Exercises File
  
  Students must
  
  Mark as done
- Select activity Exercise Workbook
  
  Exercise Workbook File
  
  Students must
  
  Mark as done
- Select activity Insert the Completed Exercises Here
  
  Insert the Completed Exercises Here Assignment
  
  Opened: Tuesday, 24 January 2023, 11:00 PM
  
  Due: Tuesday, 31 January 2023, 11:00 PM
  
  Students must
  
  Mark as done
Select section Week 12

Collapse Expand
Week 12
Data Analysis Using Power Pivot
- Select activity Content of the Week
  
  Content of the Week Page
  
  Students must
  
  Mark as done
- Select activity Data Analysis Using Power Pivot
  
  Data Analysis Using Power Pivot File
  
  Students must
  
  Mark as done
- Select activity --------------------------------------------------...
  
  Students must
  
  Mark as done
  
  -------------------------------------------------------------
- Select activity Exercises
  
  Exercises File
  
  Students must
  
  Mark as done
- Select activity Exercise Workbook
  
  Exercise Workbook File
  
  Students must
  
  Mark as done
- Select activity Insert the Completed Exercises Here
  
  Insert the Completed Exercises Here Assignment
  
  Opened: Tuesday, 24 January 2023, 11:00 PM
  
  Due: Tuesday, 31 January 2023, 11:00 PM
  
  Students must
  
  Mark as done
Select section Week 13

Collapse Expand
Week 13
Data Analysis in MS Excel - Conclusion
- Select activity Content of the Week
  
  Content of the Week Page
  
  Students must
  
  Mark as done
- Select activity Repetition Exercises
  
  Repetition Exercises File
  
  Students must
  
  Mark as done
- Select activity History of Olympic Games (Data for Repetition Exercise 2)
  
  History of Olympic Games (Data for Repetition Exercise 2) File
  
  Students must
  
  Mark as done
Select section Week 14

Collapse Expand
Week 14
Test
- Select activity Add the Completed Test Here
  
  Add the Completed Test Here Assignment
  
  Opened: Tuesday, 3 January 2023, 11:00 PM
  
  Due: Tuesday, 10 January 2023, 11:00 PM
  
  Students must
  
  Mark as done