Skip to main content

EXCERCISE 6 - Charts, Subtotal, Sorting, Filtering data



SORT & SUB TOTAL

Depending on the value type stored in cells. Some common examples include sorting alphabetically (A to Z or Z to A), by value (largest to smallest or smallest to largest), by day of the week (Mon, Tue, Wed..), or by month names (Jan, Feb..) etc. Filter Method sorting in Excel can be done depending on the type of data (number or text); there are many ways to sort data using the filter method.


CHARTS
Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers and they make showing comparisons and trends much easier. In this tutorial, you will learn how to insert charts and modify them so they communicate information effectively.




"MY OWN WORK"

































Comments

Popular posts from this blog

EXCERCISE 3 - SmartArt Graphics

SmartArt is a type of graphical tool in Word and Powerpoint, SmartArt is basically the way to make organized presentation art and It was suitable for "organizational" types of artwork, such as organization charts and process lists. 1. Go to Insert and choose Smartart. 2. The Smartart dialog box appears, Choose the type and the layout you want then click OK to insert, The dialog box will open where you can choose different types of SmartArt graphics. 3. If you want to change the layout of the recent model to another model, Click on that SmartArt model and select Design, then select Change Layout, To resize the entire Smartart graphic, Select it and drag the any corners in and out to increase or reduce the size of the graphic. *Heres My Own SmartArt Graphics* Cycle Hierarchy - Name & Title Organizational  Chart Infographics

PROJECTS - Animation

  THE PIECE OF ECOSYSTEM Ecosystems blur into each other and there are not usually clear boundaries between them.  However, humans do create these boundaries for the sake of study and understanding.  Like how we classify living things, with domains, classes, species, etc…,  we also can consider ecosystems to be something similar.