Introduction to Data Analysis (using Excel)
Description
Excel is still one of the most usefull applications in data cleaning and analysis. This course designed for beginers, to learn the data analysis techniques through practical sessions in Microsoft Excel.
COURSE OBJECTIVES
•To work with the different components of the Excel
worksheet
•To load and clean data
•To work with Excel formulas
•To learn how to work with tables
•To learn how to use conditional formatting and styles
•To import and export data
•To visualize the data using different charts
•To know how to choose the right chart for your data
•To know how to create macros
•To learn how to streamline and analyze data with Excel
Pivot Tables and Pivot Charts
•To practice what you learned in a real project
COURSE SYLLABUS
•Introduction to data analysis
•Creating a Microsoft Excel Workbook and entering data
•Formatting Microsoft Excel Worksheets
•Using formulas
•Conditional formatting techniques
•Data Visualization using different types of charts
•Developing pivot tables
•Creating and editing macros
•Importing and exporting data
•Practicing the Data cleaning techniques
•Final practical project
Registration fee :
€ 490
Target audience
- IT staff
- Analytics staff
- Fresh Graduates
- Computer Science and IT Students
Requirements
- No previous programming skills needed
- No previous skills in excel
- needed