Office Productivity Google Sheets:  Chart & Formula

Google Sheets: Chart & Formula

10.00 10.00

  • Course Delivery: On Demand
  • Duration: 0.3
  • Language: English
  • Difficulty: Intermediate
  • Audience: Google Sheets users

Chat Live | Contact Us | Toll Free: (888) 360-8764



When creating a spreadsheet, you frequently find yourself wanting to analyze your data. This can be done in the form of calculations or you can use predefined calculations called functions when trying to find the answers you need. In the analysis of your data, you can filter out data that you don’t need to see, and you can sort the data that remains visible. Depending on the type of data you have, you can solve linear equations to determine the answers to challenging problems, and you can even display your data in the form of a chart or graph. This online training series will show you how Google™ Spreadsheets make creating formulas, functions, and charts a simple task.

Topics Covered

Getting Started

  • What you’ll learn in the training

Working with Data

  • Sorting data
  • Filtering data
  • Filtering and sorting data
  • Searching data
  • Using Data Validation
  • Using the Quick Access toolbar
  • Using Auto Fill
  • Using Solve
  • Creating a filter view
  • Renaming a filter view
  • Applying an existing filter view
  • Saving a filter as a filter view

Creating & Editing Charts

  • Adding a chart to your spreadsheet
  • Editing and deleting a chart
  • Editing in Advanced mode
  • Moving and resizing a chart
  • Moving a chart to its own sheet
  • Exporting your chart as an image
  • Publishing a chart

Inserting & Editing Images

  • Inserting an image from your computer
  • Inserting an image from a Webcam
  • Inserting an image from you Web albums
  • Inserting an image from a URL
  • Inserting a drawing image
  • Searching for images using Google images
  • Editing an image in your spreadsheet
  • Deleting an image in a spreadsheet

Additional Chart Types

  • Exploring different chart types
  • Exploring Pivot tables
  • Creating a Pivot chart
  • Working with the Report Editor
  • Working with categories and fields
  • Sorting, summarizing, and filtering data
  • Formatting a Pivot table report

Working with Functions & Formulas

  • Using formulas
  • Using Sum and Count functions
  • Using Min and Max functions
  • Using the Average function
  • Using formula across sheets
  • Using range names
  • Using functions
  • Browsing other formulas and functions
  • Create a new formula
  • Using range-selection mode

Got questions? Contact us below or call 877-881-2235

Why Choose

  • Fast and easy courses completion
  • Get an education faster than at traditional colleges!
  • 100% online - No classroom attendance required.
  • Unlimited 24x7 online customer support
  • Over 500,000+ certified nationwide.