• Home
  • About Us
  • Courses
  • Blog
  • Become a Teacher
  • Contact Us
      • Facebook
      • Instagram
      • Youtube
Cad Learner
  • Register |Login
    • Home
    • About Us
    • Courses
    • Blog
    • Become a Teacher
    • Contact Us
        • Facebook
        • Instagram
        • Youtube

    Microsoft Excel - From Zero to Hero

    • Home
    • All courses
    • MS Office
    • Microsoft Excel – From Zero To Hero
    CoursesMS OfficeMicrosoft Excel – From Zero To Hero
    • Microsoft Excel zero to hero Course Introduction
      • Lecture1.1
        1.1 An Introduction To The Course
    • Microsoft Excel Fundamentals
      • Lecture2.1
        2.1 Excel Interface
      • Lecture2.2
        2.2 Customizing Excel Toolbars
      • Lecture2.3
        2.3 Working with files
      • Lecture2.4
        2.4 Common Excel shortcuts
      • Quiz2.1
        2.5 Excel fundamentals quiz 1 question
    • Editing & Formatting Data
      • Lecture3.1
        3.1 Editing data
      • Lecture3.2
        3.2 Numeric Data In excel
      • Lecture3.3
        3.3 Formatting data
      • Lecture3.4
        3.4 Characteristics of a cell
      • Lecture3.5
        3.5 Cell Reference
      • Lecture3.6
        3.6 Copying & filling
      • Lecture3.7
        3.7 Excel workbook management
    • Basic Excel Functions
      • Lecture4.1
        4.1 Introduction to excel functions
      • Lecture4.2
        4.2 The SUM() function
      • Lecture4.3
        4.3 The MIN() & MAX() function
      • Lecture4.4
        4.4 The AVERAGE() & COUNT() functions
      • Lecture4.5
        4.5 More on basic excel functions
      • Quiz4.1
        4.6 Basic Excel Functions Quiz 0 question
    • Shapes | Images |Charts In Excel Worksheet
      • Lecture5.1
        5.1 Inserting images and shapes
      • Lecture5.2
        5.2 Formatting Excel Shapes
      • Lecture5.3
        5.3 Working with smart art
      • Lecture5.4
        5.4 Creating excel charts
      • Lecture5.5
        5.5 Modifying Excel Charts
      • Quiz5.1
        Excel Charts Quiz 0 question
    • Conditional Functions
      • Lecture6.1
        6.1 IF() function
      • Lecture6.2
        6.2 Nested IF() function
      • Lecture6.3
        6.3 Nesting of IF() & AND() | OR() functions
      • Lecture6.4
        6.4 Stat functions
    • Lookup Functions
      • Lecture7.1
        7.1 VLOOKUP() & HLOOKUP()
      • Lecture7.2
        7.2 NESTED VLOOKUP()
      • Lecture7.3
        7.3 CHOOSE() function
      • Lecture7.4
        7.4 MATCH() function
      • Lecture7.5
        7.5 INDEX() function
      • Lecture7.6
        7.6 Nested MATCH() & INDEX()
      • Lecture7.7
        7.7 VLOOKUP() & MATCH() Nesting
      • Lecture7.8
        7.8 TRANSPOSE() function
      • Lecture7.9
        7.9 OFFSET() function
    • Text Functions
      • Lecture8.1
        8.1 Basic Text Functions
      • Lecture8.2
        8.2 LEFT(), MID(), RIGHT()
      • Lecture8.3
        8.3 SEARCH & FIND()
      • Lecture8.4
        8.4 SUBSTITUTE() & REPLACE()
      • Lecture8.5
        8.5 Nesting LEFT() RIGHT() FIND()
      • Lecture8.6
        8.6 Nesting MID() FIND()
      • Lecture8.7
        8.6 Nesting SUBSTITUTE() & FIND()
      • Lecture8.8
        8.7 TRIM() Function
      • Quiz8.1
        8.8 Text Functions Quiz 0 question
    • Date & Time Functions
      • Lecture9.1
        9.1 Date & Time Function Workbook
    • Pivot Charts
      • Lecture10.1
        10.1 Pivot Charts Workbook
    • Array Functions
      No items in this section
    • Printing Excel Worksheet
      No items in this section
      This content is protected, please login and enroll course to view this content!
      Prev 3.5 Cell Reference
      Next 3.7 Excel workbook management

      Leave A Reply Cancel reply

      You must be logged in to post a comment.

      Course Categories

      • MS Office

      Latest Courses

      Microsoft Excel – From Zero To Hero

      Microsoft Excel – From Zero To Hero

      ₹1,890.00 ₹1,250.00

      (+91) 9817007177

      cadlearneronline@gmail.com

      COMPANY

      • Home
      • Blog
      • About Us
      • Contact Us

      SUPPORT

      • My account
      • Profile
      • Members
      • Register

      © Copyright 2020 All Rights Reserved With Cadlearner.com

      Login with your site account

      Lost your password?

      Not a member yet? Register now

      Register a new account

      Are you a member? Login now