Навыки использования Excel для бизнеса

Бакалавриат 2021/2022

Статус: Курс по выбору (Востоковедение)

Направление: 58.03.01. Востоковедение и африканистика

Кто читает: Школа востоковедения

Где читается: Факультет мировой экономики и мировой политики

Когда читается: 2-й курс, 1 модуль

Формат изучения: с онлайн-курсом

Охват аудитории: для всех

Преподаватели: Бутурлин Илья Сергеевич

Язык: английский

Кредиты: 4

Контактные часы: 4

Full Syllabus

Abstract

The purpose of mastering the discipline "Excel Skills for business: basics" is to master the basic concepts of specialization Excel Skills for Business, learning the basics of Microsoft Excel. Ability to competently navigate the Excel user interface, perform basic calculations using formulas and functions, professionally format spreadsheets and create data visualizations using charts and graphs.

Learning Objectives

master the skills of working with: diagrams, Microsoft Excel and sorts
learn to use this software confidently
understand the fundamental functions of Excel: the user interface of Excel, the basic terminology of Excel

Expected Learning Outcomes

Creates and edits charts in Excel.
Extracts and modifies data with search and replace, uses conditional formatting to highlight specific data
Gets the skill of working with formulas and functions - learns how to write them, use them to perform calculations
Optimises a spreadsheet for printing by managing margins, orientation, headers and footers, and more.
Seize the basic foundational functions of Excel: the Excel user interface, the basic terminology of Excel.
Uses font formatting, borders, alignment, number formatting, and Excel styles and themes

Course Contents

Introduction
Theme 1. Critical core Excel
Theme 2. Performance of calculation.
Theme 3. Formatting
Theme 4. Work with data
Theme 5. Print
Theme 6. Graphics
final lesson

Assessment Elements

Test after the 1st week (10 minutes). Theme 1. Critical core Excel
Test after the 2nd week (10 minutes). Theme 2. Performance of calculation
Test after the 3rd week (10 minutes). Theme 3. Formatting
Test after the 4th week (10 minutes). Theme 4. Work with data
Test after the 5th week (10 minutes). Theme 5. Print
Test after the 1st week (10 minutes). Theme 6. Graphics

Interim Assessment

2021/2022 1st module
0.165 * Test after the 4th week (10 minutes). Theme 4. Work with data + 0.165 * Test after the 3rd week (10 minutes). Theme 3. Formatting + 0.165 * Test after the 1st week (10 minutes). Theme 6. Graphics + 0.17 * Test after the 2nd week (10 minutes). Theme 2. Performance of calculation + 0.17 * Test after the 1st week (10 minutes). Theme 1. Critical core Excel + 0.165 * Test after the 5th week (10 minutes). Theme 5. Print

Course Syllabus