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

Facebook Social Media Marketing Professional Specialization

📚 Facebook Social Media Marketing Specialization 🕐 7 months UCLA - Anderson School of Managment This six-course program, developed by digital marketing experts at Aptly together with Facebook marketers, includes industry-relevant curriculum designed to prepare you for an entry-level role in social media marketing. After an introduction to digital marketing and the main social media platforms, you’ll learn to establish an online presence, create posts, build a following, and manage your social media accounts. You’ll develop skills in creating and managing advertising campaigns in social media and learn to evaluate the results of your marketing efforts. Most importantly, throughout the program you’ll get to practice your new skills through hands-on projects, the results of which you can showcase through a portfolio of your work. Upon successful completion of the program, you’ll earn both the Coursera and the Facebook Digital Marketing Associate Certificati...

Stanford Introduction to Food and Health - Stanford University Certificate

Stanford Introduction to Food and Health - Stanford University Certificate Around the world, we find ourselves facing global epidemics of obesity, Type 2 Diabetes and other predominantly diet-related diseases. To address these public health crises, we urgently need to explore innovative strategies for promoting healthful eating. There is strong evidence that global increases in the consumption of heavily processed foods, coupled with cultural shifts away from the preparation of food in the home, have contributed to high rates of preventable, chronic disease. In this course, learners will be given the information and practical skills they need to begin optimizing the way they eat. This course will shift the focus away from reductionist discussions about nutrients and move, instead, towards practical discussions about real food and the environment in which we consume it. By the end of this course, learners should have the tools they need to distinguish between foods that will support the...

Strategies for Assisted Living Communities during COVID-19 Certificate

Johns Hopkins University - 1 WEEK Morgan Katz, MD, MHS; Juliana Bilowich;Alice Bonner, PhD, RN; Robin Jump, MD, PhD; and Molly Nace, MPH SARS-CoV-2, the virus that causes COVID-19, poses a high risk for assisted living communities due to residents’ age, health status, and communal living environment. The COVID-19 response has largely focused on nursing homes, leaving assisted living communities in the United States with fragmented guidance on how to respond to COVID-19 challenges. This course provides comprehensive instruction and resources for administrators and direct-care staff of assisted living communities. Learners will hear from experts about best practices to prevent COVID-19 outbreaks and promote well-being. Topics discussed include development of emergency preparedness plans, infection and outbreak prevention, staffing considerations, testing, and contact tracing. The course also covers strategies for communicating with stakeholders, promoting resident and staff well-being, ...

Dawid F. Prestini

Search This Blog