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
 
 
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.

How to sum cells according to their font color in Excel
 

How to sum cells according to their font color in Excel

 Microsoft Excel  27th August 2013 | Author: NikMan

You will find out how to summarize cells that have a same color of the font, the red  one in my case. Really useful when working with different types of specific data in Excel.

How to add a link to another sheet in Excel 2010
 

How to add a link to another sheet in Excel 2010

 Microsoft Excel  7th September 2012 | Author: mat

Hyperlinks is a real handy function in Microsoft Excel, let me show you how to crate a hyperlink to another Sheet.

Basics of Excel 2007
 

Basics of Excel 2007

 Microsoft Excel  14th February 2011 | Author: Realife

This is tutorial for all, who are ready to learn more about Excel, but they never used it before.

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.

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 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.

Fill every other row with color
 

Fill every other row with color

 Microsoft Excel  23rd November 2011 | Author: mat

We're going to learn how to fill every second row of your sheet with color using conditional formatting in Excel.

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.

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.

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.

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.

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.

How to make titles visible on every page you print
 

How to make titles visible on every page you print

 Microsoft Excel  4th February 2013 | Author: mat

If you want your main Excel column or row visible on every page you print out to make the data easier to read, this is what you need to do.

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.

Create a Chart by Pressing a Single Key in Excel
 

Create a Chart by Pressing a Single Key in Excel

 Microsoft Excel  20th June 2013 | Author: NikMan

Did you know that you can easily and really fast create a graph inside Excel, and I mean just with one button on your keyboard?

 
   
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