Terms

"I was an accountant over the last eight years and utilized Microsoft Excel every day for prolonged periods of time" begins Google Sheets and Apps Script an experienced instructor Ben L Collins. "Almost every task I worked on was completed by using Excel however I didn't know the basics of what Excel was all about. I wrote some codes, but I did not have knowledge of spreadsheets.

"Pretty during the first few months that I worked I was approached by my supervisor to complete various tasks using Excel for example "Combine all tables" as well as "Combine these tables. It was a challenge because I was required to finish the job using only me hands!" His supervisor explained the application of formulas in order to speed up the process. Ben instantly recognized that one of the essential skills needed by those working in finance is their capability to modify information.

"The people who have the capability to succeed in this specific field stand an impressive distance from those who appear to be chaotic," Ben continues. I thought "Right this moment I'm likely 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 sites had exactly the same workflow as I have today, employing 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 that was growing more fascinating." Ben was aware that a lot of the programming instruction that he had received in his time at college could be implemented by programming languages that connect to databases, such as VBA.

In his time as an expert certified accountant, accountants were most fascinated with technology. However, they were especially with financial accounting. "After more than eight years being in a field I loved, I was like I was done!. I didn't know what the next steps would be. The first thing I thought of was becoming an expert in programming." Ben tells me.

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

He took a few courses after which he applied for jobs. "It was not an extensive initiative, but I started building my own website, and also began to write posts. My initial articles that I made were all about Google Sheets and they're the ones I found in Google Search." Google Sheets brought in a number of requests from users in addition to pay-per-hour work.

"In the months of in 2014 and 2015. I had the opportunity to get a lot of customer calls that were outbound, asking "Hey Do you require assistance to create my dashboard with spreadsheets, spreadsheets, or any other spreadsheets? This is "Can you look at my spreadsheets from business and help me determine how I will be able to tweak my spreadsheets in order to increase their effectiveness? ? '."

The job involved Excel, Google Sheets, SQL together with Tableau. "It wasn't really a job, but rather an instance of think"Maybe there's something to be found in the sector. Maybe I'll be an independent contractor instead of going back to the job the past . This is not the intention of me returning to the accounting position I had before!" Ben smiles. "I would like to keep up on the most recent technological advances in the field of research and development."

Goodbye accounting, hello education

The website for education which was initially launched by General Assembly was just a initiative at its infancy and was in the process of launching courses for professionals in programming along and analytics analysts. "They are developing a class for part-time students on analytics of data. As I've attended one of their courses within the course that was designed by programmers for students, I know some of the students that attended the course. When they announced the class on data, they immediately began to recruit for instructors. The curriculum was composed from Excel, SQL and Tableau," Ben continues. "I was thinking"Ooh that's what I did when I was just eight years young. ! '." The applicant went through the interviewing process before being hired and was subsequently appointed an instructor of the course on a variety of times throughout the year.

"That resulted in me becoming an instructor once more" Ben recalls. "I'd taught at a university level and was an instructor to kids prior to starting my final semester in college." The initial step was adding corporate training to the courses online that included tutorials as well as lessons. "As I noticed an increase in the quantity of visitors attracted to my website, I was inspired to create my own course, and then test it to see how feasible it is to put in place it."

) A course on Google Query. Google Query feature within Sheets

The content of the course was highly accepted, and it inspired Ben to design a fresh course. "I utilized Teachable, an online platform Teachable to figure out a way for me to remain in touch with my students, and also to keep the connection rather than transferring that relationship to an online marketplace, for instance Udemy."

I conducted an Google search, and found that the first name to pop up on the internet was Ben Thompson. He is the proprietor of the technology-related magazine Stratechery. Ben Thompson. Ben Thompson is known as"the OG!" Ben is having a blast. "I am in the club several times and have been able to study the way other members use Flowing Data and Craig Mod used similar methods." Ben was reading through the newsletters of their members over a considerable period of time, and I was interested in learning about the strategies that they used to run their companies based on the member. I was thinking "I would like my business to be based on the same strategies used by them.'. I was awed by the ease and simplicity it was to do. I was thinking"I want to get this feeling of belonging..'

It is crucial to sustain the rate of development.

It's due to Ben's subscription comes with top-quality (or "gated") data that is available through WordPress and also an electronic newsletter that's excellent delivered to readers via email using Kit (formerly ConvertKit). To provide information, the primary emphasis will be on Google Sheets that include features as well as updates and alternatives - as well as ways to get use of the app to the maximum.

