Microsoft Excel Training Video

Microsoft Excel Training Video       Excel is the most important and popular computer software program used in the workplace today. That’s why more and more workers and prospective employees are required to learn Excel in order to enter, remain or even promote in the workplace. Widely used by businesses, service agencies, volunteer groups, private sector organizations, scientists, students, educators, trainers, researchers, journalists, accountants and others, Microsoft Excel has become the most widely used spreadsheet application in the world, it is a key part of the Microsoft Office suite of applications.















Outside the workplace, Excel is in broad use for everyday problem solving. Home users can use Excel to calculate sales tax on a purchase, calculate the cost of a trip by car, create a temperature converter, calculate the price of pizza per square inch and do analysis of inputted data. They also can track their debts, income and assets, determine their debts to income ratio, calculate their net worth, and use this information to prepare for the process of applying for a mortgage on a new house. The personal uses for Excel are almost as endless as the business uses for this software - and an Excel tutorial delves into the practical uses of the program for personal and business use.


Excel offers new data analysis and visualization tools that assist in analyzing information, spotting trends and accessing information more easily than in the past. Using conditional formatting with rich data display schemes, you can evaluate and illustrate important trends and highlight exceptions with colored gradients, data bars and icons.
Indeed, Excel can be customized to perform such a wide variety of functions that many businesses can’t operate without it. Excel training has become mandatory in many workplaces; in fact, computer software training is a must for any workplace trying to keep up with the times.
Microsoft Excel Training Video by Computrain Solutions LLC is designed to help computer users at different levels from beginning to advance get the most out of Excel (2003, 2007) in the shortest possible time. It is also the easiest and the most affordable way to learn your computer skills.
In order to get more understanding of the functions of Microsoft Excel, let's get started with some clear and interesting instructions in the training video.
In general, computer users when running Microsoft Excel often face many obstacles, such as
How to start Excel manually or automatically, use or hide the task pane, understand the basics of worksheets and workbooks, open an existing workbook, open other formats of spreadsheet file in Excel, navigate in workbooks and worksheets, share Information, etc.
In the limitation of the article, I just point out the instructions for some of the above questions :

  1. Start Excel manually or automatically
    The basic way to start Excel is to choose Start | All Programs | Microsoft Office | Microsoft Office Excel 2003. When it opens, Excel creates a new blank workbook containing three worksheets. By default, Excel displays the Getting Started task pane when you launch it. You can dismiss the task pane by clicking its Close button (the × button). If you want to start Excel and open an existing workbook at the same time so that you can work in that workbook, start Excel in either of these ways:
    ■ Choose Start | My Recent Documents and select the workbook from the My Recent Documents submenu. If the My Recent Documents item doesn’t appear on your Start menu, right-click the Start button and choose Properties to display the Taskbar and Start Menu Properties dialog box. Click the upper Customize button to display the Customize Start Menu dialog box. On the Advanced tab, select the List My Most Recently Opened Documents check box. Click the OK button in each dialog box to close that dialog box.
    ■ Double-click the icon for an existing workbook in a Windows Explorer window or on your desktop.

  2. Use or hide the task pane
    By default, Excel displays the Getting Started task pane when you launch the application. The task pane’s default position is to be docked (attached) to the right side of the Excel window, but you can drag it by the handle to any other edge of the window to dock it there if you prefer. Alternatively, you can display the task pane floating free anywhere in the Excel window by dragging it away from the side of the window to which it’s currently docked. When the task pane is docked, you can resize it by dragging the border on its open side to change its width or depth. When the task pane is floating free, you can resize it by dragging any side or corner If you’ve used any of the Office XP applications (or any of the other Office 2003 applications), you’ll be familiar with task panes; if you’re coming to Excel 2003 fresh or from Office 2000 or an earlier version, task panes should be a welcome addition to the interface. The task pane area can display any one of a variety of different task panes built into Excel.

  3. Understand the basics of worksheets and workbooks
    Excel’s basic unit is the worksheet, a grid of cells in which you enter data. Each worksheet consists of 256 columns and 65,536 rows. The intersection of each row and column is a cell, so each worksheet contains 16,777,216 cells. By default, Excel uses the A1 reference scheme to refer to columns, rows, and cells.
    Excel saves worksheets in workbook files. These files use the Microsoft Excel Worksheet file format, which has the .XLS file extension. Each workbook can contain either one or more worksheets. By default, new workbooks contain three worksheets and can contain up to 256 worksheets. The worksheets are named Sheet1, Sheet2, and so on. You can change these names as needed.
    Workbooks make it easy to keep related information on separate sheets that you can access quickly. For example, you might use a separate worksheet to track the sales results for each of your company’s sales territories. As you’ll see shortly, Excel provides features for entering the same data on multiple worksheets simultaneously, so you can quickly create a group of worksheets that contain the same basic information—for example, the layout of those sales results and associated information. On the top sheet of the workbook, you might put a summary worksheet that presented an executive overview of the sales results. Excel lets you create formulas that link from one worksheet to another, so the sales-territory worksheets could automatically update the summary worksheet.

  4. Open an existing workbook
    The most conventional way of opening an existing workbook is to use the Open dialog box. To do so, follow these steps:
    a. Click the Open button on the Standard toolbar or the Open link in the Getting Started task pane, or choose File | Open, or press CTRL-O, to display the Open dialog box 2. Navigate to the folder that contains the workbook:
    ■ Use the My Recent Documents button on the Places bar to display a list of your recently opened workbooks.
    ■ Use the other buttons on the Places bar to quickly access your desktop, My Documents folder, My Computer folder, or My Network Places folder as necessary.
    ■ Navigate up and down the folder tree as usual.
    b. Select the workbook. If the Open dialog box doesn’t show the workbook file, you may need to choose a different filter in the Files of Type drop-down list. The default filter is All Microsoft Excel Files, which displays all the file types that Excel claims as its own.
    c. Click the Open button to close the Open dialog box and open the workbook.

  5. Share Information
    With Other People
    If you need input from several people, you can create a shared workbook (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.) and place it on a network location where they can edit it simultaneously. For example, if the people in your workgroup each handle several projects and need to know each other's status, the group could use a shared workbook. All persons involved can then enter the information for their projects in one and the same workbook.
    There are a lot of step by step instructions for creating a shared workbook available in the training video. Nothing can be easier than watching and hearing the lessons to master the Microsoft Excel skills.
    With Other Programs
    a. Copy Excel data and charts to Word or PowerPoint
    Select the data or chart you want to copy.
    Click Copy.
    Switch to Microsoft Word or Microsoft PowerPoint.
    Click in the document or presentation where you want to put the Microsoft Excel data or chart.
    b. Paste the data into Word
    Click Paste on the Formatting toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.).
    Click Paste Options next to the data, and then do one of the following:
    - To paste the data as a Word table, click Match Destination Table Style or Keep Source Formatting.
    - To paste a link to the Excel data, so that the data in the Word document is updated whenever you change the data in the original Excel workbook, click Match Destination Table Style and Link to Excel or Keep Source Formatting and Link to Excel.
    - To paste the data as text with each row in a separate paragraph and tabs separating the cell values, click Keep Text Only.
    Besides, you can also paste a chart into Word, the data into PowerPoint, a chart into PowerPoint.

