Terms

Feb 21, 2025
Google Sheets expert Ben L Collins

"I worked as an accountant over the past 8 years and utilized Microsoft Excel every day for long durations of time" begins Google Sheets and Apps Script an expert teacher Ben L Collins. "Almost everything I was working on were completed with the help of Excel however, I wasn't familiar with the fundamentals of how Excel was about. I'd written some codes, but I didn't know much about spreadsheets.

"Pretty in the initial weeks that I worked, I was approached by my supervisor to complete some tasks with Excel like "Combine the tables" in addition to "Combine both tables. It was a challenge as I was required to finish the task manually!" His supervisor described the usage of formulas that were used to speed up the process. Ben soon realized that one of the crucial capabilities required of people working in finance is the ability to alter the data.

"The individuals who possess the capability to succeed in this specific field stand far from the ones who appear to be in chaotic," Ben continues. I was thinking "Right right now I'm probably required to improve my skills and found many websites on the internet including mrexcel.com and chandoo.org People who utilized these websites used exactly similar workflows to what me is doing today, utilizing the power of Excel in the last 15 years."

The more Ben was able to glance at spreadsheets and data like he could and become more interested "It became the tunnel which was becoming more fascinating." Ben knew that the majority of instructions in programming he received in the course of his college education could be executed using programs that interface with databases. This is a case of VBA.

As a certified accountant, accountants were most attracted by the most modern technologies. They were also particularly fascinated and enthralled by accounting finances. "After more than eight years within a profession which I loved and was happy with, I thought I was done!. I was unsure of what the next step would be. The first thing I thought of was being a pro with programming." Ben tells me.

Ben L Collins speaking at an event later in the night.

He took a few courses after which he started applying for jobs. "It wasn't a huge idea, but I started building my own website, along with 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 and also pay-per-hour job opportunities.

"In the period between 2014 and 2015. I was able to take a variety of customers' calls that were incoming and were asking "Hey Do you need assistance to create my dashboard with spreadsheets, spreadsheets or some 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 improve their efficiency? ? '."

The job called for Excel, Google Sheets, SQL as well as Tableau. "It wasn't a real work rather a case of think"Maybe there's something that can be located in the field. Maybe I'll be an independent contractor instead of being an employee returning to the post that was the previous position . The plan isn't for me to return to the accounting job I held previously!" Ben smiles. "I am always trying to keep myself up in the newest technological developments in the area involves research and development."

Goodbye accounting, hello education

The website for education which was initially launched in the year 2000 by the General Assembly was just a initial concept and was currently in the process of creating classes for professionals who are programmers an analytics analyst. "They are developing a class for students who are part-time working in the field of study of data. As I've been in one of their classes within the program that was developed by students for programmers, I've met some of the students who attended the class. After they made the announcement about data, they instantly began recruiting instructors. The syllabus was designed by using Excel, SQL and Tableau," Ben continues. "I was thinking"Ooh this is what I was doing at the age of eight years young. ! '." The applicant was through the process of selection for interviews before being selected. He was later appointed an instructor for a number of occasions during the program.

"That was the reason I became an instructor in the future" Ben recalls. "I'd taught at a university level, and I was the instructor of students prior to beginning my final year of the college." The initial steps were to incorporate the element of corporate training in the courses on the internet, which included instructional videos as well as classes. "As I noticed an increase in number of visitors to my website, I was in awe of the idea to develop my own online course and then test it to find out how practical it would be to establish it."

A course on the Query function in Google Sheets

) A brief introduction to Google Query. Google Query is one of the features in Sheets

The content of the course was a huge success, and led Ben to design a fresh course. "I used Teachable which is a web-based application Teachable to determine how I could maintain contact with my students so in sustaining the relationships instead of transferring this connection onto the marketplace online for example, Udemy."

I ran through a Google search, and among the names that appear on the web came up as Ben Thompson. Ben Thompson is the founder of the tech-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 am able to look at the different ways other members use Flowing Data along with Craig Mod's use of similar techniques." Ben was studying the member's newsletters for an extended period of time. I was interested in learning about the strategies that were used to run their businesses based on their member. I thought "I want my company to adopt the same strategies used by them.'. I was impressed by how simple and easy the process was. I was thinking"I want to get an experience of being a part of the community..'

It is vital to maintain the rate of growth.

