Магистратура
2021/2022
Набор инструментов (Excel, PPT)
Статус:
Курс по выбору (Международный менеджмент / Master in International Management)
Направление:
38.04.02. Менеджмент
Кто читает:
Департамент бизнес-информатики
Где читается:
Высшая школа бизнеса
Когда читается:
2-й курс, 2 модуль
Формат изучения:
с онлайн-курсом
Охват аудитории:
для своего кампуса
Преподаватели:
Кузнецова Юлия Александровна
Прогр. обучения:
Международный менеджмент
Язык:
английский
Кредиты:
4
Контактные часы:
2
Course Syllabus
Abstract
Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In this course (https://www.coursera.org/learn/excel-intermediate-1) you are going to discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel. In this course, you will build a solid layer of more advanced skills so you can manage large datasets and create meaningful reports. These key techniques and tools will allow you to add a sophisticated layer of automation and efficiency to your everyday tasks in Excel.
Learning Objectives
- The aim of the course is to give advanced skills to manage large datasets and create meaningful reports in Excel.
Expected Learning Outcomes
- Student can combine data, manage datasets and perform calculations across multiple sources.
- Student can create and modify pivot tables to solve a variety of business problems.
- Student can create, format, manage, sort and filter tables.
- Student can create, manage and apply Named Ranges.
- Student can extract information and manipulate data to fulfil specific business requirements.
- Student can use functions to extract information from data and generate graphical representations of it.
Course Contents
- Working with Multiple Worksheets & Workbooks
- Text and Date Functions
- Named Ranges
- Summarising Data
- Tables
- Pivot Tables, Charts and Slicers
Bibliography
Recommended Core Bibliography
- Held, B., Moriarty, B., & Richardson, T. (2019). Microsoft Excel Functions and Formulas (Vol. Fifth edition). Dulles, Virginia: Mercury Learning & Information. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=2051937
- SARTAIN, J. D. (2019). How to create, filter, and format tables in Excel. PCWorld, 37(5), 109.
Recommended Additional Bibliography
- Fraser C. Business statistics for competitive advantage with Excel 2016: basics, model building, simulation and cases. New York, NY: Springer Science+Business Media, 2016. 475 с.
- Slager, D. (2016). Essential Excel 2016 : A Step-by-Step Guide. [Berkeley]: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1361984
- Walkenbach, J. (2016). Excel 2016 Bible. Indianapolis, IN: Wiley. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1079681