Terms

Feb 19, 2025
Google Sheets expert Ben L Collins

"I was bookkeeper for the last 8 years. I worked with Microsoft Excel daily for several hours" is the first sentence of Google Sheets as well as AppsScript Professional Teacher Ben L Collins. "Almost every task I performed with my computer was accomplished by using Excel but I did not know anything about Excel prior to that. I was a programmer before, but had no prior knowledge of spreadsheets.

"Pretty when I started working at the time I was offered an opportunity under my boss. I was expected to complete numerous tasks within Excel such as "Combine tables" as well as others. Then, I was required to finish the job with my hands!" His supervisor showed him that formulas can be utilized to simplify the procedure. Ben realized that one of the key skills that you should have in the field of finance might be the ability to alter the information.

"The those who have the ability to do this feat successfully will have an advantage over the ones who don't," Ben continues. I thought "Right I'm thinking of increasing my abilities." I found a myriad of sites that I thought about for example, mrexcel.com and chandoo.org They provide the same features that I have, however when the way they were developed was using Excel around 15 years ago."

The more Ben was able to look at spreadsheets and formulas more intrigued he got "It was the rabbit hole leading down to the depths of darkness." Ben realized that the programming education was taught at his school could be combined together with different programming languages, which will aid in creating databases. It could be VBA.

While working as an accountant, he became attracted to the latest technological advances and not the field of financial or accounting. "After eight years being an accountant within the field of accounting I thought"I'm done! I'm done!. I wasn't sure what the next stage of my strategy was, but the first idea I thought of was the subject of engineering." Ben tells me.

The full name is. Ben L Collins speaking in a conference that took place at night.

He was enrolled in a couple of classes before beginning to search for a job. "It was not an overwhelming initially, however I did set up my own website, and also write essays. One of the first pieces I created was on Google Sheets and they're those that eventually became Google Search." It resulted in a wide range of clients seeking the assistance of freelancers in exchange for cash for their services.

"In 2014, and in which ended in the year 2015, we witnessed more requests from customers who needed assistance "Hey can I be assisted by creating a dashboard using spreadsheets or sheets? or "Can you review my Excel spreadsheets we've got to help our organization and aid me in determining which method is best to optimize the formulas? ? '."

The position called for Excel, Google Sheets, SQL and Tableau. "It was an ordinary job but it offered me the chance to consider"Maybe this is a sign that something is more. It is possible that I could become freelance and never have to go back to my previous work . I'm not planning to return to accounting!" Ben smiles. "I will always be on top of my game in addition to my understanding of the latest technological advances."

Goodbye accounting, hello education

The beginning of the mission of this website was to provide learning opportunities General Assembly was just a idea of a business concept that was initially a start-up. The company plans to provide courses for programmers with advanced skills and data analysts. "They have also announced an online program for analysis of information. This is only a part-time program. As I had been involved in one of their courses specially designed for developers, I had a good idea of those that were in the program. When I was at the inception of this program, their first program on data was first time they began to locate instructors. It was a class that included Excel, SQL and Tableau," Ben continues. "I began to think"Hey! This is precisely what I've done for the past eight years. ! '." Ben had to go through an interview procedure, and was offered the position. Ben also conducted the interview process Ben numerous times.

"That inspired me to return to the teaching profession" Ben recalls. "I'd been employed as a teacher at the college and tutored young students after I had completed my academic year." He also provided instruction to companies by offering online classes, offering tutorials and courses. "As I started to increase the number of customers that found my services appealing, I decided to start my own company and to figure out what the future market would be similar to."

A course on the Query function in Google Sheets

) A course on the Google Query feature within Sheets

The teaching style of the course was widely known. The course was so well-known which attracted Ben to create a new course. "I used the site Teachable in order to figure out a method to create a connection that was unique to my students as well as to make sure that I was able to hold the course for myself, rather than releasing it to markets, like Udemy."

When I was doing my research, I came across some names that are frequently used. The name came from Ben Thompson, the title of Ben Thompson, editor of Stratechery The Tech Newsmagazine Stratechery, Ben Thompson. Ben Thompson is often referred to as"the OG!" Ben smiles. "I have signed up for two different subscriptions in order to see how other companies such as Flowing Data and Craig Mod have done." Ben is looking at their newsletters, regardless of his age. He was an adolescent. I was curious to learn what they did to structure their business on subscriptions. I was thinking "I want my business to be run exactly the way they did.'. It was simple and easy to start thinking"I wish to feel exactly the same way in my role as an associate..'

The way forward is one which is future

