Get yourself trained on Data Analysis with with this Online Training Data Analysis with Google Sheets Pivot Tables and Charts.
Online Training Data Analysis with Google Sheets Pivot Tables and Charts
**** Life time access to course materials and practice activities. 100% money back guarantee ****This course is presented by Ian Littlejohn – who with over 23000 students is one of the most popular instructors on Udemy.Ian provides world leading courses on Excel, Power Pivot, Power BI and Google Data Studio.Google Sheets is becoming an extremely popular tool for data analysis and reporting. Google Sheets makes it easy to setup and share data and information within the cloud.In this course we explore one of the most powerful features of Google Sheets which is Pivot Tables. You will learn how to easily create powerful Pivot Tables and Graphs using a few clicks of the mouse.This course is primarily for people who want to learn how to get Google Sheets to do the work for them and not for you to be writing complicated formulas or functions to achieve data analysis.This course will achieve the following:Learn to correctly structure your dataCreate Pivot Tables to summarize and aggregate your dataUsing Different Methods of Calculation – Sum,Count, Unique Count, Average, Median, Max, MinCreate your own powerful custom calculationsCreate Time / Trend AnalysisTime / Trend Analysis graphsFilter and Ask Questions of your dataContribution Analysis – percentagesContribution Analysis graphsAnalyze Human Resource data – Create powerful reportsLearn to group Age and Salary dataApply conditional formatting to data
Udemy helps organizations of all kinds prepare for the ever-evolving future of work. Our curated collection of top-rated business and technical courses gives companies, governments, and nonprofits the power to develop in-house expertise and satisfy employees’ hunger for learning and development.
Learn on your schedule with Udemy
Investing in yourself through Learning
As a society, we spend hundreds of billions of dollars measuring the return on our financial assets. Yet, at the same time, we still haven’t found convincing ways of measuring the return on our investments in developing people.
And I get it: If my bank account pays me 1% a year, I can measure it to the penny. We’ve been collectively trained to expect neat and precise ROI calculations on everything, so when it’s applied to something as seemingly squishy as how effectively people are learning in the workplace, the natural inclination is to throw up our hands and say it can’t be done. But we need to figure this out. In a world where skills beat capital, the winners and losers of the next 30 years will be determined by their ability to attract and develop great talent.
Fortunately, corporate learning & development (L&D), like most business functions, is evolving quickly. We can embrace some level of ambiguity and have rigor when measuring the ROI of learning. It just might look a little different than an M.B.A. would expect to see in an Excel model.