Bonus Points
https://www.youtube.com/watch?v=D9T5g9pSqUU&list=PLN2vGEJFAtTelSzQSh0mRUJP_pgWlhQRc&index=6
Posts
Activity 9: Pivot Table and Pivot Chart
Data Create Pivot Chart with Salesperson and Order Amount - Add the Salesperson to Rows and Order Amount to Values to find out the Grand Total. Create Pivot Chart with Region, Salesperson and Order Amount - Add the Salesperson to Rows, Region to Columns and Order Amount to Values. Insert Pivot Chart. Create Pivot Chart with Sales Person, Month and Order Amount - Add the Salesperson to Rows, Month to Columns, and Order Amount to Values. Change the number format of cells to Currency. Insert Slicer and Pivot Chart. Select the data you want to know.
Activity 7: Charts, Subtotal, Sorting, Filtering of Data
1. Sort by ID: Smallest to Highest 2. Sort by Name: A-Z ascending 3. Sort by Loan Amount Z-A Highest to Lowest 4. Filter by Item Type Sporting Goods 5. Create and customize a Book Sales Chart 6. Subtotal by Item Sum by Loan Amount
Exercise 3: Text Design
Happy Birthday Happy Halloween Merry Christmas Happy Valentines Congratulations
Bonus Points: Like, Comment, and Subscribe
Youtube Link: https://www.youtube.com/watch?v=6yfJ1olR9zg
Activity 4: Creating Table of Contents, Inserting Caption, Table of Figures
Step 1: Insert Header (Inserst Header Title and design) Step 2: Insert Footer (Design footer and insert page number) Step 3: Insert Cover Page (Design your cover page) Step 4: Home - Styles - Create - New Styles Apply the Heading 1,2,3 Styles in your titles Step 5: References - Table of Contents Step 6: References - Insert Caption to Images. Step 7: References - Insert Table of Figures Step 8: Insert Footnotes Step 9: Insert Citation - Add new Sources (insert atleast 3 references) Step 10: Bibliography - Automatic Bibliography
Exercise 1: New Technologies of Hardware and Software
I. Hardware 1. Sony FX6 - The FX6 Cinema Line Camera puts revolutionary compactness and performance in the hands of creators, with its full-frame image sensor and breathtaking sensitivity. Leading-edge movie functions deliver game-changing performance and a library of cinematic looks, alongside pro interfaces and an electronic Variable ND Filter. Note: Operation of this equipment in a residential environment could cause radio interference. 2. Wacom Cintiq 27QHD - The DTH2700 Cintiq 27QHD 27" Creative Pen & Touch Display from Wacom features an AHVA LCD panel, which is Wacom's proprietary IPS technology. The panel allows for a 178° wide viewing angle, which allows you and anyone in your vicinity to fully appreciate the beauty of your work without the colors being washed out. The 27" display also features a QHD 2560 x 1440 native resolution and a 16:9 widescreen aspect ratio for higher resolution images while the 97% Adobe RGB wide ...