• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

ICT basic 01

fabs02

New Member
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….
 

AlanSidman

Well-Known Member
Homework
Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.
 
Top