MS Excel - Tutorials

Found 62 Tutorials

Most Recent Tutorials

• Tracking Job Applicants in Excel

  Need to track job applicants for a position? Make an Excel template!
  http://www.hr.com/en/app/blog/2013/05/creating-a-template-for-tracking-job-applicants-in_h...
  • 205 Hits
  • Rating
  • Cat:Data Entry
  
  

• Measurement Conversions in Excel

  Need to convert measurements for international clients? Check here
  http://www.versitas.com/blog/2011/09/12/a-few-excel-tips/
  • 2595 Hits
  • Rating
  • Cat:Functions
  
  

• Stay Organized Using Countifs

  Using Countifs for Organization
  http://www.versitas.com/blog/2012/09/25/excel-tips-stay-organized-using-the-countifs/
  • 2394 Hits
  • Rating
  • Cat:Functions
  
  

• Data Validation

  How to use data validation for dropdown lists
  http://www.versitas.com/blog/2011/03/21/excel-tips/
  • 2562 Hits
  • Rating
  • Cat:Functions
  
  

• Using Speak Cells in Excel

  How to use speak cells in Excel for accessibility purposes
  http://www.versitas.com/blog/2011/10/17/using-speak-cells-in-excel/
  • 2438 Hits
  • Rating
  • Cat:Misc
  
  

• How to insert cells in Excel

  When we work with spreadsheet sooner or later we will need to insert Cells into existing sheet. I will show a few ways we can achieve it.
  http://excel.officetuts.net/training/basics/insert-cells.php
  • 5596 Hits
  • Rating
  • Cat:Basic Concepts
  
  

• How to Find Data in Excel

  Finding data is very useful, when you have to deal with a lot of data on a worksheet.
  http://excel.officetuts.net/training/basics/find-data.php
  • 4359 Hits
  • Rating
  • Cat:Basic Concepts
  
  

• Median Function

  The median is widely used in statistics ...
  http://excel.officetuts.net/functions/statistical/median.php
  • 3820 Hits
  • Rating
  • Cat:Functions
  
  

• How to Save a PDF File as an Excel File

  Have you received some PDF tables that save from Excel spreadsheets? Or sometimes you need to extract the data and reuse them to improve spreadsheets
  http://www.anypdftools.com/tutorials/how-to-save-a-pdf-files-as-an-excel-file.html#168
  • 4973 Hits
  • Rating
  • Cat:General Development
  
  

• How to Convert PDF to Excel

  Due to the security features, compact size and compatibility on any computers, Portable Document Format (PDF) become a common document format for exch
  http://www.anypdftools.com/tutorials/how-to-convert-pdf-to-excel.html#168
  • 4692 Hits
  • Rating
  • Cat:General Development
  
  

• How to save a PDF file as an excel file

  This tutorial will show your how to split PDFs into separate files. It is easy!
  http://www.anypdftools.com/tutorials/how-to-save-a-pdf-files-as-an-excel-file.html#153
  • 4782 Hits
  • Rating
  • Cat:Functions
  
  

• How to convert my PDF file to Excel spreadsheet

  This tutorial shows how to convert PDF to Excel.
  http://www.anypdftools.com/tutorials/convert-pdf-files-to-excel-spreadsheets.html
  • 4259 Hits
  • Rating
  • Cat:General Development
  
  

• Format A Number To A Decimal In Excel

  This video tuorial shows how to format numbers to decimals in Excel.
  http://quantunet.com/excel2003/skills/sample/formatting_data_cells_decimalsII.html
  • 4472 Hits
  • Rating
  • Cat:General Formatting
  
  

• Create Cell Borders

  This video tutorial shows how to create cell borders in Excel.
  http://quantunet.com/excel2003/skills/sample/cell_borders_II.html
  • 4212 Hits
  • Rating
  • Cat:General Formatting
  
  

• Change The Cell Color Fill

  This video tutorial shows how to change the color fill of a cell in Excel.
  http://quantunet.com/excel2003/skills/sample/cell_fill_color.html
  • 4702 Hits
  • Rating
  • Cat:General Formatting
  
  

• Set Conditional Formatting

  This video tutorial shows how to set conditional formatting in Excel.
  http://quantunet.com/excel2003/skills/sample/conditional_formatting.html
  • 3607 Hits
  • Rating
  • Cat:General Formatting
  
  

• Use The Format Painter

  This video tutorial shows how to use the formatting painter in Excel.
  http://quantunet.com/excel2003/skills/sample/formatpainter_conditionalformatting.html
  • 3547 Hits
  • Rating
  • Cat:General Formatting
  
  

• Protecting Excel

  The concept of protection gets a lot of attention in the Excel newsgroups and forums.
  http://nicetutz.blogspot.com/2007/11/protecting-excel-data.html
  • 3571 Hits
  • Rating
  • Cat:General Formatting
  
  

• Printing Workbooks in Excel

  This tutorial will show you how to printing workbooks in MS-Excel 2007.
  http://nicetutz.blogspot.com/2007/11/printing-workbooks-in-excel-2007.html
  • 3461 Hits
  • Rating
  • Cat:General Formatting
  
  

• Excel Shortcut Keys

  Many users have discovered that using their keyboard can often be much more efficient than using their mouse.
  http://nicetutz.blogspot.com/2008/01/excel-shortcut-keys.html
  • 3549 Hits
  • Rating
  • Cat:General Formatting
  
  

• Input the Same Data into Individual Worksheets

  Dont waste time copy and pasting, learn to work with the same data within multiple sheets.
  http://www.excel-tutorials.org/worksheets/how-to-input-the-same-data-into-individual-works...
  • 3674 Hits
  • Rating
  • Cat:General Formatting
  
  

• Merge Columns in Excel

  You re probably used to merging cells , but did you know that merging or concatenating columns for combining data is just as easy and useful.
  http://www.excel-tutorials.org/columns/how-to-merge-columns-in-excel/
  • 3836 Hits
  • Rating
  • Cat:General Formatting