Google Sheets for Data Analysis and Workflow Automation

Partner: Udemy
Affiliate Name:
Area:
Description: "Google Sheets for Data Analysis & Workflow Automation" is a comprehensive course designed to equip learners with the skills to use a Google Sheet effectively for analysing data and automating the workflows. This course is ideal for individuals who are new to Google SpreadSheet or those who have some experience in sheets but want to enhance their skills to analyse data more effectively and streamline their workflows.Throughout the course, learners will learn to perform a range of data analysis tasks using Google Sheets, such as cleaning and organizing data, using various functions to analyze the data and implement automation through Google Forms as a bonus package of this course. Learners of this course will be able to work on two real life projects, one on Sales Data Analysis and another on implementing a completely Online Leave Application and Approval workflow by leveraging Google Sheets, Google Forms and Gmail Productivity features in Google Workspace (G Suite).The functions covered in this course include:Mathematical Functions: COUNTIF, COUNTIFS, COUNTUNIQUE, FLOOR, CEILING, ROUND, ROUNDUP, ROUNDDOWN, ISEVEN, ISODD, SUM, SUMIF & SUMIFSStatistical Functions: AVERAGE, AVERAGEIF, AVERAGEIFS, COUNT, COUNTA, MIN, MAX & RANKText Functions: LEN, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, TRIM, REPLACE, SUBSTITUTE, REGEXREPLACE, REGEXMATCH & REGEXTRACTLogical Functions: AND, OR, IF, NESTED IF, IFS, SWITCH, IFERROR & IFNAFilter Functions: FILTER, SORT & UNIQUEDate & Time Functions: DATE, ISDATE, DATEDIF, DAY, MONTH, YEAR, DAYS, DAYS360, EDATE, EOMONTH, NOW, TODAY, HOUR, MINUTE, SECOND, WEEKDAY & WEEKNUMOther Important Functions in G-Sheets: VLOOKUP, IMPORTRANGE, ARRAYFORMULA, QUERY &&n
Category: Office Productivity > Google > Google Sheets
Partner ID:
Price: 69.99
Commission:
Source: Impact
Go to Course