Master Google Sheets — A video Series
Most of the people in any organization/ business have been using excel for quite a long time. Even though we have tools like Python, R etc. to analyze data and Tableau, Power BI etc. to visualize data, we still rely on excel for analysis and sharing reports. Google sheets is quite similar to excel and is very easy to share and collaborate. It is widely used in many organizations to store data, create reports and dashboards as well. We can easily load a csv or an excel file and quickly generate some useful insights from the data. We can also create presentation ready tables, charts etc. in google sheets.
I use it quite often and prefer it over excel for quick analysis. Many a times, I use it along with Python/ R to complete the project. I summarize the data in Python/ R and use the summarized data in google sheets for creating charts.
In this blog, I will share links to my YouTube channel and videos, where I have added a few videos to cover basic to intermediate concepts in google sheets. I will also add more videos related to Python/ R/ Power BI to my channel in the coming days.
My YouTube channel: https://www.youtube.com/@learntoplaywithdata
Video 1 : Google Sheets — Toolbar and Column Stats — In this video, I have discussed Toolbar menu in details and have also covered Column Stats which is a very important feature to understand the data in a column quickly.
Video 2 : Google Sheets — Copy Paste/Filter/Conditional Formatting/Sort — In this video, I have discussed the copy paste options available in google sheets. I have also covered Filtering the data, Conditional formatting and Sorting the data.
Video 3 : Google Sheets — COUNT/SUM/FILTER — In this video, I have discussed the most common functions used in google sheets.
Video 4 : Google Sheets — Formulated Report Using Named Range — In this video, I have discussed how we can create a tabular report with formulated cells using Named Range.
Video 5 : Google Sheets — COUNTIFS vs COUNTA-IFERROR-FILTER — In this video, I have discussed the difference between COUNTIFS and the combination of COUNTA and FILTER to get the same result. I preferably use COUNTA(IFERROR(FILTER(Column1, Condition1, Condition2, …))) to write the formula as it is easier to understand the fact that we are trying to count the records after applying some filters.
Video 6 : Google Sheets — PIVOTS — It is one of the most used function in excel/ google sheets where you can easily put columns in rows/ columns and apply filters to get a summarized result. It is discussed in detail in this video.
Video 7 : Google Sheets — IF, VLOOKUP & Multiple VLOOKUP — In this video, I have discussed the IF function which is again a very widely used function. VLOOKUP is another function which is discussed in interviews as well. I have also explained the use case for Multiple VLOOKUP.
Video 8 : Google Sheets — INDEX MATCH & Text Functions — In this video, I have discussed how we can use the combination of INDEX & MATCH functions as a substitute to VLOOKUP/ XLOOKUP functions. I have also covered a few useful Text functions.
Video 9 : Google Sheets — Advance Functions — IMPORTRANGE & Query — In this video, I have discussed the two functions unique to Google Sheets and not available in Excel. Using IMPORTRANGE we can easily add data from one sheet to another. With some basic knowledge of SQL, we can use Query to easily summarize the data.
Video 10 : Google Sheets — Adding Beautiful Line Charts — In this video, I have discussed how we can create line charts in google sheets.
Video 11 : Google Sheets — Impressive Bar Charts — In this video, I have discussed how we can create presentation ready bar charts in google sheets highlighting important insights from the chart.
Video 12 : Google Sheets — Multiple Lines and Pie-Doughnut Chart — In this video, I have covered how we can create multiple lines chart to compare different trends. I have also covered Pie-Doughnut chart.
Video 13 : Google Sheets — Geo and Organization Chart — In this video, I have covered geo and organization charts.
I hope you would find these videos useful. Please subscribe the channel and share the videos with friends/ colleagues and family members who aspire to learn Google Sheets.
