• Search...

categories: Technology, Science & Productivity

Skills
Software
Technology

The Analysis Fundamentals Course

Duration: 1 h 31 m / 27 lessons

Level: General

Course Language: Arabic

By the end of this course, you will be able to

  • Understand how to insert data into cells and format and resize cells. You will also learn to use different tools such as drop-down menus and command buttons.

  • Use key functions such as SUM, AVERAGE, and IF, as well as statistical analysis tools such as graphs and charts.

  • Define the properties of Excel functions and adjusts them according to needs, use formatting tools to organize data and avoid common errors.

  • Save a lot of time by using Excel shortcuts for every action you need to take.

Course details

  • 1 h 31 m/27 lessons
  • Last updated: 7/4/2024
  • Course completion certificate

Course Content

Free lessons

1.

Workbook\Worksheet\Cells\Formula bar

2 Minutes
2.

Analysis Formatting

10 Minutes
3.

Period Functions

8 Minutes
4.

Excel Data Proofing

1 Minutes
5.

IF statements

4 Minutes
6.

Formula Tracing

3 Minutes

About this course

This course offers a comprehensive understanding of Excel for effective data analysis. You'll learn how big companies leverage data for strategic decisions and gain access to advanced Excel tools. From mastering basic tasks like data insertion and formatting to utilizing functions, statistical analysis, and charts, you'll handle Excel with confidence. Dive into practical techniques such as freezing pages, copying information, naming data, and tracing functions. Discover how to control and format data for readability and gain insights into Excel's general and advanced features. Moreover, you'll learn to discover and replace data accurately, enhancing your analytical skills. Excel is your gateway to proficient data analysis – start learning now!

Course requirements and prerequisites

1- a computer or laptop with Microsoft Windows. 2- Microsoft Excel 2016, Excel 2019, or Microsoft 365. 3- No Prior Excel Knowledge Required.

Mentor

The Analysis Fundamentals Course

Duration: 1h 31m / 27 lessons
Level: General
Course Language: Arabic