Terms

"I worked as an accountant for eight years and used Microsoft Excel every day for several hours" starts Google Sheets as well as Apps Script's teacher expert Ben L Collins. "Almost everything I was involved in was based on Excel but I did not possess a formal educational background. I'd written code however, I'd never been involved in anything using spreadsheets.

"Pretty at the beginning of my first week at my job I was told by my supervisor to accomplish some tasks making use of Excel such as "Combine tables".. However, I was doing all of it with me hands!" The supervisor showed his formulas in order to save time and Ben realized as one of the essential abilities required of professionals in finance is the ability to evaluate information.

"The individuals who possess the capacity to achieve this will have an advantage over everyone else who must struggle to survive."" Ben says. I've been contemplating "Right this is the best time to develop my capabilities and I've come across a number of websites that are online, such as mrexcel.com as well as chandoo.org They were performing exactly identical things as I do today, however they were working with Excel about 15 years earlier."

The more Ben could see at spreadsheets and formulas more interested was he "It was a rabbit-hole that was always getting deeper." Ben could see that some of the abilities he acquired in programming during his college days could be incorporated into the various programming languages that work alongside databases such as VBA.

In the time of his career in accounting, he has become more interested in technological developments in the field of accounting and finance. "After over 8 years of hard work, I've had enough and am finished!. I wasn't sure what my next steps what to do next, but one my initial thoughts was to switch careers and turn into engineers." Ben tells me.

     HTML1 Ben L Collins speaking in an event in the evening    

He enrolled in a few classes before looking for work. "It was just a small amount of time before I had to quit, but I began the blog I had created and began writing articles. My first blog post included Google Sheets and were the sheets of which Google has added to the Search." The result was the rise of freelancers wanting to be paid for their work.

"In 2014 as well as in 2015, the business received multiple requests from clients in need of assistance "Hey Can I help by constructing the dashboard with spreadsheets? Or "Can you look through my Excel spreadsheets on behalf of the company and help me determine how I can improve the formulas? ? '."

The project involved Excel, Google Sheets, SQL and Tableau. "It does not require an enormous amount of work, however it allowed me to consider "Maybe there's something to this. You could make yourself an independent contractor instead of returning to the job I had previously held . I'd prefer not to return to an accounting position!" Ben smiles. "I will keep trying to develop technology, and to come up with fresh ideas."

Goodbye accounting, hello education

The site for learning General Assembly was just a company that was launching and offering classes specifically designed specifically for developers and data analysts. "They plan to provide an online class for data analysis that is partially time-based. Since I've attended a class within the program that they offer for developers, I've made friendships with those that attended the class at when I was in the course. It was about the time they first launched of their Data class. This was in the year of 2015. The group was looking for instructors. The group was composed of Excel, SQL and Tableau," Ben continues. "I was thinking"This is exactly what I've always done from at the age of 8 ! '." He went through the procedure of being interviewed to be considered for the position. Additionally, he was an instructor several times in the year in 2015.

"That motivated me to get back into teaching" Ben recalls. "I'd taught in an academic environment as well as the instructor of children's classes towards the conclusion of my degree." He was able incorporate certain company training into the online classes including lessons as well as demonstrations. "As I noticed that there was an increase of people who are curious about what I do I decided to design my own online training course to test whether it's an effective idea."

) The course focuses on Google Query. Google Query feature within Sheets

It was well-loved by students and was appreciated by all who attended, which helped inspire Ben to design a new course. "I employed a program known as Teachable in order for a way to develop a connection personally with the students, and to keep the relationships myself, rather than make it available to the market, like Udemy."

I felt compelled to conduct some investigation and a name would keep popping up. This was the one who is responsible for the journal for the Stratechery technology. Ben Thompson. Ben Thompson is known as"the OG!" Ben is having fun. "I have signed up on some accounts to look at the different ways users enjoy Flowing Data and Craig Mod was also doing it." Ben was a member of their newsletter while it was an infant. I was intrigued by how they came up with the idea to create their own membership-based company. I thought "I would like to have my company run in similar style to the ones they have.'. I was extremely impressed with the registration process. It was quick and easy. I thought"I'm eager to experience this member's experience..'

Moving forward with a long-term perspective

