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...

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, ...

Mind Control: Managing Your Mental Health During COVID-19 Certificate

University of Toronto - 4 wks Course Professor Steve Joordens Department of Psychology University of Toronto Never in the history of humanity have so many people been feeling intense anxiety related to COVID-19 and the world it will leave in its wake. The intent of this course is to give you a deeper understanding of the anxiety reaction as it relates to various aspects of our current life, ranging from our consumption of news to the way we talk to our children about this. I will also give you clear strategies for managing and, in fact, turning off the anxiety response at least for short periods. My sincere hope is that you will leave this course with a better understanding of how your brain reacts to crises, along with some powerful tools for managing it before it manages you. University of Toronto Established in 1827, the University of Toronto is one of the world’s leading universities, renowned for its excellence in teaching, research, innovation and entrepreneurship, as well as...

Dawid F. Prestini

Search This Blog