• Home
  • About Us
    • Why Us
    • Gallery
    • Testimonials
  • Courses

    About Courses

    • Actuarial Science
    • Computer and Data Analytics
    • CFA Program
    • Sales and Digital Marketing
    • Graphic Desgining
    • Finance & Management
    • Certified Credit Research Analyst
    • Chartered Alternative Investment Analyst
    • Financial Risk Management
    CM1 with MS Excel [Earlier CT1 & CT5] (Actuarial Science)

    CM1 with MS Excel [Earlier CT1 & CT5] (Actuarial Science)

    ₹ 23,000 ₹ 20,999
    Read More
  • Corporate Training
  • IT Solutions
  • Blog
  • FAQs
  • Clients
  • Contact
    Have any question?
    +91 9015696833 , 8076456526
    cc@wkvedu.com
    Investment Banking Courses, Data Science Using R, Actuarial Science ClassesInvestment Banking Courses, Data Science Using R, Actuarial Science Classes
    • Home
    • About Us
      • Why Us
      • Gallery
      • Testimonials
    • Courses

      About Courses

      • Actuarial Science
      • Computer and Data Analytics
      • CFA Program
      • Sales and Digital Marketing
      • Graphic Desgining
      • Finance & Management
      • Certified Credit Research Analyst
      • Chartered Alternative Investment Analyst
      • Financial Risk Management
      CM1 with MS Excel [Earlier CT1 & CT5] (Actuarial Science)

      CM1 with MS Excel [Earlier CT1 & CT5] (Actuarial Science)

      ₹ 23,000 ₹ 20,999
      Read More
    • Corporate Training
    • IT Solutions
    • Blog
    • FAQs
    • Clients
    • Contact

      Computer and Data Analytics

      • Home
      • All courses
      • Computer and Data Analytics
      • MS Excel
      CoursesHomepageMS Excel
      • Part 1 10

        • Lecture1.1
          Introduction to Excel 16 min
        • Lecture1.2
          Introduction to Functions 07 min
        • Lecture1.3
          Cell Referencing 13 min
        • Lecture1.4
          Paste Special Tool 10 min
        • Lecture1.5
          Working with Ranges 17 min
        • Lecture1.6
          Formatting in Excel 06 min
        • Lecture1.7
          Conditional Formatting
        • Lecture1.8
          Status Bar
        • Lecture1.9
          Mathematical Functions
        • Lecture1.10
          Conditional Functions Part 1
        • Lecture1.11
          Conditional Functions Part 2
      • Part 2 33

        • Lecture2.1
          Lookup Functions 16 min
        • Lecture2.2
          Match Function 18 min
        • Lecture2.3
          Lookup with Match 11 min
        • Lecture2.4
          Offset Function 13 min
        • Lecture2.5
          Index Function 13 min
        • Lecture2.6
          Index Match Function 24 min
        • Lecture2.7
          Logical Functions Part 1 (IF,AND) 38 min
        • Lecture2.8
          Logical Functions Part 2 (OR,NOT) 18 min
        • Lecture2.9
          Logical Functions Part 3 (NESTED IF,AND, OR) 07 min
        • Lecture2.10
          Date Functions Part 1 10 min
        • Lecture2.11
          Date Functions Part 2 09 min
        • Lecture2.12
          Time Functions 10 min
        • Lecture2.13
          Text Functions Part 1
        • Lecture2.14
          Text Functions Part 2
        • Lecture2.15
          IS Functions
        • Lecture2.16
          Reference Functions
        • Lecture2.17
          Indirect Function
        • Lecture2.18
          What If Analysis (Goal Seek)
        • Lecture2.19
          Printing in Excel
        • Lecture2.20
          Sub Total
        • Lecture2.21
          Working with Data Part 1 (Sorting)
        • Lecture2.22
          Working with Data Part 2 (Filtering)
        • Lecture2.23
          Information Functions
        • Lecture2.24
          Text Function- Case Study
        • Lecture2.25
          Charts Part 1 (Bar Chart)
        • Lecture2.26
          Charts Part 2 (Column Chart)
        • Lecture2.27
          Charts Part 3 (Line Graph and Scatter Plot)
        • Lecture2.28
          Charts Part 4 (Pie Chart)
        • Lecture2.29
          Miscellaneous Functions
        • Lecture2.30
          Errors
        • Lecture2.31
          Tables
        • Lecture2.32
          Statistical Functions Part 1
        • Lecture2.33
          Statistical Functions Part 2
      • Part 3 14

        • Lecture3.1
          Data Table 07 min
        • Lecture3.2
          Scenario Manager 04 min
        • Lecture3.3
          Solver 08 min
        • Lecture3.4
          Collaboration Tools 11 min
        • Lecture3.5
          Auditing Workbooks 10 min
        • Lecture3.6
          Text to Column 11 min
        • Lecture3.7
          Data from Web 14 min
        • Lecture3.8
          Data Validation 08 min
        • Lecture3.9
          Data Consolidation 12 min
        • Lecture3.10
          Array Functions 09 min
        • Lecture3.11
          Hyperlink 13 min
        • Lecture3.12
          Beginning with Macros 11 min
        • Lecture3.13
          Pivot Tables and Pivot Charts 26 min
        • Lecture3.14
          Wildcard In Excel 20 min
        • Lecture3.15
          Password Proctection 25 min

        Introduction to Excel

        Subscribers who have purchased the course should email us at cc@wkvedu.com. Please remember to include the following details in the email:
        1. Name
        2. Mob No.
        3. Email
        4. Course(s) Purchased
        5. Machine ID

        Important instructions:
        1. Course Videos, Video Player, Study Material, Files etc can be downloaded from Curriculum Page by clicking ‘Download Video’.
        2. Please use the Video Player to generate the Machine ID

        Steps to Generate Machine ID
        1. Open player according to your Operating System. We provide players for both Windows & Mac.
        2. Click on ‘Select Files’ on the Dialogue Box.
        3. Select any encrypted video (Encrypted videos have extension as ‘.wkvedu’)
        4. Click on the Machine ID displayed by the player. It will get copied automatically.

        Next Introduction to Functions

        Leave A Reply Cancel reply

        Your email address will not be published. Required fields are marked *

        All Courses

        • Actuarial Science
        • CFA Program
        • Computer and Data Analytics
        • Finance & Management
        • Homepage
        • Homepage-2
        • Sales and Digital Marketing

        Latest Courses

        CM1 with MS Excel [Earlier CT1 & CT5] (Actuarial Science)

        ₹ 23,000 ₹ 20,999

        CS1 with R [Earlier CT3] (Actuarial Science)

        ₹ 23,000 ₹ 20,999

        CS2 with R [Earlier CT4 & CT6] (Actuarial Science)

        ₹ 25,000 ₹ 22,999

        © 2017 - White Knight Ventures

        • Actuarial Science
        • Computer and Data Analytics
        • CFA Program
        • Sales and Digital Marketing
        • Graphic Desgining
        • Finance & Management
        • Certified Credit Research Analyst
        • Chartered Alternative Investment Analyst
        • Financial Risk Management

        Login with your site account

        Lost your password?

        Not a member yet? Register now

        Register a new account

        Are you a member? Login now