Loading ...

Course / Course Details

MS-Excel Advance

  • Sunil Kumar image

    By - Sunil Kumar

  • N/A
  • (0)

Course Requirements

  1. Basic Computer Knowledge:

    • Familiarity with using a computer, keyboard, and mouse.
    • Understanding of basic arithmetic operations.

  2. Software Needed:

    • Microsoft Excel (preferably 2016 or later versions).

  3. Hardware Requirements:

    • A computer/laptop with at least 2GB+ RAM and internet access for updates.

  4. No Prior Knowledge of MS-Excel Required:

    • This course is designed for beginners, with intermediate and advanced topics included

Course Description

The MS-Excel Course is designed to equip learners with essential spreadsheet skills for organizing, analyzing, and visualizing data. This course covers fundamental to advanced Excel features used in personal, academic, and professional settings.

Key areas include:

  1. Excel Basics:

    • Introduction to the Excel interface and navigation.
    • Creating, saving, and managing workbooks and worksheets.

  2. Data Entry and Formatting:

    • Entering and editing data in cells.
    • Applying formatting (fonts, borders, colors, and alignment).

  3. Formulas and Functions:

    • Understanding cell references (relative, absolute, mixed).
    • Using basic formulas (SUM, AVERAGE, MIN, MAX, etc.).
    • Introduction to logical functions (IF, AND, OR).

  4. Data Analysis Tools:

    • Sorting and filtering data.
    • Using conditional formatting to highlight key data.
    • Creating pivot tables and pivot charts.

  5. Charts and Graphs:

    • Creating bar charts, pie charts, line graphs, and more.
    • Customizing chart elements (titles, labels, legends).

  6. Advanced Excel Features:

    • Data validation and drop-down lists.
    • Introduction to VLOOKUP, HLOOKUP, and INDEX-MATCH.
    • Working with advanced functions like COUNTIF, SUMIF, and CONCATENATE.

  7. Macros and Automation:

    • Recording and running macros.
    • Introduction to VBA (Visual Basic for Applications).

  8. Collaboration and File Management:

    • Sharing workbooks for collaboration.
    • Protecting sheets and workbooks with passwords.
    • Exporting and importing data in various formats.

Course Outcomes

By the end of this course, students will:

  1. Be able to create, format, and manage Excel spreadsheets.
  2. Use formulas and functions for efficient data analysis.
  3. Visualize data effectively with charts and graphs.
  4. Analyze large datasets using pivot tables and conditional formatting.
  5. Automate repetitive tasks with macros.
  6. Create a project: A complete data analysis and visualization report using Excel.

Course Curriculum

  • 2 chapters
  • 11 lectures
  • 0 quizzes
  • N/A total length
Toggle all chapters
1 Microsoft Excel Introduction
7.07 Min

In this video, you’ll learn: ✔️ What is Microsoft Excel and its importance ✔️ Key features and functionalities of Excel ✔️ Understanding the Excel interface, rows, columns, and cells ✔️ Basic operations like data entry, formatting, and simple formulas ✔️ Tips to get started with Excel efficiently

2 Basic Formulas
9.38 Min

In this video, you’ll learn: ✔️ How to use the SUM function to add values quickly ✔️ Finding the highest and lowest values with MAX & MIN ✔️ Counting data efficiently using the COUNT function ✔️ Calculating the average of a dataset with AVERAGE ✔️ Practical examples and step-by-step explanations

3 If Formula
8.5 Min

In this video, you’ll discover: ✔️ How to use the basic IF function to evaluate conditions ✔️ Using IF AND to check multiple conditions at once ✔️ Using IF OR to evaluate alternative conditions ✔️ Practical example of checking student marks and results ✔️ Step-by-step guide for calculating pass/fail based on individual subject marks

4 If And If Or Formula
6.15 Min

In this video, you’ll learn: ✔️ How to use the IF AND formula for multiple conditions ✔️ How to apply the IF OR formula for alternative conditions ✔️ Real-life example: Evaluating employee attendance and department for promotion ✔️ Step-by-step guide to building powerful decision-making formulas in Excel

5 Nested If
6.3 Min

In this video, you’ll learn: ✔️ What is a Nested IF formula and when to use it ✔️ How to build multiple IF conditions within a single formula ✔️ Step-by-step guide to solve complex logical scenarios in Excel ✔️ Practical examples for grading systems, employee bonuses, and more

6 Nested If Calculate Discount
10 Min

In this video, you'll learn: ✔️ How to apply Nested IF formulas for different discount scenarios ✔️ Step-by-step guide to calculate: 🔹 Fixed Discount 🔹 Discount Based on Quantity 🔹 Discount on Specific Items 🔹 Customer Type-Based Discount ✔️ Real-world application for businesses and retailers ✔️ Tips to optimize and simplify discount calculations in Excel

7 Salary Sheet -1
6.37 Min

In this video, you'll learn: ✔️ How to create a Salary Sheet in Excel from scratch ✔️ Setting up Employee Details, Basic Pay, and Allowances ✔️ Understanding salary components for payroll management ✔️ Useful formulas to automate salary calculations ✔️ Perfect for HR professionals, accountants, and Excel learners

8 Salary Sheet -2
6.46 Min

In this video, you'll learn: ✔️ How to calculate Deductions (PF, ESI, Tax, etc.) ✔️ Formula for Gross Salary & Net Salary ✔️ Automating payroll calculations using Excel formulas ✔️ Essential tips for HR professionals & accountants ✔️ Step-by-step guide to complete your Salary Sheet

9 Attendance Sheet-1
7.49 Min

In this video, you'll learn: ✔️ How to create an Attendance Sheet in Excel from scratch ✔️ Setting up Employee/Student Names & Dates ✔️ Formatting and structuring an efficient attendance tracker ✔️ Basic formulas to mark Present (P), Absent (A), Leave (L) ✔️ Useful for schools, offices, and businesses

10 Attendance Sheet-2
6.48 Min

In this video, you will learn: ✔️ How to count attendance using Excel formulas ✔️ Linking the Attendance Sheet to another sheet for easier tracking ✔️ Automating the process of calculating Total Present, Absent, and Leave ✔️ How to use COUNTIF and other useful functions to streamline the attendance process

11 Sort, Custom Sort & Filter
11.18 Min

In this video, you will learn: ✔️ How to Sort Data in Excel (Ascending & Descending) ✔️ Using Custom Sort to sort by multiple criteria ✔️ How to apply Filters to quickly find specific data ✔️ Advanced filtering techniques for efficient data management ✔️ Practical examples to help you master sorting and filtering

Instructor

Sunil Kumar

0 Rating
0 Reviews
0 Students
11 Courses

Course Full Rating

0

Course Rating
(0)
(0)
(0)
(0)
(0)

No Review found

Sign In or Sign Up as student to post a review

Student Feedback

Course you might like

Intermediate
Advance Diploma In Computer Application
0 (0 Rating)
The Advance Diploma in Computer Application (ADCA) is a professional program designed to equip students with advanced kn...
₹4,499.00 ₹14,999.00
Beginner
Dilpoma in Computer Application
0 (0 Rating)
The Diploma in Computer Application (DCA) is a foundational course designed for individuals looking to build a career in...
₹1,499.00 ₹6,999.00

You must be enrolled to ask a question

Students also bought

Scholarship 2025
Intermediate
  • 1 Lectures
  • 1 Hour
  • 0 (0 Rating)
  • ₹99.00
DCA-EXAM
Beginner
  • 0 Lectures
  • 50 Min
  • 0 (0 Rating)
  • ₹0.00

₹999.00

₹3,499.00

Add To Cart Buy Now

  • Duration N/A

  • Lectures 11 lessons

  • Category: Computer Course

  • 0 Quizzes

  • Language: Hinglish

  • Skill Level Intermediate

  • Certificate of Completion

  • Full lifetime access

Remove Coupon
Coupon Applied!

More Courses by Author

Discover Additional Learning Opportunities

View All
Static
HTML
0 (0 Ratings)
The HTML Course is designed to provide a foundational understanding of HTML (HyperText Markup Langua...
₹599.00 ₹2,999.00
Static
MS-Word
0 (0 Ratings)
The MS-Word Course is designed to help learners master Microsoft Word, one of the most widely used w...
₹499.00 ₹1,499.00
Static
MS-Powerpoint
0 (0 Ratings)
The MS-PowerPoint Course is designed to provide learners with the skills needed to create compelling...
₹499.00 ₹1,499.00
Static
Tally Prime
0 (0 Ratings)
This course provides a comprehensive introduction to Tally Prime, one of the most widely used accoun...
₹999.00 ₹2,999.00
Static
Advance Diploma In Computer Application
0 (0 Ratings)
The Advance Diploma in Computer Application (ADCA) is a professional program designed to equip stude...
₹4,499.00 ₹14,999.00
Static
Dilpoma in Computer Application
0 (0 Ratings)
The Diploma in Computer Application (DCA) is a foundational course designed for individual...
₹1,499.00 ₹6,999.00
Static
HTML
0 (0 Ratings)
The HTML Course is designed to provide a foundational understanding of HTML (HyperText Markup Langua...
₹599.00 ₹2,999.00
Static
MS-Word
0 (0 Ratings)
The MS-Word Course is designed to help learners master Microsoft Word, one of the most widely used w...
₹499.00 ₹1,499.00
Static
MS-Powerpoint
0 (0 Ratings)
The MS-PowerPoint Course is designed to provide learners with the skills needed to create compelling...
₹499.00 ₹1,499.00
Static
Tally Prime
0 (0 Ratings)
This course provides a comprehensive introduction to Tally Prime, one of the most widely used accoun...
₹999.00 ₹2,999.00
Static
Advance Diploma In Computer Application
0 (0 Ratings)
The Advance Diploma in Computer Application (ADCA) is a professional program designed to equip stude...
₹4,499.00 ₹14,999.00
Static
Dilpoma in Computer Application
0 (0 Ratings)
The Diploma in Computer Application (DCA) is a foundational course designed for individual...
₹1,499.00 ₹6,999.00

Shopping Cart

Loading...