Tag: Ben Collins

Replied to 2018 in review and a look forward to 2019 - Ben Collins (Ben Collins)
Create two other courses. The shortlist at the moment includes: 1) “Beyond Sheets” on what to do when your data outgrows Google Sheets, 2) Regular Expressions in Google Sheets, 3) a Data Studio course, and 4) Google Sheets for Educators
Congratulations on your year Ben.

Thought I would place my vote for the ‘education’ course. Although all of your courses provide insight and opportunities within education, I feel that there is real scope for an explicit education offering. Although there are some great offerings in regards to introductions (including your own), I think that a course which collated a range of educational scenarios would be a real benefit.

RSVPed Interested in Attending https://courses.benlcollins.com/p/apps-script-blastoff
A free, introductory course teaching Google Apps Script from scratch
I have long had an interest in Google Apps Scripts. However, I have really gotten past simply appropriating other people’s code, especially Martin Hawksey’s work.

I have read a number of posts:

I look forward to this new offering. I always enjoy the way in which Collins’ breaks things down with his courses.

RSVPed Interested in Attending https://www.crowdcast.io/e/pivot-tables-101
Come and learn how to use Pivot Tables in Google Sheets. This webinar will last for approximately 1 hour. All the example datasets will be made available to registered users.
I have watched Ben Collins’ webinars in the past, they are always well thought out and a great introduction to his longer courses. He has also written an introductory post.
Bookmarked 18 best practices for working with data in Google Sheets - Ben Collins (Ben Collins)
This article describes 18 best practices for working with data in Google Sheets, including examples and screenshots to illustrate each concept in action.
Ben Collins provides a guide for working with data in Google Sheets. Some of the useful steps that stood out were documenting the steps you take, adding an index column for sorting and referencing, creating named ranges for your datasets and telling the story of one row to check the data. Another tip I picked up from Jay Atwood has been to import data, if moving from Excel to Sheets, rather than simply copying and pasting.