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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Back

Forward

Displaying 17-29 of total 29