Microsoft Excel From A-Z

1. Introduction

1.1 Soo Dhawoow

1.2 lasoo dag Excel 2021

1.3 Building Blocks ( aas aasiyaadka excelka )

2. worksheet, And Tables

2.1 Worksheet Operations

3. Formats.

3.1 Format ( Qaabaynta excelka)

3.2 Conditional Formatting

4. Formulas ( Qaacidooyinka excelka)

4.1 Formulas Hor udhac

4.2 Logical Functions

4.3 Text Functions

4.4 Date & time Functions

4.5 Lookup Functions

4.6 Math Functions

4.7 Statistics Functions

5.Charts

5.1 Introduction

5.2 Line charts, Pie Area Charts

5.3 Doughnut, bubble stock charts

6. Pivots

6.1. Structure of pivots

6.2 Pivot table options.

6.3 Pivot table options p2

7. Data Analytics

7.1 What-if analysis

8. Data protection & validation

8.1 Data protection

8.2 Data validation

9. Real-world projects ( Tusaalayaal muhiima)

9.1 Payroll preparation ( sida mushaarka loogu diyaarsho excelka )

9.2 Gradebook ( sida buundooyinka imtrixaanka loogu diyaarsho excelka )

9.3 Sales Report ( sida invoice loogu sameeyo excelka )

1.1 Soo Dhawoow

Microsoft Excel From A-Z 1.1 Soo Dhawoow

Sign inSign up

Sign in

Don’t have an account? Sign up

Remember meLost your password?

Sign up

Already have an account? Sign in