Example with Pivot Tables in Excel

...</div><p style='width:100%;text-align:right'><a href='/blogs/5615/example-with-pivot-tables-in-excel' title='Read more' style='font-size:12px;' class='uibutton' target='_blank'>Read More</a></p></div><br clear='all'></div></div></div></div></li> <div class='unit'><div class='storyUnit'><div class='imageUnit' style='padding:10px'><a href='/user/1' target='_blank'><img src='/thumbs/../thumbs/1.jpg' width='32' height='32' alt=''></a><div class='imageUnit-content'><a href='/user/1'><strong>VCampus</strong></a><p>10-Mar-16 02:13:44 pm</p></div></div><div class='content' class='clearfix' style='padding:0 10px'><div style='position:relative;margin-bottom:10px;'><a href='/blogs/5614/excel-for-accounting-and-finance' target='_blank' style='text-decoration:none;'><h1 style='color:green;'>Excel for Accounting and Finance</h1></a><div style='float:left;margin-right:10px;position:relative;width:100%;box-sizing:border-box;'><img src='images/thumbnail.png'/></div><div style='float:left;width:100%;box-sizing:border-box;'><div style='box-sizing:border-box;white-space:pre-wrap;'><iframe class="ytplayer" type="text/html" style="width:100%;min-height:300px" src="http://www.youtube.com/embed/u1ieHLBFxAU?wmode=transparent" frameborder="0" wmode="Opaque" allowfullscreen/>...</div><p style='width:100%;text-align:right'><a href='/blogs/5614/excel-for-accounting-and-finance' title='Read more' style='font-size:12px;' class='uibutton' target='_blank'>Read More</a></p></div><br clear='all'></div></div></div></div></li> <div class='unit'><div class='storyUnit'><div class='imageUnit' style='padding:10px'><a href='/user/24' target='_blank'><img src='/thumbs/../thumbs/24.jpg' width='32' height='32' alt=''></a><div class='imageUnit-content'><a href='/user/24'><strong>Zinia  Islam</strong></a><p>08-Mar-16 01:43:45 pm</p></div></div><div class='content' class='clearfix' style='padding:0 10px'><div style='position:relative;margin-bottom:10px;'><a href='/blogs/5612/learning-vlookup-in-excel-2010' target='_blank' style='text-decoration:none;'><h1 style='color:green;'>Learning VLOOKUP in Excel 2010</h1></a><div style='float:left;margin-right:10px;position:relative;width:100%;box-sizing:border-box;'><img src='../media/image/standard/vlookup-pic1-4897.jpg'/></div><div style='float:left;width:100%;box-sizing:border-box;'><div style='box-sizing:border-box;white-space:pre-wrap;'>1. Download the Excel VLOOKUP sample file shown in the More VLOOKUP References section 

Excel sample file: 
  Download  VLOOKUP  

 2. Open the sample file you downloaded from above in Excel. 

 

The workbook will have 2 sheets at the bottom: Voters and Party Codes. The first sheet is a listing ...</div><p style='width:100%;text-align:right'><a href='/blogs/5612/learning-vlookup-in-excel-2010' title='Read more' style='font-size:12px;' class='uibutton' target='_blank'>Read More</a></p></div><br clear='all'></div></div></div></div></li> <div class='unit'><div class='storyUnit'><div class='imageUnit' style='padding:10px'><a href='/user/2296' target='_blank'><img src='/thumbs/../thumbs/2296.jpg' width='32' height='32' alt=''></a><div class='imageUnit-content'><a href='/user/2296'><strong>Md. Sohel Arman</strong></a><p>19-Nov-15 04:49:02 pm</p></div></div><div class='content' class='clearfix' style='padding:0 10px'><div style='position:relative;margin-bottom:10px;'><a href='/blogs/5437/some-excel-shortcut' target='_blank' style='text-decoration:none;'><h1 style='color:green;'>Some Excel Shortcut</h1></a><div style='float:left;margin-right:10px;position:relative;width:100%;box-sizing:border-box;'><img src='../media/image/standard/excel-shortcut-4738.jpg'/></div><div style='float:left;width:100%;box-sizing:border-box;'><div style='box-sizing:border-box;white-space:pre-wrap;'>F1: Opens a help task pane
F1 + Ctrl: Opens or closes the help window
F2: To edit the text in the active cell
F2 + Shift: To write a comment in the active cell
F2 + Alt: Opens the save as dialog box
F3 + Shift: opens the insert dialog box
F3 + Ctrl: Opens the define name dialog box
F3 + Shift + C...</div><p style='width:100%;text-align:right'><a href='/blogs/5437/some-excel-shortcut' title='Read more' style='font-size:12px;' class='uibutton' target='_blank'>Read More</a></p></div><br clear='all'></div></div></div></div></li> <div class='unit'><div class='storyUnit'><div class='imageUnit' style='padding:10px'><a href='/user/24' target='_blank'><img src='/thumbs/../thumbs/24.jpg' width='32' height='32' alt=''></a><div class='imageUnit-content'><a href='/user/24'><strong>Zinia  Islam</strong></a><p>02-Oct-15 04:57:11 pm</p></div></div><div class='content' class='clearfix' style='padding:0 10px'><div style='position:relative;margin-bottom:10px;'><a href='/blogs/5374/conditional-formats-icon-sets' target='_blank' style='text-decoration:none;'><h1 style='color:green;'>conditional Formats: Icon Sets</h1></a><div style='float:left;margin-right:10px;position:relative;width:100%;box-sizing:border-box;'><img src='../media/image/standard/create-conditional-formatting-rule1-4641.png'/></div><div style='float:left;width:100%;box-sizing:border-box;'><div style='box-sizing:border-box;white-space:pre-wrap;'>Icon Sets in Excel 2010 make it very easy to visualize values in a range of cells. Each icon represents a range of values.

