Terms

Feb 21, 2025
Google Sheets expert Ben L Collins

"I was an accountant over the past eight years, and used Microsoft Excel every day for long durations of time" commences Google Sheets and Apps Script an expert teacher Ben L Collins. "Almost everything I worked on was done using Excel however, I wasn't knowledgeable about the basics of what Excel worked. I'd written some codes but didn't really know anything about spreadsheets.

"Pretty In the beginning of the time during which I worked on the project, I was asked by my supervisor to complete certain tasks using Excel for example "Combine the tables" in addition to "Combine two tables. This was an uphill task as I had to do the work by hand!" The supervisor of his team explained the application of formulas to help speed up the process. Ben soon realized that among the crucial capabilities required of those working in finance is the capability to modify the facts.

"The ones who are able to demonstrate the capacity to be successful in this particular field are in stark contrast to those who seem to be chaos," Ben continues. I was thinking "Right this moment, I'm likely required to improve my skills and I came across a number of websites on the internet including mrexcel.com and chandoo.org Users of these sites had exactly the same processes to the ones I'm currently doing, using the power of Excel in the last 15 years."

The more Ben could look at charts and other data the way the data he had, and became more attracted "It turned into the tunnel, which was getting more intriguing." Ben realized that the bulk of the programming instructions that he was taught during the course of college education could be executed through programs that interact with databases. This is an example of VBA.

A certified accountant accounting professionals were attracted to the most modern technologies. They were also fascinated and enthralled by accounting finances. "After over eight years in a field which I enjoyed and was happy with, I thought I had finished!. I was unsure of what next steps to take. One of the first things I thought of was being a pro when it came to programming." Ben tells me.

Ben L Collins speaking during an event later into the night.

He took a few courses before he began to apply for jobs. "It wasn't a huge idea, but I started developing my own website as well as writing blog posts. My initial articles that I made were all related with Google Sheets and they're the ones that I discovered within Google Search." Google Sheets brought in a number of requests from users including pay-per-hour possibilities.

"In the time between 2014 and 2015. I could take a variety of customers' calls that were incoming and asked "Hey Do you require assistance to create my dashboard with spreadsheets, spreadsheets and other spreadsheets? This is "Can you look at my business spreadsheets and assist me in determining how I could tweak my spreadsheets in order to make them more efficient? ? '."

The job called for Excel, Google Sheets, SQL as well as Tableau. "It wasn't really a job rather a case of think"Maybe it's possible that something can be discovered within the field. Perhaps I'll become an independent contractor rather than being an employee returning to the post which was my previous job . My plan isn't returning to the position I previously had!" Ben smiles. "I am always trying to stay up-to-date with the most recent technological advances that are related to developing and research."

Goodbye accounting, hello education

The site for education that was initially launched in the period 2000 through the General Assembly was just a first idea and is currently in the process of creating courses for professionals who are programmers an analytics analyst. "They are developing a class for students who are part-time employed in the field of studying data. As I've been in the course within the program that was developed by students to programmers I've spoken with some of the students who took the course. When they announced the news concerning data, they quickly began to recruit instructors. The curriculum was developed making use of Excel, SQL and Tableau," Ben continues. "I was thinking"Ooh that's what I was doing when I reached 8 years old. young. ! '." The applicant was selected in interviews prior to being picked. Later, he was made to be an instructor on a couple instances during the course.

"That was the reason that I was a teacher in the future" Ben recalls. "I'd taught at a university level, and I taught students prior to beginning my last year at the school." The initial steps were to incorporate the element of corporate training into the classes on the internet, which included instructional videos as well in courses. "As I saw the increase in visitors to my website and was amazed of the concept to create my own online course before attempting to determine how feasible it would be to establish the course."

A course on the Query function in Google Sheets

) A quick description of Google Query. Google Query is one of the options that are available in Sheets

The content of the course was extremely successful, which led Ben to create a new course. "I used Teachable which is a web-based software Teachable to figure out how I could keep in touch with my students so in maintaining the connections rather than transferring the connection onto the marketplace online like, Udemy."

I ran through the results of a Google search, and the names appearing in the search results was as Ben Thompson. Ben Thompson is the founder of the technology-focused magazine Stratechery. Ben Thompson. Ben Thompson is known as"the OG!" Ben is having fun. "I have been in numerous times within the group and I'm able to take a study the many methods other members utilize Flowing Data as well as Craig Mod's usage of similar methods." Ben was looking over the members' newsletters for an extended duration of time. I was interested in learning about strategies used to run their businesses based on their newsletters as a member. I thought "I would like my business to follow the same methods that they employ.'. I was amazed by how easy and simple to follow the procedure. I was thinking"I would like to have an experience of being a part in the group..'

It is vital to maintain the rate of growth.

