Entries with tag ‘Excel’:

How to select every second row in an Excel spreadsheet

The problem of selecting every second row is not that rare. There are many situations where this might be needed. For example, when creating a second table based on the data of the first, when every second row is copied from the main table and inserted into the newly created table. There is no special… Continue reading –>

How to make a dash instead of a zero in a table

In some reports, it is preferable to put a dash instead of a zero in cells with a zero value, because a dash is more appropriate than a zero in a cell. To improve the readability of tables, there are several ways to notice 0 by (-). Changing the number format Using a custom format… Continue reading –>

Useful tricks for working in Excel

Useful Excel practices significantly reduce the time spent on handling spreadsheets and increase the efficiency of using the application. With the advent of new versions, it becomes more and more convenient to work with MS Excel, which is why it is so useful to know the useful functions and features of the program that have… Continue reading –>

Remove blank rows in Excel

Blank rows in Excel tables often occur when merging multiple tables into one or when importing data from one table to another. They often interfere with the comfortable perception of the table data and make it difficult to navigate the table. There are different ways to remove blank lines in Excel tables. Here we will… Continue reading –>

How to extract month name from date in Excel

Microsoft Excel stores data in the “date” format always in the same form. However, the display of this data in the table can be different. There are many ways to represent a tabular date in the format you want. For example, sometimes it is necessary to extract only one element from a date in an… Continue reading –>

How to copy values in Excel without formula

Individual cells in Excel tables can include not only ordinary numbers, text, or other formats, but also the results of calculating formulas. A normal copy and subsequent pasting of such values copies not only the contents of the cell, but also the formula applied to this data. As a result, the copied numbers, after the… Continue reading –>

Excel Pivot Tables

Users rarely use Excel PivotTables because of the apparent complexity. However, the effort and time that will be spent on learning them will pay off in a tremendous way from using this tool. Pivot tables are often indispensable when analyzing data from very large tables in various aspects. So, pivot tables should be used if… Continue reading –>

Financial Formulas in Excel

A significant part of the time for many economists or financiers is spent working on a computer with the MS Excel office application. This program has a considerable number of functions intended for creating reports, data analysis, information plans, mathematical calculations and much more. Knowledge of the most important Excel formulas and a combination of… Continue reading –>

Temporary files

Many users of computers and laptops know that among their large number of files on their devices there are so-called «temporary files”. Some believe that they need to be removed in one way or another. Other users are wary of doing this because they think it will damage their computer. What are temporary files? Where… Continue reading –>

Excel Text Functions

Excel tables contain mostly numerical data on which you can perform various mathematical, logical and other operations. At the same time, a considerable part of the tables contains cells with text. For example, price lists or customer lists with addresses certainly include test data. In order to perform various transformations on this data, Excel text… Continue reading –>