To add an icon set, execute the following steps.

1. Select a range.

2. On the Home tab, click Conditional Formatting, Icon Sets, and click a subtype.

 

 Result: 
 

 Explan...</div><p style='width:100%;text-align:right'><a href='/blogs/5374/conditional-formats-icon-sets' title='Read more' style='font-size:12px;' class='uibutton' target='_blank'>Read More</a></p></div><br clear='all'></div></div></div></div></li> <div class='unit'><div class='storyUnit'><div class='imageUnit' style='padding:10px'><a href='/user/24' target='_blank'><img src='/thumbs/../thumbs/24.jpg' width='32' height='32' alt=''></a><div class='imageUnit-content'><a href='/user/24'><strong>Zinia  Islam</strong></a><p>02-Oct-15 04:42:49 pm</p></div></div><div class='content' class='clearfix' style='padding:0 10px'><div style='position:relative;margin-bottom:10px;'><a href='/blogs/5373/conditional-formats-color-scales' target='_blank' style='text-decoration:none;'><h1 style='color:green;'>conditional Formats: Color scales</h1></a><div style='float:left;margin-right:10px;position:relative;width:100%;box-sizing:border-box;'><img src='../media/image/standard/create-conditional-formatting-rule1-4636.png'/></div><div style='float:left;width:100%;box-sizing:border-box;'><div style='box-sizing:border-box;white-space:pre-wrap;'>Color Scales in Excel 2010 make it very easy to visualize values in a range of cells. The shade of the color represents the value in the cell.

To add a color scale, execute the following steps.

1. Select a range.

2. On the Home tab, click Conditional Formatting, Color Scales, and click a subtype....</div><p style='width:100%;text-align:right'><a href='/blogs/5373/conditional-formats-color-scales' title='Read more' style='font-size:12px;' class='uibutton' target='_blank'>Read More</a></p></div><br clear='all'></div></div></div></div></li> <div class='unit'><div class='storyUnit'><div class='imageUnit' style='padding:10px'><a href='/user/24' target='_blank'><img src='/thumbs/../thumbs/24.jpg' width='32' height='32' alt=''></a><div class='imageUnit-content'><a href='/user/24'><strong>Zinia  Islam</strong></a><p>02-Oct-15 04:21:10 pm</p></div></div><div class='content' class='clearfix' style='padding:0 10px'><div style='position:relative;margin-bottom:10px;'><a href='/blogs/5372/conditional-formats-data-bars' target='_blank' style='text-decoration:none;'><h1 style='color:green;'>Conditional Formats</h1></a><div style='float:left;margin-right:10px;position:relative;width:100%;box-sizing:border-box;'><img src='../media/image/standard/create-conditional-formatting-rule-4630.png'/></div><div style='float:left;width:100%;box-sizing:border-box;'><div style='box-sizing:border-box;white-space:pre-wrap;'>Data bars in Excel 2010 make it very easy to visualize values in a range of cells. A longer bar represents a higher value.

To add data bars, execute the following steps.

1. Select a range.