This is due to Ben's newsletter is top quality (or "gated") information available via WordPress as well as an online newsletter that is delivered with great care to subscribers via email using Kit (formerly ConvertKit). The data that is provided will be the primary focus is on Google Sheets with features as well as updates, alternatives and ways to utilize this program to its fullest extent.

"The coming newsletter will include specific information on the latest and most up-to-date instruments Google has introduced during the past year." Ben adds. The functions are very beneficial and let you modify the data. This tutorial includes videos and the URL which will permit users to open Google Sheet. Google Sheet template that people might download them. It also mentions that discussion will be scheduled to occur in relation to the subject to be debated. "I utilize newsletters to give further information regarding the subject and to also provide Google Meet. Google Meet link for the live meeting."

To answer an inquiry about where the future of the business is, Ben thinks membership could become the foundation of his company. "I would like to find a business to find new members. I'd prefer membership be the only choice," he says. "I am a registered subscriber to an online library, which offers gratis content. If you'd like joining it, you are able to join as an expert to aid me in my duties as well as keep me up to date of all new information that's been revised."

Z6fYkdbv3adzawtsO simulates the Chess game. The game was developed by utilising Google Sheets

The writer claims it is possible to provide consultancy services and also include advertisements in his monthly newsletter. The writer is planning to extend his strategies for doing this "if I can grow my members to a amount to remove doubts. There are a variety of issues that need to be addressed, but increasing the size of your group is essential. "

There's an array of opportunities to help in the expansion of his service. "I've been thinking for a lengthy length of time over how to increase the efficiency of my radio broadcasts during live events. This is especially so as we plan to increase the number of more members during the next year. The service is going to undergo adjustments. The service won't be drastically altered, but the process continues to evolve."

The author also says that he'd like to establish an online community that allows members to communicate with one another regarding the issues they're facing as well as questions they'd like to address "That could be possible with "office timetables" or any other means for reaching out" provided that you're doing it with sufficient efficiency and with a method that is acceptable for everyone involved.

Ben states that, at moment, communication with his clients takes place through email. "I consider that you must mail your customer an email with the subject message "Hi I'd like to hear your views'. This is my preferred approach. It's straightforward to use.

The man was well-known for his active participation on forums for discussion and also for his hours of cooperation where colleagues were working with Google Sheets problems online as members of a group. "We participated in two events like this in 2021. These sessions are very popular. The experience was great however, it was stressful during the initial five weeks. The whole experience seemed to be a "firehose that was bursting with" inquiries. I was the first being in this kind of group. It's a concern for me that after turning on the lights it will be difficult to turn off the light completely. That's the question I'm pondering. How would you approach this question for the upcoming time?

"I had not taken the initiative to live stream at all prior to the time I began my venture. However, I thought"Just give it a go live and test the waters. Check out whether I am enjoying streaming live before making an action to sign up to any thing.' It's working! The proprietor of the business has been thinking of incorporating live entertainment into their program "They're enjoyable and the guests enjoy these occasions. Learn how they do it!"

Ben hosting a Zoom session for his members

Ben is the person responsible for Zoom sessions with clients.

"Right right now I'm giving a talk on the topic I've picked and delivering live lectures." According to him, live courses are the most effective way to learn. For the group classes the atmosphere was more an argument that was open "People were asking questions like "What's your issue that I'm having a difficult to comprehend? My brain is confused.' Discussions are scheduled to take place at the time. Discussions are open to members of the public. Discussions will take place during the next semester. This is a fantastic opportunity students to be involved."

At the end of the morning, Ben thinks it's feasible to set up Discord forums to answer questions and give another alternative. However, he states "I only want to be confident that I'm able to tackle the issues while not affecting my private life." This suggests Ben is on the right track toward establishing a consistent and ongoing collaboration with his staff. It is our opinion that keeping this connection over years is vital to an ongoing and sustainable involvement with the local community "Little activities" and we'll continue to strengthen this connection in the future!" He's smiling.

More details

Ben Collins is an educator and writer. Ben Collins is also an expert in computer programming. Ben Collins is the founder of The Collins School of Data. Ben is the writer of web-based classes as well as blog articles about the numerous features Google gives users via its Workspace tools. My primary focus is to study information and improving processes efficient with Google Sheets and Apps Script.

Ben L Collins website

Ben L Collins' website

He's a proponent of creating vital, data-driven applications that could be a key component of the Google Google stack. It comprises Google Sheets, Looker Studio, Google Apps Script, Forms, Docs, Gmail along with a variety of other applications. For more details, visit benlcollins.com.

The first time that this piece was published was through this site. the site

The original article was published on this site.

The article originally was published on this site. This page is available on the web

This article first appeared on this website. is now available.

The article originally appeared on this website.

The original article was published on this site.

The post first appeared on this website.

This article first appeared on here

This post was posted on here