Master the use of Google spreadsheets for statistical analysis and data visualizations in this free online course. In this free online course, learn how to create, view, and edit Google spreadsheets. Study how to perform basic and advanced tasks with Google spreadsheets, including data formatting and modifications, arithmetic and stats operations, as well as the capabilities for data analysis, information customization, and data visualization. The tasks to be taught will range from beginner to advanced levels for a wider reach to ensure proficiency.
| College | Alison |
| Course ID | 195467 |
| Course Type | Online Learning |
| Course Qualification | CPD Certificate |
| Course Duration | 3-4 hours |
| Course Fee | Free |
| Entry Requirements | Like all courses on the Alison Free Learning platform this is a free, CPD-accredited course. A Graduate can choose to buy a certificate or diploma upon successful completion of a course, but this is not required or necessary. At Alison we believe that free education, more than anything, has the power to break through boundaries and transform lives. Alison is the world’s largest free online empowerment platform for education and skills training, offering over 5000 CPD accredited courses and a range of impactful career development tools. It is a for-profit social enterprise dedicated to making it possible for anyone, to study anything, anywhere, at any time, for free online, at any subject level. Through our mission, we are a catalyst for positive social change, creating opportunity, prosperity, and equality for everyone. |
| Career Path | What You Will Learn In This Free Course • Describe the procedures for formatting texts and fixing errors in Google Sheets • Indicate the basic formulas used for mathematical operations in Google Sheets • Order input data by using the sorting, filtering and ranking tools • Explain basic data analysis, essential formatting, and conditional formatting techniques • Analyze data via advanced functions and multi-tab formulas • Relate the concatenation and vertical lookup functions used for processing data • Translate data into graphs, charts, and pivot tables for visualization • Indicate the applications of Google Sheets by creating a home or work budget |
| Course Code | 3561 |
Boost your business leadership and management abilities, organisational skills, and recruitment know-how, for free.
This free maths course explains geometric functions, their applications, and gives an overview of logic statements.
Learn how academic disciplines come together as the social sciences to explain societies in this free online course.
This free online course provides the administrative skills required to ensure the smooth running of a legal office.
