We welcome you to this course of approach to the world of programming. The code is the engine that moves all the technology around you and an interesting job option. Discover what is expected in this training and what are our objectives.
This product is no longer in stock
In this course you will learn to get the most out of Google sheets, knowing all its features and the tools it offers. You will learn from scratch with a spreadsheet and learn the most common formulas and the most complex. You will discover the importance of access and Multidevice organization in Google sheets and decide to adopt it in the day to day of your company.
Advantages of Google sheets and first steps
What is Google sheets 01:50
How to access and organize Google sheets 06:00
How to create and import a 04:08 worksheet
The Google Sheets Interface: the 05:15 toolbar
Sheet management in Sheets 05:13 document
Cell, column, and row management in Google sheets 06:18
Comments on sheets, how to insert and resolve comments 04:20
How to create filters in Google sheets 04:12
Conditional formatting on a sheet of Google sheets 05:14
The Find and Replace tool in Google sheets 03:12
Access and Multidevice organization in Google sheets
Working with offline files from your browser 02:36
Working with offline files from a 04:08 computer
Mobile Access: How is the app for IPad 02:45
Enabling or disabling mobile offline access 03:40
Collaborative work on Google sheets
Benefits of collaborative worksheets on Google sheets 04:07
Options when sharing on Google sheets 04:51
The version history of Google sheets 03:18
Share link to a specific cell of Google sheets 03:18
Basic functions and formulas
Add and subtract values with sum () and minus () 03:22
Get the average of the values with mean () 01:39
Get maximum or minimum value with Max () and MIN () 02:26
Get the number of items with COUNT () 01:56
✓ Challenge: Watch the minimum sale price 01:07
✓ Solution: Watch the minimum sale price 03:19
Google Sheets advanced Features and formulas
Access the list of advanced features of Google sheets 02:22
Advanced features of Google sheets: Search 05:25
The date function in Google sheets 04:23
Introducing advanced formulas with Google 04:55
The logic function of Google sheets 02:50
How to use math function in sheets 05:53
The text in Google sheets 07:03
Graphics and dynamic tables in Google sheets
How to insert graphics in Google sheets 02:24
How to customize graphics on Google sheets 05:14
How to create and filter a PivotTable in Google sheets 04:14
Size: 311 MB
Trainers: Marc Alonso Martínez
Content: 34 Videos
Duration: 2:12 hours
Base files: If included
Totally virus free and malicious software, so don't wait any longer on Descargartelo now.
Don't forget to give us an opinion about the course, to improve the content.
Note: Do not forget to follow us on our social networks of Facebook and Twitter to form part of our community and receive the notification every time we publish something new, so you will not miss anything.
NO registration required!
If the question you have has not yet been answered here, use the form below to ask something about this addon.