Tutorial for Microsoft® Office Excel 2010

Microsoft Office 2010 is the latest version of the productivity suite released by Microsoft. Microsoft Office Excel 2010 is a part of this suite. It has several advanced tools for analyzing and visualizing data trends with which you will be able to create financial reports, manage resources and more. This version includes the various new functions for arithmetic, logical, financial and statistical processing that improves the efficiency of data processing. It comes with the new Microsoft PowerPivot feature which can be used in the manipulation of a large set of data. With the web application available, you can access your workbook from anywhere. With all the new facilities available in Microsoft Office Excel 2010, you can perform your work faster and improve productivity.

• Formulas
• Specifications and limits
• Tips to use the application

Formulas

There are several formulas included in Microsoft Office Excel 2010 to help you perform your task faster and improve efficiency. The main functions available include Date, Mathematic calculations, Count and more. You can easily find the number of days between two dates with the NETWORKDAYS function; similarly DAYS360 can be used for counting days between two dates based on a 360 day year. The common math functions available include SUM, SUMIF, PRODUCT, QUOTIENT and many more to ease calculation. You can also count the number of cells between specified ranges, using COUNT.

Specifications and limits

In Microsoft Office Excel 2010, a workbook specification is given as 1,048,576 rows by 16,384 columns. The column width is 255 characters and row height is 409 points. The allowed page breaks are 1,026 horizontal and vertical. You can enter a maximum of 32,767 characters in a cell. The number of sheets available by default is 3. The names and windows in a workbook are limited by memory and the number formats in a workbook range between 200 and 250.

Microsoft Office Excel 2010 is available in 32 bit and 64 bit. You can purchase it with Microsoft Office 2010 product suite which is available in any Microsoft store. In order to install this in your system, you need a 500 MHz processor, 256 MB RAM, 3.5 GB available hard disk space and a monitor with 1024x768 or higher resolution for display. You need to fulfil the system requirements before installing the product on your system. You can install the product by following the instructions in the installation wizard. You can start using it by clicking on Microsoft Office Excel 2010 in 'Programs' or entering ‘Excel’ in 'Run'. You can get online training for using Microsoft Office Excel 2010 from the official Microsoft website.

iYogi is the fastest growing online and remote tech support provider in the direct-to-consumers and small businesses sector. Our highly skilled and experienced tech experts available, 24x7x365 can provide the best issue resolution and customer satisfaction.

• Comprehensive support for Microsoft Office Excel 2010
• Diagnostic & repair for your technologies
• Troubleshoot software errors
• Update drivers and security to protect against online threats
• Connect to Internet, devices, and peripherals
• Optimize your computer’s speed and performance.