Terms

"I worked as an accountant over the last 8 years, and I used Microsoft Excel every day for many hours." The class includes Google Sheets and Apps Script taught by an experienced instructor Ben L Collins. "Almost everything I worked on was completed using Excel but I did not have any background. Although I'd written code, I'd never done anything using spreadsheets.

"Pretty in the early days of my career, I was told that my boss wanted me to complete a range of tasks that required Excel like "Combine the tables" etc. The problem was that I needed to finish all of it in my own hand!" Ben was taught a couple of formulas that can aid in speeding the procedure. Ben could see that one of the most important capabilities of every professional in finance is the capability to alter the information.

"The those who are able to master it achieve a greater amount of success over those who struggle." Ben continues. I was thinking "Okay this is the case, I'm likely to have to enhance my skills.' I checked out a few sites on the web, including mrexcel.com along with chandoo.org The sites had exactly the capabilities I have and I was only working with Excel about 15 years prior."

The more Ben played with formulas and spreadsheets, more intrigued he was: "It was this rabbit tunnel that just got deeper and more." Ben realized that some of the knowledge he gained in the university years could be applied to programming languages that handle databases like VBA.

Throughout his career as an accountant He began to become more interested in technological advancements as opposed to accounting and finance. "After eight years of work I realised that if I've had enough that I've got enough!. I didn't know what I should do, however one of my initial thoughts was to become an engineer." Ben tells me.

It's yWYQFjXiawUjOZ9. Ben L Collins speaking in a nightclub.

He was enrolled in several courses, after which he began applying for work. "It did not receive any notice when I went to the college level, however I began constructing my own website and writing pieces. My first pieces of content were written on Google Sheets and they're the ones that got taken up by Google Search." The result was an appearance of customers asking for payment for freelancers.

"In 2014 and 2015 there was a lot of calls outbound asking "Hey Could you please help me in creating the dashboard with spreadsheets? or "Can you go through the spreadsheets I have created for my organization and assist me in finding ways you can improve the formulas? ? '."

The task involved Excel, Google Sheets, SQL as well as Tableau. "It was not a real job, but it's sufficient to consider"Maybe you're able to find something that can be discovered in this post. The possibility exists of becoming a freelancer, instead of a returnee to your previous work . It's not something I'm looking forward to going back to the accounting department!" Ben smiles. "I would like to stay one step ahead in technological innovation and to be innovating."

Goodbye accounting, hello education

The website for education General Assembly was just a firm that was only beginning and was planning to introduce classes for programmers as well as data analysts. "They created an online database analysis software that was only full-time. Since I'd taken the class when I was student in one their courses designed for programmer students and was a good friend of their team when they started the program. The initial time they introduced the course on data was the first time they began to find instructors. It was a course that consisted of Excel, SQL and Tableau," Ben continues. "I said to myself "Hey it's exactly the way I've always been doing my work since I was 8 years old. ! '." He applied for the position and was later granted the position as well as the opportunity to instruct the course on several occasions during the course.

"That inspired me to get back into teaching," Ben recalls. "I'd taught at the college level as a mentor to young students when I finished my school year." He added business training to the online course, along with the sales of tutorials and courses. "As I was beginning to build a following, in the year 2017 I decided to launch an online course of my own to try out the waters."

) A course on the query function of Google Sheets

Instructional content was received by the students - enough to convince Ben to launch a second course. "I made use of Teachable, a platform Teachable since I wanted to create a strong relationship with my viewers and be in a position to manage the relationships, rather than handing the course to an online platform like Udemy."

I did a search for a name and what kept coming to my mind was that of the man who edits the technology news magazine Stratechery, Ben Thompson. Ben Thompson is known as the OG!" Ben smiles. "I was a member for a few months to check out the other members' use of Flowing Data and Craig Mod has done exactly the same." Ben was looking through their newsletters over some time, and was fascinated by the methods they used to establishing their membership business. I was thinking "I want to make an experience similar to theirs.'. I was awed at the simplicity of signing up, and also the simplicity of joining and thinking"I want to experience a the same experience..'

Moving forward in a way which is durable

