• 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

    Microsoft Excel – From Zero To Hero

    Admin bar avatar
    Ashish Singh
    MS Office
    (0 review)
    ₹1,890.00 ₹1,250.00
    Microsoft Excel – from Zero To Hero
    • Overview
    • Curriculum
    • Instructor
    • Reviews

    Microsoft Excel -From Zero To Hero 

    all in One Package

    This Microsoft Excel course combines 4 different courses.

    • Microsoft Excel 101 – An Introduction to Excel
    • Microsoft Excel 102 – Intermediate Level Excel
    • Microsoft Excel 103 – Advanced Level Excel
    • Master Microsoft Excel Macros and VBA in 6 Simple Projects

    Material recorded with Excel 2013 but works in 2010, 2013, 2016, 2019 (Office 365)

    Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor I will use my 15+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.

    As you participate in each of the 4 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

    At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

    • Creating effective spreadsheets
    • Managing large sets of data
    • Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)
    • Create dynamic report with Excel PivotTables
    • Unlock the power and versatility of Microsoft Excel’s AddIn, PowerPivot
    • Audit Excel Worksheet formulas to ensure clean formulas
    • Automate your day to day Excel tasks by mastering the power of Macros and VBA

    So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newb to Excel Guru!

    Who this course is for:
    • This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).
    • If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

    Course Features

    • Lectures 45
    • Quizzes 4
    • Duration 50 hours
    • Skill level All levels
    • Language English
    • Students 1
    • Certificate No
    • Assessments Yes
    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
    Admin bar avatar
    Ashish Singh

    Reviews

    Average Rating

    0
    0 rating

    Detailed Rating

    5
    0%
    4
    0%
    3
    0%
    2
    0%
    1
    0%
    • Overview
    • Curriculum
    • Instructor
    • Reviews
    ₹1,890.00 ₹1,250.00
    • Share:

    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