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

Become a Customer Service Specialist Learning Path

Become a Customer Service Specialist Learning Path Discover how to provide great customer service and make your customers feel heard. Develop and sustain great relationships, even when customers get abusive or unruly. Learn skills to listen to customer needs, build rapport with those you're helping, and turn challenging customers into true allies. COURSES: Customer Service Foundations By: Jeff Toister Customer Service: Problem Solving and Troubleshooting By: Noah Fleming Building Rapport with Customers By: Myra Golden Customer Service: Call Control Strategies By: Myra Golden Customer Service: Handling Abusive Customers By: David Brownlee Creating Positive Conversations with Challenging Customers By: Myra Golden De-Escalating Intense Situations By: Myra Golden Customer Service: Serving Customers Through Chat and Text By: Leslie O'Flahavan

Dawid F. Prestini

Search This Blog