MASTER 2013 - VideoAndMovie

59 Change row height

0:28

59 Change row height

58 Change width of the column

0:28

58 Change width of the column

57 if statment

1:19

57 if statment

56 Average function to get an average of the values

0:22

56 Average function to get an average of the values

55 MIN function to find lowest value

0:45

55 MIN function to find lowest value

54 MAX function to find highest value

0:47

54 MAX function to find highest value

53 Apply different cell styles excell

0:44

53 Apply different cell styles excell

52 Zooming in or Zooming out your worksheet

0:48

52 Zooming in or Zooming out your worksheet

51 Delete a column from worksheet

0:56

51 Delete a column from worksheet

50 Delete a row from worksheet

0:48

50 Delete a row from worksheet

49 Workbook views Page Break Preview

0:42

49 Workbook views Page Break Preview

48 Replicate the same formula to other cells

1:02

48 Replicate the same formula to other cells

47 Replace the word in your worksheet

1:25

47 Replace the word in your worksheet

46 Insert chart Bar Line

0:58

46 Insert chart Bar Line

45 Insert chart Pie or Column

1:14

45 Insert chart Pie or Column

44 Insert a hyperlink to your worksheet

1:10

44 Insert a hyperlink to your worksheet

43 Change the page orientation to landscape

0:51

43 Change the page orientation to landscape

42 Remove the gridlines from the given worksheet

0:33

42 Remove the gridlines from the given worksheet

41 Insert a new worksheet and rename it

0:41

41 Insert a new worksheet and rename it

01 Change the attribute of the file to Read only

0:45

01 Change the attribute of the file to Read only

02 Rename the file

0:39

02 Rename the file

03 Copy the file from one folder to another folder

0:33

03 Copy the file from one folder to another folder

04 Move the file from one folder to another folder

0:39

04 Move the file from one folder to another folder

05 Delete the file folder

0:39

05 Delete the file folder

06 Change the attribute of the file to hidden

1:19

06 Change the attribute of the file to hidden

07 Replace a word with another word throughout the document

0:41

07 Replace a word with another word throughout the document

08 Change the font of the given text

0:47

08 Change the font of the given text

29 Apply words only underline style

0:38

29 Apply words only underline style

30 Insert a picture and align it to left or right

1:12

30 Insert a picture and align it to left or right

39 Text wrapping in a cell

0:26

39 Text wrapping in a cell