MS Excel is one of the most popular data processing tools out there and there is a reason for this – this program can save you so much time once you learn how to use it properly.
This hub introduces you to Microsoft Office Excel 2007, a spreadsheet program. It is ideal for performing Mathematical calculations, it can also be used for data analysis, and creating charts.
Bubble charts created in Excel 2007 or Excel 2010 allow you to show data in three dimensions in a visually stunning chart. This can then be saved as a template to be used to create additional charts.
Thematic maps show themes or variations across geographical regions. Data is linked to the chart in Excel 2007 or Excel 2010 using Visual Basic code which updates each part of the map automatically.
Guide to Visual Basic or Visual Basic for Applications (VB or VBA) code in Excel 2007 and 2010, learning the basic commands, how to work with errors and how to run the code that you have written.
The edit menu provides important editing commands for making changes to an Excel document. Mastering the usage of these tools is important so as to enable you work fast on your worksheet.
Apart from typing a document, it is vital to know how to format, make it easy to use and presentable. This hub explores how you can make use of the Microsoft Office Word 2007 Page Layout Ribbon Tab.
Visual Basic code allows you to configure a User Interface using a UserForm in Excel 2007 or Excel 2010. Scripts initialise the User Interface, configure the buttons and add data into the worksheet.
The table menu is used for inserting tables in MS Office Word 2003. This tutorial shows you how to insert or draw tables in MS Word 2003 and also how to perform calculations in the table.
Step-by-step tutorial to use VLookup function to search for a list of values present in a table in Microsoft excel.