Excel Basics - Cut Copy Paste Special Format Painter

If you are following my tutorials then by now you have an idea about Microsoft Excel interface and templates. Now I am going to start with a series of tutorial to cover basic functions in Microsoft Excel.

In this video I am talking about clipboard section under home tab on the ribbon which has functions like cut, copy, paste, paste special and format painter. I am sure that you already know about cut, copy and paste as this is a very common function of any kind of standard editor. In Microsoft Excel there some additional property of these functions. These additional properties could be useful and can save your time if you know how to use them.   

So check this video tutorial for the details of cut, copy, paste, paste special and format painter. If you have any question/ comment/ suggestion; please use the comment section.

Excel - How to create Templates in Excel 2010

In my last tutorial I talked about “how to use templates” in Microsoft Excel. Also I explained what is a template and why should we use templates. To recollect I would like to mention again that - templates in Microsoft Excel can be used to eliminate efforts for repetitive work and we should use templates to increase productivity of our excel work.

In this tutorial I am going to show how to create an excel template. Once we have an excel work book ready to use as template, we have to save it as type “Excel Template (*.xltx)” or “Excel Macro-Enabled Template (*.xltm)”. “Excel Macro-Enabled Template” is for a template having macros defined in it and for simple templates the option “Excel Template” can be used.

Check the video tutorial for details about how to create a Template in Microsoft Excel. Use template, save time, be productive.

How to use Templates in Excel 2010

Templates in Microsoft Excel can be used to eliminate repetitive work. Even if you use a template for one time only, it can save some of your time which you would have been spent on formatting tables, font, color, page set up for printing etc. So using templates you could be much more productive. Let’s take an example: every month you need to take dump of your sales details and then you generate report of sales by product and by customer and then you take print of these reports. If you use a template which is preformatted for this job then only thing you have to do is take dump of sales details and put into the template. It will automatically generate all your report. Also the report is then ready for print also.

So check the video tutorial below for details about how to use a template in Microsoft Excel. Use template, save time, be productive.

Microsoft Excel 2010 - Introduction to the Interface

Microsoft Excel 2007 and 2010 interface are almost same. So if anyone used 2007 version will have no issue in finding different commands or actions in Microsoft Excel 2010. The interface has completely changed since the 2003 version. The new interface is much more improved by categorizing similar command/ actions into a single tab. So the tabular format of the ribbon is much easier to browse through. Also pictorial representation of each commands/ actions creates better visual impact to the users.

There are many more improvements in interface, performance, capability, security etc in 2010 version of Microsoft Excel. Please check the video tutorial below for an introduction to Microsoft Excel 2010 interface. This will be helpful for people who only worked with 2003 or earlier versions and not familiar with 2007 or 2010 version. Beginners anyway will get a good overview of the Microsoft Excel 2010 interface from this video.

What is Microsoft Excel and Use of Microsoft Excel

What is Microsoft Excel and Use of Microsoft Excel

• A powerful tool for data analysis
• Track data
• Build models for data analysis
• Formula based calculation of data
• Pivot data generation
• Professional chart presentation

Use of Microsoft Excel

It can be used for any kind of data tracking, calculations and analysis for personal, small scale to large scale business, organization etc.

Examples: Use of Microsoft Excel - Check the video tutorial

• Personal Monthly Budget
• Sales Report
• Loan Amortization
• Time Cards
• Charts
• Checklist
• Flowchart
• Test Plan
• Status Reporting
• And many more

Here is the video tutorial

This video is to provide an idea about Microsoft Excel to beginners. This will help people to understand capabilities of Microsoft Excel. The different way Microsoft Excel can be used is demonstrated with multiple examples.