Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel for Beginners : A hands-on course
10 students

Excel for Beginners : A hands-on course

The course will enable an absolute beginner to learn excel in a very structured and practical manner
Created byKnowledge Varsity
Last updated 9/2016
English

What you'll learn

  • Proficiently work on excel
  • Choose right type of graphs in excel
  • Use conditional formatting
  • Use SumIfs, CountIfs, Sumproduct and other functions
  • Apply filter on large data sets
  • Apply vertical and horizontal sorting
  • Use V Lookup, H Lookup with confidence
  • Use Pivot table, Pivot Chart, Slicers
  • Use Match and Index
  • Use Goal Seek, Scenario Manager, Data Table

Course content

8 sections • 41 lectures • 4h 58m total length

  • Introduction to Excel Workbook, Sheets, Ribbon, Status Bar8:41
    • Learn to create new workbook, rename sheet,
    • Understand ribbon elements, status bar elements
    • Understand rows and columns. 
    • Learn how to zoom
  • Navigation8:53
    Learn how to 
    • Move to different cells.
    • Move across sheets
    • Navigate faster


  • Autofill, Increasing width& Number formats6:36

    Learn how to 

    • increase column width
    • extend the cells to autofill the values
    • use different number formats
  • Formula Entering & Simple Formatting11:21

    Learn how to 

    • use date format
    • use time format
    • use negative in accounting format
    • Enter formulas
  • Understanding Functions, Dragging Formulas & Paste Special6:32
    • Learn how to insert functions
    • Understand various types of functions
    • Learn how to drag the formula
    • Understand how paste special works
  • Referencing Part 18:16

    This video illustrates absolute and relative referencing through a comprehensive example.

  • Referencing Part 212:14

    This video illustrates absolute and relative referencing through a comprehensive example.

  • Freeze Panes6:01

    This video illustrates freeze panes through a comprehensive example.

Requirements

  • Installed Microsoft Excel 2007 or later on Windows or Mac
  • Devote 5 hours a week for 6 weeks to watch the videos and solve all the practice problems

Description

This course is designed to teach you the basics and intermediate excel. 

Everything in the course is taught in step-by-step approach to make it as practical as possible.

While learning excel it is very important to practice the concepts explained in the videos, In this course we provide excel assignments file so that you can apply the concepts and learn faster. 

This course is for you - if you are a beginner or intermediate Excel user.

This course is divided into 8 sections. These sections are clubbed in weeks and the course will take 6 weeks of your time (assuming you devote 5 hours per week). 

You should watch the videos and then solve the problems which are given in the practice excel files attached with each of the section. 

Note: This course is specifically designed for learning on a PC (Windows), some concept in slicer and Pivot Tables may not work on a Mac.


Who this course is for:

  • This course is for the beginners to excel
  • You can also take this course - If you have worked earlier on excel, but need to refresh the concepts or learn new concepts
  • This course is not for you if you are an expert in excel

Report abuse