2. On the Home tab, click Conditional Formatting, Data Bars, and click a subtype.
 

 Result: 
 

 Explana...</div><p style='width:100%;text-align:right'><a href='/blogs/5372/conditional-formats-data-bars' title='Read more' style='font-size:12px;' class='uibutton' target='_blank'>Read More</a></p></div><br clear='all'></div></div></div></div></li> <div class='unit'><div class='storyUnit'><div class='imageUnit' style='padding:10px'><a href='/user/3' target='_blank'><img src='/thumbs/../thumbs/3.jpg' width='32' height='32' alt=''></a><div class='imageUnit-content'><a href='/user/3'><strong>Mohammad Towhidul Islam</strong></a><p>04-Sep-15 09:44:08 am</p></div></div><div class='content' class='clearfix' style='padding:0 10px'><div style='position:relative;margin-bottom:10px;'><a href='/blogs/5331/idb-bisew-mid-test-computer-fundamentals-cf' target='_blank' style='text-decoration:none;'><h1 style='color:green;'>IDB-BISEW Mid Test Computer Fundamentals (CF) Evidence</h1></a><div style='float:left;margin-right:10px;position:relative;width:100%;box-sizing:border-box;'><img src='../media/image/standard/234.jpg'/></div><div style='float:left;width:100%;box-sizing:border-box;'><div style='box-sizing:border-box;white-space:pre-wrap;'>BASICS 
Freezing row and column titles
Row and Column Transpose 

 FORMULAS 
