Essay about Excel Notes

Submitted By Marlo-P
Words: 1080
Pages: 5
Open Document
Excel Notes
12/13/12
Each worksheet in a workbook has 16,384 columns and 1,048,576 rows for a total 17,179,869,180 cells.
If you prefer using the keyboard instead of the mouse, you can press the ALT key on the keyboard to display a Key Tip badge, or keyboard icon, for certain commands.
Entering text in a cell means left-aligned.
In Excel, you can enter numbers into cells to represent amounts. A number can contain only the following characters: 0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e
If a cell entry contains any other keyboard character (including spaces), Excel interprets the entry as text.
Calculating a Sum: A range is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
1. Select a range
2. Start with the equal sign
3. Use sum or average or minimum or maximum
4. Use parentheses to enclose your range. Also use the colon to obtain a large range.
5. Make sure your cursor is activating the proper cell, for your formula total.
Example: =SUM(B4:B8)
To copy a cell function, the cell being copied is called the source area or copy area. The range of cells receiving the copy is called the destination area or paste area.
The easiest way to copy the Sum (or other functions) formula is to use the fill handle, located in the lower right corner. Drag the fill handle to the destination.
Standard Copy and Paste applies
Other ways: Select source area, click point to border of range ( while holding down CTRL), drag source area to destination area.
3/4/13
Arithmetic Operators
Arithmetic Operator
Meaning
-
Negation
%
Percentage
^
Exponentiation
*
Multiplication
/
Division
+
Addition
-
Subtraction
Use parenthesis to override the order of operations.
Point mode allows you to select cells for used in a formula by using the mouse.
Copy the formulas using the fill handle.
Smart Tags and Option Buttons
To use smart tags, use the AutoCorrect options in Options dialog button.
To change AutoCorrect options, click the Office Button, on the Office Button menu to click Word Options, click Proofing.
Correct Options
Once Smart Tags are turned on, Excel places a small purple triangle called a Smart Tag indicator in the cell.
Clicking the Smart Tag Actions button arrow produces a list of actions you can perform on the data in that specific cell.
Name
Auto Fill Options
AutoCorrect Options
Insert Options
Paste Options
Smart Tag Actions
Trace Error

Every time you enter a value into a cell in the worksheet, Excel automatically recalculates all formulas.
Selecting a Range: Press F8 key use Arrow Keys.
A function takes a value or values, performs an operation, and returns a result to the cell. Examples: AVG, MAX, MIN
3/5/13
Entering Functions: You can drag the Function Arguments dialog box out of the way in order to select a range.
Statistical Functions: Excel usually considers a blank cell to be equal to zero. The statistical functions, however, ignore blank cells.
Insert Functions Dialog Box contains SUM, AVG, MIN, MAX, IF, COUNT
To copy a range of cells across columns to an adjacent range using the fill handle.
1. Select the range
2. Drag the fill handle in the lower-right corner.
Other ways: Select source area, point to border of range, while holding down CTRL key, drag source area to destination area. Also, copy and paste.
To verify a formulas using Range Finder, double click the cell to activate Range Finder. Press the escape key (ESC) to deactivate Range Finder.
Formatting the Worksheet: A theme is a predefined set of colors.
To Apply Conditional Formatting, use the conditional formatting button.
Formatting Numbers Using the Ribbon, formatting the number using the format cells dialog box to apply currency style formats.
Conditional Formatting Operators: New Formatting Rule Dialog box allows you to select a relational operator, such as less than, to use in the condition.
Relational Operators:
Between
Not Between
Equal to
Not equal to
Show More

Related Documents: Essay about Excel Notes

ACS 101 Excel Short Notes Essay example

ACS 101 July Block II 2004 Excel Notes Workbooks Multiple worksheets: Excel allows you to have several worksheets in a single file, which is referred to as a workbook . A workbook may also contain other types of sheet and Visual Basic macros for automating tasks. Whenever you save the file, all sheets in the workbook will be saved together. Similarly, loading a file loads into memory all the sheets in a workbook. The sheets are shown in the sheet tabs at the bottom of the window.…

Words 7088 - Pages 29

Business Context Essay

