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.
When making reports, multiple Excel documents are often used. As you know, data in another worksheet or other document, if it is open, we can easily access by specifying the absolute address of a cell or cell range. But what if we want to access a closed document? And can Excel be used as a data repository? About the link to other Excel files more in the text that follows.
Excel is a software with lots of features, but perhaps its best application is data analysis. In order to have something to analyze, we must retrieve the data. Operational data are held in relational databases, so we should connect to DBMS. Most of the time it is and istance of Microsoft SQL Server. When connecting we’ll importing a content of a table, view or result of a query into Excel worksheet.
Switching the Excel spreadsheet to another application like, for example, PowerPoint can be an inconvenient job. If it hates you to deal with details, there is a very simple way to do this, that is to convert the final table into an image, and then copy the image to the desired destination. This can be done using the Paste Special option, as well as using the Camera tool, and the following text will explain how to make the most of this option.