Category: Excel files

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 –>

Basic Excel formulas and functions

Microsoft Excel is the most common application used for calculations and visual presentation of data. Excel makes it possible to automate even the most complex calculations. Knowing the basic formulas and functions of this program allows you to perform all these tasks much faster. It is very useful to use formulas when a large number… Continue reading –>

How to draw a line in Excel

In MS Excel, you can not only create tables and work with data from these tables, but also create charts and graphs, as well as draw various shapes, lines, arrows. You will be surprised how easy it is to draw a line of the desired length and parameters. Lines can be used to connect different… 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 –>

A few tips for working with Excel

Have you used Microsoft Excel office application in your work? Many people will answer this question in the affirmative. It doesn’t matter if you are an experienced user or a beginner, there are many ways that will greatly simplify the work with this program and make the process less time consuming and more efficient. How… 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 –>