"The forthcoming newsletter will feature extensive information on the latest and most current tools Google launched in the last year." Ben adds. The features are highly useful that allow you to alter data. This will be an instructional video along with the URL that will open Google Sheet. Google Sheet template that people could download for themselves. In addition, the speaker declares that discussion will take place regarding the subject matter to be addressed. "I utilize newsletters to give additional information about the topic, as well as for offering Google Meet. Google Meet link for the live events."

When asked what direction the business is headed, Ben thinks membership could serve as the foundation for his business. "I am definitely looking to attract new members. I'd prefer membership to be the only choice," he says. "I am currently a user of an online library which has free cost contents. If you want to join, sign up as a professional in order to support me in my job and to keep me updated of any new info."

Z6fYkdbv3adzawtsO A game online that simulates the Chess game. The game was developed with Google Sheets

The writer states that he was able to provide consultation services as well as to incorporate advertisements into his monthly newsletter. He hopes to expand his methods of doing this "if I can grow my members to the point that it's sufficient to eliminate doubts. There's an array of concerns to consider however, expanding the membership of your club is essential. "

There are a myriad of thoughts that could assist in expanding his service. "I've thought for an extended period of time about how I can enhance the effectiveness of my broadcasting during the live events, especially as we're preparing to add new members in the coming year. The actual service is going to change. The service won't be drastically altered however, the process will continue to develop."

The writer further says that he'd like to establish an online platform that allows members to to share information regarding the type of issues they're having and what problems they'd like to solve "That could be accomplished through "office times" or some other method to contact" so long as you do it with the appropriate amount of efficiency and in a manner that is acceptable to everyone affected.

Ben states that, at the present, all communication with his clients is via email. "I would suggest that you send a email with the subject line 'Hi I'd like to hear your comments'. My preferred method since it's easy to control.

The man was well-known for his participant on discussion forums and also for his cohort sessions' during which participants were working on Google Sheets problems online as part of a larger group. "We attended two sessions similar to this in 2021. These sessions are extremely popular. It was a great experience but it was quite stressful during the first five weeks. It was as if everything was an "firehose full of" queries. It was my first time with a group of this type. I'm concerned that, after turning on the light, it'll be hard to turn the light off completely. It's something I'm thinking about. how you would approach this concern for the upcoming period?

"I did not take the time to live-stream any occasions prior to when I began the business, however, I thought"Just do it live and check how it goes. Check if it's enjoyable to live-stream before I make a commitment to something.' It's working! The owner of the company is thinking about including live events into the mix "They're entertaining and people get satisfaction from these occasions. Find out how this occurs!"

Ben is the one who is in charge of Zoom sessions for his customers.

"Right this moment I'm teaching the subject I've picked and giving in live classes," He says. But in the cohort classes the atmosphere was more an open discussions "People were present asking questions like 'Hey, what's the issue which I'm struggling to understand? my mind around.' The discussions would occur right on the spot. The discussion would be open to all the general public. It's something we'll consider about for the next semester. This is a great opportunity for students to get involved."

The end of the day, Ben thinks it's feasible to create Discord forums to facilitate Q&A and give another alternative. But, he says "I simply want to make confident that I'm able to tackle the issues in a manner that isn't intruding on my daily life." Evidence suggests Ben is on the route to creating the basis of a constant, consistent and ongoing cooperation with his team. We believe that maintaining that relationship over time is essential for the longevity of involvement in community "Little Activities" and we'll keep working on building this over time!" he smiles.

More details

Ben Collins is an educator and writer. He also is a computer programer. Ben Collins is the founder of The Collins School of Data. Ben is the creator of online courses as well as blog posts on the various tools made available by the Google Workspace tools. My primary interest is studying data, and making processes more efficient using Google Sheets and Apps Script.

Ben L Collins' website

He's an advocate of developing basic, data-driven programs which can become an integral part of Google's Google stack. It includes Google Sheets, Looker Studio, Google Apps Script, Forms, Docs, Gmail as well as a host of other apps. For more details, visit benlcollins.com.

The first time the article appeared was on this web site. the web site

The article originally was published here.

The original article appeared here. This website

This article first appeared on this site. here

This post was posted on here

This post was posted on here