Benefits of Microsoft Excel Training Video
Microsoft Excel Training Video        With lessons in Microsoft Excel Training Video, you will soon discover all features and usage of this software necessary for your job and especially the software is an even more powerful tool in the management of your business.
  - Smashing Spreadsheets Microsoft Excel offers the ultimate in spreadsheet creation. Time after time users can create, edit and improve upon spreadsheets created with Excel. The beauty of Excel’s spreadsheet program is that it stands the test of time. Perfectly spaced columns and rows make reading your spreadsheet a breeze. There are many shortcuts people overlook when creating spreadsheets that are readily covered in Microsoft Excel training courses. These training video are easily accessible, cost effective and available on the Internet.
  - Terrific Tables Microsoft Excel extends your table-creating abilities by allowing room to expand. 
 - Marvelous Macros The use of macros worries some business owners, but with Microsoft Excel, you can easily set macro security levels to protect your company against viruses. Macros can be created to bypass a lot of time-consuming data entry functions, effectively improving the speed at which employees complete every-day tasks.
- Website Creation Any web designer will agree; tables can be annoying to type up. With Microsoft Excel, you can create amazingly accurate tables for your website with minimal effort.
It can be said without exaggeration that whether you are looking for a beginner, intermediate or advanced Excel training program, you won't be disappointed in the end result. You will learn valuable tips and tricks to improve their productivity, efficiency and your bottom line.

      All of the above instructions is just a small part of the Microsoft Excel Training Video. After completing this Excel training, you will be well-prepared to make your work easier and simpler. This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, you can purchase it from this website


15 CDs Video Training - includes beginner, intermediate and advance courses
MS Word XP
MS Excel XP
MS Access XP
MS Outlook XP
MS Power Point XP
15 CDs Video Training - beginner, intermediate and advance courses
MS Word XP
MS Excel XP
MS Windows XP
MS Outlook XP
MS Power Point XP
Select any 5 out of 21 courses
Providence Mortgage
Portland Schools Foundation
Latin American Association
Pierce Industries
Workforce Developent
Scandinavian Airlines
NorthWest Airline
American Airline
University of Hue
Vietnam’s Polytech Hanoi
Australian International
Polymedco Inc.
Intel international

Important Links

Online Survey Software

American Red Cross
Online Survey Software United Way
Human Resource Consultant & Training Mel Trotter Ministry
Free Awning Software Salvation Army

Computrain Solutions is a member of the Better Business Bureau
Copyright 2004. Computrain Solutions. All Rights Reserved.

 Microsoft Windows Training Video
 Microsoft Access Training Video
 Microsoft Outlook Training Video
 Microsoft Word Training Video
 Affordable Computer Training
 Easy Computer Training
 Computer Training Help
 Video Professor
 Microsoft Excel Training Video
 Computer Training Video
 Computer Video Professor