Create a slug maker inside your sheet. We'll take any title with any case, even if it's wrong. Our sheet template will lower case the whole line, and replace any spaces with hyphens. This way we can enter any kind of title we want and get a hyperlink slug out for use in blogs or cataloging.

Learn how to use Formulas in Google Sheets. Use the Equal sign "=" to unlock a magical portal of over 500 functions and formulas. Learn one cool trick that even experts might not know about formulas.

The video explains three ways to count cells or information in Google Sheets: using the Explorer, using the COUNT function, and using the COUNTALL function. The Explorer is a tool located at the bottom right of the screen that allows you to quickly understand your data and find the count of items in a column. The COUNT function allows you to count the number of cells that contain numbers in a range of cells, while the COUNTALL function counts all the cells in a range, including those that contain formulas or are blank. The video also mentions other functions such as SUM and UNIQUE

Discover effective methods to handle misspelled duplicates in Google Sheets using formulas without destroying your data. Search and find duplicates that are spelled differently.

Unveiling the Art of Taming Misspelled Duplicates: A Harmonious Symphony of Google Sheets Tricks and Tips

Embark on a captivating journey as we unravel enchanting secrets in this video guide.

Discover an ethereal dance of formulas that transcends the limitations of Google Sheets' native features, gracefully addressing the conundrum of misspelled duplicates. 

Delve into the profound intricacies of the issue, where statuses and names intertwine, inviting chaos into your CRM or meeting records. 

Witness the mesmerizing revelation of unorthodox yet elegant techniques that preserve your data's essence without sacrificing its integrity. Unveil the hidden world of the duplicate detector, where rows are harmoniously synchronized, leaving no spelling errors unnoticed. 

Prepare to be enchanted by the sublime artistry of equals unique, a symphony of transformation that transforms hundreds or thousands of rows into a carefully curated masterpiece. Immerse yourself in this poetic quest and unlock the mystique of finding truth amidst a sea of missteps.

How to figure out a percentage score when our reporting numbers are a formatted in a particular way. In this case we have a score and then a slash and then the total possible score in a single cell. We go through each option of solution and try to derive a solution that is both useful in the exact situation and possibly useful for other problems too.

We find that the Query formula and other solutions are inflexible or time intensive. We want a solution that does actually solve the problem at hand, in a quick way, and also is easy to edit and flexible to solve other problems.

Wanted to share with members this course outline I am using for my own course making process. I outlined the course then added a bunch of cool little stats to help see my progress and keep me on a certain pace of video creation. 

Learn How to Take Your Google Sheets Checkbox to the Next Level and Get More Organized! Click Now to Discover Creative Ways to Use Checkboxes and Boost Your Productivity!

We're going to take a basic function of Google sheets, which is the checkbox, and we are going to take it to its nth degree.