Terms

Feb 21, 2025
Google Sheets expert Ben L Collins

"I worked as an accountant for the last 8 years and utilized Microsoft Excel every day for long durations of time" starts Google Sheets and Apps Script an expert teacher Ben L Collins. "Almost all the tasks I worked on was accomplished making use of Excel however, I wasn't aware of the fundamentals of the basics of what Excel was about. I had written a few codes, but I did not know anything about spreadsheets.

"Pretty in the initial weeks I worked, I was approached by my supervisor to complete several tasks in Excel for example "Combine the tables" as well as "Combine the tables. It was a challenge as I was expected to finish the job by hand!" His supervisor explained the application of formulas that were used to speed up the procedure. Ben quickly realized that among the crucial capabilities required of those who work in finance is their capability to modify the information.

"The individuals who possess the capability to succeed in this specific field stand an impressive distance from those who seem to be chaos," Ben continues. I thought "Right right now I'm probably to have to develop my abilities and I found a myriad of web-based sites such as mrexcel.com as well as chandoo.org The people who used these websites used exactly similar workflows to what me today, utilizing the power of Excel for the last fifteen years."

The more Ben was able to glance over data and spreadsheets as he did and the more interesting grew "It was the tunnel which was becoming more fascinating." Ben was aware that the majority of instructions in programming he received in his time at college could be executed using programs that communicate with databases. This includes VBA.

When he was an expert certified accountant, accountants were most fascinated with the latest technology. They were also particularly fascinated in love with accounting for financials. "After over eight years of being in a field that I enjoyed, I felt thinking I was done!. I didn't know what the next steps would be. The first thing I thought of was becoming a professional at programming." Ben tells me.

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

He took a few courses following which he began applying for positions. "It wasn't a huge plan, but I did begin building my own website, as well as began writing blog posts. My initial articles that I made were all related to Google Sheets and they're the ones I found in Google Search." Google Sheets brought in a number of requests from users and also pay-per-hour employment.

"In the period between 2014 and 2015. I had the opportunity to receive a number of customer calls which were inbound and asking "Hey Do you require help in creating my dashboard using spreadsheets, spreadsheets or some other spreadsheets? This is "Can you look at my business spreadsheets and assist me in determining how I will be able to tweak my spreadsheets so as to improve their efficiency? ? '."

The task required Excel, Google Sheets, SQL as well as Tableau. "It wasn't a real work, but more an instance of think"Maybe there's something that can be found in the sector. Maybe I'll be an independent contractor, instead of being a returnee to the position of previously held . It's not in the plan for me to return to the accounting job I held previously!" Ben smiles. "I want to stay current with the latest technological advances in the field that of development and research."

Goodbye accounting, hello education

The website for education which was initially launched in the year 2000 by General Assembly was just a idea in its beginnings and was currently in the process of creating classes for professional programmers along and analytics analysts. "They are developing a class for students who are part-time in the field of the analysis of data. Because I've taken one of their classes within the program that was developed by students for programmers, I know some of the students who attended the class. When they announced the class about data, they instantly began recruiting instructors. The syllabus was created using Excel, SQL and Tableau," Ben continues. "I was thinking"Ooh that's what I did when I was only eight years young. ! '." The applicant went through the selection process for interviewing before being accepted and was subsequently appointed an instructor for a number of occasions during the course.

"That led to me becoming an instructor again" Ben recalls. "I'd taught at a college level and was an instructor to kids prior to starting my final semester in college." Initial steps included adding an element of corporate training into the courses online, including tutorials as well as lessons. "As I noticed an increase in the quantity of people who visited my website, I was inspired to create my own course, and then test it to find out how practical it would be to put in place it."

A course on the Query function in Google Sheets

) An introduction to Google Query. Google Query is a feature of Sheets

The material of the course was well-received, and it inspired Ben to create a new course. "I made use of Teachable, an web-based service Teachable to figure out how I could keep in contact with my students as well as to maintain the relationship rather than transfer this relationship onto the marketplace online, such as Udemy."

I ran a Google search, and found one of the names to pop up on the internet came up as Ben Thompson. He is the proprietor of the tech-oriented magazine Stratechery. Ben Thompson. Ben Thompson is known as"the OG!" Ben is having a blast. "I am in many times in the club and am in a position to observe the ways others members utilize Flowing Data along with Craig Mod utilized similar strategies." Ben was reading through the members' newsletters for a long amount of time. I was interested in learning about the strategies that were employed to manage their businesses based on member. I thought "I would like my own business to follow similar strategies employed by them.'. I was impressed by how easy and simple the process was. I was thinking"I want to get the feeling of belonging..'

