The calculation of matrices is one of the most difficult numerical computation tasks. You may need to add values diagonally in a table when performing mathematical computations. Excel allows you to sum diagonal numbers without having to add the values one by one. We’ll go through how to sum cells diagonally down or diagonally up.[mai mult...]
AutoFit in Excel
Excel’s AutoFit is used to automatically resize cells in a worksheet to accommodate different sized data and avoid manually changing the column width and row height. We can set column width and row height manually as per our requirement by clicking on column width or row height in the Format option in the cells group on the Home tab.[mai mult...]
Send and receive Gmail from the Linux command line
Because it’s relatively rare to run your own email server today, and because Gmail is very common, this tutorial assumes you’re using Mutt with Gmail. If you’re concerned about email privacy, consider opening an account with ProtonMail or Tutanota, both of which provide fully encrypted email.Tutanota has many open source components, and ProtonMail provides an IMAP bridge for paid users so that you don’t have to work around accessing your email outside a browser. However, many companies, schools, and organizations don’t run their own email services and just use Gmail, so you may have a Gmail account whether you want one or not.[mai mult...]
Shrink PDF size with this command line trick
Simple Scan has two resolution settings, Images and Text, and saves files as PDFs. Unfortunately, the quality of the scans—the words, numbers, and graphics—is unsuitable using the Text setting, but the files are quite large—up to 5MB for just a few pages—using the Image setting. I found an answer to the latter problem using the commands
ps2pdf, which are part of the Ghostscript package. This solution shrinks the size of PDF files, making them easier to share via email.
The man pages for these commands are terse, and it was challenging to find good documentation for them and their settings. So I pieced together the following by combining information from the man pages with various other bits of advice I found on the internet.[mai mult...]
Edit PDFs on the Linux command line
Many of the documents you receive come in PDF format. Sometimes those PDFs need to be manipulated. For example, pages might need to be removed or added, or you might need to sign or change a specific page.
There are some fancy graphical user interface tools that let you edit PDFs, but I have always been most comfortable with the command line. Of the many command-line tools for this task, the ones I use when I want to modify a PDF are
How to Automate Excel Report using Powershell Script
In this article, we will learn how to manipulate excel rows and columns to automate a repetitive report generation in PowerShell.
- To open the ISE -> click the windows button + r to open the run window and type powershell_ise.exe
- As you can see on the right-hand side of the screen tab, Commands has a list of modules that can be imported for use.
Excel not responding, hangs, freezes or stops working
How to Create a Drop Down List in Excel
A drop-down list is an excellent way to give the user an option to select from a pre-defined list. It can be used while getting a user to fill a form, or while creating interactive Excel dashboards. Drop-down lists are quite common on websites/apps and are very intuitive for the user.[mai mult...]
Excel VBA MsgBox
VBA MsgBox function is like an output function used to display the generalized message provided by the developer. It is like a print statement. This function or statement has no arguments. The personalized messages in this function are written under double quotes, while one must provide the variable reference for the values.[mai mult...]