- Aggregating and grouping with SQL
- Data searching, filtration, and formatting with SQL
- Extracting column headers/names from a table
- Extracting uneditable macros content
- Extracting values from specified HTML tags
- Filling in empty cells based on the upper-cell present values
- Formatting as strings
- Getting local time of different time zones
- Number formatting
- Replacing uneditable macros content
- Searching for a specified pattern in a column
- Searching for a specified pattern through the entire table
- Executing calculations with SQL
- Accounting for the monthly budget
- Calculating cumulative (running) totals
- Calculating standard deviation / variance
- Calculating the completion ratio
- Calculating the number of distinct (unique) values by categories
- Calculating the number of workdays in a period of time
- Calculating time difference
- Counting the definite value in a column
- Using formulas to calculate with SQL
- Merging/JOINing tables with SQL
- Merging columns with SQL
- Processing links with SQL
- Setting conditions with SQL
- Using multiple SQL statements
- Using regular expressions in SQL
- Using SQL with Jira Issues
- Working with variables in SQL