課程介紹

In this course you will learn the fundamentals of Google Sheets (much of which translates to MS Excel!). You will not only learn the basics, like adding and subtracting. But you will also learn valuable advanced formulas like VLOOKUP, INDEX(MATCH()MA

…[更多細節]

哪些人適合這堂課？

• Spreadsheet users of all levels, those who want to get better at analyzing data or building spreadsheets for personal use!
• This course is not for you if you are an experienced data analyst or power spreadsheet user.
• Students who want to start a career in management consulting or tech operations!

學習目標

• Create beautiful spreadsheets with amazing formatting tricks
• Learn to manipulate text in formulas
• Connect multiple Google Sheets together using a single formula
• Analyze data sets with ease using complex functions & formulas
• Learn to build incredible data visualizations using charts
• Feel completely comfortable in a spreadsheet environment
• Learn formulas that work in both Google sheets & Excel!

課程介紹

**Updated to Include Google Sheets November 2015 Updates!!**

Become a master Google Docs user with this course on using Google Spreadsheets. You’ll learn:

How to use Google Spreadsheets just like you use Microsoft Excel
3 amazing tools only availab

…[更多細節]

哪些人適合這堂課？

• This course is meant for anyone looking to master Google Spreadsheets. You’ll learn why Spreadsheets is more powerful than Excel, and how to do everything in Spreadsheets you can do with Excel (and more).
• Students should not take this course if you are a horse, lack thumbs, or already know how to do advanced things with Spreadsheets like write scripts and use pivot tables.

學習目標

• Use Google Spreadsheets like Da Vinci
• Create charts and graphs using Spreadsheet data
• Format and customize any data
• Use advanced tools like Macros, ImportHTML and Scripts to do things you can do with Excel

課程介紹

Hi and welcome to the Google Sheets course for beginners. If you are brand new to Google Sheets, or if you are an Excel user who needs to transition your work to the Google Sheets platform, this course is for you!

This course was designed to make yo

…[更多細節]

哪些人適合這堂課？

• New students looking to learn about Google Sheets or experience users transitioning from Excel.
• Beginner to advanced Google Sheets users.

學習目標

• In this course you’ll become proficient in Google Sheets.
• You’ll start at the beginning and move to advanced skills in Google Sheets.

課程介紹

Learn Google Sheets in a fascinating way by doing real-world, highly-applicable projects.

As I walk you through every important feature of Google Sheets, I’ll be showing you real-world examples of situations where you can use your new Google Sheets

…[更多細節]

哪些人適合這堂課？

• Professionals and business owners who need to use Microsoft Excel or Google Sheets

學習目標

• Learn Google Sheets quickly
• Use Pivot Tables
• Use sorting and filters
• See three practical examples as class projects

課程介紹

This is the only Google Sheets course you’ll ever going to need: Because it’s going to teach you everything you need to know. From data collection, automation, to proper data analysis and visualization.

What will happen by the end of the course:

Yo

…[更多細節]

哪些人適合這堂課？

• Business professionals looking to expand their skills.
• Absolute beginners who want a structured, engaging, fun and practical Google Sheets course.
• Spreadsheet users who want to discover & showcase new tips and tricks at work.
• Students who want to make sure they have the right level of knowledge to succeed at their next job.
• Data analysts looking to discover new tools to help them do more in less time.

學習目標

• Solve real-life spreadsheet challenges with ease
• Create interactive & visually effective dashboards in Sheets
• Learn hacks and hidden Google Sheets features that even the Experts don’t know
• Import & append data from other Google Spreadsheets
• Learn advanced functions like QUERY, IMPORTHTML, IMPORTXML and more
• Master Pivot tables, charts and sparklines to create impressive Google spreadsheets
• Secrets to properly use tricky features like Conditional formatting
• Automate your work with Macros & Google Apps Script

課程介紹

Since I am a full time Google Spreadsheet consultant, with clients all over the world, I know what are the things that are important and should be taught to students.

Google Spreadsheet is on of the most powerful tool developed by Google. It has su

…[更多細節]

哪些人適合這堂課？

• If you are a student and you want to add another skill set in your resume, this course is for you. Having relation with data and knowing how to use them, gives you an edge always.
• If you are a working professional and and has some messy data and number of unrelated spreadsheets, this course will help you clean those mess and organize the way you work.
• If you are a manager, this course will help you to handle your team more efficiently, as you can create spreadsheet and share with your team and ask them to update. You get all data at one place in real time and your own dashboard will give you all that you need.
• If yo want to be a freelancer, this is a good place to start with. There is huge demand of google sheet experts and companies need them to fix their internal mess as well as data analysis.

學習目標

• Get to know the elements of Google Spreadhseet
• Format the text and cell to add aesthetic sense
• Arranging Rows and Columns for easy navigation
• Sharing the Spreadsheet with others for collaboration
• Using powerful functions to get desired result
• Perform various operations like concatenate, replace, substitute on bulk data
• Combine multiple functions to get more complex result easily
• Creating a dashboard to handle restaurant details
• Create an HR tracker that can be used in any office
• Creating Sales Dashboard
• Using a set of data to create any dashboard with visual appeal

課程介紹

**** Lifetime access to course materials and practice activities. ****

This course is lead by Ian Littlejohn – an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teachi

…[更多細節]

哪些人適合這堂課？

• Google Sheet users who want to learn Pivot Tables
• Excel users who want to learn how to use Google Sheets
• Google Sheets users who want to learn to analyze and report data

學習目標

• Learn to create POWERFUL PIVOT TABLES in Google Sheets in minutes
• Lifetime access to course material and practice activities from an experienced Udemy instructor
• Learn powerful methods of analysis to turn your data into INSIGHT and INTELLIGENCE
• Learn to create Google Sheet GRAPHS from Pivot Table data with a few clicks of the mouse
• Create CUSTOM calculations that can be added to your Pivot Tables TRANSFORMING the analysis of your data
• Create CUSTOM GROUPINGS of data to display your data in new ways
• Learn conditional formatting to HIGHLIGHT the key information in your data

課程介紹

Google Sheets and Forms are two incredibly powerful office apps that Google provides for free! 

This course will show you how to use Google Sheets to create incredibly powerful and complex spreadsheets, while being able to easily share and collabora

…[更多細節]

哪些人適合這堂課？

• Business professionals with a desire to increase efficiency and accessibility
• High school and college students
• People looking to transition from Microsoft to Google products
• Anyone who uses office productivity software

學習目標

• Be able to create, edit, and share spreadsheets quickly and efficiently
• Understand and add charts to spreadsheets
• Understand how to work with and filter data
• Gain a basic understanding of formulas and how to apply them
• Create forms and surveys
• Collect and analyze data from forms and surveys

課程介紹

Master Google Docs & Sheets, as well as supplemental Apps in the G Suite including Google Drive and Slides, and learn to use these tools to improve your business, market yourself as a professional, and collaborate effectively on cloud based projects.

…[更多細節]

哪些人適合這堂課？

• Anyone who needs to learn to use, and master Google Docs & Sheets
• Entrepreneurs, small business owners, non-profit leaders
• Business leaders considering a change to Docs & Sheets from Microsoft Office, Excel, and Word

學習目標

• Utilize Google Docs & Sheets to their maximum potential, to include project collaboration, data sorting and interpretation, and writing business proposals and documents.
• Create complex spreadsheets to effectively collect and interpret data within your organization.
• Create professional documents with Google Docs, including Business Proposals and summaries.
• Transition your business or non-profit into using Google Docs & Sheets smoothly, if you are new to G Suite.

課程介紹

If you’ve ever dreamed of using those really cool functions in your spreadsheets that you’ve seen other people use, then this course if for you. By the end of the course, you will be on your way to becoming a spreadsheet wizard!

In this course we’l

…[更多細節]

哪些人適合這堂課？

• Business professionals with a desire to increase spreadsheet efficiency
• High school and college students
• People looking to transition from Microsoft to Google products
• Anyone who uses spreadsheets regularly

學習目標

• Understand what functions are and how to apply them
• Full understanding of what various different functions do, and how to use them