For a brief overview of Ben's subscription service. Ben subscription service, it's made up of premium (or "gated") material and hosted on WordPress in addition to electronic newsletters distributed via emails created with Kit (formerly ConvertKit). To create the content, it is based around Google Sheets - including products enhancements, brand new features and much more, as well in methods of getting most value of the application.

"The following newsletter will contain an in-depth review of certain new functions Google has announced at the end of the calendar year." Ben adds. This is a very beneficial feature which allow you to alter the details. This article will provide information on the subject and provide links for Google Sheet, a Google Sheet template available to download. In addition, there will be discussions live about the subject. "I use newsletters that provide details about times, and to share Google Meet's Google Meet link for the live discussions."

If asked about his plans for the future are, Ben believes that membership is the primary part of his business. "I will definitely try to bring new members into my fold as I would like this to become my primary source of income," he says. "I am able to provide archived content for free price, but I also have possibility of being a professional member. This will enable me to get more material."

Z6fYkdbv3adzawtsO playing the game Chess by using Google Sheets

The writer claims that he was once in a position to offer consultations as well as placing advertisements on his site, but his current goal is to eliminate the procedure "if I'm able to connect to a large number of people, then I'll be able remove all other products. There are a few minor aspects which need to be a focus and a rise in the amount of customers is crucial. "

You can think about different possibilities for expanding his offerings. "I've thought about ways to increase the effectiveness of broadcasting live events and have come up with a couple of strategies to help to attract new customers over the next year. The streaming service is most likely to undergo a change. It's unlikely to change in the way we do things but we'll still be broadcasting streaming live."

The president also reveals the need to find the ideal method for members to talk about the issues they're facing as well with the queries they'd like to answer in the future "That might be possible via "office hours" or an ideal way to reach out with inquiries" so long as it is viable and beneficial to the people affected.

Ben says that for this moment, the only way to interact with his fans is through messages. "I want to suggest that you reach me with a message that says "Hey please tell me the things you're working on'. It's a great concept since it's easy to track.

Forum chats were scheduled with an "cohort class" that saw participants working with Google Sheets issues online together as a small group. "We were part of two classes in 2021. Google Sheets were the talk across the city. It was a great experience, however it made you extremely nervous during the first few weeks. It felt like you were in being the victim of a "firehose filled with questions. It was my first experience as a participant in an educational program However, I'm afraid that once I shut off the device the device will be impossible to switch off the device. This is something I'd like contemplate, and to figure out how I will I handle it, as I keep an eye on the long coming?

"I did not have the chance to perform live prior to starting since I was thinking"Just do it live and observe how people respond. It is important to ensure that you're having fun prior to making a commitment to everything. The process is working well! Owner wants live-streamed sessions "They're fun and everyone is a beneficiary from these occasions. This is sure to be exciting since we'll be watching how this goes!"

HTML0 Ben hosts an online gathering along with his guests

"Right now I'll present subjects to the students. I'll choose a subject then we'll debate the topic during a live debate," he continues. In the course of group discussions, this was not an open discussion open to anyone willing to take part "People took part during the class to say, "Hey, there's some reason that's confusing me." The discussion was live, with others would observe. The topic will be dealt with during the entire year. It's a great occasion for individuals to become involved."

The end of the day, Ben thinks that the idea of the Q&A forum is an option, however Ben states: "I just want to make sure that I'm doing it with a manner that's not controlling my private life." This suggests that Ben is currently working toward creating the most lasting and longest-lasting connections with his local community. Being able to keep those connections that you've made with your community strong is crucial to ensure a with a long-lasting membership "Little step: Let's build the next step over time!" The person is happy.

More details

Ben Collins is an educator in addition to a writer, director and creator of The Collins School of Data. Ben Collins creates online classes and writes on Google's Workspace tools. My primary focus is the study of automated process of data using Google Sheets along with Apps for Script. LmVftNPgfKbMpZsophnG

Ben L Collins' website

He loves creating simple applications using data to benefit from the capabilities of his Google stack. It includes Google Sheets, Looker Studio, Google Apps Script, Forms, Docs, Gmail and many more. For more information visit benlcollins.com.

This post was first published on this site.

The original post appeared on this website.

The post was published on this website.

This post was first seen on here

This post was posted on here