Professor Excel
checklist, finalize, excel, worksheets, workbooks

Finalize Your Excel Workbook: The Complete Checklist

Before sending out an Excel workbook, there are several things you should check: Are the contents correct? Can you print the workbook? How are the structure and formatting of the worksheets? Are the workbook properties all right? With this article, you’ll get a checklist of the things you should consider when you finalize a workbook. Probably not all items on these lists are applicable for any workbook.

[…]

Adjust Rows and Columns in Excel: The 4 Best Ways!

Do you spend a lot of time changing the column width in Excel? On the one hand, you’d like to see as many columns as possible for having a good overview, but on the other hand, you want to see as much content as possible within a column. In the worst case, you’d only see ### instead of values.

excel, fails, failure, mistake, biggest

Mistakes in Excel: The 5 Biggest Spreadsheet Fails

These people probably have their worst days ever: They made fatal errors in their spreadsheets. But they are not alone: According to a study88% of all spreadsheets have errors. The reason – of course – is that every Excel file is created by a person – and people make mistakes.

The larger an Excel model gets, the more opportunities for mistakes exist. Many errors don’t really matter as they are not having an impact on the final results. But there are others which are quite serious. Let’s have a look at the 5 biggest Excel fails.

[…]

excel, paste, tranpose, link, cells

Transpose and Link Data to Source in Excel

When you copy and paste cells in Excel, you can either paste them as links or transpose them. Excel doesn’t allow doing both at the same time. Unfortunately, you often need to link and transpose. But there are three ways for accomplishing this: Doing it manually, using the array formula {=TRANSPOSE()} or Professor Excel Tools. 

[…]

wrong, calculations, excel

Wrong Calculations – Why Does Excel Show a Wrong Result?

Excel calculates wrong. Yes, in some cases, Excel will return wrong results. You don’t believe me? Then type the following formula into an empty Excel cell: =1*(0.5-0.4-0.1). The result should be 0. But what does Excel show?  -2,77556E-17. This is just a simple example, but when it comes to larger Excel models it can be quite annoying. Especially if you want to compare the result – let’s say you want to check the result with an IF-formula if it equals 0. So what is the reason for these obviously wrong calculations and how to solve it?

[…]

combine, chart, types, excel

How to Combine Two Chart Types in Excel

Creating charts in Excel is quite easy: Select the data and choose your desired chart type on the ‘Insert’ ribbon. But when it comes to combining two chart types – for example a column chart with a line on top – many users suddenly struggle. But actually, it’s almost as simple as inserting a normal chart. Let’s have a look at how to do it and how to further adjust your chart. […]

now, formula, function, excel

NOW: Learn the Secrets of the Simple NOW() Formula in Excel

The NOW formula returns the current date and time. It can be applied easily by just typing =NOW()

How to Create Drop Down Lists for Excel Cells

You are creating an Excel sheet, in which another user has to enter text data (for example, the name of a person or a place). Such texts can be misspelled easily. To prevent misspelling, you can provide drop-down lists, from which the user can select. The user can also simply type text, but the text has to match exactly one of the items on the list.

How to Create Charts in Excel

Once your calculations are done, you might want to show your results in charts. Charts are a good way of getting a feeling of the values and leading to conclusions.

How to Work on Several Worksheets Simultaneously

Sometimes you want to do changes to several worksheets at the same time. That requires, that all the worksheets have the same structure. So, how to do that?