Basic skills in Excel

Courses Objectives:

• Understanding the program interface and key elements.

• Enter and organize data in tables.

• Use mathematical formulas and functions for calculations.

• Create graphs and visual reports.

• Analyze data using statistical tables.

• Apply skills to practical data analysis projects.

THE Axes:

Unit1:Learn how to enter and organize data in Excel tables:

• Understand how to create Excel tables and enter data into cell.

• Learn how to format data and add headings and labels to rows and columns.

Unit2:Understand the use of Excel's mathematical functions and formulas to analyze data:

• Learn to use simple math formulas such as addition, multiplication, and division.

• Understand how to use Excel's built-in functions to perform complex calculations.

Unit3:Learn to create graphs and reports that show results in a visual and easy-to-understand format:

• Learn to create different types of graphs such as lines, bars, and circles.

• Learn how to customize graphs and add different labels and colors.

Unit4:Learn how to analyze data using tools available in Excel such as periodic tables, rankings, and filters:

• Understand how to use periodic tables to summarize data and show trends.

• Learn how to use classifications and filters to analyze data specifically and accurately.

Target group:

• Accountants and Finance

• Administrative staff

• University students

• Engineers

• Teachers and trainers