Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde.

Excel - Large amount of data and visualization (EN)

e-kurz

Kurzem Vás provede Microsoft office Specialist

The lecturers have over 10 years of experience in leading training and belong to the core team of MS Office. In addition to Office, HTML and Adobe…

Základní info

Popis kurzu

We will introduce you to tools that will help clean up and organize data into a database.

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.

Cíle kurzu

Editing a table into a database form

Data visualization - conditional formatting

Subtotals in tables

Určeno pro

Všem uživatelům Excelu.

Obsah kurzu

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

Předpoklady

Basic work with PC and Excel.

Návaznosti

Excel - Functions for working with text and calendar dates, Excel - Logical and conditional functions, Excel - Top 6 search functions, Excel - Introduction to reporting with contingency table, Excel - Advanced reporting, Excel - Interactive dashboards, Excel macros - Easy uploading, Excel: macros - Don't be afraid of code or an introduction to understanding VBA

Bližší popis na stránkách dodavatele