The aim of the course is to provide participants with the specific knowledge of data use and management with MS Office Excel. The course will focus in particular on the tools used to import data from external sources and the database normalization. The course applies to the various versions of Microsoft Excel that are available on the market.
1. Importing data
• Importing data from a text file
• Importing data from web pages
• Importing data from a database
2. Working with the text
• Text functions
o The Text to Columns tool
o Using names as references in cells
o The control functions: ISERR, IFERROR
3. Working with numbers
o Rounding and cutting off numbers with functions
• Date and time functions
• Database functions
Ad hoc
Contatti
