where to get help basic function writing tricks = tells excel you want to write a function the...
TRANSCRIPT
![Page 1: where to get help basic function writing tricks = tells excel you want to write a function The function then tells you what you need to enter Then you](https://reader035.vdocuments.us/reader035/viewer/2022070413/5697bffa1a28abf838cc0303/html5/thumbnails/1.jpg)
Making Excel Work for you
![Page 2: where to get help basic function writing tricks = tells excel you want to write a function The function then tells you what you need to enter Then you](https://reader035.vdocuments.us/reader035/viewer/2022070413/5697bffa1a28abf838cc0303/html5/thumbnails/2.jpg)
Structure of this afternoon
where to get help
basic functionwriting
tricks
![Page 3: where to get help basic function writing tricks = tells excel you want to write a function The function then tells you what you need to enter Then you](https://reader035.vdocuments.us/reader035/viewer/2022070413/5697bffa1a28abf838cc0303/html5/thumbnails/3.jpg)
Function writing
= tells excel you want to write a function
The function then tells you what you need to enter
Then you select ranges, set criteria, chose an option.....
![Page 4: where to get help basic function writing tricks = tells excel you want to write a function The function then tells you what you need to enter Then you](https://reader035.vdocuments.us/reader035/viewer/2022070413/5697bffa1a28abf838cc0303/html5/thumbnails/4.jpg)
Function writing
Example 1: Countif statementLets count the number of sales that are £300o or above
1) Tell excel that you are writing the equation
2) Select the range3) Add the criteria“>=3000”
![Page 5: where to get help basic function writing tricks = tells excel you want to write a function The function then tells you what you need to enter Then you](https://reader035.vdocuments.us/reader035/viewer/2022070413/5697bffa1a28abf838cc0303/html5/thumbnails/5.jpg)
Have a play......
About 10 minutes
![Page 6: where to get help basic function writing tricks = tells excel you want to write a function The function then tells you what you need to enter Then you](https://reader035.vdocuments.us/reader035/viewer/2022070413/5697bffa1a28abf838cc0303/html5/thumbnails/6.jpg)
Sort vs Filter
UsesSort Arrange by more than one factor at a
time Ranks data quickly by your definitions No limit to criteria selectable
Filter
Quick selection of data Removes information you don’t need
![Page 7: where to get help basic function writing tricks = tells excel you want to write a function The function then tells you what you need to enter Then you](https://reader035.vdocuments.us/reader035/viewer/2022070413/5697bffa1a28abf838cc0303/html5/thumbnails/7.jpg)
Tricks
Changes a cells format based on a criteria
![Page 8: where to get help basic function writing tricks = tells excel you want to write a function The function then tells you what you need to enter Then you](https://reader035.vdocuments.us/reader035/viewer/2022070413/5697bffa1a28abf838cc0303/html5/thumbnails/8.jpg)
Tricks
Lets highlight sales for Luke over $3000
1) Setup a column that is 1 for Luke and 0 for not Luke using an IF statement
2) Do the same for >3000 and not
3) Setup a column that counts the previous two
![Page 9: where to get help basic function writing tricks = tells excel you want to write a function The function then tells you what you need to enter Then you](https://reader035.vdocuments.us/reader035/viewer/2022070413/5697bffa1a28abf838cc0303/html5/thumbnails/9.jpg)
Pivot Tables
Are AwesomeSelect all data
Press the button using default
settings
Choose row headingChoose column
headingGive excel
something to count
![Page 10: where to get help basic function writing tricks = tells excel you want to write a function The function then tells you what you need to enter Then you](https://reader035.vdocuments.us/reader035/viewer/2022070413/5697bffa1a28abf838cc0303/html5/thumbnails/10.jpg)
Where to get help....
Excel help:Each function is explain with examples
Youtube:Search a termOrSearch Excel is fun