دبلوم مايكروسوفت اوفيس

1- Interface

06:23

2- Manage Rows and Columns

04:34

3- Navigation and Selections

07:07

4- Data Types

16:46

5- Format Data

10:15

6- More about Format Content

06:54

7- Work Easy With Big Data

07:35

8- Freezing Panes

04:53

9- Fill Handle and Flash Fill

14:04

10- Paste Special Options part 1

09:25

11- Paste Special Options part 2

10:03

12- Sporting and Advanced Sorting

13:47

13- Sorting and Advanced Sorting

08:43

14- Advanced Filter part 1

11:17

15- Advanced Filter part 2

10:11

16- Conditional Formatting

16:18

17- Main Formulas

15:36

18- Absolute Reference Concept

11:21

19- IF and Nested If Part 1

08:47

20- If and Nested If part 2

10:26

21- Sum If, Sum Ifs

17:54

22- Countif, Countifs

10:28

23- Vlookup

11:57

24- Index Match 1

12:10

25- Index Match 2 Create Dynamic Lists

08:04

26- Index Match 2 Create Dynamic Lists

08:06

27- Round , Round up and Round Down

05:29

28- Text Functions

04:20

29- Calulate Age Using Datedif

08:32

30- Charts Overview and Start With Column Chart 1

10:20

31- Charts Overview and Start With Column Chart 2

11:15

32- Column Chart 3

08:12

33- Bar Chart

05:13

34- Line Chart

06:40

35- Pie Chart

07:30

36- Combo Chart

07:43

37- Spartines

06:06

38- Test To Columns and Merge Columns

07:57

39- Merge Workbooks

08:57

40- Grouping and Outlines

06:31

41- Remove Random Spaces

02:06

42- Remove Duplicated

02:58

43- Format Sheet Together

03:44

44- Consolidate

07:08

45- Using Hyperlinks

11:24

46- Creat Lists

04:56

47- Using Macros

07:33

48- Save Files

03:32

49- Print and Page Layout

12:13

50- All Ways To Protect Workbook and worksheet

15:21

Advanced Excel For Business Lec-1

17:43

Advanced Excel For Business Lec-2

12:46

Advanced Excel For Business Lec-3

08:43

Advanced Excel For Business Lec-4

14:39

Advanced Excel For Business Lec-5

06:04

Advanced Excel For Business Lec-6

11:02

Advanced Excel For Business Lec-7

15:55

Advanced Excel For Business Lec-8

09:46

Advanced Excel For Business Lec-9

11:21

Advanced Excel For Business Lec-10

12:44

Advanced Excel For Business Lec-11

08:20

Advanced Excel For Business Lec-12

13:00

Advanced Excel For Business Lec-13

14:35

Advanced Excel For Business Lec-14

10:23

Advanced Excel For Business Lec-15

07:48

Advanced Excel For Business Lec-16

09:10

Advanced Excel For Business Lec-17

12:18

Advanced Excel For Business Lec-18

07:26

Advanced Excel For Business Lec-19

24:32

1- MS Word User Interface

04:45

2- Start Typing and Selecting Text

14:49

3- Tool to Boost Your Performance Part 1

09:56

4- Tool To Boost Your Performance Part 2

07:08

5- Font Formatting Part 1

08:58

6- Font Formatting Part 2

09:55

7- Paragraph Formatting Part 1

10:36

8- Paragraph Formatting Part 2

15:12

9- CoverPage and Blank Page

09:22

10- Insert, Format and Manage Tables Part 1

08:34

11- Insert , Format and Manage Tables Part 2

13:35

12- Insert and Format Pictures

17:24

13- Insert and Format Shapes

10:37

14- Insert and Format SmartArts

09:27

15- Insert and Format Charts

03:51

16- Manage Page Layout

15:28

17- Document Design Part 1

13:51

18- Document Design Part 2

16:27

19- Manage Header and Footer

15:42

20- Insert and Control Page Number

03:06

21- Create Links and Bookmarks

08:01

22- Mail Merge

10:19

23- Compare and Combine Documents

05:55

24- Footnote and Endnote

06:48

25- Track Changes

06:54

26- Create Table Of Content

18:18

27- Create Table Of Figurs

06:55

28- Record Macros

04:49

29- Protect Documents

07:01

30- Print Document

06:14

31- Save Documents

05:15

01- User interface

06:12

02- Slide layout

12:25

03- Undo, Redo, Clipboard and format painter

10:01

04- Find, Replace and select

05:44

05- Format slides using background formatting

12:45

06- Using themes

10:32

07- Create your own theme

29:04

08- Typing and formatting text

10:24

09- Manage bullets and numbering

09:57

10- Format paragraph

04:49

11- Insert and format tables

16:32

12- Insert and format pictures

16:49

13- Insert and format shapes

17:55

14- Insert and format smarter

10:49

15- Insert and format charts

07:19

16- Insert and format textboxes

03:51

17- Insert audio files

05:16

18- Insert videos

06:52

19- Insert slide number and slide footer

03:30

20- Create and edit photo albums

07:17

21- Insert updatable excel chart to Power Point

07:50

22- Insert slides from other presentation

03:48

23- Insert text from word file

06:20

24- Create hyperlinks and actions

14:20

25- All about animations P1

10:50

26- All about animations P2

17:40

27- Slide transitions

07:21

28- Using sections

11:13

29- Presentation views

05:05

30- Start your show

12:47

31- Setup slide show with all details

08:24

32- Printing with all details

05:17

33- Protect your presentation

06:58

34- Save presentation to PDF

12:34