 |
|
 |
Home »
Microsoft Excel »
General Formatting
::
ReportRelated Tutorials
 |
|
|
|
Microsoft Excel / General Formatting Formatting techniques: Learn how to format numbers, format cells, use special and custom formats, apply AutoFormat on a cell or text, and more. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Excel / General Formatting Microsoft Excel provides a faster and customized technique used to to apply a particular and user-created format that can be applied to a series of cells. As effective as that technique is, it has its own limitations. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Finding the sum and average of cells can be very useful for quickly processng months worth of aculimated data. Site: gelper.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula There are many functions built into many spreadsheets. One of the first ones that we are going to discuss is the Average function. The average function finds the average of the specified data. (Simplifies adding all of the indicated cells together and dividing by the total number of cells.) Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / General Formatting A simple way to create a linking system within Excel, to create a Table of Contents. |
||
|
|
|
|
|
|
Microsoft Excel / General Formatting Spreadsheets can be pretty dry, so we need some tools to dress them up a little. We can use most of the tricks in our word processor to do the formatting of text. We can use : bold face, italics, underline, change the color, align (left, right, center), font size, font, etc. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started Often we have several cells that need the same formula (in relationship) to the location it is to be typed into. There is a short cut that is called Fill Down. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started So let's get started digging into what makes a spreadsheet work. Spreadsheets are made up of,columns,rows,and their intersections are called cells.. Site: www.usd.edu
|
||
|
|
|
|
|
 Microsoft Excel / Getting Started You can use the Find and Replace feature to quickly locate every occurrence of a specific string (a series of characters) in a worksheet and then have Excel actually update the cells that it finds with new text or numbers. Site: excel.brainbell.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 / Functions and Formula The function we will discuss is Min (which stands for minimum). This will return the smallest (Min) value in the selected range of cells. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Discuss Max function(which stand for Maximum). This will return the largest (max) value in the selected range of cells. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula The function we will discuss is Count. This will return the number of entries (actually counts each cell that contains number data) in the selected range of cells. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started We can also fill right. We must select the original cell (and the cells to the right) and select from the Edit menu -- Fill and Right. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula This tutorial describes CountA function. This will return the number of entries (actually counts each cell that contains number data OR text data) in the selected range of cells. Site: www.usd.edu
|
||
|
|
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
|
|