View this video on how to protect cells in an Excel spreadsheet https://youtu.be/4f1j0oCGeRk
More drop downs using vlookup
This video shows the use of vlookup with indirect Fx https://youtu.be/0kYzmBncec4
Create dependent drop-down boxes in excel
Watch this video on how to create dependent drop-down boxes in excel 2013
Grouped Frequency Distribution in excel
Use A grouped Frequency distribution to understand your data. <iframe width=”1280″ height=”720″ src=”//www.youtube.com/embed/liRkhrOKQKQ?rel=0″ frameborder=”0″ allowfullscreen></iframe>
Excel Shortcuts
http://office.microsoft.com/en-us/excel-help/quick-reference-card-RZ102673162.aspx?CTT=1&client=1§ion=10&mode=print Excel Key Shortcuts Excel 2010 keyboard shortcuts I: CTRL key shortcuts Quick Reference Card See also Full list of keyboard shortcuts in Excel 2010 All Microsoft Office Training Basic keyboard shortcuts This is only a partial list. For a comprehensive list, see the links at the top of this page. To do this Press […]
Password Protect Excel 2010 files
http://www.groovypost.com/howto/geek-stuff/password-protect-encrypt-microsoft-office-2010-documents/ This is a great explanation on how to Password Protect your files. How To Password Protect A Word or Excel 2010 Document Using Built-in Office Encryption Step 1 – Click the File tab, then Click Info. On the menu to the right Click Protect Document and Click Encrypt with Password. Step 2 – The Encrypt Document dialog […]
Converting a text date to a date format in Excel
Many of us get into a situation when the dates in our data are coded as text. Excel does not recognise such text entries as date and we can not use them for any calculation purpose. However you can easily covert them to date by the help of excel formula. Converting Text to Date
Printing Header on Every page in Excel
If your spreadsheet is too long, you are able to print multiple sheets with the same header information on each page. Use this link to learn how to Print a Header on every Page in a Excel Spreadsheet
Updating a Pivot Table
Use this link for info on updating your pivot table after you have made some changes to data. http://www.ehow.com/how_6818802_update-pivot-table-data.html
Unhide first row and colum in excel 2010
http://office.microsoft.com/en-us/videos/video-unhide-the-first-column-and-row-in-excel-2010-VA102529883.aspx?CTT=1 Unhide first row and colum in excel 2010 Video explaining how to unhide (i.e. find) the first row and column if hidden
Recent Comments