Microsoft PowerPoint - Business 295fexcel.ppt
Short Description
Tutorial. Monday, September 11, 2006. Eric Dolansky. What is Microsoft Excel? Microsoft Office Spreadsheet. program. Used for charts, graphs, and …
Website: www.ivey.uwo.ca | Filesize: 179kb
Content
Business 295f: Excel
Tutorial
Monday, September 11, 2006
Eric Dolansky
What is Microsoft Excel?
.. Microsoft Office Spreadsheet
program
.. Used for charts, graphs, and
calculations
.. Lots and lots of functions
Excel is made up of cells
.. What is a cell?
.. Can contain text and/or
numbers
.. Referred to by the column
(letter) and row (number),
e.g. A3
.. Can manipulate size, colour,
border, font, etc.
Getting Started?
.. Open Excel
.. In column A, type in any 10
random words in the first ten rows
..In column B, type in any 10
random numbers in the first ten
rowsHow to do basic calculations
.. All functions must begin with ‘=’
.. Can use numbers or non-text cells
.. Can do arithmetic (+, -, *, /)
.. Uses order of operations -
BEMDAS
.. Exponent/power (^)
.. Summations
Some Notes About Functions
.. Cutting, copying, and pasting
.. Unmoving reference - F4 ($)
.. Other functions - use Insert,
Function and follow
instructions
Numerically Formatting Cells
.. Go to Format, Cells, Number
.. Choose number type
.. Choose number of places after
the decimal
.. Can also be done with some
buttons on the toolbar
Other Functionality
.. Sort
.. Graphs
.. Sequences
.. Putting charts into Word…
Get the file Download here
Related Books:Related Searches: text cells, format cells, spreadsheet program, column letter, excel microsoft
Comments
Leave a Reply