LIVING IN IT ERA

  BONUS ACTIVITY SUBSCRIBE COMMENT LIKE

PIVOT TABLES HOW TO CREATE A PIVOT TABLE 1. Select Cells that you want to create a pivot table from. 2. Select Insert > Pivot Table 3. Choose the data you want to analyze, Select a table or range. 4. In table/range, Verify the cell range. 5. Choose where you want to place the Pivot Table, New worksheet or Existing Worksheet. 6. Select Ok.   PIVOT CHARTS HOW TO CREAT PIVOT TABLE TO CHARTS 1. Select a cell in your table. 2. Select PivotTable Tools > Analyze > PivotChart  3. Select a chart 4. Select OK.

 

EXERCISE 8: CHART, SORTING, FILTER, SUBTOTALS 1. Printscreen Sort the data by ID A-Z smallest-highest 2. Printscreen Sort  by Name A-Z sort Ascending 3. Printscreen Sort by Loan Amount Z-A sort Highest to lowest 4. Printscreen Filter by Item Type-Sporting Goods 5. Print Screen Create and Customize a book sales chart

  Steps To Complete this Spreadsheet: Budget and Format Supplies: 1. Create the Company Logo and Title. 2. Format as Table, choose your color. 3. Format price per unit and line total. 4.Compute Line total and total supplies. Total Monthly Bills too. 5. Change the tab or sheet name and table color. 6. Printscreen the Final Output.                Steps to Complete this Spreadsheet: Customer Invoice 1. Create the Company logo and title. 2. Format as table, choose your color. 3. Format price per unit and line total. 4.Compute. 5. Change the tab or sheet name to customer invoice and change the tab color. 6. Printscreen the final output.

LINK OF THE VIDEO: https://l.facebook.com/l.php?u=https%3A%2F%2Fyoutu.be%2F6yfJ1olR9zg%3Ffbclid%3DIwAR19Gh-NpcGBclTzmAcW08k1ADJwFeS3M8QUt9Bo9Q_-udcWb_Z9iYCLlfA&h=AT2CQPE97WtP1FlHdOABj0O-ebJ2_EUV-8VyghCrL7EsWCgQLQDttnjhVAAcwWlFb1MLCGFvt-ZGDEVavp9hfSIOStCwBYBNww7B6QVgx5STlojBAqi3Lx93O9uO5Nt-Sy3q9Q  COMMENT: LIKE: SUBSCRIBE:

 THE MS WORD MANUAL 1. Print Screen the following steps and upload it to your Blogger Account. 2. Create a document that consist a topic about MS WORD, at least 10 pages. And indicate your sources properly in the Bibliography. 3. Insert Header, Footer and Page Number. 4. Insert Cover Page, Design it the way you want. 5. Home - Styles - Create - New Styles 6. Apply Heading 1,2,3 styles in your titles. 7. References - Table of Contents. 8.References- Insert Caption to images. 9. References - Insert Table of Figures. 10. Insert Footnotes, 11. Insert Citation, At least 3 References. 12. Bibliography - Automatic Bibliography. Insert Header, Footer and Page Number. Insert Cover Page, Design it the way you want. Home - Styles - Create - New Styles Apply Heading 1,2,3 styles in your titles. References - Table of Contents. References- Insert Caption to images.  References - Insert Table of Figures. Insert Footnotes Insert Citation, At least 3 References. Bibliography - Automatic Biblio...