This is due to the fact that Ben's subscription is high top-quality (or "gated") information accessible via WordPress and an online newsletter which is excellently delivered to readers via emails using Kit (formerly ConvertKit). For data to be provided The primary focus will be on Google Sheets that include features along with updates and alternatives and methods to use this application to the fullest extent.

"The coming newsletter will include specific information on the latest and most recent instruments Google has launched over the past year." Ben adds. The features are highly beneficial and let you modify the information. The tutorial will come with a video along with the URL that will allow you to open Google Sheet. Google Sheet template that people could download for themselves. The presenter also states that discussion will be expected to take place with respect to the topic that will be debated. "I utilize newsletters to give more information on the subject and to also provide Google Meet. Google Meet link for the live meeting."

As a response to a query concerning where the company's future is going, Ben thinks membership could be the basis of his business. "I am looking for the company to recruit new members. I'd prefer membership be the only choice," he says. "I am a current member of an online library which provides no cost content. If you'd like to join, you can join as an expert in order to help me in my tasks and keep me informed on all information that has been updated."

Z6fYkdbv3adzawtsO is a simulation the Chess game. The game was developed by using Google Sheets

The writer claims it is possible to provide consulting services as well as to incorporate advertisements into his monthly newsletter. The author plans to expand his strategies for doing this "if I can grow my membership to the enough level to eliminate doubts. There's a myriad of concerns to be considered, but expanding the membership of your group is essential. "

There's an array of opportunities to help in the expansion of his service. "I've considered for a long length of time over ways to improve the quality of my radio broadcasts at live events, particularly as we plan to increase the number of more members during the next year. This service will have changes. This service will not be significantly altered, but the process continues to evolve."

The writer also states that he'd like to establish an online community that allows users to interact with each with regards to the problems they're dealing with and issues they'd like to solve "That is possible through "office timetables" or some other method for reaching out" in the event that you're doing it in a manner that's sufficient effectiveness and in a manner that is acceptable for all parties.

Ben says that at the present, all communication with his clients takes place via email. "I think you should send your customer an email with the subject message "Hi I'd love to hear your views'. My preferred method is straightforward to use.

The man was well-known for being an active participant on discussion forums in addition to his sessions of co-operation where people worked on Google Sheets problems online as members of a team. "We were at two similar sessions like this in 2021. They are extremely popular. The experience was great however, it was stressful during the first five weeks. It was as if everything seemed to be a "firehose overflowing with" inquiries. It was my first time with a group like this. I'm concerned that after you turn on the light, it's going to be a challenge to shut off the light completely. It's something I'm thinking about. how you would approach this issue for the coming period?

"I haven't taken the time to stream live on in any way prior to the moment I started my venture. However, I thought"Just try it live to check out how it goes. Find out if I enjoy the live stream before taking a the decision to sign up to any thing.' It's working! The proprietor of the business is thinking about including live entertainment into their program "They're fun and attendees get satisfaction out of these events. Learn how they do it!"

Ben hosting a Zoom session for his members

Ben is responsible for Zoom sessions with clients.

"Right this moment, I'm giving a lecture on the topic I've picked and teaching in live classes." according to him, live classes are the most effective way of learning. In the classes in groups, there was more of a debate which was quite open "People were asking questions like 'Hey, what's the issue which I'm having a hard time understanding? My brain is confused.' Discussions would take place right at the time. Discussions will be open to members of the public. Discussions will be held during the next semester. This is a great chance for students to get involved."

At the end of the day, Ben thinks it's feasible to create Discord forums to answer questions and give another alternative. However, he states "I only want to be confident that I'm able to deal with the problems without hindering my own personal life." It appears that Ben is on the path to creating a continuous, steady and constant co-operation with his staff. We think that maintaining this connection over time is essential for the long-term sustainability of involvement with the local community "Little Activities" and we'll work to build this up over time!" He is 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 author of web-based classes as well as blog articles on the many features that Google offers through its Workspace tools. My focus is on investigating data and making processes more efficient using Google Sheets and Apps Script.

Ben L Collins website

Ben L Collins' website

He's a proponent of creating essential, data-driven programs which can be integral to in the Google Google stack. It includes Google Sheets, Looker Studio, Google Apps Script, Forms, Docs, Gmail along with a variety of additional apps. For more details, visit benlcollins.com.

The first time that this article was published was on this website. the site

The original article was originally published here.

The article originally was published on this website. This page on the internet

This article first appeared on this web site. is available.

This article was originally posted on this website.

The article originally appeared on on this site.

This post was first seen on this site

Article was first seen on here