تفاصيل الدورة

Google Sheet is an extremely powerful alternative to Microsoft's Excel spreadsheet software. Jon will teach you step-by-step how to create a basic spreadsheet and analyze the. This course covers all the essentials that will help you manipulate and analyze large sets of data. Of course, you will learn the fundamentals such as the basic calculations, formulas, creating charts, and tips & tricks that will get you started quickly.

By the end of this introductory course, you will feel confident maneuvering around Google Sheets and gain instincts to use it effectively for data analysis, and ultimately adding value to your company or to your own personal life.

In this course you will learn how to:

  • Effectively and efficiently navigate around Google Sheets
  • Enter and edit data in Google Sheets
  • Adjust the way data and information are displayed in Google Sheets
  • Write formulas quickly and easily
  • Leverage data with Vlookup, Hlookup, Index, and Pivot Tables
  • Use relative, absolute, and mixed references in Google Sheets
  • Create powerful calculations with Google Sheets functions
  • Visually represent your data with charts and graphs in Google Sheets
  • Use data tools like sorting, filtering, and filter views
  • Utilize freeze panes in Google Sheets
  • Format worksheets in Google Sheets for impact and appeal
  • Learn shortcuts, tips, and tricks
  • Learn how to use commenting and sharing in Google Sheets

  • As a fun bonus material, you will also learn how to create art with Google Sheets!

    Enroll today in this course! We are 100% confident that you will learn


تحديث بتاريخ 22 March, 2018
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Soft Skills ابتداءً من الآن. See all courses

قيِم هذه الصفحة