Learn Ezy

1. Introduction

1. Introduction to Excel

2. Start Basic Data Entry

3. Start Excel Basic Formula

4. Excel Relative References

5. Order of Operations

6. Start Working With Ranges

7. Start Working With Freez Panes

8. Headers and Footers in Excel Sheet

9. Working with split screen

10. Working With Print Titles

11. Working with Notes and Comments

12. Print Options in Excel

13. Add Delete Isert column Rows and Cells

14. Cut Copy Past

15. Introduction to Functions and Formulas

1. Sheet Basic Operations

2. Connect Multiple sheet in One formula (3D formula)

3. Boarder and Shading

4. Data Validation

5. Fill Handle and Custom List

6. Format Numbers

7. Wtach Window

8. Sheet Formating-Format Number

9. Sheet-Formating-Format Painter

10. Sheet Formating-Font

11. Sheet Formatting- Allignmnet

12. Sheet Formating- styles and cell

13. Search in Sheet and Woorkbook

14. Working with Range Names

15. Sheet Sorting

16. Sheet Protection

17. Working with Tables

18. Remove Duplicates

19. Working with Charts

20. Pivot Tables and Pivot Charts

21. Working with Slicer and Time Lines

1. Count , Countif, and Countifs Functions

2. Sum, Sumif, and Sumifs Functions

3. Average, Averageif, and Averageifs Functions

4. If function-1

5. If Function-2

6. IF Function-3

7. AND OR functions

8. And Or with If function

9. IFS Function

10. Max, Maxif, Mini and Minif Functions

11. Date and Time Functions

12. DatedIF Function

13. Age Calculation In Excel

14. Weekdays and Network Days Functions

15. Vlookup-Part 1

16. Vlookup-Part 2

17. Text Functions(left,right, mid,join)

18. Forcast Function- Part 1

19. Forcast Function Part 2

20. Mode Function

21. Standard Deviation Functions

22. Rand, Ranbetween and Rand Array Functions

23. Rank and Rank average Functions

1. Create Barcode in Excel Part1

2. Create Barcode in Excel Part 2

3. Integrate Chatbot in Excel