The Job Market
It has long been a staple of employment in the corporate world that employees have a solid working knowledge of Excel.
That requirement hasnāt changed, but more and more employers are requiring knowledge and experience using Google Sheets.
An increasing number of freelance jobs require experience in Google Sheets.
Itās no longer enough to be proficient in one programming language or one spreadsheet application. Itās about knowing the important ones.
Knowing one of these well makes it easy to learn about others. Much of your hard-earned Excel experiences transfer easily to Google Sheets. Granted the features may have different names and the buttons might be in different places, but the concepts are the same. It just takes a small orientation period to get comfortable with the new environment.
What can Google Sheets do?
As you might expect, Google Sheets can do everything you would expect from a spreadsheet program.
You can track income, create budgets, perform data analysis, or anything that would be needed when dealing with numbers.
Google Sheets has hundreds of built-in functions that can be used individually or in combination to create solutions ranging from simple to mind-bending complex.
Can my team collaborate on a sheet at the same time?
Because the data is stored in the Cloud and Google Sheets runs in a Web browser, the collaboration between team members is as easy as checking email.
Spreadsheets can be worked on simultaneously and edits made in real-time. You can even hold a chat session within the program.
What if I make a mistake that negatively changes the work of my colleagues?
Relax. With a feature called Version History, itās like having a time machine built into every spreadsheet. With a single click, you can return the spreadsheet to an earlier point in time.
Edit History keeps a record of each cellās changes when they were changed, and from what to what.
If various users require different levels of access, different levels of range and sheet protection can be applied to ensure sensitive data is not unintentionally (or intentionally) overwritten.
I need to collect data from different people. Can this be done easily?
Collecting data, such as survey data, is easily done with just a few clicks.
This survey can be easily shared with others and have the responses collected and stored directly into a spreadsheet.
Can I bring data in from a different spreadsheet?
Google Sheets has a function called IMPORTRANGE to automatically link to and import data from a different spreadsheet.
Is it easy to summarize and visualize information?
Summarizing and visualizing data has never been easier.
Using Google Sheetsā Explore feature, you can leverage Googleās artificial intelligence to create formulas, charts, and pivot tables with just a few clicks.
Can I embed my report on a website?
You mean, like this?
Yes, and you retain full functionality, like slicers, filters, and dropdown lists.
Can my spreadsheet be automatically translated to other languages?
Using The Google Sheets functions GOOGLETRANSLATE and DETECTLANGUAGE you can easily switch all text from one language to another. You can even give the user the ability to select their preferred language.
Sheets can be quickly translated into over 100 different languages.
Is it possible to get the latest information about the stocks in my financial portfolio?
Using Google Sheetsā IMPORTXML and IMPORTHTML functions, you can import any data from public webpages.
Also, the GOOGLEFINANCE function allows you to retrieve the latest information about stocks and currencies.
My job requires complex data analysis. Can Sheets handle complex queries and calculations?
Built-in functions like FILTER and QUERY give you the power to generate incredibly functional and intelligent reports.
Iām Sold! Now, where can I learn all these amazing things?
You can watch countless hours of YouTube videos, read an endless number of technical documents and webpages, and even subscribe to paid resources.
The problem is separating the good from the bad.
I was not satisfied with much of what I discovered. Much of what I discovered failed to focus on the common issues, needs, and mistakes users encounter or what would be considered ābest practicesā.
A lack of challenges and quizzes existed to help reinforce the learning process and demonstrate different application scenarios.
I decided to create a Google Sheets course based on what I believe most people would benefit from.
This course is designed to be your one-stop-shop for all your Google Sheets needs.
The course is designed for two types of people:
- Spreadsheet beginner, and
- Those familiar with other spreadsheet programs.
Both types of users are looking to expand their skills to be ready for the future.
The Course
The Google Sheets course is divided into two main parts: Essentials, and Advanced.
If you are already an advanced Excel user, Iāve planned out your exact learning path, which lectures you need to watch, which challenges to complete so you can master Sheets.
The course is comprised of:
- Over 14 hours of hands-on tutorials
- Challenges
- Fun but meaningful exercises where you get to discover and correct mistakes in existing worksheets
This way, you donāt just understand Sheetsā¦ you master Sheets.
Course Process
After you sign up, you will perform the following steps:
- Register for the course.
- Complete the assessment quiz. This will provide a baseline of your current knowledge level.
- Start learning.
- Become the expert youāve always wanted to be.
Be aware that you will become the āgo-toā person in the office whenever anyone has a spreadsheet question. Your popularity ranking is about to skyrocket.
Leila Gharani
I'm a 6x Microsoft MVP with over 15 years of experience implementing and professionals on Management Information Systems of different sizes and nature.
My background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert, SAP BW Project Manager. My passion is teaching, experimenting and sharing. I am also addicted to learning and enjoy taking online courses on a variety of topics.
