GAIN COMPUTER KNOWLEDGE
computerknowledge
.info
Home
1. Definition
2. Price
3. Use
4. Setup
5. Tutorial
6. Troubleshooting
7. Internet
8. Download
বাংলা
Contact Us
5. Tutorial of Microsoft Excel.
(1) What is Microsoft Excel and its installation.
(2) How to create & save a file Microsoft Excel.
(3) How to make a password protected Microsoft Excel file.
(4) How to select Cells/ Text.
(5) How to font change.
(6) How to Font size change.
(7) How to Font color change.
(8) How to make a text bold (
B
), Italic (
I
), Underline (
U
).
(9) How to Merge cells.
(10) How to cut, copy & paste cells/ text.
(11) How to align content with Left, Right, Center align, Top, Middle or Bottom align.
(12) How to Draw Cell border.
(13) How to change cells background color.
(14) How to cells background color, font, border change with condition (Conditional Formatting).
(15) How to use Data Validation to input fixed text in cells.
(16) How to hide or unhide rows and columns.
(17) How to apply filter.
(18) How to Page setup.
(19) How to print page.
(20) How to mimic a watermark or place background image.
Formulas and Functions
(1) Use of
Sum
&
AutoSum
.
(2) Use of
Average
function.
(3) How to
Divided
two value.
(4) How to
Multiply
two value.
(5) How to use
Count
formula.
(6) How to use
COUNTIFS
formula.
(7) How to use
MAX
formula.
(8) How to use
MIN
formula in Microsoft Excel.
(9) How to use
RANK
formula.
(10) How to use
IF
formula.
(11) How to use
SUMIFS
formula.
(12) How to use
LOOKUP
formula.
Graph
(1) How to make a Column Graph.
(2) How to make a Line Graph.
(3) How to make a Line Graph with two or more series.
(4) How to make a Pie Graph.
(5) How to make a Combo Graph with secondary axis.
Share