To give you an overview to give an overview Ben subscription service, we will provide a brief overview. It is made up of premium (or "gated") information that are stored in WordPress and an email newsletter, which is delivered via email via Kit (formerly ConvertKit). For more specifics It's based on Google Sheets with new functions for the product along with new features and ways to maximize the benefits of it.

"The forthcoming newsletter dives into various modern technologies Google launched in the last year's holiday season." Ben adds. They are extremely useful tools for modify the data. The demonstration will be on this, which includes links to a Google Sheet template that people are able to download. In addition, an actual live discussion on the use of Google Sheets will be a live demonstration. "I utilize newsletters to communicate details about the event in addition to provide the Google Meet link for the live sessions."

Asked how the future is going to be for Ben, Ben believes that membership will become the major area of his business. "I sure would like to draw many more members in, as I'd like my membership to be my primary product," he says. "I offer an archive of my material for at the cost of a monthly membership. You will then be able to sign up for my professional membership, join my Facebook group and receive additional information."

0.WZ6fYkdbv3adzawtsO Simulating a game of Chess through the use of Google Sheets

The author also talks about his previous experiences in which offered consultation as well as publish advertisements in his newsletter. The author is trying to avoid these things: "if I can build an audience of the right size, it's best to get rid of all the other things. There are a few small issues to address. But increasing the number that subscribers are a part of the main aspect. "

He acknowledges that he's been thinking of different ways of expanding his offerings. "I've thought about how I can improve with live broadcasts of the events. There are plans to recruit new members to the next event. The event itself will continue to evolve. It's unlikely to change too much, but there'll be to be additional items that will live."

A member suggests finding an easier way for the members to communicate the information concerns they're facing and issues they'd like to address. Another option is "That could be via 'office hours' or another way to ask questions" so long the method is implemented in a timely and sustainable manner to everyone that is.

Ben affirms that at the moment, all communication with his followers is through email. "I recommend that people contact me with a message that says, 'Hey Let me know what you're getting going'. It's a great idea since it's manageable.

The forum he was in offered chats and "cohort courses" that let participants work to solve Google Sheets issues online together in a group. "We completed two courses in 2021 and they became popular. The training was extremely efficient However, it was extremely stressful for the entire period of five months. It was like being an endless "firehose' of questions. It's been a while when I've participated in a community similar to this. As I'm worried about what will happen the moment I get started, it's hard to shut off. I'd like to look it over and consider ways I could ensure that this can be sustained?

"I did not have any live shows in mind when I started, as I was thinking"Just start, then decide what my response will be. Check to see if you are comfortable with before making promise following promising. The system is doing well! He is keen on adding live sessions "They're entertaining and everyone benefits lots from these sessions. Let's see how this goes!"

HTML0 Ben hosts an online conversation with his guests.

"Right now, I'm teaching classes like the following: I'll choose an area of study to cover and then we'll be discussing live via chat," he continues. If the class was constructed on groups, it became more like an open forum "People were able to come in and have questions such as"Hey, I've got an equation that I'm not certain about..' The discussion was live while others watched. The discussion will continue in the next year. It's an excellent possibility for everyone to participate."

One final thought, Ben thinks there's a possibility that there's a Q&A forum which may be possible. However, Ben states "I just want to ensure that I'm ready to face this situation with a degree of calm that's not overpowering me." This statement indicates Ben is on the road to establishing the longest-lasting, lasting friendship with his peers. It is essential to maintain connections for the success of any involvement "Little actions is what we'll do to build the foundation as we go along!" The person smiles.

More details

Ben Collins is an educator author, designer, as well as the co-founder and founder of The Collins School of Data. Ben Collins develops online classes and blogs on the Google Workspace tools. My primary focus is study and evaluation of the data, and automated processes that are made using Google Sheets as well as Apps and Script.

Ben L Collins' website

He's a fan of creating simple programs which are based on data and that can be added to The Google stack. Google Sheets, Looker Studio, Google Apps Script, Forms, Docs, Gmail and many more. For more details, visit benlcollins.com.

This article first appeared on on this website.

This post was posted on here

This post was first seen on here