www.exceladvisor.net

In my previous article about 5 easy ways to learn Excel I explained 5 methods that can help you learn the program and its interface quickly.

Read more..

Workbook defaults
There are various options in Excel that you can modify to make setting up your workbooks quicker and easier according to your preferences.

Read more..

Outlook provides many e-mail functions that make it a good choice for implementing a routing solution.

Read more..

It is useful therefore, to know how to effectively use toolbars e.g. how to access hidden buttons, move them, view them and customise them.

Read more..

The SUMIF() and COUNTIF() functions can only evaluate a single criterion.

Read more..

Excel 2003 has a built-in feature that enables data in a worksheet to be sorted. Sorting data in Excel 2003 can bring important data together, organise its appearance within the document, and allow the user to spot data that are incorrectly formatted or incomplete.

Read more..

The number formats provided by Excel don’t meet your needs you can easily create your own custom formats.

Read more..

This tutorial outlines how to convert a complex pivot table from Excel into an interactive web based application

Read more..

The accounting format has several advantages but one disadvantage is that it will yield a “–“ (dash) rather than a zero

Read more..

Microsoft Excel is a fantastic tool for analyzing scientific data. Microsoft Word is a fantastic tool for writing up scientific research. So surely Microsoft Office is the only software a scientist would ever require beyond that associated with specialist scientific apparatus?

Read more..

In the past the developers of Excel (and most of the other Microsoft Office applications) built in little hidden programs that would run inside the application if you knew the secret sequence of keys. These secret routines were generally humorous and entertaining.

Read more..

Creating a Pivot Table with Grouped Dates

Imagine that you have the output from an accounts system: a table of payments made by your company. For each row of the table in Excel you have:

Read more..

When you have a massive amount of data, you can let excel calculate the subtotals in your worksheets. All you need to do is group the data by the items to be subtotaled and then tell excel to outline.

Read more..

Shared workbooks is a great feature of Microsoft Excel. You need to set up ‘shared workbooks’ if input from many persons is required to complete a project. This feature allows you to collaborate with others in your team quickly and easily.

Read more..

You can format anything in Excel so it will not appear on the worksheet but still be present in the worksheet. This works for both screen and printing. The custom format characters are three semicolons or ;;;

Read more..

You can fill in several types of series by selecting cells and dragging the “fill handle” or by using the Series command (point to Fill on the Edit menu, and then click Series). By dragging the fill handle of a cell, you can copy the contents of a cell to other cells in the same row or column

Read more..

Similarities between Excel VBA and Access VBA

In theory it should be easy to switch from one MS Office VBA programming language to another, since all the underlying principles are the same

Read more..

MS Excel can be customized in a way that suits a user to achieve his goal. It is extensively used in financial organizations. The features of MS Excel are as follows:

Read more..

<Question to Dr ExcelAdvsior>

I was trying to publish a pivot table on excel 2010 with powerpivot add on, but I do not know how to save with feature interactivity likes in excel 2003

Read more..

Are you in the process of selecting accounting software for your small business? If the answer is yes then you have plenty of options open to you, these include, to name but a few, Sage, QuickBooks and Microsoft Solomon.

Read more..