 |
|
 |
Home »
Microsoft Excel »
Getting Started
::
ReportRelated Tutorials
 |
|
|
 Microsoft Excel / Getting Started This top basics list lays out all the fundamental skills required to successfully use Excel 2007. Site: nicetutz.blogspot.com
|
||
|
|
|
|
|
 Microsoft Excel / Getting Started Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. |
||
|
|
|
|
|
 Microsoft Excel / Getting Started This tutorial discover the new Excel interface that provides you with the right tools at the right time. In most Windows programs, you see menus and toolbars from which you select your options. Site: nicetutz.blogspot.com
|
||
|
|
|
|
|
 Microsoft Excel / Getting Started This tutorial shows you a number of Excel tools you can use to improve your document layout, including headers, footers, page orientation, and margins. Site: nicetutz.blogspot.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula If someone sends you an XML file containing data that fits into tables, you don't need to read the text and all its angle brackets. You can load the document into Excel directly, tell Excel how you want to present it, and work with the data through maps. Site: www.brainbell.com
|
||
|
|
|
|
|
 Microsoft Excel / Charts and Graphs A chart (also known as a graph outside Excel circles) is a way to present a table of numbers visually. The visual display allows you, for example, to quickly examine trends or compare the relative contributions of various items. Site: nicetutz.blogspot.com
|
||
|
|
|
|
|
 Microsoft Excel / Getting Started Working with documents is critical to using any software. Microsoft Excel documents are known as workbooks. This part covers the procedures that you need to know to manage workbook documents efficiently. Site: nicetutz.blogspot.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula This tutorial relies on Excel's ability to perform web queries, so you'll need Excel 97 or higher. Excel's Web Queries tool transforms simple HTML tables into Excel spreadsheets. Site: www.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Although cell numbers are at the foundation of everything Excel does, it's much easier to remember names, such as Item Number and Quantity, than it is to remember cell numbers, such as A1:A100. Excel makes this easy. Excel uses the same technique for defining named cells and named ranges: the Name box at the left end of the Formula bar. Site: www.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started Data validation makes it easy to specify rules your data must follow. Unfortunately, Excel insists that lists used in data validation must appear on the same worksheet as the data being validated. Fortunately, there are ways to evade this requirement. In this tutorial, we provide two methods you can use to validate data based on a list on another worksheet. The first method takes advantage of Excel's named ranges, and the second uses a function call. Site: www.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Since Excel XP, Excel has included an XML export option. SpreadsheetML provides an XML representation of your spreadsheets, complete with formatting and formula information. Site: www.brainbell.com
|
||
|
|
|
|
|
 Microsoft Excel / Getting Started Templates are predesigned and formatted spreadsheets, the provide consistency of layout's structure and save time and repetition of work. Site: nicetutz.blogspot.com
|
||
|
|
|
|
|
|
Microsoft Excel / Charts and Graphs In this tutorial, I use data from a fictitious company called Celeste Cosmetics Co. Below please find a snapshot of the company and the data that will be used. Site: barrelofcrafts.com
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started As you are aware, when Microsoft Excel starts, it opens a workbook made of three worksheets. A worksheet is simply made of cells that are patiently waiting for you to enter data. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started Microsoft Excel 2003 tips and tricks for developing spreadsheets (worksheets). Adjusting macro security, tweaking Excel 2003 startup, customizing Excel spreadsheet views, and more. Site: malektips.com
|
||
|
|
Site Search
Categories
Adobe Fireworks
Adobe Flash
Adobe Illustrator
Adobe Image Ready
Adobe Photoshop
3D Studio Max
Cinema 4D
Maya 3D
Microsoft Excel
Microsoft PowerPoint
Microsoft Word
Microsoft Access
MySQL
C and C++ 
Python
Visual Basic
.htaccess
Adobe DreamWeaver
ASP
CGI & Perl
CSS
Java
JavaScript
Microsoft FrontPageAdvertisement
|
|