Terms

"I worked as a bookkeeper for 8 years. I worked with Microsoft Excel daily for several hours" is the opening sentence of Google Sheets as well as AppsScript Professional teacher Ben L Collins. "Almost everything I did on the computer was done with the help of Excel but I did not have prior knowledge. I had coded before, but had no prior experience with spreadsheets.

"Pretty when I started working at the time, I was offered a job with my boss. I was required to perform many tasks inside Excel such as "Combine tables" as well as others. Following that, I was required to complete the task by hand!" His supervisor showed him that he could use formulas to streamline the process. Ben discovered that the most important skill that you should have in finance could be the ability to alter the facts.

"The individuals who can achieve this feat effectively will are a significant advantage over those who do not," Ben continues. I thought "Right I'm thinking of increasing my abilities." I discovered a variety of websites that I considered for example, mrexcel.com as well as chandoo.org They offer the same capabilities that I do, however when the way they were developed was using Excel about 15 years ago."

The more Ben was able to look at spreadsheets and formulas, more fascinated he became "It was the rabbit hole going down into the dark." Ben knew that the programming training that he was given at school could be combined together with different programming languages which can help in creating databases. This could include VBA.

Through his time working as a bookkeeper, he was drawn to technological advancements, rather than field of accounting or financial. "After eight years being an accountant within the field of accounting I thought"I'm finished! I'm done!. I wasn't sure what the next stage of my plan but the first idea I thought of was the subject of engineering." Ben tells me.

The full title is. Ben L Collins speaking during an event which took place at night.

He attended some classes, before beginning to search for jobs. "It was not a huge success at first however I did create my own site and write essays. One of the very first articles I wrote was about Google Sheets and they're those that later became Google Search." The result was a range of customers seeking out freelancers' help as well as offering cash in exchange to use their services.

"In 2014 and the year the year 2015, we saw an increase in requests from clients seeking assistance "Hey can I be assisted by creating a dashboard using sheets or spreadsheets? or "Can you review my Excel spreadsheets that we have for our company and assist me in determining which method is best to optimize the formulas? ? '."

The position called for Excel, Google Sheets, SQL and Tableau. "It was a normal job but it offered me an opportunity to consider"Maybe this is a sign that something is more. There is a possibility that I could become a freelancer and not having to return to my former job . I don't intend to return to accounting!" Ben smiles. "I am determined to be on top of my game in addition to my understanding of the latest technological advances."

Goodbye accounting, hello education

The beginning of the mission of the website is to provide learning opportunities General Assembly was just a concept for a business that was a start-up. They are planning to offer special classes for advanced programmers and data analysts. "They are also introducing an online program for analysis of information. It's only part-time. Because I'd been in one of their programs specifically designed for developers, I knew of the people who were there. At the time of the beginning of the program, the first course on data was the first time they began to find instructors. The class comprised Excel, SQL and Tableau," Ben continues. "I began to think, 'Hey! this is exactly what I've done for the past eight years. ! '." Ben was interviewed procedure and he accepted the job. It was also conducted by Ben on several occasions.

"That inspired me to return to the teaching profession" Ben recalls. "I'd had a job as a teacher in the college and tutored young students once I finished my academic year." Additionally, he provided training to firms via online classes which included selling courses and tutorials. "As I started to increase the number of clients who were attracted to my business, I decided to start my own business and try to see what the market would be like."

) A course on the Query function within Google Sheets

The teaching style of the course was well-known. It was an excellent course that it enticed Ben to create a new course. "I made use of the website Teachable as I tried to discover a means to build a rapport which was unique to my students and to ensure that I would be able to hold the course to myself rather than giving it to markets, like Udemy."

While doing my homework I came across names that were repeated. It was Ben Thompson, the title of Ben Thompson, editor of Stratechery The Tech Newsmagazine Stratechery, Ben Thompson. Ben Thompson is often referred to as"the OG!" Ben smiles. "I have signed for two subscriptions to check out what other companies like Flowing Data and Craig Mod did." Ben is looking at their newsletters, despite his young age. was a teenager. I was interested to know how they structure their business around subscriptions. I was thinking "I want my business to operate in exactly the same way they did.'. It was easy and simple to be thinking"I want to experience exactly the same way in my role as an associate..'

Moving forward in a way which is future

