Course review
In this course, you will learn the basics of Spreadsheet Automation and working with Tables, Microsoft Excel and Google Sheets automation activities in the ElectroNeek Studio Pro.
Course plan
-
1
Intro to Spreadsheet Automation
-
Spreadsheet Automation Challenges
-
Spreadsheet Automation Activities
-
Check your understanding
-
-
2
Practice: Tables Automation Activities
-
The 'Read table' activity
-
Check your understanding
-
The 'Remove empty rows' activity
-
Check your understanding
-
The 'For each row' activity
-
Check your understanding
-
The 'Save table' activity
-
Check your understanding
-
-
3
Practice: Microsoft Excel Automation Activities
-
The 'Read Excel file' activity
-
Check your understanding
-
The 'Write Excel file' activity
-
Check your understanding
-
The 'Append row to Excel file' activity
-
Check your understanding
-
The 'Read Excel Range' activity
-
Check your understanding
-
The 'Write Excel Range' activity
-
Check your understanding
-
The 'Read Excel Row' activity
-
Check your understanding
-
The 'Update Excel Row' activity
-
Check your understanding
-
The 'Read Excel Cell' activity
-
Check your understanding
-
The 'Update Excel Cell' activity
-
Check your understanding
-
-
4
Practice: Google Sheets Automation Activities
-
The 'Get values' activity
-
Check your understanding
-
The 'Update values' activity
-
Check your understanding
-
The 'Append values' activity
-
Check your understanding
-
-
5
Next steps
-
Share your feedback!
-
Resources & Certificate
-