Learn Excel Online

(0 review)
Free
Learn Excel Online

WHY THIS COURSE

Excel is a professional skill that surely helps in fruitful developments in your career.  If you are going for a job interview and you have Excel Proficiency as one of the key skill in your resume, you will surely have an edge over other candidates who aren’t familiar.

This Excel Online Course helps you in learning sorting and filters lists, track numbers, create formulas, perform complex computations and reporting effortlessly and much more.

 LEARNING OUTCOMES

This is a tailored made course which will help you to understand excel skills and techniques which are applicable to any industry

  • This course helps you to manage large amount of data quickly and give you the result for data analysis.
  • Perform calculations in an Excel worksheet.
  • You can organize and interpret information more easily.
  • Modify the appearance of data within a worksheet and manage Excel Formulas.
  • After doing this program, you will be considered a strong and competent Excel professional.

COURSE OUTLINE

  • KNOW YOUR EXCEL
  • COUNT AND SUM FUNCTIONS
  • STATISTICAL FUNCTIONS
  • TEXT FUNCTIONS
  • DATE/TIME FUNCTIONS
  • LOOKUP & REFERENCE FUNCTIONS
  • LOGICAL FUNCTIONS
  • IMPORTANT TOOLS
  • EXCEL SHORTCUT KEYS

CAREER SCOPE

  • There are many jobs like finance, accounting, business analyst, marketing managers etc where excel skills are necessary and provide you a competitive edge.
  • Most companies, banks & financial institutions, accounting firms, IT/BPO companies look for professionals with Excel skills.
  • This could be a great boost to your career, apart from recognition among peers, you have all the reasons to ask for a better pay for your services and expertise.
  • Many businesses and organisations seek candidates with strong excel and analysis skills.

WHO SHOULD DO THIS COURSE?

Recruiters are always on the lookout for hot keywords and this course will be a great value-add to your resume

  • Commerce Students, Marketing Students, Teachers, Finance Professional, Account Professional, Marketing Managers, Project Managers, Administrative Assistant, Business Analyst etc.
  • For students aspiring for entry level jobs in any domain this is mandatory.

Course Features

  • Lectures 65
  • Quizzes 0
  • Duration 35 hours
  • Students 40
  • Certificate No
  • Assessments Self
  • KNOW YOUR EXCEL 0/7

    • Lecture1.1
      What is Excel
      30m
    • Lecture1.2
      What is Workbook in excel
      30m
    • Lecture1.3
      How to insert Worksheet in Excel
      30m
    • Lecture1.4
      Columns, Rows, and Cells
      30m
    • Lecture1.5
      Formatting Text
      30m
    • Lecture1.6
      Printing Workbooks
      30m
    • Lecture1.7
      Practice Set
      30m
  • MATH FUNCTIONS 0/7

    • Lecture2.1
      SUM
      30m
    • Lecture2.2
      SUMIF
      30m
    • Lecture2.3
      COUNT
      30m
    • Lecture2.4
      COUNTIF
      30m
    • Lecture2.5
      COUNTA
      30m
    • Lecture2.6
      VIDEO
      0m
    • Lecture2.7
      FAQ
      0m
  • STATISTICAL FUNCTIONS 0/9

    • Lecture3.1
      AVERAGE
      30m
    • Lecture3.2
      AVERAGEIF
      30m
    • Lecture3.3
      MODE
      30m
    • Lecture3.4
      MIN
      30m
    • Lecture3.5
      MAX
      30m
    • Lecture3.6
      LARGE
      30m
    • Lecture3.7
      SMALL
      30m
    • Lecture3.8
      VIDEO
      0m
    • Lecture3.9
      FAQ
      0m
  • TEXT FUNCTIONS 0/8

    • Lecture4.1
      CONCATENATE
      30m
    • Lecture4.2
      TRIM
      30m
    • Lecture4.3
      LEN
      30m
    • Lecture4.4
      UPPER
      30m
    • Lecture4.5
      LOWER
      30m
    • Lecture4.6
      PROPER
      30m
    • Lecture4.7
      LEFT
      30m
    • Lecture4.8
      RIGHT
      30m
  • DATE AND TIME FUNCTIONS 0/6

    • Lecture5.1
      DATE
      30m
    • Lecture5.2
      DAY
      30m
    • Lecture5.3
      MINUTE
      30m
    • Lecture5.4
      DAYS
      30m
    • Lecture5.5
      VIDEO
      0m
    • Lecture5.6
      FAQ
      0m
  • LOOKUP & REFERENCE FUNCTIONS 0/6

    • Lecture6.1
      COLUMN
      30m
    • Lecture6.2
      HLOOKUP
      30m
    • Lecture6.3
      LOOKUP
      30m
    • Lecture6.4
      VLOOKUP
      30m
    • Lecture6.5
      VIDEO
      0m
    • Lecture6.6
      FAQ
      0m
  • LOGICAL FUNCTIONS 0/5

    • Lecture7.1
      IF
      30m
    • Lecture7.2
      OR
      30m
    • Lecture7.3
      AND
      30m
    • Lecture7.4
      VIDEO
      0m
    • Lecture7.5
      FAQ
      0m
  • IMPORTANT TOOLS 0/16

    • Lecture8.1
      Sorting
      30m
    • Lecture8.2
      Filter
      30m
    • Lecture8.3
      Conditional Formatting
      30m
    • Lecture8.4
      Charts
      30m
    • Lecture8.5
      Find Duplicates
      30m
    • Lecture8.6
      Drop Down List
      30m
    • Lecture8.7
      Percent Change
      30m
    • Lecture8.8
      Remove Duplicates
      30m
    • Lecture8.9
      Transpose
      30m
    • Lecture8.10
      Copy, Paste & Paste Special function
      30m
    • Lecture8.11
      Text to Columns
      30m
    • Lecture8.12
      Alignment
      30m
    • Lecture8.13
      Wrap Text
      30m
    • Lecture8.14
      Merge & Centre
      30m
    • Lecture8.15
      Spelling Checks
      30m
    • Lecture8.16
      Freeze Panes
      30m
  • EXCEL SHORTCUTS KEYS 0/1

    • Lecture9.1
      EXCEL SHORTCUTS
      30m
Admin bar avatar
Sample title.

Reviews

Average Rating

0
0 rating

Detailed Rating

5 stars
0
4 stars
0
3 stars
0
2 stars
0
1 star
0
Free