It is essential to continue the growth rate.

The reason is that Ben's subscription comes with excellent quality (or "gated") information available via WordPress and an online newsletter which is excellently delivered to readers via email using Kit (formerly ConvertKit). In order to provide data, the primary emphasis will be on Google Sheets that include features along with updates and alternatives, as well as ways to get use of the application to its maximum.

"The forthcoming newsletter will feature detailed information about the most recent and most recent tools Google launched in the last year." Ben adds. The features are highly useful and allow you to edit the data. This will be an instructional video along with the URL which will open Google Sheet. Google Sheet template that people might download themselves. Additionally, the presenter affirms that the discussion is expected to take place on the subject matter to be discussed. "I use newsletters to provide additional information about the topic and also for offering Google Meet. Google Meet link for the live meetings."

In response to a question about where the business is headed, Ben thinks membership could be the basis of his company. "I would like for new members. I would prefer that membership be the only choice," he says. "I am currently a member of a library online that offers free content. If you want to join you can sign up to become an expert to assist me with my work and keep me informed on any information that is updated."

Z6fYkdbv3adzawtsO is a game simulates the Chess game. This game was created using Google Sheets

The author claims that he could provide consultation services as well as to incorporate advertisements in his newsletter. He plans to increase his strategies for doing this "if I am able to increase my membership to a point that it's sufficient to eliminate doubts. There are a variety of issues to think about, but expanding the membership of your club is vital. "

There's a myriad of possibilities to help in the expansion of his services. "I've thought for an extended amount of time on ways to improve the quality of my radio broadcasts during live events, specifically when we're planning to add new members over the next year. This service will have change. The service won't be drastically modified, however the method continues to evolve."

The writer further says that he'd like to establish an online community that permits users to communicate with each other concerning the issues they're facing and the issues they'd like solved "That can be done via "office timings" or some other method to reach out" in the event that you're doing it with the necessary amount of effectiveness and in a manner that's acceptable to all concerned.

Ben states that, at the present, all communication with his clients is via emails. "I would suggest that you email your client with the subject line "Hi I'd like to hear your thoughts'. The method I prefer is simple to manage.

He was well-known as being a participant in discussion forums as well as for his co-operative sessions' during which people were working with Google Sheets problems online as part of a group. "We attended two sessions similar as this in 2021. These are highly popular sessions. The experience was great however it was a bit stressful during the first five weeks. It was as if everything was an "firehose overflowing with" inquiries. It was my first time with a group like this. I'm worried that, once switching on the light it will be difficult to switch the light off completely. That's a concern I'm contemplating. how you would approach this issue for the coming time?

"I did not take the time to stream live on at any time prior to the moment I started my business. but I thought"Just try it live and see how it goes. Find out if I enjoy the live-stream prior to making a decision to commit to anything.' It's working! The proprietor of the business is thinking about including live shows into their mix "They're enjoyable and the attendees get satisfaction out of these events. Learn how they do it!"

Ben hosting a Zoom session for his members

Ben is the person responsible for Zoom sessions with his clients.

"Right right now I'm currently teaching the subject I've chosen and teaching in live classes," According to him, live classes are the best way of learning. However, in the group classes there was more of an discussion that was open "People were asking questions like 'Hey, what's the issue which I'm having trouble understanding? My mind is boggled.' Discussions would take place right at the time. Discussions will be available to members of the public. We'll be discussing this in the coming semester. This is a great chance for students to be involved."

The end of the day, Ben thinks it's feasible to create Discord forums for Q&A and give another alternative. However, he states "I just want to be confident that I'm able to deal with the problems in a manner that isn't impinging on my personal routine." There is evidence to suggest that Ben is well on his way to establishing continuous, steady and constant collaboration with his team. We believe maintaining that relationship over time is crucial to ensure the longevity of involvement with the community "Little Activities" and we'll keep working on building this over time!" He smiles.

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 creator of online classes and blog entries about the different tools offered by Google's Workspace tools. My primary interest is studying data, and making operations more efficient with Google Sheets and Apps Script.

Ben L Collins website

Ben L Collins' website

He's a proponent of creating fundamental, data-driven apps that can become an integral part the Google Google stack. It comprises Google Sheets, Looker Studio, Google Apps Script, Forms, Docs, Gmail as well as a host of additional apps. For more details, visit benlcollins.com.

The first time that the post appeared was on this web website. the web site

The original article was originally published here.

The article originally appeared on this site. This web page

This article first appeared on this site. is here.

This article was originally posted this site.

This article was originally posted this website.

This post was first seen on here