Ebook – 101 tricks in Google Spreadsheets

Ebook – 101 tricks in Google Spreadsheets

Why was this ebook written?

We have noticed that a significant number of companies and individuals have yet to profit from using the full potential of Google Sheets.

We hope that the set of guidelines contained in this ebook will help improve the work and collaboration of many teams.

Brand24

Knowledge contained in this publication should be canonic to anyone who wants to get the most out of Google software.

Marketing i Biznes

Free knowledge is often associated with low-quality content, but this ebook proves that it’s not always the case. Have you ever thought about using sheets in your company? If so, this ebook is a must-have

Szymon Słowik

Although I’ve been using Google Sheets in my daily work for years, I admit that I wasn’t aware of all the possibilities until the lecture of this guide. I’d recommend it to anyone who wants to find out how versatile this tool can be.

Robert Marczak

This practical guide collects all the handy functions of Google Sheets in one place. Thanks to the ebook, you’ll be able to plan the work of a whole team using only Google tools.

101 tricks

We want to share with you our extensive experience with working on Google Sheets.

magic wand image

Collection of tricks

yes image

Useful hints

shooting image

Practical examples

paint palette and brush image

Ready-made templates

Table of Contents

We believe in transparency,

so take a peek at what’s waiting for you inside our publication:

współpraca image

1. Cooperation

Access management, range protection and history of changes – how to work safely in teams on company’s data.

ctrl cmd skroty klwiszowe image

2. Useful shortcuts

Macros, formulas and shortcut keys – we present the best ways to speed up your work.

bazy danych image

3. Databases

Importing data from other spreadsheets, stock exchange and websites – collection of all possible methods.

podstawowe formuly image

4. Basic calculation formulas

7 most commonly used formulas that are the basis of building custom formulas.

formatowanie image

5. Formatting

Presenting large amounts of data in a clear and comprehensible way.

wizualizacja danych image

6. Data visualization

A few methods of creating compelling charts and tables.

intergacje image

7. Integrations with other Google services

Creating reports and dashboards within the Google ecosystem.

polecane dodatki image

8. Useful add-ons

Broadening the functionality of Google Sheets with selected third-party plugins.

edytor skryptow image

9. Script editor – code your own functions in Sheets

Customisation of functions and add-ons in Google Sheets.

gotowe szablony image

10. Ready-made templates

10 ready-to-use templates that you can use in your daily work.

download the ebook

Partners of this publication:

marketing biznes
SzymonSlowik.pl
narczak.me
premium consulting
damianrams.pl
programuj.pl
Wroclife
marketing biznes
SzymonSlowik.pl
narczak.me
premium consulting
damianrams.pl
programuj.pl
Wroclife