MS Excel has become an essential element in the work of many business establishments and individual users as it considerably facilitates and accelerates the working process. Despite widespread perception, the scope of its possibilities is not limited to finance and accounting activities but also includes data organization, programming graphing and many more. In this respect, the American Chamber of Commerce in Ukraine held free Chamber Friday University Course "Excel Basics". Session 3 to master participants' level of competence with Excel.
October 16, Module 3:
Topic 5. Creation of "smart" tables. Named Tables
- Filling the table
- Structuring tables
- Creating subtotals and totals
- Drop-down list
- Visualization using sparklines, mini-diagrams and icons
- Conditional formatting in a table
Topic 6. Pivot tables. Bulk data analytics and verification
- Create pivot tables
- Setting up pivot table fields
- Calculated fields
- Grouping in pivot tables
- Creating pivot tables based on data from several sources
- Prediction and seasonality
Speaker:
Oleksandr Kruglyakovsky
Founder and curator, ProExcel. Earlier Oleksandr was Senior PM at the department of operational processes in Eastern Europe at 4service company and managing director at EMPO company where he was engaged in the analysis of key performance indicators of companies to increase profitability.
Upcoming Session:
- Topic 7. Work with charts. Simple visualization
