Introduction to Data Analysis Using Excel with Top Free Course

Introduction to Data Analysis Using Excel

Mark as Favorite Share
image

What Will You Learn?

Excel is an indispensable tool in today's business landscape, utilized by organizations of all sizes for its robust data analysis capabilities. Our introductory course is tailored to equip you with practical Excel skills, setting the stage for tackling advanced Business Statistics topics down the line. Whether you're a newcomer to Excel or have been using it at a basic level, this course caters to both audiences. We guide you through fundamental tasks like data input, organization, and manipulation, gradually delving into the more sophisticated features of Excel. Throughout the course, we illustrate Excel functionalities with clear, easy-to-follow examples, ensuring you grasp and apply them with confidence.

About This Course

Provider: Coursera
Format: Online
Duration: 24 hours to complete [Approx]
Target Audience: Beginners
Learning Objectives: By the end of this free course, you will be proficient in using Excel for data analysis.
Course Prerequisites: NA
Assessment and Certification: NA
Instructor: Rice University
Key Topics: Data Analysis, Microsoft Excel, Pivot Table, Lookup Table
Topic Covered: 
  1. - Introduction to Data Analysis Using Excel
  2. - Reading Data into Excel
  3. - Basic Data Manipulation in Excel
  4. - Arithmetic Manipulation in Excel
  5. - Basic Functions in Excel
  6. - Functions Using Absolute and Relative References
  7. - Functions Explained
  8. - The “IF” Command in Excel
  9. - The “IF” Command in Excel Using Numerical Data
  10. - The "Nested IF" Command in Excel
  11. - The "VLOOKUP" Function in Excel
  12. - Another "VLOOKUP" Example
  13. - The "HLOOKUP" Function in Excel
  14. - Using the “VLOOKUP” Function Across Worksheets
  15. - Data Filtering in Excel
  16. - Use of Pivot Tables in Excel
  17. - More Pivot Table Options
  18. - Application of Pivot Tables to Numeric Data
  19. - Introduction to Charts in Excel
  20. - Line Graphs
  21. - Bar Graphs and Pie Charts
  22. - Pivot Charts
  23. - Scatter Plots
  24. - Histograms

0 Comments

No reviews yet !!

Please login first