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 1-16 of total 29
 
 
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.

How to freeze rows and columns in Excel 2010
 

How to freeze rows and columns in Excel 2010

 Microsoft Excel  23rd August 2012 | Author: mat

Great function which u can use to make big Excel sheets with lots of entries more transparent and easier to handle.

Making your Excel sheets look nicer
 

Making your Excel sheets look nicer

 Microsoft Excel  12th September 2011 | Author: mat

In Microsoft Excel you canĀ  use formating tools like colors, text alignment, font styles and many more to make your sheets look nicer and more transparent.

Text adjustment in Microsoft Excel 2013
 

Text adjustment in Microsoft Excel 2013

 Microsoft Excel  23rd January 2014 | Author: Pena

In this lesson I will show you how to adjust text that is too long for one single cell. There are two different ways to do that.

How to group rows and columns in Excel 2010
 

How to group rows and columns in Excel 2010

 Microsoft Excel  20th October 2012 | Author: mat

Let's learn how to  group rows and cells in Excel to make complex spreadsheets much easier to deal with.

Subtract time and display its negative value in Excel
 

Subtract time and display its negative value in Excel

 Microsoft Excel  8th June 2013 | Author: NikMan

I will show you a nice little Microsoft Excel trick which you can use to subtract time and also display its negative time value.

Filtering data in Microsoft Excel
 

Filtering data in Microsoft Excel

 Microsoft Excel  6th January 2012 | Author: mat

One of the more useful functions in Excel, which you can use to filter and display only the data you are interested in.

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.

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

Copy same formula into entire column in Excel 2013
 

Copy same formula into entire column in Excel 2013

 Microsoft Excel  13th January 2014 | Author: Brodjan

In this lesson I will show you a simple and useful trick, how you can copy the formula from any cell and paste it into entire colunm.

Data validation in the drop down list
 

Data validation in the drop down list

 Microsoft Excel  23rd September 2011 | Author: mat

We will learn how to make a drop down list and validate the data you enter. It can be quite helpful when organizing your data.

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.

My first Excel document
 

My first Excel document

 Microsoft Excel  12th September 2011 | Author: mat

Introduction to Microsoft Excel 2010, let's make a simple accounting sheet.

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.

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.

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.

 
   
Displaying 1-16 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