Management by the formats of cells for a quality reflection from values
Editing and registration of spreadsheets for presentation presentation of data. New possibilities of formatting of cells.Registration of tables by means of formats of cells
How to make a selection in Excel from the list with conditional formatting?.Effective applications of the combination of conditional formatting and the drop-down list to retrieve data groups from the table by condition. How to quickly make to the simple sampling of identical cells?
Transformation of the text to a number in the Excel cell.How to convert to a text into a number using the Error menu, the simplest mathematical operations, special insertion, the tool Text on columns and macros.
How to hide or display rows and columns in Excel.Configure the visibility of data by hiding rows and columns. Document formatting for easy viewing and preparing of the printing. There is displaying of hidden data in the rows and the columns.
How to TRANSPOSE a data table in Excel with invert.You can transpose the table via the TRANSPOSE function with using the special insert and creating the PivotTable. All methods are different from each other functionally and effectively.
Conversion of the number in the currency format on the condition.There are automatic assignment of the currency format with different currency for the entire column on the condition and the highlighting of duplicate cells with color with the same value.
How to find Identifying Duplicate values in Excel column?.The searching of the duplicate cells values in the whole table or in the single column. How we can automatically to find the duplicates date and to highlight them with color in the large control list?
How to compare two Excel spreadsheets using 2 columns.Comparison of two lists in a single sheet on the coincidence of data. Color highlighting of missing values in two similar tables by content.
Conditional formatting training in Excel with examples.Conditional formatting serves to visualize information on a user-defined rule. How to use and in which cases it is rational to apply this effective tool.
How to copy a table in Excel by saving the format cells.Copying tables while preserving column width, row height, cell formats and data types. Examples of effective use of a special insert. The fastest way to qualitatively copy a large and complex table.
4 methods to change comma to decimal point in Excel.An overview of the different ways to replace a point with a comma suitable for certain conditions and tasks. Eliminate the problems associated with a dot in place of a comma in fractional numbers.