2014 Lecturer : Second marker : Notes for students : 1. Hard copy of assignment should be stapled in the top left corner and submitted to the School Office. 2. Electronic copy of assignment should be submitted through the Turnitin software. 3. 10% of marks are awarded for satisfactory use of language and/or good presentation. 4. 5% of marks are awarded for satisfactory referencing and/or presentation of a bibliography where either is required. Note that all referenced work should be obtained…

Words 668 - Pages 3

Essay on IF Functions working with Logical Functions

Excel for Office & Home IF Functions - working with Logical Functions Overview =IF() Nested IF Statements =AND() =OR() =COUNTIF() =COUNTIFS() =SUMIF() =SUMIFS() Overview When analysing data in Excel, we often want to pick some data and eliminate unwanted data (temporarily or permanently). This can be done in a number of ways: ● Using the functions =IF() | =AND() | =OR() | =COUNTIF() ● Using filters ● Using PivotTables For the purpose of this topic we are going to concentrate on the functions…

Words 989 - Pages 4

Essay on Sippican Corporation

5: Cost per Unit Note: For exact calculations please see the attached excel file. Recommendations Flow Controllers Starting with flow controllers, there are two ways to deal with the negative gross margin. First way would be to keep on producing the flow controllers and increase the batch sizes and thereby reduce the setup- and shipping related cost. If the batch sizes for shipments and production were increased to 25 units, the gross margin would amounts to 8.6% (see excel sheet for precise…

Words 1681 - Pages 7

Microsoft Excel As A Financial Callculator Part I

Microsoft Excel as a Financial Calculator Part I Excel (and other spreadsheet programs) is the greatest financial calculator ever made. There is more of a learning curve than a regular financial calculator, but it is much more powerful. This tutorial will demonstrate how to use Excel's financial functions to handle basic time value of money problems using the same examples as in the calculator tutorials. I will keep the examples rather elementary, but if you already understand the basics of using…

Words 6517 - Pages 27

Carelink Community Support Services Of Pennsylvania, Inc.

that needs to be streamlined. Currently, staff provides services, handwritten notes are taken, these notes get typed into the computer whenever the staff person has time, the notes are then entered into a software program called ETO, the Accounts Receivable clerk accesses ETO to run a report to see how many consumers were given services for the month, the Accounts Receivable clerk then types this information into excel, and then e-mails the spreadsheet to the respective county for payment. Several…

Words 991 - Pages 4

Essay on Tutorial: Microsoft Excel and Sample Excel Spreadsheets

“Try it!” exercises in green. These “Try it!” exercises are a key feature of this tutorial. I have embedded numerous sample Excel spreadsheets so that you can try out the directions right away—without switching into Excel. When you double-click on one of these spreadsheets, you launch Excel, and the spreadsheet “comes alive.” The menus and toolbars even change to those for Excel. By clicking outside one of these spreadsheets, you’re back in Word. The easiest way to maneuver around this tutorial is…

Words 1377 - Pages 6

Accounts Receivable and Gst Essay

Introduction There are two objectives in this assignment: Students completing this assignment will demonstrate understanding of 1. The accounting cycle 2. Excel spreadsheet use in analysing accounting information The assignment focuses on a small business registered for GST on the invoice basis. Students will use Microsoft Excel templates to show the recording and processing of accounting input data through to the preparation of financial statements. Background Serious Science is a sole…

Words 2598 - Pages 11

Requirement Of Computer With Computer Application

GENERAL INFORMATION UGBA 104 last updated: 11 August 2014 Requirements • • • Excel Knowledge / Willingness to learn Excel Computer with Internet Connection Professional Attitude Registration Q: I am currently waitlisted in your class. Can you get me in? A: Faculty and GSIs cannot enroll students. Please contact the…

Words 2754 - Pages 12

FINAN.+MANAGE.ACCT.F/DECISION MAKERS Essay

ISBN-978-1-111-53045-7 New Perspectives: Microsoft Access 2010, Brief, Adamski – Finnegan, Cengage Learning, ISBN-978-0-538-79849-5 New Perspectives: Microsoft Excel 2010, Brief, Carey, Parsons, Oja, and Ageloff, Cengage Learning, ISBN-978-0-538-74292-4 REQUIRED SOFTWARE: Microsoft Office 2010 is available to registered Hofstra students at no cost. NOTE: Additional materials may be assigned during the semester. A Blackboard site has been established for the course. It is your responsibility to check the…

Words 1445 - Pages 6