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 2 to master participants' level of competence with Excel.
October 9, Module 2:
Topic 3. Building a Dashboard. Calculations in Microsoft Excel
- Functions for processing logical operations (AND, OR, IF, IFERROR)
- AutoSum (SUM, AVERAGE, ACCOUNT, MIN, MAX)
- Summation functions according to one or several criteria (SUMMES, SUMMESlim)
- Data binding. Creating User Dictionaries
- Creating indirect links
Topic 4. Work with large tables. Organizing and summarizing data
- Subtotal tool
- Grouping and structure. Grouping by columns and rows. Work with control buttons. Multilevel grouping of information
- Data consolidation - combining data from several tables into one
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 Sessions:
- Topic 5. Creation of "smart" tables. Named Tables
- Topic 6. Pivot tables. Bulk data analytics and verification
- Topic 7. Work with charts. Simple visualization