Actually, the present subscription package includes top-quality (or "gated") information and is hosted on WordPress and an exclusive email newsletter delivered via email, which is made possible through Kit (formerly ConvertKit). For further details this service runs on Google Sheets and includes specific information on the features of the program and its adjustments as well as strategies to get the most value from the program.

"The forthcoming newsletter will offer detailed information on the latest tools Google have made available over the last 12 months," Ben adds. Google Sheets can be extremely beneficial that allow users to alter data. That's why you'll be able to find an instructional video about Google Sheet's abilities and the possibility of downloading Google Sheet which is which is a Google Sheet template you can download. In addition, he'll hold one-on-1 discussions on the topic. "I use emails to provide specific information regarding the day's time along with the place. In addition I utilize google meet. Google Meet link for the live chat."

If you want to know what the next steps are for the business, Ben thinks membership could be the primary source of income for his business. "I definitely want to attract many members since I would like to make membership the primary service I offer," he says. "I offer an array of information for free, however it is also possible to choose being a member active by purchasing the premium version, or assist me in getting access to more details."

An exciting game of Chess with the help of Google Sheets Google Sheets

The author claims to be competent to provide consultations along with incorporating advertisements into the journals he writes, but the goal of his blog is to finish by saying "if I'm able to get enough people to join I would like to eliminate all other things. There are a few small concerns to be considered but increasing the number of members is crucial. "

He has contemplated a number of options for expanding the types of events that he organizes. "I've thought of a few ways to improve the efficiency of arranging the events in real time. Also, we've come up with ideas that can encourage more members to become involved in the coming year. The software itself will change. The software will remain consistent with what you expect, but it will stream live media."

One participant says he'd want to figure out how best to allow members to share the data problems they're working on and also issues that they'd like to address in the next few months "That could be done using "office timers" or any other method effective in addressing questions" as long as the process is executed in a long-lasting, efficient and effective way that's profitable for everyone who are involved.

Ben states that a majority of his interactions with his followers are via emails. "I believe that people should reply with a message like 'Hey, provide me with a quick description of the work that you're working on'. It's fun because it's manageable.

Forum chats may be offered, similar to "cohort classes" that would allow students to work through Google Sheets issues online together as a smaller group. "We have completed two in 2021 since they are at the forefront of technological innovation. It was an incredible achievement, but it was extremely difficult in the initial five weeks that we were involved in. It was always a flood of questions. It's been a while since I joined this group in the past, but I'm worried that should I decide to change my membership again, I'll not be able to end the group. That's something I'd love to consider, but how do deal with this issue from a long-term standpoint?

"I had no live streams at the moment. I started thinking"Just start streaming and see how people react. Check if it's fun to live stream before I commit to the whole thing. The stream is running great! The owner is keen to include live shows "They're entertaining and people appreciate the advantages of these shows. It will be interesting to know exactly what's happening!"

Ben hosts Zoom Sessions for his guests.

"Right at the moment, I'm giving lectures on subjects selected by me. The topic will then be discussed during the live course," he continues. In the course, this technique was developed to appeal to a wide audience "People were able to walk into the class and say "Hey I'm struggling with a issue which I'm unable with. I'm having trouble with this method and trying to resolve the problem" They would then be able to discuss the topic live in real time. Other participants would be able to observe. We'll think about this during the next year. It's an excellent opportunity to everyone to participate."

Ben believes that the possibility that creating an online platform to answer questions may be a feasible possibility, however he says "I just want to be sure that I'm in a situation to accomplish the project with a method that isn't consuming a significant amount of my time." The conversation suggests Ben is in the process of building the foundation to ensure a consistent and consistent communication with his customers. It is our opinion that sustaining a bond with time is crucial to the life of a community "Little step, eventually we'll expand our audience!" He smiles.

More details

Ben Collins is an educator as well as a programming expert, co-founder of The Collins School of Data. Ben Collins develops online classes as well as writes to Google Workspace. Google Workspace tools. My main focus is on automation of the process of analyzing data with the help of Google Sheets and Apps Script.

Ben L Collins' website

He is a fan of creating lightweight software that's dependent on data. It works alongside the Google collection of apps: Google Sheets, Looker Studio, Google Apps Script, Forms, Docs, Gmail as well as many more. For more details, visit benlcollins.com.

The article was first spotted on this. is available.

The article was originally posted on this site.

The article was published on this site

This post was posted on this site.

Article was first seen on here