We meet the hyperlinks every day while surfing the Internet, and they have long time ago become part of Office applications. In Excel, this is often an unfairly ignored functionality. In addition to allowing you to go to an Internet presentation or write a letter to the specified e-mail address, a link can also be used to create a new document or position it on a prefix in an existing document.
In several previous posts I wrote about the formatting of the contents of the cell. In addition to the standard ways of displaying its content, users can also define custom views. User-defined formats can be greatly used to enrich the appearance of the report. Using them, we achieve effects similar to the conditional formatting technique, and we can easily copy them or use them to create formatting styles.
A digital signature is a way to check the authenticity of a digital message or document. A valid digital signature is a proof that a message or document has been created by a well-known author, and that she has reached the recipient in the unmodified form. The text that follows will first be about the digital certificate, then how the user signature is inserted into the Excel, the digital certificate is appended and the digital signature of the document is generated.
When formatting the content of a cell, one of the items that we can set up is the way the content of the cell is displayed. Since the options for creating such formats are in the Number tab of the Format Cells dialog box, the settings to be addressed are often called “formatting the number”. Although the content of a cell does not have to be a number. It can also be text, date, time or other information. Have you ever wondered: how to create custom formats?
Inventory is necessary but always dull (whatever kind of inventory you do). Since some time ago and I was a member of the Inventory Commission, this experience has served as an inspiration to write an article about a good way of using collaboration tools in Excel (Shared tables) to facilitate inventory process. This is also a good way to use Windows tablets that your company have bought. Most of the time they are only used for show off, and now they could have a real purpose.