Microsoft Excel - express course - Excel mastery

The course "Mastery of Microsoft Excel" is designed for those who want to master effective methods of working with spreadsheets. During 6 classes of 2 astronomical hours of intensive training, you will gain practical skills that will allow you to automate routine tasks, create complex reports and analyze data using powerful Excel tools.

Target audience:

• Accountants and financiers

• Economists and analysts

• Managers and marketers

• Specialists working with large amounts of data

• Project managers

• Professionals looking to improve their data productivity

After the course, participants will be able to:

• Efficiently enter, edit, and format data in Excel
• Use complex formulas and functions to analyze data
• Create and manage tables in Excel
• Work with databases: sorting, filtering, grouping
• Consolidate data from different sheets and workbooks
• Build pivot tables and charts for dynamic data analysis
• Use keyboard shortcuts to speed up your work

Course program

Module 1: Data Fundamentals

• Data entry and editing
  • Autofill functions for different data types
  • Autocomplete lists
  • Cell content and format
  • Adding, deleting, moving, and copying items
  • Custom insert with dynamic preview
  • Keyboard shortcuts to speed up work
    
    
• Working with books
  • Quickly move through a book
  • Moving and copying sheets
  • Grouping and working with sheets
  • Move and copy sheets between files
  • View books and sheets simultaneously

Module 2: Formatting and Structuring Data

• Document preparation
  • Number formats — basic and custom
  • Date display formats for analysis
  • Format cells and ranges using styles
  • Copying formats
    
    
• The concept of a table in Excel
  • Converting ranges to Table objects
  • Built-in templates for designing Tables
  • Applying styles to tables
  • Convert Table to Range

Module 3: Formulas and Functions

• Basics of working with formulas
  • Entering and editing formulas
  • Reference operators and their precedence
  • Relative, absolute, and mixed references
  • Function Wizard
    
    
• Using functions
  • Mathematical and statistical functions
  • Date and time functions
  • Logical and Conditional Functions
  • Data lookup functions
  • Text functions
  • Nested functions
  • Eliminating errors in formulas

Module 4: Working with data and tables

• Databases and tables
  • Fast data entry
  • Data validation and drop-down lists
  • Sorting and filtering data
  • Calculations on filtered data
  • Features of writing formulas in tables
  • Interim results and structural criteria
  • Copying filtered and structured data
    
    
• Combining and organizing data
  • Three-dimensional references
  • Data Consolidation Tool
  • Removing duplic