Intermediate
Excel lms

Excel Intermediate

Andries Andries
Overview
Curriculum
  • 11 Sections
  • 44 Lessons
  • 8h Duration
Collapse All
Section 1 - Excel Intermediate Introduction
2 Lessons
  1. Excel Intermediate Introduction
  2. Intermediate Shortcut Keys
Section 2 - Lists
6 Lessons
  1. What are Lists
  2. Sorting a List
  3. Sorting - Multiple Criteria
  4. Custom Sort
  5. What are Filters
  6. Format a List as a Table
Section 3 - DataBase Functions
7 Lessons
  1. Introduction to DataBase Functions
  2. DSum Function
  3. DSum - Single Criteria
  4. DSum - Multiple Criteria
  5. DAverage
  6. DCount
  7. Subtotal
Section 4 - Data Validation
3 Lessons
  1. Data Validation - List
  2. Data Validation - Decimal
  3. Input and Error Messages
Section 5 - Importing and Exporting
3 Lessons
  1. Importing Data from Text Files
  2. Importing Data from MS Access
  3. Exporting Data to a Text File
Section 6 - Creating Basic Charts
4 Lessons
  1. Creating a Column Chart
  2. The Chart Ribbon
  3. Adding and Modifying Data on a Chart
  4. Formatting Charts
Section 7 - Pivot Tables
9 Lessons
  1. Understanding Pivot Tables
  2. Creating Pivot Tables
  3. Pivot Table Calculations
  4. Grouping Pivot Table Data
  5. Formatting Pivot Table Data
  6. Drilling Down into Pivot Table Data
  7. Creating Pivot Charts
  8. Filtering Pivot Table Data
  9. Filtering using the Slicer
Section 8 - Working with Large Data
2 Lessons
  1. Grouping Data
  2. Consolidating Data
Section 9 - LookUp Functions
3 Lessons
  1. VLookUp
  2. HLookUp
  3. Index and Match
Section 10 - Additional Functions
4 Lessons
  1. FV Function
  2. PMT Function
  3. Hyperlinks
  4. Text to Columns
Section 11 - Conclusion
1 Lesson
  1. Excel Intermediate – Course Conclusion

Excel Intermediate is the next step in mastering Microsoft Excel beyond the basics. This course is designed to build upon your foundational knowledge of Excel and introduce you to more advanced features and functions. You'll learn how to work with large datasets more efficiently, perform complex calculations using formulas and functions, create dynamic charts and graphs, and automate repetitive tasks with macros and VBA. By the end of this course, you'll be equipped with the skills needed to tackle more complex data analysis and reporting tasks with confidence. Excel Intermediate is perfect for anyone looking to take their Excel skills to the next level and enhance their productivity in both personal and professional settings.

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Related Courses

Expert
Excel lms

Excel VBA

Andries Andries

  • Automate repetitive tasks

    • Enhance Excel functionality

    Increase productivity

    16h
    53
    Advanced
    Excel lms

    Excel Advanced

    Andries Andries

  • Advanced data analysis techniques

    • Solver for optimization problems

    What-If Scenarios for exploring possibilities

    8h
    34
    Intermediate
    Excel lms

    Excel Beginner

    Andries Andries

    User-Friendly Interface

  • Basic Formulas and Functions

    • Data Organization

    8h
    44
    Scroll to Top