Developing Better Spreadsheet Skills
Robobunnyattack!
Course Summary
Use spreadsheets to analyze and understand your data! Learn handy Excel formulas, functions, data clean-up skills & more
-
+
Course Description
In these tutorials, I'll demonstrate each step using LibreOffice, a free and open-source office productivity suite. You can apply these skills in your preferred spreadsheet application program, such as Microsoft Excel, LibreOffice, or OpenOffice.WHAT'S INCLUDED?This course has over 1 hour of step-by-step videos, along with links to helpful resources and downloadable project files.HOW LONG WILL IT TAKE ME?The length of time it takes to complete this course depends on your availability and learning preference. You can power through all the video lectures all at once, or pace yourself over several days –– it's up to you!CAN I ASK QUESTIONS AND GET HELP?Yes! You can post your questions and discuss problems with your fellow students in the course dashboard.I'll also be personally checking in every week to answer questions and provide feedback. I look forward to meeting you!What am I going to get from this course?- Over 14 lectures and 1 hour of content!
- In this course, we'll use a real-world example to practice spreadsheet navigation, formatting tricks, understanding and writing functions, and how to use data clean-up tools
- We'll focus on WHY and HOW things work in spreadsheets –– so you can develop an intuitive understanding of how to use ANY spreadsheet software
- By the end of this course, you'll be able to use spreadsheet software with confidence, so you can better analyze and understand your data!
What is the target audience?- Beginner and intermediate-level users of Microsoft Excel (or any spreadsheet software)
- Knowledge workers seeking to strengthen their data management skills
- Learners of all ages who want to REALLY understand how to use spreadsheets –– not just memorize a series of steps!
-
+
Course Syllabus
- SECTION 1: Introduction
- SECTION 2: Spreadsheet navigation and formatting
- SECTION 3: Spreadsheet functions
- SECTION 4: Data clean-up
- SECTION 5: More spreadsheet functions
- SECTION 6: Conclusion
-
+
Recommended Background
- A computer (Windows, Mac, or Linux) with Internet access
- Any spreadsheet software, such as Microsoft Excel, LibreOffice, or OpenOffice
- Some rudimentary spreadsheet skills (data entry, basic calculations)
- A desire to learn!
This course is listed under
Open Source
, Development & Implementations
, Data & Information Management
and Operating Systems
Community
Related Posts: