The print options of Microsoft Excel applications is also another important series of Excel Help Tutorial as this will help you print the entire spreadsheet you needed or just a particular selected areas. This series of tutorial will show you how the print options of a particular worksheet can be accessed through various locations that include the print button seen at the standard tool bars.  
Another important series of Excel Help Tutorial is the IF function, which is only applicable on the versions of Microsoft Excel applications that are 2003 and 2007. Most of the tutorial for IF functions are usually step by step and come with examples and explanations for the users.

The Series of Excel Help Tutorial  

Every free Excel Help Tutorial may cover either an intermediate or introductory level topics in Microsoft Excel applications no matter what the versions are. Each of this tutorial will give the user the good understanding on how to use the Excel applications as well as accomplishing tasks in using the program. The Excel Help Tutorial covers different series including the entering of data and formulas, creating charts, creating database files, basic formatting and column charts.  

The series of entering data and formulas in Excel Help Tutorial covers the basic functions. Among the important items included in this series are the importance of planning a spreadsheet, the different types of data being used in Excel applications, how to enter data, editing cells enabling to change data and widening columns of cells. In entering formula, the step by step Excel Help Tutorial will show the user how to write the basic formulas, how to use the pointing to simplify the writing formulas, the importance of using cell references as well as the various mathematical operators that can be used, and editing a certain formula.  

The series of creating charts in Excel Help Tutorial also come with step by step instructions. This series cover all essential steps and functions to be able to create a particular chart with the use of the Chart Wizard in Microsoft Excel applications. It also covers and discusses the best practices in entering data and formula in the chart data to be able to produce quality and accurate charts.  

In the basic formatting series of Excel Help Tutorial, there are two parts covered. First part consists of using percent, currency, and comma number in formatting. It also includes adding of text formatting and changing of cell colors. The second part of the basic formatting series is the completion of the spreadsheet that was started from the first part. This part initially covers using the functions of NOW, adding formulas, adding range names, bolding text, and changing alignments of text in the cells.  

In creating a database file in Microsoft Excel applications is another series of Excel Help Tutorial whereas it will show you how to create a list or a database in Excel that will help you keep track of the valuable information such as contact list of your organization’s members, DVD collections, phone numbers and many more. This database file created in Microsoft Excel applications will serve as your built-in tools in creating easier lists that will filter and sort your data accordingly to your needed criteria at a particular time.   

The Excel Help Menus

The Excel Help Menus would always be there to assist you to have a further understanding of using and working with Microsoft Excel applications. In every upgraded versions of Microsoft Excel applications, the Excel Help Menus and functions are beefed up as well.

The Excel Help is an animated office assistant that automatically appears every time you open the application of Microsoft Excel. Apparently, this automated assistant can be turned off. It can also be excluded from the installation process of the Microsoft Excel applications in to your computer. The Excel Help is the Microsoft Office logo that is usually attached to the dialog box of the tip of the day. If the Excel Help does not appear automatically upon launching the application, you can always turn it on from the Excel Help Menu option. The Excel Help always has a light bulb icon and a question mark and by clicking from here, it would automatically bring out the office assistant. With the use of the toolbar button that looks like a yellow dialog balloon with question mark inside will accomplish the same thing.

Whenever the Excel Help assistant is open, the appearance of the yellow light bulb in the window will be occasionally. As you click this assistant, a tip will appear that is related to your current tasks in Microsoft Excel applications. After clicking this, a yellow box will appear asking “what would you like to do?”, which then will lists suggested topics that are related on what you want to know depending on the context of what you currently working on. Below these suggested topics there is a space where you can type a question and then search the command box. It is recommended to key in a complete question or sentence. After clicking the search command box there would be a list of help topics will be displayed that are related to the sentence or question you type in.

Along the bottom of the dialog box of “what do you want to do”, you will find some tips, close and options. The close function will make the office assistant disappear from the screen. The tips function will bring up selected tip that is similar to the “tip of the day” that appears every time you start the Microsoft Excel program. The options function will let you modify the office assistant. For high priority tips, you can turn off the “tip of the day”. The capabilities of the office assistant such as displaying alerts, offering help with wizards and sound can be manipulated by the users. It is also the user options to choose to show the tips about using shortcuts on keyboard, mouse and features. In any case that you grow tired of looking at your current office assistant, you can change it from the Excel Help Menus by going into the gallery in options.

The Excel Help Menus options of contents and index are the most helpful menu in Excel Help as these display a box with three tabs the find, index and the contents. Each of these three tabs has its specific purpose in Excel Help. Meanwhile the contents page of the Excel Help Menus is like a table of contents that displays the listing of chapters where you can find several subtopics.