📊 Advanced video course "MS Excel 2013" - 53 lessons
Content: MS Excel 2013.txt (688 B)
Uploaded: 02.08.2026
Positive responses: 0
Negative responses: 0
Sold: 0
Refunds: 0
~ $23.54
The exact amount is on the payment page
🚀 **Want to transform Excel from a simple spreadsheet into a powerful tool for analytics, automation, and data visualization?**
Most office workers have a basic knowledge of Excel. But when it comes to complex formulas, conditional formatting, data protection, and creating professional charts, many remain at the "sum a column" level.
This advanced 53-lesson course will take you to the level of confident user who can automate routine tasks, analyze large volumes of data, and create reports that will impress management and clients.
**What´s inside the course (53 lessons in 6 units):**
🎨 **Unit 1: Design and Visualization (Lessons 3, 10-16)**
• Using themes and table formatting
• Working with graphic objects: SmartArt, shapes, grouping
• Integrating images and objects with mathematical calculations
📈 **Unit 2: Charts and Graphs (Lessons 17-24)**
• Creating charts using two methods and recommended types
• Formatting elements, changing types, trendlines
• Pie charts and sparklines (mini-charts in cells)
🔒 **Unit 3: Data Protection (Lessons 7-9)**
• Protecting data in a sheet and partially protecting it
• Password-protecting the entire workbook - maintaining confidentiality
📋 **Unit 4: Working with Data (Lessons 25-32)**
• Freezing Rows and Columns (for Viewing and Printing)
• Sorting, Filtering, Removing Duplicates
• Subtotals and the Text to Columns tool
• Retrieving Data from Web Pages - Importing External Information
🧮 **Module 5: Functions and Formulas (Lessons 33-47)**
• The IF Function and Its Nested Constructions
• Error Handling: IFERROR
• Logical Operators: AND, OR, NOT in Combination with IF
• Functions for Working with Text, Dates, and Numbers
• Conditional Calculations: COUNTIF, AVERAGEIF, SUMIF
• Rank Detection and Hidden Functions
✨ **Module 6: Conditional Formatting and Automation (Lessons 48-53)**
• Flash Fill - Smart Input Automation
• Conditional Formatting of Cells Based on Contents
• Color indicators, icons, rules for leading/lower values
• Creating and managing formatting rules from scratch
**Who is this course for?**
💼 Finance professionals, accountants, and economists working with large spreadsheets and reports.
📊 Data analysts who need advanced tools for processing information.
🎓 Students in economics and engineering fields mastering Excel for their studies and careers.
👔 Managers and executives who want to automate routine tasks and create visual reports.
🚀 Entrepreneurs who manage their own accounting and analytics.
💡 Anyone who wants to move from a basic level to confident mastery of Excel.
What benefits will you get:**
✓ **Complete Coverage:** 53 lessons cover all the advanced features of Excel 2013.
✓ **Structured:** The material is divided into 6 logical sections—learn sequentially or select topics as needed.
✓ **Practical Focus:** Each lesson teaches a specific skill applicable to real-world work.
✓ **Automate Routine:** Learn to delegate tasks to Excel that used to take hours.
✓ **Professional Visualization:** Create impressive reports and charts.
✓ **Data Protection:** Master privacy and access control techniques.
✓ **Instant Access:** Download all 53 video lessons immediately after payment. ✓ **Lifetime Use:** Return to the lessons as a reference when working on real-world problems.
**Technical Details:**
— File format: MP4 (compatible with any video player).
— Number of lessons: 53 full-length video lessons.
— Structure: 6 thematic units with sequential study.
— Language: Russian.
— Level: Advanced (basic knowledge of Excel required).
— Compatibility: Microsoft Excel 2013 (most features work in newer versions).
— : Instant digital download link after payment.
— License: For personal and commercial use.
⚠️ **Important Note:** This course is designed for MS Excel.
Most office workers have a basic knowledge of Excel. But when it comes to complex formulas, conditional formatting, data protection, and creating professional charts, many remain at the "sum a column" level.
This advanced 53-lesson course will take you to the level of confident user who can automate routine tasks, analyze large volumes of data, and create reports that will impress management and clients.
**What´s inside the course (53 lessons in 6 units):**
🎨 **Unit 1: Design and Visualization (Lessons 3, 10-16)**
• Using themes and table formatting
• Working with graphic objects: SmartArt, shapes, grouping
• Integrating images and objects with mathematical calculations
📈 **Unit 2: Charts and Graphs (Lessons 17-24)**
• Creating charts using two methods and recommended types
• Formatting elements, changing types, trendlines
• Pie charts and sparklines (mini-charts in cells)
🔒 **Unit 3: Data Protection (Lessons 7-9)**
• Protecting data in a sheet and partially protecting it
• Password-protecting the entire workbook - maintaining confidentiality
📋 **Unit 4: Working with Data (Lessons 25-32)**
• Freezing Rows and Columns (for Viewing and Printing)
• Sorting, Filtering, Removing Duplicates
• Subtotals and the Text to Columns tool
• Retrieving Data from Web Pages - Importing External Information
🧮 **Module 5: Functions and Formulas (Lessons 33-47)**
• The IF Function and Its Nested Constructions
• Error Handling: IFERROR
• Logical Operators: AND, OR, NOT in Combination with IF
• Functions for Working with Text, Dates, and Numbers
• Conditional Calculations: COUNTIF, AVERAGEIF, SUMIF
• Rank Detection and Hidden Functions
✨ **Module 6: Conditional Formatting and Automation (Lessons 48-53)**
• Flash Fill - Smart Input Automation
• Conditional Formatting of Cells Based on Contents
• Color indicators, icons, rules for leading/lower values
• Creating and managing formatting rules from scratch
**Who is this course for?**
💼 Finance professionals, accountants, and economists working with large spreadsheets and reports.
📊 Data analysts who need advanced tools for processing information.
🎓 Students in economics and engineering fields mastering Excel for their studies and careers.
👔 Managers and executives who want to automate routine tasks and create visual reports.
🚀 Entrepreneurs who manage their own accounting and analytics.
💡 Anyone who wants to move from a basic level to confident mastery of Excel.
What benefits will you get:**
✓ **Complete Coverage:** 53 lessons cover all the advanced features of Excel 2013.
✓ **Structured:** The material is divided into 6 logical sections—learn sequentially or select topics as needed.
✓ **Practical Focus:** Each lesson teaches a specific skill applicable to real-world work.
✓ **Automate Routine:** Learn to delegate tasks to Excel that used to take hours.
✓ **Professional Visualization:** Create impressive reports and charts.
✓ **Data Protection:** Master privacy and access control techniques.
✓ **Instant Access:** Download all 53 video lessons immediately after payment. ✓ **Lifetime Use:** Return to the lessons as a reference when working on real-world problems.
**Technical Details:**
— File format: MP4 (compatible with any video player).
— Number of lessons: 53 full-length video lessons.
— Structure: 6 thematic units with sequential study.
— Language: Russian.
— Level: Advanced (basic knowledge of Excel required).
— Compatibility: Microsoft Excel 2013 (most features work in newer versions).
— : Instant digital download link after payment.
— License: For personal and commercial use.
⚠️ **Important Note:** This course is designed for MS Excel.
No feedback yet