DataSherpas Quick Tips

A collection of quick tips and articles helping you achieve more with Google Sheets, Excel, Power BI and Looker Studio - Short practical help with no fluff.

How to make a graph in Google Sheets. Pie chart, line graph, or bar chart.
How to hide and unhide columns in Google Sheets
How to total or sum a column in Google Sheets
How to add columns in Google Sheets
How to rotate text in Excel
How to merge and center in Excel
How to wrap text in Google Sheets
How to freeze columns in Google Sheets
How to freeze a row in Google Sheets
How to remove a hyperlink in Excel
How to create a drop down list in Google Sheets
How to highlight every other row in Excel
How to lock cells in Google Sheets
How to unmerge cells in excel
How to merge cells in Google Sheets.