What you'll learn
How to import and manipulate data sets big or small
How to use macros to automate repetitive tasks
How to protect, freeze, and hide data in your spreadsheets
How to make data visualizations with images, charts, and pivot tables
How to customize the theme, colors, fonts, and layout of your spreadsheets
How to make dynamic spreadsheets with functions & conditional formatting
How to find and replace data on a large-scale with regular expressions.
How to gain insights from you data with filter views and slicers
How to collaborate and share your files with other people
How to do a data cleanup and a data extraction
Requirements
A working computer
A reasonably reliable internet connection
An accessible Google account
Description
Become an effective Google Sheets user and learn it through and through. Learning Google Sheets will help you A LOT!Learn to appreciate the power of the Google Sheets.Understand the ins and outs of Google Sheets Structure.Learn to use Google Sheets to build powerful tools to help you in your daily life.See how to approach breaking down and rearranging information to where it's more usableLearn shortcuts get things done faster.Learn macros to automate tasks.Learn how to create your own custom systems with Google Sheets.You will also find videos to help you understand complex concepts in a very simple way.There are several projects associated with the course allowing you to practice what you learn and make sure you are learning what you need.Who this course is for:anyone who wants to get started with Google Sheets.existing users or learners who wants to be effective at using Google Sheets lesser known features.Excel who wants to migrate to Google Sheets but are afraid to make the move!Those who already know Google Sheets but now want to go to the next level by understanding how to analyze large data sets and build and integrate third-party tools.
Overview
Section 1: Course Introduction
Lecture 1 Introduction Video
Lecture 2 The Course Structure
Section 2: Project: Exercise Tracker
Lecture 3 Creating the File
Lecture 4 Planning the Project
Lecture 5 Making the Key Page
Lecture 6 Filling out the Key
Lecture 7 Making our Schedule
Lecture 8 Adding Exercises
Lecture 9 Formatting and Clean Up
Section 3: File Menu
Lecture 10 Creating Files
Lecture 11 Open Files
Lecture 12 Import Files
Lecture 13 Make a Copy
Lecture 14 Sharing
Lecture 15 Email Files
Lecture 16 Download Files
Lecture 17 Rename Files
Lecture 18 Move
Lecture 19 Add Shortcut to Drive
Lecture 20 Deleting Files
Lecture 21 Version History
Lecture 22 Details
Lecture 23 Settings
Lecture 24 Printing
Section 4: Edit Menu
Lecture 25 Undo & Redo
Lecture 26 Cut, Copy, Paste
Lecture 27 Paste Special
Lecture 28 Move
Lecture 29 Delete
Lecture 30 Find and Replace
Section 5: View Menu
Lecture 31 Show
Lecture 32 Freeze Rows and Columns
Lecture 33 Group Rows and Columns
Lecture 34 Hide Sheets
Lecture 35 Zoom
Lecture 36 Full Screen
Section 6: Insert Menu
Lecture 37 Insert Cells
Lecture 38 Insert Rows and Columns
Lecture 39 Insert Sheets
Lecture 40 Insert Charts
Lecture 41 Customize Charts
Lecture 42 Pivot Tables
Lecture 43 Insert Images
Lecture 44 Insert Drawing
Lecture 45 Function Basics
Lecture 46 Other Insert Options
Lecture 47 The IF Function
Lecture 48 Insert Link
Lecture 49 Checkboxes
Lecture 50 Dropdowns
Lecture 51 Emojis
Lecture 52 Comment
Lecture 53 Notes
Section 7: Format Menu
Lecture 54 Theme
Lecture 55 Text
Lecture 56 Alignment
Lecture 57 Wrapping
Lecture 58 Rotation
Lecture 59 Font Size
Lecture 60 Font Family
Lecture 61 Text Color
Lecture 62 Fill Color
Lecture 63 Conditional Formatting
Lecture 64 Alternating Colors
Lecture 65 Clear Formatting
Lecture 66 Borders
Lecture 67 Merge Cells
Section 8: Data Menu
Lecture 68 Sort Sheet
Lecture 69 Sort Ranges
Lecture 70 Filters
Lecture 71 Filter Views
Lecture 72 Slicer
Lecture 73 Protect Data
Lecture 74 Named Ranges
Lecture 75 Named Function
Lecture 76 Randomize Ranges
Lecture 77 Column Stats
Lecture 78 Data Validation Rules
Lecture 79 Data Clean Up
Lecture 80 Split Columns
Lecture 81 Data Extraction
Section 9: Tools
Lecture 82 Forms
Lecture 83 Spell Check
Lecture 84 Autosuggest
Lecture 85 Notification Settings
People who love spreadsheets,People who enjoy using spreadsheets as tools to become more effecient,People who like learning new things,People who interested in working with data sets using spreadsheets





Download link

rapidgator.net:


uploadgig.com:


nitroflare.com: