Class 02:
- Data entry:
* series, autofill
AUTOFILL:
Take the little green thing and pull it down
SERIES:
you select the column and go to HOME-EDITING-FILL- SERIES
you fill in the the column or the row and growth by … is multiplies you current number by that number so 5*2=10*2=20…
If you have an email and you want name and last name separated what you want to do is go into a different cell go to HOME-EDITING-FILL- FLASH FILL
*date/time
If you want to change the date in full words go to NUMBER-LITTLE ICON- CUSTOM- choose what you want.
* percentages
- if there is an increase each year you do (=C5+(C5*$B5) basically amount of sudden year+(AS* percentage(F4)
- percentage of the total sales =Sales/TOTAL(F4)
- Percentage increase/decrease=(C38-B38)/B38 (LAST-CURRENT)
- original number before percentage was added
= amount with VAT/(1+VAT)
* ALT+ ENTER - Comment ( add, edit, delete)
COMMENT: rechtermuis + ADD comment - Create basic formulas
SUM ( a2+a3)
Product ( a2*a3)
Difference (a2-a3)
Quotient: (a2/a3)
Power(tot de macht: (a2^a3)
Opposite= (=-9)
Calculate how to add a percentage =B2*(1+C2) (B2=100 C2=15%)
subtract is =B2*(1-C2) - if you want to calculate a whole row you do =SUM(a2;a6) (counts for everything)
AVARAGE: =AVARAGE(a2;a6) (for percentage same)
HIGHEST NUMBER OF COLUMN:=MAX( WHOLE COLUMN)
2ND HIGHEST NUMBER= LARGE(WHOLE COLUMN, 2)
LOWEST NUMBER= MIN(whole column)
2ND LOWEST NUMBER= SMALL ( whole column, 2)
- Calculate basic percentage increase/decrease
- PERCENTAGE IS TOTAL OF (SALES/ sale of that product) and then you go to numbering-PERCENTAGE
- Change currencies into euro
NUMBER-CURRENCY-EURO
= AUD (=$A$3*B2) - Formatting:
* Fonts
* Cell backgrounds
* borders - Allignment
* horiz/vert alignment
searchbox on excel
* angled tekst
ROTATE 45* go to SEARCHBOX AND CLICK ROTATE!
* indented tekst
* merge and center
* wrap tekst - Nummering formatting
* custom number formatting
you go to HOME-NUMBER-LITTLE ICON-SPECIAL….
