Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn Microsoft Excel Basics Fast
Rating: 1.0 out of 5(1 rating)
604 students
Created byGoh Ming Hui
Last updated 3/2019
English

What you'll learn

  • Microsoft Excel

Course content

1 section45 lectures43m total length
  • Getting Started0:49
  • Download Dataset1:11
  • Read CSV0:48
  • Bold0:19
  • Italics0:18
  • Underline0:19
  • Text Color0:18
  • Change Font0:23
  • Border0:28

    Learn how to apply and customize borders in Excel by selecting cells and using the border button to apply the chosen border style.

  • Cells Color0:35
  • LIne Styles0:36
  • Line Color0:37
  • Autosize0:23
  • Left Align0:19
  • Center Align0:17
  • Right Align0:30
  • Merge and Align0:21
  • Format Cells1:06
  • Conditional Formatting1:30

    Discover how to apply conditional formatting in Microsoft Excel to highlight cells, use rules such as top or bottom percent, greater than, or above average, and add color scales.

  • Format as Tables1:04
  • Change Cells Styles0:47
  • Format as Tables vs Format Cels Styles1:31
  • Sum Function0:43
  • Average Function0:29
  • Min Function0:29
  • Max Function0:25
  • Correlation0:42
  • Variance0:28
  • Standard Deviation0:28
  • Kurtosis0:27
  • Skewness0:22
  • VLOOKUP2:37
  • COUNTIF1:18
  • IF Function4:48
  • More Functions1:02
  • Find and Replace0:25
  • Sort Data0:38
  • Filter Data0:29
  • INsert Line Chart2:54
  • INsert Bar Chart1:33
  • INsert Pie Chart1:36
  • INsert Scatterplot1:10
  • Insert Combo Chart1:07
  • Pivot Table3:47
  • INsert Pivot Table and Pivot CHarts1:23

Requirements

  • Basic COmputer Knowledge

Description

Why Study Microsoft Office?


According to academyoflearning


1. Almost Every Company Worldwide Uses Microsoft Office

Microsoft office has users worldwide, wit hover 97139in Canada. Its widespread means it is important in many roles and makes it the best skill.


2. Helps You Step Up Your Game in Job Hunting

Almost all organizations use Microsoft Office, they use it for administration, projects, and communications. Thus, most jobs will require you ti know Microsoft Office.


3. Industry-Recognized Microsoft Office Certification Will Help Advance Your Career

You can demonstrate that you have the skills needed for Microsoft Office by earning Microsoft Office Certifications (MOS) in a specific office program. You can also get certified with SVBook Advanced Certificate in Microsoft Office or SVBook Advanced Certificate in Microsoft Office and Data Analysis using Excel.


This is the bite-size course to learn Microsoft Excel fast.  

You will need to know some computer knowledge before learning this course.


You can take the course as follows, and you can take an exam at EMHAcademy to get SVBook Advance Certificate in Microsoft Office: 

- Learn Microsoft Word Basics Fast

- Learn Microsoft Powerpoint Basics Fast

- Learn Microsoft Excel Basics Fast



You can take the course as following and you can take an exam at EMHAcademy to get SVBook Advance Certificate in Microsoft Office and Data Analysis with Excel:

- Learn Microsoft Word Basics Fast

- Learn Microsoft Powerpoint Basics Fast

- Learn Microsoft Excel Basics Fast

- Learn Data analysis using Microsoft Excel Basics Fast.


Content

  1. Getting Started

  2. Download Data set

  3. Read CSV

  4. Bold

  5. Italics

  6. Underline

  7. Text Color

  8. Change Font

  9. Border

  10. Cells Color

  11. Line Styles

  12. Line COlors

  13. Autosize

  14. Left Align

  15. Center Align

  16. Right Align

  17. Merge and Center

  18. Format Cells

  19. Conditional Formatting

  20. Format as Tables

  21. Change Cell Styles

  22. Format as Tables vs Change Cell Styles

  23. Sum Function

  24. Average Function

  25. Min Function

  26. Max Function

  27. Correlation

  28. Variance

  29. Standard Deviation

  30. Kurtosis

  31. SKewness

  32. VLOOKUP

  33. COUNTIF

  34. IF FUnction

  35. More Functions

  36. Find and Replace

  37. Sort Data

  38. Filter Data

  39. Insert Line Chart

  40. Insert Bar Chart

  41. Insert Pie Chart

  42. Insert Scatterplot

  43. Insert COmbo CHart

  44. Insert Pivot Table

  45. Insert Pivot Tables and Pivot Charts


Who this course is for:

  • Beginner Computer Passion People who want to learn Microsoft Excel