Dreevoo.com | Online Learning and Knowledge Sharing

English | Login & Registration

Dreevoo.com

CONTRIBUTE

FORUM

INFO

| Programs | Microsoft Office | Microsoft Excel

Guest

Topics


	Programs
	Languages
	Recipes
	Home

Shortcuts

Microsoft Excel

Back

Forward

Displaying 1-16 of total 29

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

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.

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

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.

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.

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.

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.

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.

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.

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

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

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.

Back

Forward

Displaying 1-16 of total 29