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.


      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
      premium consulting
      marketing biznes
      premium consulting

      By continuing to use the site, you agree to the use of cookies. more information

      The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.