, a business plan for a virtual
company
Brief overview (main goals, tasks, desirable results etc.) and teamwork distribution
presented as MS Word document or a separate worksheet within project MS Excel
workbook (max. volume ~2 000 symbols with spaces)
• Main part which reflects each seminar subjects (MS Excel functions and tools). In the
main part students should apply MS Excel functions and tools to predefined goals and
tasks to reach any valuable results within the overall framework of the project (e.g.
hypothesis check, profit/loss balance, data visualization etc.). Main part should be
submitted as MS Excel workbook.
• Conclusions that reflects project results presented as MS Word document or a separate
worksheet within project MS Excel workbook (max. volume ~1 000 symbols with
spaces)
You should use most of this topics:
Module 3:
Sem 1.xlsx (topic "Intro")
Sem 2.xlsx (topic "Math")
Sem 3.xlsx (topic "Charts")
Sem 4.xlsx (topic "Basic Lookups")
Sem 5.xlsx (topics "Advanced lookups and Advanced filtering and copy-pasting")
Sem 6.xlsx (topic "Finance")
Sem 7.xlsx (topics "What-if analysis and consolidation")
Sem 8.xlsx (topics "Date&Time, CHOOSE, OFFSET")
Big_HW_RS2021_solved_full.xlsx
Module 4:
Sem 9.xlsx (topic "Basic pivot tables")
Sem 10.xlsx (topic "Multiple pivot tables")
Sem 10 EXTRA.xlsx (topic "Pivot table summary")
Sem 11 (1).xlsx(topic "Pivot wizard and Power query")
Sem 11 (2).xlsx(topic "Getpivotdata")
Sem 11 (3).xlsx(topics "Formula Dependence" , "Information Functions" and "Forecasting")
Sem 12.xlsx (topic "Basic macro and VBA")