Free Microsoft Excel Help

If you need Microsoft Excel Help then you have to the right place. With loads of new Microsoft Excel Help videos which can be viewed online with their transcripts, you will learn how to master difficult calculations, analysis, and modelling functions in no time.

You will for instance, get Microsoft Excel Help with the ISEVEN & ISODD.

ISEVEN & ISODD

If you need to find even and odd numbers in a list you can either use a complex formula to perform the function or you can simply make use of the Function Wizard. Your first step will be to open the Function Wizard and then to view the Information category. You will find the ISEVEN and ISODD functions in the list.

ISEVEN
Select a reference number in you list. Point to the number and the Wizard will give you the value of ISEVEN false or ISEVEN true. If you for instance, get a false you can copy it down the whole list and will then be able to identify which of the numbers are ISEVEN false. The same principle counts for ISODD.

Imported header checking

You may want to check imported headers and as such only require a quick reference help. This is where our short training videos make things easier for you. One of the new videos uploaded in the free training section is that of Import headers.

When you receive new information in your spreadsheet through importing it from another application, you will want to check the headers to confirm that you have received what you wanted. You can do this by including the headers twice. You will first type the headers that you expect to see in your spreadsheet as this will be your control to compare against. Now you can copy and paste from the other system or application.

You will use the EXACT function which is available once you activate the Function Wizard. Select the function and specify the cells that need checking for true or false values. When making use of our training video you will find out how and also learn an even easier way.

Microsoft Excel Help is just a button click away for any of the areas that you may struggle with.