Kıbrıs Google Workspace - Sheets Advanced Eğitimi

Module 1 - Automating Tasks in Sheets with Macros 

• What is a Macro
• Record Macros
• Comparing Relative and Absolute Macros
• Running a Macro
• Edit or Delete a Macro

Module 2 - Formatting Cells with Conditional Formatting 

• Add Conditional Formatting to a Range of Cells
• Add Multiple Conditional Formats
• Apply a Conditional Format with Colour Scales
• Apply Conditional Format with Formulas

Module 3 - Use Data Validation to Restrict User Entry

• Restrict User Entry with Numbers
• Restrict User Entry with Text
• Dropdown List Validation
• Creating Dynamic Validation Lists

Module 4 - Google Sheet Protection and Sharing 

• Protecting a Cell Range
• Protecting a Google Sheet
• Applying an Editable Range to a Protected Sheet
• Share a Protected Sheet with a Colleague

Module 5 - Advanced Formulas and Functions 

• Date and Time Functions
• Logical Functions – IF, AND, OR, SUMIFS
• Lookup Functions – Index, Match
• Array Formulas in Sheets

Module 6 - Working with Sparklines

• What are Sparklines
• Insert Sparklines into a Google Sheet
• Change Sparkline Options

Module 7 - Importing and Exporting 

• Importing a Range of Data from another Google Sheet
• Importing Data from a Web Page