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.

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.

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.

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

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

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.

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

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.

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.

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.

Back

Forward

Displaying 17-29 of total 29