Course Overview

Let’s check your update today

Mastering Excel: From Basics to Advanced Formulas

AJOY Sarker

Microsoft

Welcome to "Mastering Excel: From Basics to Advanced Formulas"! This course is your passport to unlocking the full potential of Microsoft Excel, whether you're a beginner taking your first steps or an experienced user aiming to sharpen your skills.

What You'll Learn:

  • Excel Essentials: Navigate the interface, master basic functions, and manage data efficiently.
  • Intermediate Skills: Create dynamic charts, apply advanced formatting, and validate data.
  • Advanced Formulae: Dive into powerful tools like VLOOKUP, INDEX-MATCH, SUMIFS, for advanced
  • Data Analysis Techniques: Explore pivot tables, sorting, filtering, and formatting for insights.
  • Optimization: Discover shortcuts and automation to streamline your workflow.

Why Take This Course:

  • Practical Application: Gain hands-on experience applicable across industries.
  • Career Advancement: Boost your employability with sought-after Excel skills.
  • Flexibility: Study at your own pace, anytime, anywhere.
  • Expert Guidance: Learn from seasoned Excel professionals dedicated to your success.

Who Should Enroll:

  • Beginners and intermediate users seeking to excel in Excel.
  • Professionals aiming to enhance productivity and data analysis.

Course Content

Lecture (15) Total (10:3 Hrs)

1.Intro

1 video | 20 min

  • Getting started lessons

    1 video | 20 min

  • Overview about basic tools

    1 video | 20 min

  • Overview about basic tools

    1 video | 20 min

2. Introductions

1 video | 20 min

3. Understanding Art

1 video | 20 min

4. Using Colors & Graphic

1 video | 20 min

5. Creating Text Style

1 video | 20 min