Microsoft Excel Intermediate: Next-Level Skills

Categories: Microsoft Excel
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Elevate your Excel expertise with “Excel Intermediate: Next-Level Skills.” This course is designed for users who have a basic understanding of Excel and are ready to deepen their knowledge and enhance their productivity with more advanced tools and techniques.

What Will You Learn?

  • Logical functions (IF, AND, OR).
  • Lookup functions (VLOOKUP, HLOOKUP, MATCH, INDEX).
  • Text functions (LEFT, RIGHT, MID, CONCATENATE).
  • Conditional formatting.
  • Using Tables for data management.
  • Introduction to PivotTables.
  • Creating and customizing more complex charts (Bar, Scatter, Combo).
  • Sparklines.
  • Using slicers with charts and PivotTables.
  • Advanced sorting and filtering.
  • Data validation with custom rules.
  • Removing duplicates.
  • Sharing and protecting workbooks.
  • Track changes and comments.
  • Merging and comparing workbooks.
  • Grouping and outlining data.
  • Using the Watch Window.
  • Hyperlinks and external references.
  • Recording simple macros.
  • Assigning macros to buttons.
  • Basic introduction to VBA.

Course Content

Advanced Formulas and Functions

  • Logical functions (IF, AND, OR)
  • Lookup functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
  • Text functions (LEFT, RIGHT, MID, CONCATENATE)

Data Analysis Tools

Advanced Data Visualization

Data Management and Validation

Collaboration Features

Advanced Worksheet Management

Introduction to Macros

Student Ratings & Reviews

No Review Yet
No Review Yet