Course information:

We will teach you to work with data from a bigger perspective and look at it in a more systemic way. We will deepen your knowledge of working with contingency tables and graphs. Of interest will be iterative recalculations using cyclical links.

Content:

• Selected features for data cleaning
• Selected text functions
• Creating named areas
• Working with dynamic links to different areas
• Selected mathematical functions
• Selected search functions
• Merging data from multiple sheets
• Import data from external sources
• Advanced work with graphs
• Tables
• Data grouping
• Data tabulation
• Advanced work with contingency tables
• Mini graphs
• Using cyclic links for iterative recalculations
• Selection of useful aids