• Home
  • About Us
  • Courses
  • Blog
  • Become a Teacher
  • Contact Us
      • Facebook
      • Instagram
      • Youtube
Cad LearnerCad 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 1

      • Lecture1.1
        1.1 An Introduction To The Course
    • Microsoft Excel Fundamentals 5

      • 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 7

      • 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 6

      • 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 6

      • 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 4

      • 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 9

      • 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 9

      • 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 1

      • Lecture9.1
        9.1 Date & Time Function Workbook
    • Pivot Charts 1

      • Lecture10.1
        10.1 Pivot Charts Workbook
    • Array Functions 0

      No items in this section
    • Printing Excel Worksheet 0

      No items in this section
      This content is protected, please login and enroll course to view this content!
      Prev 3.4 Characteristics of a cell
      Next 3.6 Copying & filling

      Leave A Reply Cancel reply

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

      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