Creating formulas
How to create a formula
Copying formulas
Operators
Formula error messages
Common functions
Sum function
Average function
Max function
Min function
Count function
The COUNTA function
The COUNTBLANK func...</div><p style='width:100%;text-align:right'><a href='/blogs/5331/idb-bisew-mid-test-computer-fundamentals-cf' title='Read more' style='font-size:12px;' class='uibutton' target='_blank'>Read More</a></p></div><br clear='all'></div></div></div></div></li> <div class='unit'><div class='storyUnit'><div class='imageUnit' style='padding:10px'><a href='/user/3' target='_blank'><img src='/thumbs/../thumbs/3.jpg' width='32' height='32' alt=''></a><div class='imageUnit-content'><a href='/user/3'><strong>Mohammad Towhidul Islam</strong></a><p>10-Oct-13 04:40:00 pm</p></div></div><div class='content' class='clearfix' style='padding:0 10px'><div style='position:relative;margin-bottom:10px;'><a href='/blogs/3721/how-to-determine-rank-from-a-list-of-numbers-with-microsoft-excel-formula-syntax-rank' target='_blank' style='text-decoration:none;'><h1 style='color:green;'>How to determine rank from a list of numbers with microsoft excel</h1></a><div style='float:left;margin-right:10px;position:relative;width:100%;box-sizing:border-box;'><img src='../media/image/standard/3111.jpg'/></div><div style='float:left;width:100%;box-sizing:border-box;'><div style='box-sizing:border-box;white-space:pre-wrap;'>How to determine rank from a list of numbers with Microsoft excel        
 Formula Syntax: 
 =RANK(number, ref , [order] ) 
 number  - This parameter  indicates a specific cell which is compare with the list.
 ref   -  This parameter indicates a rang of absolute cells where numbers are exists.
 [or...</div><p style='width:100%;text-align:right'><a href='/blogs/3721/how-to-determine-rank-from-a-list-of-numbers-with-microsoft-excel-formula-syntax-rank' title='Read more' style='font-size:12px;' class='uibutton' target='_blank'>Read More</a></p></div><br clear='all'></div></div></div></div></li> <div class='unit'><div class='storyUnit'><div class='imageUnit' style='padding:10px'><a href='/user/463' target='_blank'><img src='/thumbs/../thumbs/463.jpg' width='32' height='32' alt=''></a><div class='imageUnit-content'><a href='/user/463'><strong>Md  Kowshik</strong></a><p>08-Oct-13 12:08:55 am</p></div></div><div class='content' class='clearfix' style='padding:0 10px'><div style='position:relative;margin-bottom:10px;'><a href='/blogs/3696/microsoft-office-shortcut' target='_blank' style='text-decoration:none;'><h1 style='color:green;'>Microsoft office shortcut</h1></a><div style='float:left;margin-right:10px;position:relative;width:100%;box-sizing:border-box;'><img src='images/thumbnail.png'/></div><div style='float:left;width:100%;box-sizing:border-box;'><div style='box-sizing:border-box;white-space:pre-wrap;'>Microsoft office shortcut  
Ctrl+Z Undo
Ctrl+C Copy,
Enter, Paste,
Ctrl+V Multiple Paste,
Ctrl+X Cut
Ctrl+F, Find,
Ctrl+H Find&amp;Replace
Ctrl+P, Print,
Ctrl+S, Ctrl+F4, Alt+F4 Save, Close, Excel
Ctrl+Arrow Move to edge of region
Ctrl+* Select current region
Ctrl+A Select all cells
Ctrl+Home Sele...</div><p style='width:100%;text-align:right'><a href='/blogs/3696/microsoft-office-shortcut' title='Read more' style='font-size:12px;' class='uibutton' target='_blank'>Read More</a></p></div><br clear='all'></div></div></div></div></li></ol><style>form.pagination{display:inline}</style><div class='clearfix uibutton-group'><a rel='first' href='?page=1' class='uibutton'>First</a><a rel='prev' href='?page=1' class='uibutton'>Prev</a><a href='/blogs/ms-excel' class='uibutton confirm'>1</a><a href='?page=2' class='uibutton'>2</a><a rel='next' href='?page=2' class='uibutton'>Next</a><a rel='last' href='?page=2' class='uibutton'>Last</a><form action='/blogs/ms-excel' class='pagination' method='post'><input type='text' name='page' style='width:25px;border:1px solid gray;padding:2px;text-align:center;margin-right:4px;' value='1'/><button type='submit' class='uibutton'>Go</button></form><div style='float:left;font-size:12px;font-weight:bold;'>1 of 2 pages</div></div></div></div></div><div class="colgroup colgroup2 clearfix"><div class="col col3"><div class="section_wrapper"></div></div><div class="col col4"><div class="section_wrapper"></div></div></div></div></div></div><div id="FooterWrapper"><div id="FooterContext"><div class="row clearfix center"><style>.publicFooter{position:relative;margin-top:20px}.publicFooter a{text-decoration:none;font-family:Verdana,Geneva,sans-serif;font-size:12px;text-decoration:none}.publicFooter a strong{color:#2ca6d6!important}.publicFooter a:hover{text-decoration:underline!important;color:#fff!important}.publicFooter ul{margin:0;padding:0;display:flex;flex-flow:row wrap;list-style:none;width:100%;align-items:center;justify-content:space-between}.publicFooter ul li{padding:0;margin:0 5px}.publicFooter ul li .fitem{position:relative;padding:2px}</style><div><div></div><nav class="publicFooter"><ul><li><a href="http://vcampusbd.com/schools/"><div class="fitem"><strong>Schools</strong></div></a></li><li><a href="http://vcampusbd.com/store/"><div class="fitem"><strong>App Store</strong></div></a></li><li><a href="http://vcampusbd.com/class/231"><div class="fitem"><strong>Whiteboard</strong></div></a></li><li><a href="http://vcampusbd.com/blogs/"><div class="fitem"><strong>Blogs</strong></div></a></li><li><a href="http://vcampusbd.com/quizzes/"><div class="fitem"><strong>Quiz</strong></div></a></li><li><a href="http://vcampusbd.com/tests/"><div class="fitem"><strong>Test</strong></div></a></li><li><a href="http://vcampusbd.com/apply/"><div class="fitem"><strong>Apply Course</strong></div></a></li><li><a href="http://vcampusbd.com/games/vcampus.php"><div class="fitem"><strong>Games</strong></div></a></li><li><a href="http://vcampusbd.com/Freelancers/"><div class="fitem"><strong>Freelancers</strong></div></a></li><li><a href="http://vcampusbd.com/professionals/"><div class="fitem"><strong>Professionals</strong></div></a></li><li><a href="http://vcampusbd.com/newspapers/"><div class="fitem"><strong>Newspapers</strong></div></a></li><li><a href="http://vcampusbd.com/terms_of_service.php" target="_blank"><div class="fitem"><div><strong>Terms</strong></div></div></a></li><li><a href="http://vcampusbd.com/privacy.php" target="_blank"><div class="fitem"><div><strong>Privacy</strong></div></div></a></li></ul></nav><div style="font-size:.8rem;color:gray;width:100%;text-align:center;bottom:0;margin-top:20px">Copyright &copy; 2024. Powered by <a href="https://intels.co" target="_blank" style="color:#fff;font-size:10px;">Intellect Software Ltd</a></div></div></div></div></div></div><script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script><script>window.jQuery||document.write('<script src="js/vendor/jquery-1.10.2.min.js"><\/script>')</script><script src="js/plugins.js"></script><script src="js/main.js"></script></body></html>