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:
- - Introduction to Data Analysis Using Excel
- - Reading Data into Excel
- - Basic Data Manipulation in Excel
- - Arithmetic Manipulation in Excel
- - Basic Functions in Excel
- - Functions Using Absolute and Relative References
- - Functions Explained
- - The “IF” Command in Excel
- - The “IF” Command in Excel Using Numerical Data
- - The "Nested IF" Command in Excel
- - The "VLOOKUP" Function in Excel
- - Another "VLOOKUP" Example
- - The "HLOOKUP" Function in Excel
- - Using the “VLOOKUP” Function Across Worksheets
- - Data Filtering in Excel
- - Use of Pivot Tables in Excel
- - More Pivot Table Options
- - Application of Pivot Tables to Numeric Data
- - Introduction to Charts in Excel
- - Line Graphs
- - Bar Graphs and Pie Charts
- - Pivot Charts
- - Scatter Plots
- - Histograms
0 Comments