In reality, the current subscription package includes top-quality (or "gated") information and is run on WordPress along with an exclusive newsletter delivered via email, which is made possible by Kit (formerly ConvertKit). To learn more about this service, click here. is based using Google Sheets and includes specific information about the capabilities of the program and its changes as well as ways to get the most benefit from the software.

"The coming newsletter will provide details on the most current tools Google has made available in the last 12 months," Ben adds. Google Sheets can be extremely beneficial that allow users to modify data. It's the reason you'll be in a position to view a video tutorial regarding Google Sheet's features and also it's possible to download Google Sheet, which is the Google Sheet template you can download. Additionally, he'll have individual discussions about the subject. "I make use of emails to deliver specific information regarding the time of day and the place. Additionally, I use Google meet. Google Meet link for the live chat."

If you want to know what next steps to take for the business, Ben thinks membership could become the main source of revenue for the business. "I definitely want to attract many members since I would want to make membership my primary service I offer," he says. "I provide an assortment of free information, however it is also feasible to become a member in good standing by purchasing the premium version, or assist me in getting access to additional information."

A thrilling game of Chess using Google Sheets Google Sheets

The author claims to be competent to offer consultations and advertising in the journal he writes, but the aim of his blog is conclude by saying "if I'm able to get sufficient people to sign up, I would like to eliminate the other issues. There are minor concerns to be considered but increasing the number of members is vital. "

He's thought of a variety possibilities for extending the types of events that is organized by him. "I've thought of a few ways to improve the efficiency of organizing the activities in real-time. We've also thought of suggestions that could help more members get involved in the coming year. The program itself is changing. It will be consistent with what you expect However, you will see it stream real-time content."

One member says that he'd like to figure out how best to let members share their data issues they're working on as well as questions they'd like to be able to address over the next couple of months "That could be done using "office timers" or some other technique effective in addressing questions" so long as the process is executed in a long-lasting, efficient and cost-effective manner that's beneficial for all those in the process.

Ben affirms that the bulk of his communications with followers are via emails. "I believe that you should reply with a message like 'Hey, provide me a short explanation of the project you're working on'. It's enjoyable because it's easy to manage.

Chats on forums could be offered in a similar fashion to "cohort classes" which allow students to work through Google Sheets issues online together in smaller groups. "We had two completed in 2021, as they're on the cutting edge of technological innovation. It's an impressive feat, but it was extremely challenging in the first five months we took part in. It was always a flood of inquiries. There's been some time since I joined this community before, but I'm concerned that if I choose to alter my membership once more and I'm not able to stop the group. It's a thing I'd like to consider, but how do solve this dilemma from a long-term standpoint?

"I didn't have live streams in the present. I started thinking"Just start streaming, and then see how people react. See if I like the live stream before I commit to the whole thing. The stream is working great! The proprietor is eager to bring live entertainment "They're enjoyable and viewers appreciate the advantages of these programs. It's interesting to keep track of what's happening!"

Ben hosting a Zoom session for his members

Ben is host of Zoom Sessions for his guests.

"Right at the moment I'm delivering lectures on subjects selected by me. This topic is then discussed during the live course," he continues. This technique was developed in order to reach a broad population "People could walk into the class and state "Hey I'm struggling with a difficulty that I'm having trouble with. I'm having trouble in this way and I'm trying to resolve the problem" They'd then be able to discuss the topic during the live discussion. Other participants would have the ability to observe. We'll think about this in the coming year. It's a fantastic opportunity for all to take part."

Ben is convinced of creating an online platform for answering questions could be an option, but he says "I simply want to make sure that I'm in a position to complete the task in a way that's not taking up a lot in my personal time." This conversation indicates Ben is currently in working on laying the basis to guarantee a continuous and constant contact with his clients. It is our opinion that sustaining a bond with time is crucial to the life of any community "Little steps, but eventually we'll expand our audience!" He smiles.

More details

Ben Collins is an educator as well as a software expert. He is the co-founder of The Collins School of Data. Ben Collins develops online classes as well as writes to Google Workspace. Google Workspace tools. My primary focus is automated processes for analyzing data with the help from Google Sheets and Apps Script.

Ben L Collins website

Ben L Collins' website

He's an advocate of making lightweight software depended on information. It works alongside the Google range of applications: Google Sheets, Looker Studio, Google Apps Script, Forms, Docs, Gmail along with many others. For more details, visit benlcollins.com.

The article was first spotted by this. is accessible.

The original article was posted on this website.

The article was first published on this website.

This article was originally posted on this blog.

This article first appeared on here

This post was first seen on here