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

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

Dawid F. Prestini

Search This Blog