
Google Sheets
Google Sheets is a spreadsheet program that is part of the vast suite of applications Google provides, all of which are available online anytime, anywhere. With sheets, you can analyze and organize data, design charts, implement calculations, create macros and collaborate easily with others.rnThis course will begin with the fundamentals of Google Sheets. You will learn how to navigate the interface, understand the terminology, create basic spreadsheets, format data and manage your files on the Google platform. You will then learn how to utilize numerous formulas and functions along with sorting and filtering your data. With Sheets you will be able to help others understand data through a visual chart. By learning how to work with pivot tables, macros, add ons and templates you can truly master the program. Most importantly, this course will teach you how to easily collaborate with others by sharing files and keeping those files safe by restricting permissions.rnGoogle Sheets is a vast program that can help you both in a professional or personal setting. Work through this course and master Sheets so you can be efficient and effective with data.
Course content
Welcome1 lessons
Fundamentals4 lessons
Sheets Basics5 lessons
Sheets Essentials7 lessons
- Formatting basics4:261 credit or ad
- Colors, borders, & merging cells3:151 credit or ad
- Paint format & Removing Formatting2:271 credit or ad
- Links, comments & notes5:221 credit or ad
- Themes & alternating colors3:201 credit or ad
- Views & freezing or hiding data5:291 credit or ad
- Conditional formatting2:281 credit or ad
Managing Your Files3 lessons
Data4 lessons
Working with Data7 lessons
Calculations6 lessons
- Formula basics - Mathematical operations3:331 credit or ad
- Addition & Subtraction2:571 credit or ad
- Multiplication & Division2:221 credit or ad
- Relative, Absolute and Mixed cell references pt. 13:241 credit or ad
- Relative, Absolute and Mixed cell references pt. 23:101 credit or ad
- Range names2:391 credit or ad
Formulas & functions20 lessons
- Sum & SumIf3:411 credit or ad
- Average, Median & Mode3:561 credit or ad
- AverageIf2:541 credit or ad
- Maximum & minimum4:451 credit or ad
- Count, countA, countIf5:581 credit or ad
- If3:091 credit or ad
- Comparison operators5:081 credit or ad
- and & Or5:071 credit or ad
- Today, now & date6:471 credit or ad
- Calculate time3:491 credit or ad
- Calculate days, months & years3:191 credit or ad
- Split3:491 credit or ad
- Concatenate4:171 credit or ad
- Trim1:461 credit or ad
- Clean & duplicates2:481 credit or ad
- Proper2:501 credit or ad
- Substitute4:561 credit or ad
- Transpose1:351 credit or ad
- Random number3:271 credit or ad
- Vlookup4:061 credit or ad
Charts & Graphs21 lessons
- Visual representations of data5:451 credit or ad
- Chart basics5:461 credit or ad
- Pie chart5:061 credit or ad
- Column chart6:001 credit or ad
- Bar chart5:571 credit or ad
- Line chart7:091 credit or ad
- Combo chart5:461 credit or ad
- Area chart pt. 16:021 credit or ad
- Area chart pt. 24:321 credit or ad
- Scatter chart3:201 credit or ad
- Histogram chart4:231 credit or ad
- Candlestick chart3:001 credit or ad
- Organizational chart4:121 credit or ad
- Tree Map chart1 credit or ad
- Geo chart3:251 credit or ad
- Waterfall chart4:141 credit or ad
- Gauges chart4:101 credit or ad
- Table chart2:161 credit or ad
- Timeline chart2:561 credit or ad
- Radar chart4:251 credit or ad
- scorecard chart1:581 credit or ad