Excel Course : Beginner to Advanced

Categories: Finance
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Microsoft Excel stands as a cornerstone in various industries, playing a crucial role in every business operation. This foundational course aims to furnish you with expertise in data modeling, analysis, leveraging advanced Excel formulas for enhanced data analytics, and a multitude of other essential skills.

What Will You Learn?

  • Foundational Skills: Starting with data entry, formatting, and basic formulas.
  • Intermediate Techniques: Progressing to conditional formatting, sorting, and filtering for effective data organization.
  • Advanced Functions: Mastering VLOOKUP, HLOOKUP, INDEX, and MATCH for precise data retrieval and manipulation.
  • PivotTables Mastery: Delving into the intricacies of PivotTables to summarize and analyze complex datasets effectively.
  • Actionable Insights: Developing the ability to derive insights and make informed decisions, driving business growth.
  • Efficiency Boosters: Learning Excel shortcuts and advanced strategies to work faster and smarter across the Microsoft Office suite.

Course Content

Basics

  • Getting Started with Excel
    22:16
  • Data Entry, Data Editing, and Number Formatting
    21:02
  • Data Formatting
    25:01
  • Working with Cells and Ranges in Excel -1
    15:05
  • Working with Cells and Ranges in Excel – 2
    15:30
  • Managing Worksheets
    16:45

Intermediate

Advanced

Bonus Files

Shopping Cart