ISTM EXCEL ********
goal seek
A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell
complex functions
ADD
simple functions
ADD
conditional formatting
Apply formatting to a cell or range based on a criteria you choose
things you can do with excel
Calculations, formulas, charts, store data, what if analysis, pivot tables, filtering,sorting
PROPER function
Converts a block of test to title-case.
IF function
Function that is used to make a decision based on a comparison ALWAYS = BEFORE >or< =IF(B9>=70,"pass","false")
LEFT function
Returns the characters in a text based on the number of characters you specify starting with from the left
MID function
Returns the characters in a text based on the number of characters you specify starting with from the middle
RIGHT function
Returns the characters in a text based on the number of characters you specify starting with from the right
data tables
a chart containing data
pie chart
a chart that shows the relationship of a part to a whole no more than 6 values
line chart
a chart that uses points connected by a line to illustrate values in a worksheet uncovers trends compares data over time
absolute reference vs relative reference
absolute: has money signs, used when you want it to stay on the exact cell relative: used when you essentially want to drag down to use on different cells
shortcut control A
add
shortcut control F
add
shortcut control N
add
shortcut control O
add
shortcut control W
add
shortcut control home
add
filtering
allows for better organization and look at different perspectives
PMT function
calculates the periodic payment for a loan can be determined on diff dates versitile!! =PMT(#,#,#)
CONCATENATE function
combines text
LEN function
counts length and characters in a block of text
piviot table
creates a table of stats default value is sum groups data to summarize and present
scenario manager
enables you to define and manage scenarios to compare how they affect results
what if analysis
enter
VLOOKUP function
helps you locate specific values in a table must be in ascending order!!! use approximate match =VLOOKUP( lookup value, search this range, return a match from this column, FALSE)
bar charts
horizontal compares same or different data dont make it unreadable (6 values)
how to look at formula
in the formula bar, click show formulas, or click on cell
if you see ## in a cell what does that mean
it needs to be widened
what was the OG excel called
multiplan
do you have to save indivisual worksheets?
no
key to having an effective worksheet
organize the info and know whats needed
sorting
organizes data and can be done on multiple levels
SEARCH function
returns with a specific word or phrase
how have students been caught cheating
same mispellings on work
how can you tell that a cell is active
theres a dark box around it
how did excel get their name
they bought it from someone else
whats important to remember about "sums"
they can be written in multiple ways
column charts
vertical compares same or different values dont make it unreadable (6 values)
cell range definition
when you select multiple cells
the bottom tabs on excel are called what
worksheets
when filling in a collumn, how do you do it
you can drag down or copy and paste
when was excel released
1987
formulas always begin with what
=
SUMIF function
A function that adds the values in a range that match criteria you specify adds numbers selected together uses dollar signs =SUMIF(Range, criteria, range)
LOWER function
A function that converts all uppercase letters to lowercase
UPPER function
A function that converts text to uppercase letters
SUBSTITUTE function
A function that substitutes new text for old text