kolkata-ff-lucky number-official-logo-browseall.in

browseall.in

browse everything on the web

Advanced Computer Classes offered to all students (Class 5 to Class 12). 100% Free. You can learn Advanced MS Word, MS Excel, MS PowerPoint and MS Access classes with live examples. Computer Programming available with very easy steps : such as C, C++, Java, Blue Java, GW Basic, Q Basic, HTML, SQL and More.

Advanced Computer Classes - Microsoft Word

Class 1 - Format Painter

Change your own language - Hindi, Marathi, Assames, Tamil and more

Check the right bottom side corner language button to change language

Definition of Format Painter : - It means copy of formatting, copy formatting from one place and apply it to another places in the document. You can apply it at multiple times.

How to Apply :- At first select any word or sentence -> Modify the word by style, color or size -> double click on Format Painter button -> where to apply, just go to there and click once or drag on word or sentence.

Shortcuts :-
1) After completed the formatting, go to applying area, Press CTRL+SHIFT+C.
2) After completed the formatting, go to applying area, Press Alt -> Press H -> Press FP.


Subscribe for more interesting videos click here <@aacAVI ( Adavnced Computer Classes ).

Practical Explained step by step in this video.

Class 2 - Change Case

Definition of Change Case : - Case means the selected text to change the paragraphs, letters and words into small, capital and other capitalization. Such as Sentence Case, Lower Case, Upper Case, Capitalize Each Word and Toggle Case.

Sentence Case :- First letter of the paragraph is Capital and all other letters and words is small letter. Example : - "The quick brown lazy dog."

Lower Case :- all letters, words and the paragraphs is small letter. Example : - "the quick brown lazy dog."

Upper Case :- all letters, words and the paragraphs is capital letter. Example :- "THE QUICK BROWN LAZY DOG."

Capitalize Each Word :- First letter of the each word is capital and other letters is small letter. Same in the paragraph also. Example : - "The Quick Brown Lazy Dog."

Toggle Case :- First letter of the each word is small letter and other letters is capital letter. Opposite of the Capitalize Each Word. Example :- "tHE qUICK bROWN lAZY dOG."

How to Apply :- At first select any paragaraph -> Go to Change Case -> Select what are you want to apply there (choose any case to apply) .

Shortcuts :-
1) At first select the specific paragraph by Press SHIFT+ down arrow -> Press Alt -> Press H -> Press 7 -> Press S (Sentence case) / Press L (lower case) / Press U (UPPER CASE) -> Press C (Capitalize Each Word) / Press T (tOGGLE cASE).

Subscribe for more interesting videos click here @aacAVI ( Adavnced Computer Classes ).

Practical Explained step by step in this video.

Class 3 - Line Spacing

Definition of Line Spacing : - Change the spacing between line of text and paragraphs.

How to Apply :- At first select or click on the specific paragraph at anywhere -> Go to Line Spacing -> select points to applying (such as 1.0, 1.15, 1.5, 2.0, 2.5).

Shortcuts :-
1) At first select the specific paragraph by Pressing SHIFT+ down arrow -> Press Alt -> Press H -> Press k -> Choose your requirement to apply.
Press B (Add space before paragraph) and Press A (Remove space after paragraph).

Subscribe for more interesting videos click here @aacAVI ( Adavnced Computer Classes ).

Practical Explained step by step in this video.

Class 4 - Bullet List

Definition of Line Spacing : - Create a bullet list with different style of bullets. Click the down arrow to explore more.

How to Apply :- click on bullet list or menu to choose different style of bullets -> Type your list -> Modified with the bullet menu to change color and decoration.

Shortcuts :-
1) Press Alt -> Press H -> Press U -> Choose your requirement to apply by left or right arrow -> Press C (change list level) / Press D (Define new Bullet).

Subscribe for more interesting videos click here @aacAVI ( Adavnced Computer Classes ).

Practical Explained step by step in this video.

Class 5 - Multilevel List

Definition of Multilevel List : - Create a list. Multiple list or Multilevel list. You can create a multilevel list to 9 levels at a time. Use Tab key and Enter Key to build more. Click the down arrow to explore more.

How to Apply :- click on multilevel list or menu to choose different style of lists -> Type your list -> Modified with Define new multilevel list to change list type or color and list decoration.

Shortcuts :-
1) Press Alt -> Press H -> Press M -> Choose your requirement to apply by left or right arrow -> Press C (change list level) / Press D (Define new Multilevel List) / Press L (Define new List Type).

Subscribe for more interesting videos click here @aacAVI ( Adavnced Computer Classes ).

