About the Course
Are you fascinated by the versatility of Google Sheets, a fundamental tool used across various industries? If so, we invite you to embark on a journey of exploration with "Google Sheets for Beginners." This course is meticulously crafted to provide you with the essential skills needed to proficiently manage and analyze data for business, research, and personal projects. In today's data-driven landscape, businesses are in constant need of professionals who can effectively handle, analyze, and visualize data, making this course an ideal starting point for individuals aspiring to pursue a career in business and data analysis.
Throughout this course, you'll gain invaluable expertise in data organization, manipulation, and visualization, harnessing the diverse functionalities offered by Google Sheets. Learn to leverage formulas, functions (including sorting, filtering, and pivot tables), and create compelling charts to present data insights crucial for informed decision-making.
Enhance your learning journey with hands-on exercises and a real-world case study, enabling you to apply acquired knowledge to practical scenarios effectively. Upon completion of the course, you'll possess the proficiency to work with data sets confidently and derive meaningful insights from them.
Join us today and take your analytics skills to new heights!
Who should take this course?
This course caters to individuals eager to embark on a career in business analysis, including pre-MBA students. It also serves as a valuable resource for professionals seeking to augment their expertise in this field.
Course Duration:
The course is self-paced and it takes between 10-15 hours to complete including watching the videos, and working on the knowledge checks, exercises and case studies.
Course Support:
There is a community page where you can ask questions, share your ideas and knowledge, and connect with other students and the staff.
Prerequisites:
• Gmail account.
• A thirst for knowledge.
*Courses can be conducted live online or in person upon request. For more information send an email ([email protected])!
Course curriculum
-
-
Welcome
-
Course Structure
-
ScholarU Community
-
About You Survey
-
-
-
Introduction to Spreadsheets
-
Anatomy of a Spreadsheet
FREE PREVIEW -
Getting Started with a Blank Spreadsheet
FREE PREVIEW -
Check: Rename a Spreadsheet
FREE PREVIEW -
Navigating Around the Spreadsheet
FREE PREVIEW -
Check: Cell Name
-
Formatting Columns, Rows and Cells
-
Course Content
-
Copying Course Content
-
Opening Files
-
Exercise: Spreadsheet Basics
-
-
-
Introduction to Different Data Types
-
Format Dates, Currency and Decimals
-
Check: Percentage
-
Check: Left Justified
-
Undo, Redo and Keyboard Shortcuts
-
Check: Undo
-
Check: Shortcut Keys
-
Number Data Type
-
Check: Scientific Notation
-
Exercise: Data Type Basics
-
Exercise: Data Type Basics Part 2
-
-
-
Introduction to Equations
-
Check: Addition
-
Order of Operations
-
Check: Order of Operations
-
Renaming Cells
-
Check: Renaming Cells
-
Circular References
-
Check: Circular References
-
Decimals
-
Check: Decimals
-
Exercise: Equations
-
-
-
Introduction to Functions
-
Chack: Ranges
-
Common Functions
-
Check: Common Functions
-
Nested Functions
-
Check: Nested Functions
-
Random Operations
-
Check: Random Operations
-
Customize Functions
-
Check: Customize Functions
-
Exercise: Functions
-
Exercise: Function Documentation
-
-
-
Sheet Basics
-
Exercise: Sheets
-

About this course
- $199.00
- 10-15 hrs