Many of us store and manage PDF files in Google Drive. It is an excellent tool if we want to share the files with someone or access them remotely. However, when it comes to editing, that is a bit more difficult because PDF is hard to modify, and there are still no inbuilt editing features … Read more
We have already shown you how you can convert PDF tables to Google Sheets, and now we can talk about what happens when you have a spreadsheet ready for further editing. On mobile phones the Google Sheets interface is different than on the web, which is why some things are done differently. The following tips … Read more
Microsoft Excel has a limit on the number of rows it supports. The limit is 1,048,576 rows or 16,384 columns. If you are trying to open a csv file that contains an exceeding number of rows or columns in Excel, the software will send a notification that the file is not loaded completely. Understandingly, that … Read more
When you need to send someone a spreadsheet and want to make sure that no changes to any formulas are made, you can resort to locking a sheet or workbook. It is also possible to lock specific cells. That way you can protect your document from changes in certain places, while other cells can easily … Read more
Everybody who has worked with Microsoft Excel knows that it is a complex piece of software that takes years to master. Many professionals are still not confident in their knowledge of Microsoft Excel. If you are a beginner in learning Excel and want to advance beyond basic operations, the best solution is to attend a … Read more
We have already explained how Microsoft Excel can be used as a basic statistical analysis software. The first step in the process requires turning on the Statistical Analysis feature, after which you can perform linear regression, ANOVA and much more. Unfortunately, for a more serious analysis users need specialized software such as SPSS, Eviews or … Read more
Your knowledge of Microsoft Excel is not complete until you’ve learned the VBA language. Knowing VBA can help you automate repetitive tasks easily. Furthermore, if you know how to code, you’ll be able to spend only an hour or less on things that you previously needed a whole day to do them manually. That is … Read more
When code is not working as it should, it can be hard to locate the error if you have multiple lines of code. Hours can be spent searching for the mistake, without success. To avoid such situations, it can be helpful to use some of the debugging tools that come with Microsoft Excel. Run Code … Read more
Writing VBA code in Excel has many challenges. Sometimes we test and experiment with large blocks of code. In such cases it would be useful to have an option to comment or uncomment multiple lines at once. Otherwise, if we do it line by line, we can waste a lot of time. This tip can … Read more