To have a variety of data lists is a luxury! Often you have different data sources such as SAP or CRM. How to import data smoothly from external sources to Excel? And how to convert the data into useful information? Our trainer will answer all these questions during this two-part session. You will also learn how to filter and sort your data to retain an overview.
Anyone who uses Excel to process data
Thorough basic knowledge of Excel
Importing your external data to Excel becomes a breeze after this session. The trainer will also focus very briefly on analysing this data using PivotTables and charts. This enables you to create powerful analyses that will impress everyone.
1. Importing data
2. Correcting data
3. Analysing data
Do you need to quickly filter a long list only by data you want to view immediately? In this session, you will discover the power of Excel filters! We will focus in detail on the best way to filter data types and what options there are. Apart from filtering, sorting data can also be useful to add more structure. We take a look at how you can create your own lists to use for sorting.
1. Filtering and sorting
2. Text filters
3. Numerical filters
4. Chronological filters