Spreadsheets for Beginners using Google Sheets Certificate

Completed by Dawid F. Prestini

May 1, 2021

12 hours

Grade Achieved: 95%

Certifies their successful completion of Spreadsheets for Beginners using Google Sheets

This 12-hours long guided tutorial is an introduction to spreadsheets. We’ll be using Google Sheets in this tutorial, which is the free spreadsheet program offered by Google. With that said, most of the concepts that you will learn in this tutorial will be applicable to other spreadsheet programs, such as Microsoft Excel. We will cover the following concepts in a hands-on manner: - Basic data entry, formatting and calculations
- Relative and absolute cell references - Basic functions: concatenate, split, sum, average, median, min, max, count, counta
- Advanced functions: vlookup, if, and, or, iferror, countif, countifs, averageif, averageifs, sumif, sumifs - Dealing with error messages
- Conditional formatting - Filtering and sorting
- Basic charts to visualize our data We will end the tutorial by applying these concepts and create a basic spreadsheet model that helps us analyze household expenses.

Task 1: The Basics - Basic data entry, formatting and calculations
Task 2: Cell References - Relative and absolute cell references
Task 3: 9 Basic functions
Task 4: Dealing with error messages
Task 5: 11 Advanced functions
Task 6: Formatting, conditional formatting, sorting and filtering
Task 7: Building our expense model
Task 8: Basic charts to visualize our data

Comments

Create an A/B web page marketing test with Google Optimize

Create an A/B web page marketing test with Google Optimize Completed by Dawid F. Prestini May 2, 2021 1.5 hours Grade Achieved: 80% Certifies their successful completion of Create an A/B web page marketing test with Google Optimize In this 12-hours long project-based course, you will learn how to create an A/B web page marketing test with Google Optimize and Google Analytics, personalizing weight option, goals, targeting, activation, and using a sample Google Sites to practice. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions. Intro and get started with Google Optimize Activate Google Optimize, Analytics and install the extension Create a sample Google Site Install Optimize, Analytics and set up the first experience Create a page variant for A/B testing Set up page and audience targeting Create objectives Finish additional settings, traffic allocation and ac...

Introduction to Web Development Certificate

📖 I ntroduction to Web Development Certificate Daniel Randall Web Dev. Instructor University of California Davis 🕐 6 wks Completed by Dawid F. Prestini April 14, 2021 6 weeks of study Grade Achieved: 82.92% Certifies their successful completion of Introduction to Web Development This course is designed to start you on a path toward future studies in web development and design, no matter how little experience or technical knowledge you currently have. The web is a very big place, and if you are the typical internet user, you probably visit several websites every day, whether for business, entertainment or education. But have you ever wondered how these websites actually work? How are they built? How do browsers, computers, and mobile devices interact with the web? What skills are necessary to build a website? With almost 1 billion websites now on the internet, the answers to these questions could be your first step toward a better understanding of th...

Giving Helpful Feedback Certificate

Giving Helpful Feedback Certificate Completed by Dawid F. Prestini April 25, 2021 5 weeks of study Grade Achieved: 92% Certifies their successful completion of Giving Helpful Feedback This course teaches you the simple principles expert managers use to improve and motivate employee performance. You’ll never have to avoid telling an employee “the truth” again, because the seven techniques we teach will not make employees defensive or afraid. As a manager, or someone who would like to be a manager, you’ll also learn specifically what feedback is, how negative feedback is weighed more heavily than positive, and how positive feedback can super-charge behaviors such as creativity and teamwork. Giving feedback is a skill which develops over time. We give you a process you can use to improve your feedback skills and deliver it with confidence. You will find that there is a scientific basis for many of your observations and intuitions about feedback—such as, it is hard to give ...

Dawid F. Prestini

Search This Blog