Skip to content
Smart Computer Education
  • Home
  • Course List
  • Pages
    • About
    • Instructor
    • Blog
    • Contact
    • Sign In
(0)
Getting Started

Advance Excel

SC
By Smart Computer Categories: Account & Finance, Data Analytical, Data Science
Wishlist Share
Share Course
Page Link
Share On Social Media
  • Course Info
  • Reviews
  • More
    • Course Content

      Monthly Budget Basic Level

      • 1.1. Monthly Budget
        36:38
      • 1.2. Monthly Budget
        42:34
      • 1.3 monthly budget
        41:54
      • 1.4 Monthly Budget Print & Chart
        45:54

      Intermediate Level

      • Sort, Filter, Sub Total, Customize, Remove Duplicate
        55:51
      • Dsum, DAverage, DCount, SubTotal
        30:52
      • Data Validation Part 1
        28:06
      • Data Validation Part 2
        30:24
      • Pivot Table Part 1
        28:32
      • Pivot Table Part 2
        24:01
      • Pivot Table Part 3
        18:35
      • Power Pivot
        21:11
      • 3d Formula, Consolidate, Freeze, Print Adv
        23:47

      Advance Level

      • If, And, Min
        53:02
      • Countif, Sumif
        31:41
      • VLOOKUP, If Error
        42:57
      • HLookup, Index, Match
        27:55
      • Index, Match
        45:53
      • Trace Precedent, Dependence, Show Formula, Sheet Protection
        39:24
      • Goal Seek, Solver
        30:34
      • Data Table, Scenario
        29:46
      • Macro
        18:46

      VBA Coding in Excel

      • VBA Basic
        41:18
      • VBA Project 1 (Part 1)
        33:07
      • VBA Project 1(part 2)
        56:30
      • VBA Project 1(part 3)
        40:31
      • VBA Project 2
        33:13
      • VBA Project 3
        30:55
      • VBA Project 4
        25:19
      • VBA Project 5
        01:02:00

      Dashboard

      • Dashboard Part 1
        00:00
      • Dashboard Part 2
        00:00
      • Dashboard Part 3
        00:00
      • Dashboard Part 4
        00:00

      Student Ratings & Reviews

      No Review Yet
      No Review Yet
      ₹4,500.00 ₹6,000.00
      • All Levels
      • 2 Total Enrolled
      • June 26, 2024 Last Updated
      Hi, Welcome back!
      Forgot?
      Don't have an account?  Register Now

      A course by

      SC
      Smart Computer

      Tags

      • DataAnalysis
      • ExcelAutomation
      • ExcelFormulas

      Our Course Certificate will be eligible for both Govt. and Private Jobs

      +91 7276749377

      Quick links

      • About
      • Blog
      • Careers
      • Pricing

      Resources

      • Course List
      • Instructor
      • Membership
      • FAQs

      Support

      • Forums
      • Documentation
      • Community
      • Policy

      Copyright 2015-2024 - Smart Computer Education

      © All rights reserved.