This is the bite size course to learn Data Analysis using Microsoft Excel fasts. This course will use CRISP DM MOdel, and we will go through Data Understanding (Data Visualizations, Statistics, Data ANlaysis) and Data Preparation (Remove Mssing values, remove duplicates) using Mcirosoft Excel.  

You will need to know some COmputer knowledge before learning this course and you need to know Microsoft Excel before learning also. You can learn Microsoft Excel at my course "Learn Microsoft Excel Basics Fast". 


You can take the course as follow 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 Aalysis using Microsoft Excel Basics Fast.


Content

  1. Getting Started

  2. Download Dataset

  3. Read CSV

  4. Data Mining Process

  5. INsert Lien CHart

  6. INsert Bar Chart

  7. INsert Pie CHart

  8. INsert Scatterplot

  9. INsert Combo Chart

  10. Pivot Table

  11. INsert Pivot Table and Pivot Chart

  12. Data Analysis Plugins

  13. Data Analysis PLugins 2

  14. Descriptive Statistics

  15. Histogram

  16. Correlation

  17. Covariance

  18. TTest Two Samples Paired for means

  19. TTest Two Samples Equal Variances

  20. TTest Two Samples Unequal Variances

  21. F Test Two Samples for Variances

  22. ANOVA Single Factor

  23. ANOVA Two Factor WIthout Replication

  24. Regression ANalysis

  25. Remove Duplicates

  26. Remove Missing

  27. Sort Data

  28. Filter DAta

12.99
https://www.udemy.com/learn-data-analysis-using-microsoft-excel-basics-fast/?couponCode=EMHACADEMY1

This is the bite size course to learn Microsoft Word fasts.  

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


You can take the course as follows, and you can take a 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 follow 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 Aalysis using Microsoft Excel Basics Fast.


Content

  1. Getting Started

  2. Theme

  3. Bold

  4. Italics

  5. Underline

  6. Strkethrough

  7. subscript

  8. superscript

  9. Chnage Font

  10. Change Font Size

  11. Change TExt Effects

  12. Text Highlights

  13. Change Text COlors

  14. CHnage Text Styles

  15. Left Align

  16. Center

  17. Right Align

  18. INcrease Indent

  19. Decrease Indent

  20. Bullets

  21. Numbering

  22. INsert Tables

  23. Style Tables

  24. INsert Photos

  25. Edit Pictures

  26. INsert Shapes

  27. INsert Icons

  28. INsert Smartart

  29. INsert Charts

  30. INsert Header

  31. Insert Footer

  32. INsert Page Number

  33. Insert Textbox

  34. INsert Symbols

  35. Insert Equations

  36. Themes

  37. Colors

  38. Paragraphs Spacing

  39. Watermark

  40. Page COlor

  41. Borders

  42. Text Direction

  43. Margins

  44. Orientations

  45. Size

  46. Columns

  47. INsert COver Page

  48. INsert Blank Page

  49. INsert COnetnet Page

  50. POtrait and Landscape in a DOcument

  51. Word COunt

  52. Spelling Check

  53. Protect Document

  54. Export PDF



12.99

https://www.udemy.com/learn-microsoft-word-basics-fast/?couponCode=EMHACADEMY1

** If you faced any disabilities, we can gives you free books, courses, and softwares. Email: gohminghui88@svbook.com


This is the bite size course to learn Microsoft POwerPoint fasts.  

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


You can take the course as follows, and you can take a 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 follow 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 Aalysis using Microsoft Excel Basics Fast.


Content

  1. Getting Started

  2. Bold

  3. Italics

  4. Underline

  5. Text Shadow

  6. Strkethrough

  7. Character Spacing

  8. Change Case

  9. Text Highlighting

  10. Change Text Color

  11. Change Font

  12. Chnage FOnt Size

  13. Bullets and Numbering

  14. Create Tables

  15. INsert Pictures

  16. Edit Image 1

  17. Edit Image 2

  18. Edit Image 3

  19. Create SHapes

  20. Create Shapes 2

  21. INsert Icons

  22. Insert SmartArts

  23. INsert Charts

  24. Insert Textbox

  25. INsert Header and Footer

  26. Insert WordArt

  27. Insert Equation

  28. INsert Symbols

  29. Insert Videos

  30. Theme

  31. Format Background

  32. Design Ideas

  33. Transition

  34. Animating Objects and Text

  35. Slideshows

  36. Spelling

  37. Print

  38. Print 2 or 3 slides

  39. Export Handouts

12.99
https://www.udemy.com/learn-microsoft-powerpoint-basics-fast/?couponCode=EMHACADEMY1

** If you faced any disabilities, we can gives you free books, courses, and softwares. Email: gohminghui88@svbook.com


This is the bite size course to learn Microsoft Excel fasts.  

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


You can take the course as follows, and you can take a 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 follow 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 Aalysis 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. Chnage 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 Fucntion

  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 Dtaa

  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

12.99
https://www.udemy.com/learn-microsoft-excel-basics-fast/?couponCode=EMHACADEMY1

** If you faced any disabilities, we can gives you free books, courses, and softwares. Email: gohminghui88@svbook.com