Practical Explained step by step in this video.

Class 6 - Advanced Video 1 (Statesman newspaper making in word)

How to make Statesman Newspaper in MS Word within 10 Minutes?

Step 1 :- At first open MS Word -> Go to Page Layout -> Orientation -> Choose Landscape mode.
Step 2 :- Click center alignment -> Type "The Statesman" -> select the word -> apply font face "vivilda" and size will be "48". After that type date, time and day below the heading -> apply font face "calibri (body)" and size will be "14".
Step 3. Go to Insert -> Table -> Choose 1 Row and 13 Columns -> Select all and go to format -> Shading (choose color "black") and font color "white" -> type menu details manually and insert home logo and search logo on the first section column and last section column.
Step 4. Press enter -> again go to Insert -> Table -> Choose 4 Row and 3 Column -> select first column's all row -> Layout -> Merge Cell -> insert big image in the first column which is merge cell applied and small images one by one (second column images alignment will be center position, choose from layout option) -> Type specific word with these images which is present on the right side of the small images -> select whole the table -> format -> Border (choose no border).
Step 5. First column insert the big image -> choose a simple white border from Format option -> go to Insert -> Shapes -> Text box -> Draw on the 3 times on the big image -> type sports(background color is "red" and font color is "white") and headings (background color is "white" and font color is "black") -> format -> border ( no border).
Step 6. Go to Insert -> Shapes -> Rounded Ractangle -> draw on the top right corner -> Type follow us on and insert fb, twitter and social media logo below on the text.
7. Select one by one text and images -> Insert -> Hyperlink -> choose file -> ok.
Complete the process to making the statesman newspaper.

Subscribe for more interesting videos click here @aacAVI ( Adavnced Computer Classes ).

Practical Explained step by step in this video.

Class 7 - Excel Functions

What is Function?
Function means a formula which is doing a lot of calculation within a seconds.

Definition of Sum() Function, Max() Function, Min() Function and Average() Function

Sum() Function :- When you will doing some addition with values in the table, then use this function.
Max() Function :- When you will find the maximum value in the table, then use this function.
Min() Function :- When you will find the minimum value in the table, then use this function.
Average() Function :- When you will find an average or percentage of the total value from a table data, then use this function.

Decleration of Function :
1. =sum(number1,number2,number3).
2. =max(number1,number2,number3).
3. =min(number1,number2,number3).
4. =average(number1,number2,number3).

Function Define Methods :
Sum() Functions Method =
1. =sum(b2+c2+d2)
2. =sum(b2,c2,d2)
3. =sum(b2:d2)

Max() Functions Method =
1. =max(b2,c2,d2)
2. =max(b2:d2)

Min() Functions Method =
1. =min(b2,c2,d2)
2. =min(b2:d2)

Average() Functions Method =
1. =total value/no. of subjects
2. =average(b2,c2,d2)
3. =average(b2:d2)

Subscribe for more interesting videos click here @aacAVI ( Adavnced Computer Classes ).

Practical Explained step by step in this video.

Class 8 - Excel Functions - Rank() Function

Definition of Rank() Function : - This is a logical function. You can create the ranks from the student table data for finalizing the position of the students marks.

Function Define :-
=rank(number,ref,[order])

Decleration :-
=rank(total value,all total value column,0 or 1)
0 means Dscending order and 1 means Ascending order

Example :- =rank(G2,G2:G5,0) Dsecending Order.
=rank(G2,G2:G5,1) Ascending Order.

Subscribe for more interesting videos click here @aacAVI ( Adavnced Computer Classes ).

Practical Explained step by step in this video.

Class 8 - Excel Functions - If() Function

Definition of if() Function : - This is a logical function. This function will doing logical test and set-up by true and false condition with given details. When we will have some different result from a specific table then we will use this function to figure out.
Example : =if(G2>=300,"Good","Bad"). In this example we will find out Good or Bad Position from an table. If anyone marks is above 300 then he will get Good position otherwise Bad position.

Function Define :-
=if(logical_test,[value_if_true],[value_if_false])

Decleration :-
=if(total value>=200,"Pass","Fail")


Example :-
Basic Step : =if(G2>200,"Pass","Fail")
Medium Step : =if(G2>=200,"Good",if(G2>=150,"Pass","Fail"))
Advanced Step : =if(G2>=300,"Very Good",if(G2>=200,"Good",if(G2>=150,"Pass","Fail")))

Subscribe for more interesting videos click here @aacAVI ( Adavnced Computer Classes ).