Excel - Large amount of data and visualization

This is a tool for text into columns, removing duplicates, finding empty cells and filling them. For better clarity, it is advisable to dock a row or column and turn on the filter in case we would be interested in data only according to specified criteria. To work with large data, it is advisable to sort the tables according to the specified parameters. Large tables should also be edited from a printing point of view in case they are exported to PDF format.

Basic work with PC and Excel.

Všem uživatelům Excelu. 

Editing a table into a database form

• Text in columns
• Remove duplicates
• Find empty cells
• Data filtering
• Setting of partitions
• Set up drop-down lists in cells
• Sort records in a table
• Header and footer
• Print larger tables
• Database table

Data visualization - conditional formatting

• Simple rules
• Complex rules with functions

Subtotals in tables

• Automatic creation of subtotals - summaries

• Editing a table into a database form
• Data visualization - conditional formatting
• Subtotals in tables