Program of new courses in Microsoft Excel
Course 1: Introduction to Microsoft Excel
Basics of working in Excel: Introduction to the interface, basic functions and capabilities.
Data entry and formatting: Basic operations with cells, rows, columns.
Working with formulas and functions: Basic mathematical, logical and text functions.
Creating simple tables and graphs: Constructing and formatting tables and charts.
Basics of data sorting and filtering: Methods for organizing and filtering information.
Course 2: Advanced Excel
Complex functions and formulas: Working with functions VLOOKUP, HLOOKUP, INDEX, MATCH.
Conditional Formatting: Apply conditional formatting rules.
Pivot tables: Create and customize pivot tables for data analysis.
Working with big data: Optimizing work with large volumes of data.
Data protection: Methods for protecting and encrypting data in Excel.
Course 3: Data Analysis in Excel
Data Import and Export: Methods for importing data from various sources and exporting data from Excel.
Data analysis functions: Using the functions SUMIFS, COUNTIFS, AVERAGEIFS.
Scripts and Data Tables: Create scripts and use data tables for what-if analysis.
Regression analysis: Conducting regression analysis.
Data visualization: Creation of interactive dashboards and reports.
Course 4: Financial Analysis in Excel
Financial functions: Using the functions PV, FV, NPV, IRR.
Budgeting: Creation and analysis of budget tables.
Sensitivity Analysis: Sensitivity Analysis Methods.
Evaluation of investment projects: Project evaluation methods such as DCF and NPV analysis.
Financial Modeling: Creating financial models for forecasting and analysis.
Course 5: Project Management with Excel
Project Planning: Create project schedules and plans.
Resource Management: Managing resources and costs in projects.
Progress Tracking: Techniques for keeping track of project tasks and deadlines.
Project Reports: Generate project status reports and variance analysis.
Using Gantt charts: Creating and using Gantt charts for project management.
Course 6: Advanced Excel Tools
Power Query: Import and transform data using Power Query.
Power Pivot: Analyze big data using Power Pivot.
Power BI integration: Integrate Excel with Power BI to create powerful dashboards.
Data Modeling: Creating complex data models and analyzing them.
Report Automation: Create automated reports using macros and VBA.