Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

Microsoft Excel

   
Displaying 17-29 of total 29
 
 
How to create a custom list in MS Excel 2010
 

How to create a custom list in MS Excel 2010

 Microsoft Excel  22nd June 2012 | Author: mat

If you are using the same entries all over again, you can create a custom list with these entries and when you need it just enter the first one then drag the cell down for the rest to fill out automatically.

Calculate workdays between dates using Excel
 

Calculate workdays between dates using Excel

 Microsoft Excel  24th September 2011 | Author: mat

We're going to calculate how many workdays, considering the holidays, are there between two specific dates

Very basic accounting sheet
 

Very basic accounting sheet

 Microsoft Excel  19th October 2011 | Author: mat

Point of this lesson is to show you a couple of very basic functions in Microsoft Office Excel.

How to use Quick analysis option in Excel 2013
 

How to use Quick analysis option in Excel 2013

 Microsoft Excel  15th January 2014 | Author: Brodjan

Excel 2013 provides a useful innovation called Quick analysis, which gives you instant overview of your data in spreadsheet.

How to copy the cell value in Excel 2013
 

How to copy the cell value in Excel 2013

 Microsoft Excel  19th January 2014 | Author: Pena

When you want to copy the result of the cell to another cell in Excel, the target displays an invalid references error messag. This error can be avoided by copying cell value into target cell and not the whole formulas.

Password protect your Excel sheets
 

Password protect your Excel sheets

 Microsoft Excel  12th September 2011 | Author: mat

If you don't want other people changing the content of your sheet, you can put a password on it.

Reversing colums and rows
 

Reversing colums and rows

 Microsoft Excel  16th October 2011 | Author: mat

Sometimes you need to change the your Microsoft Office Excel sheet by reversing or transposing it.

Share a workbook with other users in Excel 2010
 

Share a workbook with other users in Excel 2010

 Microsoft Excel  8th March 2012 | Author: mat

I will show you how to share an Excel workbook so more then one person in a network can edit it at a same time.

Displaying Dates in Excel
 

Displaying Dates in Excel

 Microsoft Excel  17th October 2013 | Author: bole

Let me introduce you to a few useful tricks on how to display dates, and make your Excel work easier.

How to sort Excel sheet according to font color
 

How to sort Excel sheet according to font color

 Microsoft Excel  9th September 2013 | Author: mat

Microsoft Excel allows you to sort your data in a number of different and custom ways, let's learn how to sort Excel data according to the color of the fonts.

Basic Usage of AutoSum Function in Excel
 

Basic Usage of AutoSum Function in Excel

 Microsoft Excel  9th October 2013 | Author: bole

Use the SUM function to sum numbers in a range. It is the most basic and simple formula that every computer user should know.

Set number of zeros in Excel's cell
 

Set number of zeros in Excel's cell

 Microsoft Excel  5th August 2013 | Author: NikMan

If you are working with numbers often and you also like to be organized, then this tutorial might be helpful for you.

Calculate your retirement date with Excel
 

Calculate your retirement date with Excel

 Microsoft Excel  23rd April 2013 | Author: mat

If you know how many years or months you got left until the retirement or any other event or project in your life, Excel can return you the exact date and the number of days left to reach it.

 
   
Displaying 17-29 of total 29
 
 
Categories
Microsoft Word Microsoft Word
Microsoft Excel Microsoft Excel
Microsoft PowerPoint Microsoft PowerPoint
Microsoft Outlook Microsoft Outlook
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO