2.3.Learning spreadsheet basics

Spreadsheets are a very important data analytics tool. In this part of the course, you will learn about how data analysts use spreadsheets in their work every day. You will also explore why structured thinking helps analysts better understand problems and come up with solutions.

Learning Objectives

• Discuss the data analyst’s use of spreadsheets with reference to roles and responsibilities
• Demonstrate the use of spreadsheets to complete basic tasks of the data analyst including entering and organizing data
• Demonstrate an understanding of the use of formulas in spreadsheets including a definition and specific examples
• Compare formulas and functions with reference to similarities and differences
• Describe the key ideas associated with structured thinking including the problem domain, scope of work, and context

---

• Working with spreadsheets
• Using formulas in spreadsheets
• Using functions in spreadsheets
• Save time with structured thinking
• Weekly challenge 3