What you’ll learn
-
Use different types of functions for Data Cleaning and Data Analysis
-
Prevent the user from adding Bad Data to your Google Sheets Database and Highlight Important Data based on pre-defined rules.
-
Use Data Security features to protect your work when working on Collaborative Projects
-
Complete a Project to Streamline and Automate the Workflow at your Company
The functions covered in this course include:
- Mathematical Functions: COUNTIF, COUNTIFS, COUNTUNIQUE, FLOOR, CEILING, ROUND, ROUNDUP, ROUNDDOWN, ISEVEN, ISODD, SUM, SUMIF & SUMIFS
- Statistical Functions: AVERAGE, AVERAGEIF, AVERAGEIFS, COUNT, COUNTA, MIN, MAX & RANK
- Text Functions: LEN, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, TRIM, REPLACE, SUBSTITUTE, REGEXREPLACE, REGEXMATCH & REGEXTRACT
- Logical Functions: AND, OR, IF, NESTED IF, IFS, SWITCH, IFERROR & IFNA
- Filter Functions: FILTER, SORT & UNIQUE
- Date & Time Functions: DATE, ISDATE, DATEDIF, DAY, MONTH, YEAR, DAYS, DAYS360, EDATE, EOMONTH, NOW, TODAY, HOUR, MINUTE, SECOND, WEEKDAY & WEEKNUM
- Other Important Functions in G-Sheets: VLOOKUP, IMPORTRANGE, ARRAYFORMULA, QUERY & CONCATENATE
Who this course is for:
- This course is meant for all such learners who use Google Sheets or Microsoft Excel at their Job and want to streamline and automate their workflow
Can I download Google Sheets for Data Analysis and Workflow Automation course?
You can download videos for offline viewing in the Android/iOS app. When course instructors enable the downloading feature for lectures of the course, then it can be downloaded for offline viewing on a desktop.Can I get a certificate after completing the course?
Yes, upon successful completion of the course, learners will get the course e-Certification from the course provider. The Google Sheets for Data Analysis and Workflow Automation course certification is a proof that you completed and passed the course. You can download it, attach it to your resume, share it through social media.Are there any other coupons available for this course?
You can check out for more Udemy coupons @ www.coursecouponclub.com
Note: 100% OFF Udemy coupon codes are valid for maximum 3 days only. Look for "ENROLL NOW" button at the end of the post.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.