Excel In English Advanced Level

Formation Excel In English Advanced Level

Créé par

Wiki form

5h 57m

2 Enrolled

(0 Avis)

Dernière mise Ã jour

Mon, 21-Apr-2025

Course description

Formation complète sur Excel In English Advanced Level

What will i learn?

40 leçons • Durée totale: 05:57:08 Développer toutes les sections

Section 1: Leçons 1 à 5

5 leçons 39 min

1_0_Introduction

2 min
1_1_COUNTIF COUNTIFS Functions

9 min
1_3_MAXIFS MINIFS Functions

8 min
1_2_SUMIF SUMIFS Functions

15 min
1_4_AVERAGEIF AVERAGEIFS

8 min

Section 2: Leçons 6 à 10

5 leçons 51 min

Quiz A | Functions for processing multiple criteria.

3 min
1_5_INDEX and MATCH are better than V LOOKUP

10 min
1_6_How To Perform INDEX or MATCH

14 min
1_7_How To Combine INDEX and MATCH

14 min
1_8_How To Perform INDIRECT

11 min

Section 3: Leçons 11 à 15

5 leçons 38 min

Quiz B | Combine advanced search functions

3 min
1_9__Text To Column Feature

8 min
1_10_How To Manage TEXT functions

16 min
1_11_Using Flash Fill

9 min
Quiz C | How to manipulate text values

3 min

Section 4: Leçons 16 à 20

5 leçons 64 min

1_12_How To Up Date Pivot Table

16 min
1_13_Perform Advanced Calculation In Pivot Table

11 min
1_14_Show Report Filter Pages

8 min
1_15_Create Pivot Chart Report

18 min
1_16_How To Merge Databases To Pivot Tables

13 min

Section 5: Leçons 21 à 25

5 leçons 46 min

1_17_Create A Dashboard

16 min
1_18_Create Automatic Subtotals

10 min
1_19_Merge Tables With Consolidation Tool

8 min
1_20_Merge Tables To Pivot Tables

11 min
Quiz D | Advanced Pivot Table & Pivot Chart Insert subtotals in a list of data in a worksheet and how to merge data from different Excel’s sources.

3 min

Section 6: Leçons 26 à 30

5 leçons 39 min

1_21_Goal Seek Feature

9 min
1_22_Data Table Feature

11 min
1_23_Scenario Manager Feature

12 min
Quiz E | Data analysis tools

3 min
1_24_What Is A Recorded Macro

5 min

Section 7: Leçons 31 à 35

5 leçons 50 min

1_25_Prepare Your Workbook To Record A Macro

6 min
1_26_Record Basic Macro

12 min
1_27_Run And Edit Macro

11 min
1_28_Record A Personal Macro Workbook

9 min
1_29_Define Macro Buttons

14 min

Section 8: Leçons 36 à 40

5 leçons 22 min

1_30_Relative VS Absolute Macros

11 min
1_31_How To Remove Macro

3 min
1_32_Macro Security

5 min
Quiz F | How to record and manage macros

3 min
1_33_Conclusion

2 min

Wiki form

Voir le profil Follow

80 €

Cours

40

Skill level

Débutant

Expiry period

Lifetime

Remove from cart Ajouter au panier Acheter maintenant

Related courses

Avancé

Excel 2019 Avance

(0 Avis)

Comparer

tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1 tets 1