Description
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 SheetsEnter and edit data in Google SheetsAdjust the way data and information are displayed in Google SheetsWrite formulas quickly and easilyLeverage data with Vlookup, Hlookup, Index, and Pivot Tables Use relative, absolute, and mixed references in Google SheetsCreate powerful calculations with Google Sheets functionsVisually represent your data with charts and graphs in Google SheetsUse data tools like sorting, filtering, and filter viewsUtilize freeze panes in Google SheetsFormat worksheets in Google Sheets for impact and appealLearn shortcuts, tips, and tricksLearn how to use commenting and sharing in Google SheetsAs 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
