Generated by All in One SEO v4.9.9, this is an llms.txt file, used by LLMs to index the site.

# Spreadsheet Class

Learn to automate and grow your business with spreadsheets

## Sitemaps

- [XML Sitemap](https://www.spreadsheetclass.com/sitemap.xml): Contains all public & indexable URLs for this website.

## Posts

- [How to copy and paste values only (Not formatting or formulas) in Google Sheets](https://www.spreadsheetclass.com/how-to-copy-and-paste-values-only-in-google-sheets/)
- [How to automatically create a series of values in Google Sheets](https://www.spreadsheetclass.com/automatically-create-a-series-of-values-in-google-sheets/)
- [How to color cells, and alternate row colors in Google Sheets](https://www.spreadsheetclass.com/color-cells-and-alternate-row-colors-in-google-sheets/)
- [How to filter based on a list in Google Sheets](https://www.spreadsheetclass.com/filter-based-on-a-list-in-google-sheets/)
- [Using the FILTER function in Google Sheets (Single or multiple conditions)](https://www.spreadsheetclass.com/google-sheets-filter-function/) - I am going to show you how to easily filter in Google Sheets, by using a formula. With the FILTER function you can filter data in any way that you want.
- [All the ways to extract text or numbers from a string in Google Sheets](https://www.spreadsheetclass.com/extract-text-or-numbers-from-a-string-in-google-sheets/)
- [6 formulas that combine columns in Google Sheets](https://www.spreadsheetclass.com/combine-columns-in-google-sheets/)
- [How to add and sum in Google Sheets (Addition and SUM function)](https://www.spreadsheetclass.com/google-sheets-add-and-sum/)
- [How to average in Google Sheets (AVERAGE function + mathematical method)](https://www.spreadsheetclass.com/google-sheets-average/)
- [2 ways to freeze rows & columns (& How to unfreeze) in Google Sheets](https://www.spreadsheetclass.com/freeze-unfreeze-rows-columns-in-google-sheets/)
- [Insert a new line in cells / formulas in Google Sheets (+ Automatic line break formulas)](https://www.spreadsheetclass.com/new-line-in-cells-or-formulas-in-google-sheets/)
- [Hide or show the toolbar menu in Google Sheets](https://www.spreadsheetclass.com/hide-show-menu-google-sheets/)
- [Adding a checkbox toggle switch to a formula in Google Sheets](https://www.spreadsheetclass.com/checkbox-toggle-switch-formula-in-google-sheets/)
- [Build a YouTube Dashboard in Google Sheets](https://www.spreadsheetclass.com/google-sheets-youtube-dashboard/)
- [Fast & Simple dashboard tutorial in Google Sheets (Build in under 15 minutes)](https://www.spreadsheetclass.com/simple-google-sheets-dashboard/)
- [How to build a dashboard in Google Sheets (Free Course)](https://www.spreadsheetclass.com/how-to-build-a-dashboard-in-google-sheets/) - Today I am going to teach you exactly how to analyze data, and build dashboards in Google Sheets. You will not need any special add-ons or apps.
- [Using the "Not Equal" sign in any formula in Google Sheets](https://www.spreadsheetclass.com/google-sheets-not-equal/)
- [TRANSPOSE function: Switch columns and rows in Google Sheets](https://www.spreadsheetclass.com/google-sheets-transpose-function/)
- [Math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square](https://www.spreadsheetclass.com/math-in-google-sheets-add-sum-subtract-multiply-divide-square/) - You can use functions or operators to do math in Google Sheets, and here I am going to show you how to use both, as well as how to use cell references with math.
- [How to use the SORT function in Google Sheets](https://www.spreadsheetclass.com/google-sheets-sort-function/) - The SORT function is an incredibly useful formula that you can use to sort your data in Google Sheets. I will show you all of the ways to use this function.
- [Using the SORT and FILTER functions together in Google Sheets](https://www.spreadsheetclass.com/google-sheets-sort-filter-functions/) - This lesson will show you how to use the Google Sheets SORT function and FILTER function together in a nested formula that both sorts and filters.
- [Using the UNIQUE function to remove duplicates in Google Sheets](https://www.spreadsheetclass.com/remove-duplicates-with-google-sheets-unique-function/) - The UNIQUE function is an incredibly useful function in Google Sheets, that can be used to remove duplicate entries, or in other words duplicate rows.
- [How to change text case in Google Sheets with UPPER, LOWER, & PROPER functions](https://www.spreadsheetclass.com/change-text-case-in-google-sheets-with-upper-lower-proper/)
- [ARRAYFORMULA & 5 ways to apply a formula to an entire column in Google Sheets](https://www.spreadsheetclass.com/using-arrayformula-to-apply-a-formula-to-an-entire-column-in-google-sheets/) - There is a very simple way to apply a formula to an entire column in Google Sheets, by using a special function called ARRAYFORMULA, which I will show you how to use in this lesson.
- [How to hide and unhide tabs in Google Sheets](https://www.spreadsheetclass.com/google-sheets-hide-unhide-tabs/)
- [7 ways to highlight duplicates in Google Sheets](https://www.spreadsheetclass.com/highlight-duplicates-in-google-sheets/)
- [Using the UNIQUE and TRANSPOSE functions together in Google Sheets](https://www.spreadsheetclass.com/google-sheets-unique-transpose-functions/)
- [Using the SORT and UNIQUE functions together in Google Sheets](https://www.spreadsheetclass.com/google-sheets-sort-unique-functions/)
- [How to convert currency in Google Sheets (Detailed examples)](https://www.spreadsheetclass.com/google-sheets-convert-currency/)
- [All the ways to round numbers in Google Sheets (ROUND, ROUNDDOWN, ROUNDUP)](https://www.spreadsheetclass.com/google-sheets-round-numbers/)
- [23 Best formulas for Google Sheets (+ Examples)](https://www.spreadsheetclass.com/google-sheets-best-formulas-examples-template-tutorial/)
- [Automatically resize columns (autofit column width) with "Fit to data" in Google Sheets](https://www.spreadsheetclass.com/automatically-resize-columns-in-google-sheets-with-fit-to-data/)
- [Using the FILTER and TRANSPOSE functions together in Google Sheets](https://www.spreadsheetclass.com/google-sheets-filter-transpose-functions/)
- [Sorting horizontally and using the SORT & TRANSPOSE functions together in Google Sheets](https://www.spreadsheetclass.com/google-sheets-sort-horizontally-sort-transpose-functions/)
- [Using the FILTER and UNIQUE functions together in Google Sheets](https://www.spreadsheetclass.com/google-sheets-filter-unique-functions/)
- [2 ways to format values as currency in Google Sheets](https://www.spreadsheetclass.com/google-sheets-currency-format/)
- [How to divide without a remainder in Google Sheets](https://www.spreadsheetclass.com/google-sheets-divide-without-remainder/)
- [Finding the greatest common divisor with the GCD function in Google Sheets](https://www.spreadsheetclass.com/google-sheets-greatest-common-divisor-gcd-function/)
- [Finding the least common multiple with the LCM function in Google Sheets](https://www.spreadsheetclass.com/google-sheets-least-common-multiple-lcm-function/)
- [Calculate days between dates (& days elapsed from row to row) in Google Sheets](https://www.spreadsheetclass.com/google-sheets-days-between-dates/)
- [Calculate duration between times and dates (time difference) in Google Sheets](https://www.spreadsheetclass.com/google-sheets-duration-between-times-and-dates/)
- [How to convert duration to decimal in Google Sheets](https://www.spreadsheetclass.com/google-sheets-convert-duration-to-decimal/)
- [Convert decimal to duration in Google Sheets (& converting to hours)](https://www.spreadsheetclass.com/google-sheets-convert-decimal-to-duration/)
- [Convert between duration, hours, minutes, and seconds in Google Sheets](https://www.spreadsheetclass.com/google-sheets-convert-between-duration-hours-minutes-seconds/)
- [Add or subtract days, months, or years to/from a date in Google Sheets](https://www.spreadsheetclass.com/google-sheets-date-add-or-subtract-days-months-years/)
- [Calculating percentage increase in Google Sheets](https://www.spreadsheetclass.com/google-sheets-percentage-increase/)
- [Copy / paste formatting + using paint format in Google Sheets](https://www.spreadsheetclass.com/google-sheets-copy-formatting-paint-format/)
- [Using duration format in Google Sheets](https://www.spreadsheetclass.com/google-sheets-duration-format/)
- [2 ways to remove duplicates in Google Sheets](https://www.spreadsheetclass.com/remove-duplicates-in-google-sheets/) - There are multiple ways to remove duplicates in Google Sheets, and in this article I am going to show you how to use the two main methods for removing duplicate entries / rows.
- [How to calculate percentage in Google Sheets](https://www.spreadsheetclass.com/google-sheets-calculate-percentage/)
- [How to capitalize all letters in Google Sheets with the UPPER function](https://www.spreadsheetclass.com/capitalize-all-letters-in-google-sheets-with-the-upper-function/)
- [How to make text lowercase in Google Sheets with the LOWER function](https://www.spreadsheetclass.com/make-text-lowercase-in-google-sheets-with-the-lower-function/)
- [Capitalize the first letter of words in Google Sheets with the PROPER function](https://www.spreadsheetclass.com/capitalize-the-first-letter-of-words-in-google-sheets-with-the-proper-function/)
- [Copying chart formatting, and duplicating charts in Google Sheets](https://www.spreadsheetclass.com/copying-chart-style-and-duplicating-charts-in-google-sheets/)
- [2 ways to convert decimal to percentage in Google Sheets](https://www.spreadsheetclass.com/google-sheets-decimal-to-percent/)
- [2 ways to convert decimals to fractions in Google Sheets](https://www.spreadsheetclass.com/google-sheets-decimal-to-fraction/)
- [How to convert fractions to decimals in Google Sheets](https://www.spreadsheetclass.com/google-sheets-fractions-to-decimals/)
- [Beginner's tutorial for Google Sheets](https://www.spreadsheetclass.com/google-sheets-beginner-tutorial/) - This beginner's Google Sheets tutorial will get you up to speed on a lot of really important Google Sheets concepts, from basic formatting, to using formulas.
- [How to export / create a CSV in Google Sheets (Download as CSV)](https://www.spreadsheetclass.com/google-sheets-export-csv/) - If you have data in a Google spreadsheet that you want to export into a CSV, Google Sheets has a very easy way of converting your spreadsheets into CSV files.
- [7 Reasons why your business should use Google Sheets](https://www.spreadsheetclass.com/7-reasons-why-your-business-should-use-google-sheets/) - There are lots of ways to use Google Sheets in your business, from storing data and safely sharing spreadsheets with staff, to analyzing important data.
- [How to import or convert a CSV into Google Sheets](https://www.spreadsheetclass.com/import-or-convert-csv-into-google-sheets/) - There is a super easy way to import CSV files into Google Sheets, and in this article I am going to teach you how.
- [Pull data from websites in Google Sheets with IMPORTXML (Web scraping)](https://www.spreadsheetclass.com/pull-data-from-websites-in-google-sheets-with-importxml-web-scraping/)
- [How to increase and decrease decimal places in Google Sheets](https://www.spreadsheetclass.com/google-sheets-increase-decrease-decimal-places/)
- [How to highlight text and cells in Google Sheets](https://www.spreadsheetclass.com/google-sheets-highlight-text-and-cells/)
- [How to use strikethrough in Google Sheets](https://www.spreadsheetclass.com/google-sheets-strikethrough/)
- [How to underline text and cells in Google Sheets](https://www.spreadsheetclass.com/google-sheets-underline/)
- [How to convert dates to text in Google Sheets](https://www.spreadsheetclass.com/google-sheets-date-to-text/)
- [How to convert dates to numbers in Google Sheets](https://www.spreadsheetclass.com/google-sheets-date-to-number/)
- [Make cells the same size / square in Google Sheets](https://www.spreadsheetclass.com/make-cells-same-size-make-cells-square-in-google-sheets/)
- [How to easily clear formatting in Google Sheets](https://www.spreadsheetclass.com/google-sheets-clear-formatting/)
- [Insert one or multiple columns in Google Sheets](https://www.spreadsheetclass.com/google-sheets-insert-columns/)
- [Highlight row based on cell values in Google Sheets](https://www.spreadsheetclass.com/highlight-row-based-on-cell-value-in-google-sheets/)
- [Fixing or removing the #DIV/0! error (divide by zero) in Google Sheets](https://www.spreadsheetclass.com/google-sheets-divide-by-zero-error/)
- [Fixing SUM function errors in Google Sheets (SUM not working or not correct)](https://www.spreadsheetclass.com/google-sheets-sum-error/)
- [How to divide in Google Sheets (Divide numbers, cells, columns, & rows)](https://www.spreadsheetclass.com/google-sheets-divide-numbers-cells-columns-rows/)
- [How to create a drop-down list in Google Sheets (Data validation)](https://www.spreadsheetclass.com/create-drop-down-list-in-google-sheets-data-validation-lesson/)
- [How to change the series order of a chart in Google Sheets](https://www.spreadsheetclass.com/change-series-order-of-a-chart-in-google-sheets/)
- [How to change column width in Google Sheets](https://www.spreadsheetclass.com/google-sheets-change-column-width/)
- [Change row height in Google Sheets (4 easy methods)](https://www.spreadsheetclass.com/google-sheets-change-row-height/)
- [Pulling cryptocurrency prices into Google Sheets (3 Methods)](https://www.spreadsheetclass.com/pulling-cryptocurrency-prices-into-google-sheets-2-methods/)
- [How to make a graph or chart in Google Sheets](https://www.spreadsheetclass.com/make-a-graph-or-chart-in-google-sheets/)
- [How to wrap, clip, or overflow (unwrap) text in Google Sheets](https://www.spreadsheetclass.com/wrap-clip-or-overflow-unwrap-text-in-google-sheets/)
- [How to fix the "FILTER has mismatched range sizes" error in Google Sheets](https://www.spreadsheetclass.com/filter-has-mismatched-range-sizes-error-in-google-sheets/)
- [How to fix the "Circular dependency detected" error in Google Sheets](https://www.spreadsheetclass.com/circular-dependency-detected-error-in-google-sheets/)
- [How to square, and calculate exponents in Google Sheets (Cube etc.)](https://www.spreadsheetclass.com/google-sheets-square-calculate-exponents/)
- [How to square root, and calculate roots in Google Sheets (Cube root etc.)](https://www.spreadsheetclass.com/google-sheets-square-root-calculate-roots/)
- [How to multiply in Google Sheets (Multiply numbers, cells, columns, & rows)](https://www.spreadsheetclass.com/google-sheets-multiply-numbers-cells-columns-rows/)
- [How to subtract in Google Sheets (Subtract numbers, cells, columns, & rows)](https://www.spreadsheetclass.com/google-sheets-subtract-numbers-cells-columns-rows/)
- [How to change tab color in Google Sheets](https://www.spreadsheetclass.com/google-sheets-change-tab-color/)
- [Google Sheets Templates for Teachers](https://www.spreadsheetclass.com/google-sheets-templates-for-teachers/)
- [Google Sheets Skills Test (Can you complete these projects?)](https://www.spreadsheetclass.com/google-sheets-skills-test/)
- [How to remove gridlines (& customize color) in Google Sheets](https://www.spreadsheetclass.com/google-sheets-remove-gridlines/)
- [Build a Google Sheets dashboard in 3 simple steps](https://www.spreadsheetclass.com/build-a-google-sheets-dashboard-in-3-steps/)
- [Insert one or multiple rows in Google Sheets](https://www.spreadsheetclass.com/google-sheets-insert-rows/)
- [How to change cell size in Google Sheets](https://www.spreadsheetclass.com/google-sheets-change-cell-size/)
- [Simple guide to changing date format in Google Sheets](https://www.spreadsheetclass.com/google-sheets-date-format/)
- [How to remove date formatting in Google Sheets](https://www.spreadsheetclass.com/google-sheets-remove-date-formatting/)
- [5 ways to insert bullet points in Google Sheets](https://www.spreadsheetclass.com/google-sheets-bullet-points/)
- [How to add an image to a cell (or over the cells) in Google Sheets](https://www.spreadsheetclass.com/google-sheets-add-image/)
- [How to copy a tab to another sheet / file in Google Sheets](https://www.spreadsheetclass.com/google-sheets-copy-tab-to-another-sheet-file/)
- [Move or copy a chart to another sheet in Google Sheets](https://www.spreadsheetclass.com/moving-copying-a-chart-to-another-sheet-in-google-sheets/)
- [Chart data from another sheet (Or multiple sheets) in Google Sheets](https://www.spreadsheetclass.com/chart-data-from-another-sheet-or-multiple-sheets-in-google-sheets/)
- [How to make a copy of a file in Google Sheets](https://www.spreadsheetclass.com/google-sheets-make-a-copy-of-a-file/)
- [How to duplicate tabs / sheets in Google Sheets](https://www.spreadsheetclass.com/google-sheets-duplicate-tabs/)
- [How to add a text box in Google Sheets](https://www.spreadsheetclass.com/google-sheets-add-text-box/)
- [Distribute columns evenly / make columns the same width in Google Sheets](https://www.spreadsheetclass.com/distribute-columns-evenly-in-google-sheets/)
- [5 ways to indent in Google Sheets](https://www.spreadsheetclass.com/google-sheets-indent/)
- [Get dates without weekends with WORKDAY & WEEKDAY in Google Sheets](https://www.spreadsheetclass.com/google-sheets-workday-function-weekday-function-dates-without-weekends/)
- [How to add a trendline to charts in Google Sheets](https://www.spreadsheetclass.com/google-sheets-trendline/)
- [How to alphabetize (with or without a formula) in Google Sheets](https://www.spreadsheetclass.com/google-sheets-alphabetize/)
- [Filter where cells contain / do not contain criteria in Google Sheets](https://www.spreadsheetclass.com/google-sheets-filter-contains/)
- [Insert checkboxes in Google Sheets (& Cool ways to use them)](https://www.spreadsheetclass.com/google-sheets-checkboxes/)
- [Pulling stock & crypto data with the GOOGLEFINANCE function in Google Sheets](https://www.spreadsheetclass.com/googlefinance-function-stock-crypto-data-google-sheets/)
- [How to filter horizontally in Google Sheets](https://www.spreadsheetclass.com/filter-horizontally-in-google-sheets/)
- [How to edit chart data range in Google Sheets](https://www.spreadsheetclass.com/edit-chart-data-range-in-google-sheets/)
- [How to chart multiple series in Google Sheets](https://www.spreadsheetclass.com/chart-multiple-series-in-google-sheets/)
- [How to rotate text (make text vertical + more) in Google Sheets](https://www.spreadsheetclass.com/rotate-text-in-google-sheets/)
- [How to copy a formula down an entire column (2 Methods) in Google Sheets](https://www.spreadsheetclass.com/copy-a-formula-down-an-entire-column-in-google-sheets/)
- [How to add a series to a chart in Google Sheets](https://www.spreadsheetclass.com/add-series-to-chart-in-google-sheets/)
- [Add / edit data labels or pie chart labels (slice labels) in Google Sheets](https://www.spreadsheetclass.com/google-sheets-data-labels-pie-chart-slice-labels/)
- [Insert, delete, rename, & organize tabs in Google Sheets](https://www.spreadsheetclass.com/insert-delete-rename-organize-tabs-in-google-sheets/)

## Pages

- [9 Budget and Expense Tracker Templates for Google Sheets](https://www.spreadsheetclass.com/7-google-sheets-budget-and-expense-tracker-templates/)
- [The Ultimate Cheat Sheet for Google Sheets](https://www.spreadsheetclass.com/best-google-sheets-cheat-sheet/)
- [Google Sheets Cheat Sheet (Formulas & Quick Reference)](https://www.spreadsheetclass.com/complete-google-sheets-cheat-sheet/) - This Google Sheets cheat sheet has all of the essential formulas, shortcuts, and spreadsheet operators that you need to make creating spreadsheets fast and easy
- [Attendance tracker templates for Google Sheets](https://www.spreadsheetclass.com/attendance-tracker-templates-for-google-sheets/) - These attendance tracker templates for Google Sheets will help you easily track student attendance, and will automatically calculate attendance rates for you.
- [24 of the best Google Sheets templates](https://www.spreadsheetclass.com/google-sheets-templates/) - These Google Sheets templates are great for businesses, teachers, and for personal use as well. Find the right template for your exact needs.
- [2026, 2027, & Automatic Calendar Templates (Monthly & Yearly) for Google Sheets](https://www.spreadsheetclass.com/google-sheets-calendar-templates/) - Here you'll find the best Google Sheets calendar templates, for any purpose. There are a wide variety of templates, so you can find the exact one that you need.
- [Google Sheets and PDF Guitar Tabs Templates](https://www.spreadsheetclass.com/google-sheets-and-pdf-guitar-tabs-templates/)
- [Google Sheets consulting](https://www.spreadsheetclass.com/consulting/) - Need help with Google Sheets? Spreadsheet Class can help you create the perfect spreadsheet for your business with our Google Sheets consulting services.
- [Build Dashboards with Google Sheets](https://www.spreadsheetclass.com/google-sheets-dashboards-course/) - Google Sheets provides an amazing free platform where data reports and dashboards can be built quickly, without having to have programming skills. In this course, you will learn how to turn plain spreadsheet data into amazing professional dashboards.
- [Dashboards Course for Google Sheets](https://www.spreadsheetclass.com/dashboards/)
- [Google Forms dashboard tutorial for Google Sheets](https://www.spreadsheetclass.com/google-sheets-customer-survey-dashboard-tutorial/)
- [Interactive dashboard tutorial for Google Sheets](https://www.spreadsheetclass.com/google-sheets-online-sales-dashboard-tutorial/)
- [Student attendance dashboard tutorial for Google Sheets (Simple + Advanced)](https://www.spreadsheetclass.com/google-sheets-student-attendance-dashboard-tutorial/)
- [Sales template (+expenses) for Google Sheets](https://www.spreadsheetclass.com/google-sheets-sales-template/)
- [About](https://www.spreadsheetclass.com/about/)
- [Contact](https://www.spreadsheetclass.com/contact/)
- [How to copy and paste values only (Not formulas or formatting) in Excel](https://www.spreadsheetclass.com/excel-copy-and-paste-values-only/)
- [How to filter based on a list in Excel](https://www.spreadsheetclass.com/excel-filter-based-on-a-list/)
- [Using the SORT and FILTER functions together in Excel](https://www.spreadsheetclass.com/excel-sort-filter-functions/)
- [Attendance tracker templates for Microsoft Excel](https://www.spreadsheetclass.com/attendance-tracker-templates-for-excel/)
- [Using the FILTER function in Excel (Single or multiple conditions)](https://www.spreadsheetclass.com/excel-filter-function/)
- [Automatically resize columns & rows (AutoFit column width / row height) in Excel](https://www.spreadsheetclass.com/excel-automatically-resize-autofit-columns-and-rows/)
- [How to copy a formula down an entire column (2 Methods) in Excel](https://www.spreadsheetclass.com/copy-formula-down-entire-column-in-excel/)
- [Microsoft Excel Lessons and Templates](https://www.spreadsheetclass.com/excel/)
- [Free Microsoft Excel Templates](https://www.spreadsheetclass.com/microsoft-excel-templates/)
- [Excel Gradebook Templates (Points + Percentage)](https://www.spreadsheetclass.com/gradebook-templates-for-microsoft-excel/)
- [Distribute columns evenly (make columns the same width) in Excel](https://www.spreadsheetclass.com/distribute-columns-evenly-in-excel/)
- [How to automatically create a series of values in Excel](https://www.spreadsheetclass.com/create-a-series-of-values-in-excel/)
- [2023, 2024, 2025, & Automatic Calendar Templates (Monthly & Yearly) for Excel](https://www.spreadsheetclass.com/excel-calendar-templates/)
- [5 formulas that combine columns in Excel](https://www.spreadsheetclass.com/formulas-that-combine-columns-in-excel/)
- [Checklist / To-do list templates for Google Sheets](https://www.spreadsheetclass.com/google-sheets-checklist-to-do-list-templates/)
- [Contact list template for Google Sheets with built in search](https://www.spreadsheetclass.com/google-sheets-contact-list-template/)
- [Daily, Weekly, & Monthly Schedule templates for Google Sheets](https://www.spreadsheetclass.com/google-sheets-schedule-templates/)
- [Data organizer / calculator template for building reports in Google Sheets](https://www.spreadsheetclass.com/google-sheets-report-builder-template/) - With this report generator you will be able to quickly organize / analyze your data, and build professional reports without having to use any formulas.
- [Excel & PDF graph paper templates (How to make + Premade)](https://www.spreadsheetclass.com/excel-pdf-graph-paper-templates/)
- [Google Sheets and PDF graph paper templates](https://www.spreadsheetclass.com/google-sheets-and-pdf-graph-paper-templates/)
- [Google Sheets Gradebook Templates (Points and Percentage)](https://www.spreadsheetclass.com/google-sheets-gradebook-templates/) - These Google Sheets gradebook templates will allow you to easily record grades, and will also automatically calculate and color code for you.
- [Google Sheets Language Translation (Template & Instructions)](https://www.spreadsheetclass.com/google-sheets-language-translation/) - This article will teach you how to use the Google Sheets language translate formula, and I will also give you a language translation template for Google Sheets.
- [House Hunting Template for Google Sheets (Organize your job search)](https://www.spreadsheetclass.com/google-sheets-house-hunting-template/)
- [How to fix a circular reference error in Excel](https://www.spreadsheetclass.com/excel-fix-circular-reference/)
- [How to use the SORT & SORTBY functions in Excel](https://www.spreadsheetclass.com/excel-sort-and-sortby-functions/)
- [Inventory Template for Google Sheets (Multi-use)](https://www.spreadsheetclass.com/google-sheets-inventory-template/) - This inventory template for Google Sheets will make tracking your inventory very easy, and will help you track the purchase & sales price of your inventory.
- [Job application tracker template for Google Sheets](https://www.spreadsheetclass.com/google-sheets-job-application-tracker-template/)
- [List templates (Movies & shows, books, music, general) for Google Sheets](https://www.spreadsheetclass.com/google-sheets-list-templates/)
- [Loan payoff calculator template for Google Sheets](https://www.spreadsheetclass.com/google-sheets-loan-payoff-calculator-template/)
- [Math problem solver template for Google Sheets (Algebra, Fractions, Quadratic, & more)](https://www.spreadsheetclass.com/google-sheets-math-problem-solver-template/)
- [Math worksheets & math problem generator template for Google Sheets (Math testing template)](https://www.spreadsheetclass.com/google-sheets-math-worksheets-template/)
- [Project Management Timeline Templates for Google Sheets (Gantt Chart)](https://www.spreadsheetclass.com/project-management-timeline-templates-for-google-sheets/) - These daily, weekly, and monthly project timelines in Google Sheets will allow you to easily keep track of tasks, with a color coded Gantt chart.
- [Stock tracker templates for Google Sheets (Portfolio + watchlist)](https://www.spreadsheetclass.com/google-sheets-stock-tracker-templates/)
- [Tic Tac Toe Game Template for Google Sheets](https://www.spreadsheetclass.com/google-sheets-tic-tac-toe-game-template/)
- [Using array formulas to apply a formula to an entire column in Excel](https://www.spreadsheetclass.com/apply-formulas-to-entire-column-with-arrays-in-excel/)
- [Weightlifting tracker template for Google Sheets](https://www.spreadsheetclass.com/weightlifting-tracker-template-for-google-sheets/)
- [Privacy Policy](https://www.spreadsheetclass.com/privacy-policy/)
- [Terms and Conditions](https://www.spreadsheetclass.com/terms-and-conditions/)

## Media Hub

- [](https://www.spreadsheetclass.com/media/9186/)
- [24 templates for Google Sheets: For business, teachers, and fun](https://www.spreadsheetclass.com/media/8986/)
- [Create a dashboard: Full tutorial](https://www.spreadsheetclass.com/media/create-a-dashboard-full-tutorial/)
- [Hide or show the toolbar menu in Google Sheets](https://www.spreadsheetclass.com/media/8961/)
- [Beginner Video](https://www.spreadsheetclass.com/media/beginner-video/)
- [Sort and Filter video](https://www.spreadsheetclass.com/media/sort-and-filter-video/)
- [Cheat Sheet Video](https://www.spreadsheetclass.com/media/cheat-sheet-video/)
- [Fast Dashboard Video Tutorial](https://www.spreadsheetclass.com/media/fast-dashboard-video-tutorial/)

## Categories

- [Google Sheets Formulas](https://www.spreadsheetclass.com/category/google-sheets-formulas/)
- [Google Sheets Formatting](https://www.spreadsheetclass.com/category/google-sheets-formatting/)
- [Google Sheets Tips](https://www.spreadsheetclass.com/category/google-sheets-tips/)
- [Google Sheets Error Troubleshooting](https://www.spreadsheetclass.com/category/google-sheets-error-troubleshooting/)
- [Microsoft Excel Formulas](https://www.spreadsheetclass.com/category/microsoft-excel-formulas/)
- [Microsoft Excel Formatting](https://www.spreadsheetclass.com/category/microsoft-excel-formatting/)
- [Microsoft Excel Tips](https://www.spreadsheetclass.com/category/microsoft-excel-tips/)
- [Microsoft Excel Error Troubleshooting](https://www.spreadsheetclass.com/category/microsoft-excel-error-troubleshooting/)
- [Google Sheets Templates](https://www.spreadsheetclass.com/category/google-sheets-templates/)
- [Microsoft Excel Templates](https://www.spreadsheetclass.com/category/microsoft-excel-templates/)