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
 
 
Excel Pivot tables explained for the beginners
 

Excel Pivot tables explained for the beginners

 Microsoft Excel  22nd October 2012 | Author: mat

Using Pivot tables can really help you to see and present your Excel data in a nice and more functional way.

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.

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.

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

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.

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

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.

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.

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.

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.

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.

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.

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.

 
   
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