Overview

A warm welcome to the Google Sheets course by Uplatz.Google Sheets is the spreadsheet application software available within Google's cloud-based office suite. Google Sheets has been designed with the needs of agile organizations in mind. AI features mean you can tap into the right insights to make meaningful business decisions. A cloud-based architecture enables you to collaborate with anyone, anytime, anywhere. Compatibility with external systems, including Microsoft Office, removes the friction of working with multiple data sources. Based on Google's infrastructure, Sheets provides the flexibility to create amazing spreadsheets while helping to keep your information secure.Google sheets is being used by more and more companies instead of Microsoft Excel. There are many advantages to using Google Sheets the main one being the ability to share a sheet with multiple users. It is free to use and works in a browser! So there is no need to install anything on your machine neither to buy any license.This Google Sheets training course by Uplatz will get you used to Google sheets and be able to create and manage it in practical situations even if you have never used spreadsheets before. The Google Sheets course will introduce you to the basics of creating spreadsheets using the free Google Sheets application. This course will teach you some of the essential features of Google Sheets and how they can be used to work together in an interactive and graphical way. You will be able to take a deep-dive into all the features and options available in Google Sheets. This Google Sheets training provides detailed demonstration on how to use functions, build pivot tables, charts, formatting, filtering, sorting, AI-based and dynamic functions, analyze data on the fly, and more in Google Sheets.Course Topics at high-levelAn Introduction to Google SheetsCreate a new Google SheetName a SpreadsheetUpload an Existing Excel SpreadsheetEdit CellsUse Auto-fillFormat CellsFormat Text and NumbersBasic Formulas and FunctionsUse the Sum functionCreate and Copy Formula using Auto-fillSort and Filter dataFinding your way around Google SheetsOpening FilesMove data from Excel Files to Google Sheets and vice-versaWhat about saving files?File ManagementAdding/Deleting WorksheetsRenaming WorksheetsBasic FormattingFormatting NumbersDealing with DatesChanging the TypefaceAdding more fontsAdding ColorsFormat PainterFormulas in Google SheetsBasic ArithmeticOperator PreferenceAbsolute ReferencesUsing FunctionsCalculating between WorksheetsPrinting Google SheetsSelecting a print areaFitting everything onto a pageCreating a PDFPrinting all sheetsSharing a Google SheetChoosing people to share withRestricting EditingPreventing others from downloaded and printingGoogle Sheets course curriculumIntroductionMenu Options - FileMenu Options - EditMenu Options - ViewMenu Options - InsertMenu Options - FormatMenu Options - Data and moreEntering Data and FilteringFunctions - Numeric FunctionFunctions - Text FunctionFunctions - Data FunctionsCharts and Conditional FormattingPivot TablesSaving, Sharing, CollaborationCourse ObjectivesLearn how to navigate around Google SheetsLearn how to adjust the way data and information are displayedLearn how to write formulas quickly and easilyLearn how to create powerful calculationsLearn how to visually represent your data with charts and graphsLearn how to use data tools like sorting, subtotaling, and filteringLearn Google sheets shortcuts, tips, tricks

Skills

Reviews