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 17-29 of total 29

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

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.

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.

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?

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

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.

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.

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.

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

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.

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.

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.

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.

Back

Forward

Displaying 17-29 of total 29