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 qpdf and poppler-utils.

[mai mult...]

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.

[mai mult...]

[mai mult...]

jQuery UI is a curated set of user interface interactions, effects, widgets, and themes built on top of the jQuery JavaScript Library. Whether you’re building highly interactive web applications, or you just need to add a date picker to a form control, jQuery UI is a perfect choice.

[mai mult...]

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...]

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...]

In VBA, it is mandatory to understand the loops. A loop allows you to conduct the same activity for many cells or objects in excel. VBA For Each Loop can loop through all the set collections of objects or items. For example, a group means “All the opened workbooks,” “All the worksheets in a workbook,” and “All the collection of shapes and charts in the workbook.”

[mai mult...]

A macro is a code written in VBA (Visual Basic for Applications) that allows you to run a chunk of code whenever it is executed. When you record a macro, Excel closely watches the steps you’re taking and notes it down in a language that it understands – which is VBA.

And since Excel is a really good note taker, it creates a very detailed code (as we will see later in this tutorial). Now, when you stop the recording, save the macro, and run it, Excel simply goes back to the VBA code it generated and follows the exact same steps.

[mai mult...]

You can easily edit a formula through the formula bar or directly in the cell. While this makes it convenient to create formulas in Excel, it comes with a few disadvantages as well. By default, all the cells are locked in Excel. Only when you protect the locked cells can you truly restrict the user from making changes. This also means that if a cell is not locked and you protect it, the user would be able to make changes.

[mai mult...]

Excel is the most popular spreadsheet software available in the Microsoft Office package. It is easy to use and it provides many useful features. But recently, Windows users have been complaining that Excel is using too much CPU.

Here’s a list of possible reasons that can provoke Excel to use too much CPU.

• Outdated Microsoft Office application
• Corrupted Excel file
• Interference by third-party applications
• Problematic Add-ins

Now that you have become familiar with the issues behind high CPU usage of Excel, let’s move forward to the solutions to these issues.

[mai mult...]