by Lalit Salunkhe | Nov 29, 2021 | Format
One thing Google Sheets lack is the ability to add table objects to store your data. There is no such option under Google Sheets to add a table for a selected range. It sometimes compromises the readability of the data. If you are working with data with multiple...
by Lalit Salunkhe | Nov 24, 2021 | Functions
If you are working with datasets stored in different workbooks or worksheets, often the headache would be finding a way of merging information from multiple sheets based on a specified key column. You may frequently come across a situation where some part of the...
by Lalit Salunkhe | Nov 15, 2021 | Functions
If you are frequently working on Google Sheets, you might have observed a dataset with first and last names being stored in two different columns. Keeping these two fields in separate columns makes it easier for analysts to filter people based on their first or last...
by Lalit Salunkhe | Nov 1, 2021 | Shortcuts
Zooming in and out is such a basic feature in any tool that we usually forget its importance unless it’s not available and you have to find alternatives. Imagine a situation where you need to enlarge the sheet during a presentation and your manager is sitting...