Open Office 4 Calculator: How to Create Vertical and Horizontal Pivot Tables Instantly * Save Time скачать в хорошем качестве

Open Office 4 Calculator: How to Create Vertical and Horizontal Pivot Tables Instantly * Save Time

In this video I demonstrate how to instantly create vertical and horizontal pivot tables using Open Office 4 Calculator. With pivot tables, you can sum up how much a specific person (in a list) has spent and also get this value as a percentage of the total spent. The added feature is, you can select / deselect specific names in a list, giving you the power to filter information that is useful to you. Pivot tables will save you a lot of time and energy and knowing how to set them up is an important skill to have whether you're working in finance or marketing. In this fast paced world, shortcuts will make a massive difference to your finances and mental health. If this video was useful to you, ensure you are subscribed to my channel as similar content will be posted up regularly. You can follow me on social media via:   / tiago_hands     / tiago_hands   For mathematical content and proofs, go to:   / mathematics.proofs   Thanks for watching!! ENTIRE OPEN OFFICE CALCULATOR 4 PLAYLIST: Link:    • Open Office 4 Tutorials [Spreadsheets]   1. How to get numbers going down a column in multiples (Open Office 4)    • How to get numbers going down a column in ...   2. How to sum up columns of numbers (with a currency) using Open Office 4    • How to sum up columns of numbers (with a c...   3. How to get the percentages of values in a column, relative to one specific value (Open Office 4)    • How to get the percentages of values in a ...   4. How to save and password protect your spreadsheet file (Open Office 4)    • How to save and password protect your spre...   5. How to increase the size of many cells with overlapping text - all at once (Open Office 4)    • How to increase the size of many cells wit...   6. How to sum up values associated with multiple names - all at once [SUMIF] (Open Office 4)    • How to sum up values associated with multi...   7. How to sum up all the values associated with a specific name in a list (Open Office 4)    • How to sum up all the values associated wi...   8. How to compare two lists on a spreadsheet [ISNUMBER, MATCH, TRUE OR FALSE] :: Open Office 4    • How to compare two lists on a spreadsheet ...   9. How to Create a Line Chart using Open Office 4 [Applied Statistics]    • How to Create a Line Chart using Open Offi...   10. How to Create a Pie Chart using Open Office 4 [Applied Statistics]    • How to Create a Pie Chart using Open Offic...   11. How to Sum up Cells from Different Sheets, Open Office [Spreadsheet Tricks]    • How to Sum up Cells from Different Sheets,...   12. How to Make Grid Lines Invisible on Open Office [Free Spreadsheet Tutorial]    • How to Make Grid Lines Invisible on Open O...   13. How to make Days and Dates go down a Column in Corresponding Order [Open Office Spreadsheets]    • How to make Days and Dates go down a Colum...   14. How to Calculate Percentage Changes using Open Office and Format in Colour (Conditional Formatting)    • How to Calculate Percentage Changes using ...   15. How to Quickly Create a Table with the Powers of Ten In Digits (Open Office Spreadsheets)    • How to Quickly Create a Table with the Pow...   16. How to automatically mimic data from the column on one sheet to another sheet (Open Office)    • How to automatically mimic data from the c...   17. Find amount of days that have passed between two dates - Open Office Calculator    • Find amount of days that have passed betwe...   18. Conditional formatting: How to highlight specific text in a list (Open Office Calculator)    • Conditional formatting: How to highlight s...   19. How to graph in 2 dimensions using Open Office Calculator [Example: y=x^2]    • How to graph in 2 dimensions using Open Of...   20. How to do basic probabilities using Open Office Calculator [Example: Dice Roll]    • How to do basic probabilities using Open O...   21. How to Transform Date Text to Date Formatted Text (Open Office Calculator)    • How to Transform Date Text to Date Formatt...   22. Open Office Calculator 4 Tricks: How to Create New Lines within 1 Cell [CTRL+Enter]    • Open Office Calculator 4 Tricks: How to Cr...   23. Open Office Calculator 4, Productivity: How to Apply and Use The Auto-Filter Feature    • Open Office Calculator 4, Productivity: Ho...   24. Open Office 4 Calculator: Bold, Italic and Underline Keyboard Tricks to Save Time & Energy    • Open Office 4 Calculator: Bold, Italic and...   25. Open Office 4 Calculator: How to Create Vertical and Horizontal Pivot Tables Instantly * Save Time    • Open Office 4 Calculator: How to Create Ve...   26. Open Office 4 Calculator: How to Wrap Your Text and Keep it Within Boundaries    • Open Office 4 Calculator: How to Wrap Your...