ICT Tutorials
  • HOME
  • INTRO & WINDOWS
    • INTRODUCTION >
      • FUNDAMENTAL OF IT
      • TYPE OF COMPUTER DEVICES
      • COMPUTER GENERATION
      • SYSTEM COMPUTER
      • TYPE OF COMPUTERS
      • NUMBERING SYSTEM
      • TYPE OF MOUSE
      • KEYBOARD
      • DATA PROCESSING
      • OPERATING SYSTEM
      • HISTORY OF COMPUTER
    • MS WINDOWS >
      • ABOUT MS WINDOWS
      • WINDOWS DESKTOP
      • Win Control Activation
  • MS OFFICE
    • ABOUT MS-OFFICE
    • MS WORD >
      • INTRO TO MS-WORD
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • CUT, COPY, PASTE, FORMAT PAI
        • FONT
        • STYLES
        • FIND, GO TO, REPLACE
      • INSERT >
        • PAGES -COVER, BLANK, BREAK
        • TABLES
        • ILLUSTRATIONS >
          • PICTURES, ONLINE PICTURE
          • SHAPES, ICONS, 3D MODELS
          • SmartArt
          • CHART, SCREENSHOT
        • LINK, BOOKMARK, CROSS-REF
        • COMMENT, HEADER/FOOTER
        • TEXTS >
          • TEXT BOX, WORDART, DROP CAP, OBJECT
        • SYMBOL
      • DRAW >
        • PENS
      • DESIGN >
        • DOC STYLES, WATERMARK
        • PHARAGRAPH
        • PAGE COLOR, BORDERS
      • LAYOUT >
        • PAGE SETUP, SPACING
        • ARRANGE OBJECTS
      • REFERENCES >
        • TABLE OF CONTENTS
      • MAILINGS >
        • ENVELOPES
      • REVIEW >
        • DOC REVIEWS
      • VIEW >
        • WEB LAYOUT, NEW WIN, SPLIT
        • SWITCH WINDOWS, MACROS
    • MS EXCEL >
      • INTRO TO MS-EXCEL
      • FILE >
        • INFO, NEW, OPEN
        • SAVE/SAVE AS, PRINT
        • SHARE, EXPORT
      • HOME >
        • ALIGNMENT >
          • CELL ALIGN, ORIENTATION
          • INDENTS, MERGE & CENTER
        • NUMBER, COND FORMAT
        • TABLE, INSERT, DELETE
        • FORMAT >
          • ROW HEIGHT, COLUMN WIDTH
          • HIDE, RENAME, MOVE OR COPY
        • PROTECT SHEET, FILL
        • SORT & FILTER, AUTOSUM
      • FORMULAS >
        • INTRO TO FORMULAS
        • MATH & TRIM >
          • ABS( ), COMBIN( )
          • SUM FUNCTIONS( )
          • COS( ), SIN( )
          • BASE( )
        • STATISTICAL >
          • AVERAGE FUNCTIONS( )
          • MAX FUNCTIONS( )
          • MIN FUNCTIONS( )
          • COUNT FUNCTIONS( )
          • MODE FUNCTIONS( )
        • ENGINEERING >
          • BIN2DEC
          • CONVERT
        • TEXT FUNCTIONS >
          • LEFT( ) RIGHT( ) MID( )
          • FIND( ) LEN( ) PROPER( )
          • TRIM( ) EXACT( ) FIXED( )
          • REPLACE, UNICHAR, UNICODE
          • CODE( ) CHAR( ) REPT( )
        • DATE & TIME FUNCTIONS >
          • TODAY( ) YEAR( ) DAYS( )
        • LOGICAL >
          • IF( ), IFERROR( )
          • IFS( ), SWITCH( )
          • AND( ), OR( )
          • IFNA( ), XOR( )
      • INSERT >
        • CHARTS, SPARKLINES
      • PAGE LAYOUT >
        • PRINT TITLES, SHEET OPTION
      • DATA >
        • GET DATA, DATA VALIDATION
        • CONSOLIDATE
      • VIEW >
        • WORKBOOK VIEWS
      • Excel Functions Exercises >
        • Exercises 1 and 2
        • Exercises 3 and 4
    • MS POWER POINT >
      • INTRO TO MS-POWERPOINT
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • NEW SLIDE, STYLES, FILL
      • INSERT >
        • PHOTO ALBUM, VIDEO, AUDIO
        • SCREEN REC, SHOT, SLIDE NUM
      • DESIGN >
        • THEMES, SLIDESIZE, FORMAT
      • TRANSITION >
        • TRANSITION, SOUND
    • MS ACCESS >
      • INTRO TO MS-ACCESS
      • FILE >
        • HOME, NEW, OPEN
    • OFFICE QUESTION & ANSWER
  • VISUAL STUDIO
    • VISUAL BASIC .NET >
      • INTRODUCTION
      • .NET FRAMEWORK
      • OPERATORS IN VB.NET
      • DATAYPES IN VB.NET
      • VB.NET KEYWORDS
      • VARIABLE AND CONST
      • INTRO TO VB.NET PLATFORM
      • INTRO TO PROGRAMMING
      • OBJECTS USAGE IN WIN-FORM
    • Python >
      • Introduction
    • C++
  • GOOGLE TIPS
    • GMAIL ACCOUNT >
      • Email Forwarding
      • Setting up Authenticator App
      • SIGNATURE SET UP
    • GOOGLE WORKSPACE
  • INVENTS
    • NEW INVENTS
  • ABOUT ME

SORT & FILTER, AUTOSUM

19/12/2017

0 Comments

 
Sort & Filter:
When you get handed an Excel spreadsheet with thousands of rows inside of it, and you realize the data is all out of order. You might need to sort it based on the names inside of a column, or by sorting data from large to small.

On the surface, sorting data is a simple task in Excel, and the app certainly makes simple sorting easy. However, there's much more power in how you can sort and reorder the data in your worksheets.

In addition to sorting, you may find that adding a filter allows you to better analyze your data. When data is filtered, only rows that meet the filter criteria will display, and other rows will be hidden. With data filtered, you can then copy, format, print, etc., your data, without having to sort or move it first.

To use the filter:
Click Home Ribbon =>
Click the arrow below the Sort & Filtering icon in the Editing Group =>
Choose Filter.

You will notice that all of your column headings now have an arrow next to the heading name. Click on the arrow next to the heading by which you want to filter, and you will see a list of all the unique values in that column. Check the box next to the criteria you wish to match and click OK. Click on the arrow next to another heading to further filter the data. So you can continue as same for all other columns which you have in data worksheet.

To clear the filter:
Click on Filter icon next to the heading =>
Choose Clear Filter From “Name of Heading”.

Let me give an example bit more about sorting with question and answer.

How to sort the values to descending order in the selected cells?
Select the cells that you want to sort them in order to your criteria =>
Select Home Menu =>
Click Sort & Filter Tool =>
Click Sort Largest to Smallest.

For more understanding, look at the screenshot please:
Picture

AutoSum:
When you need to sum a single range of cells, whether a column, row or several adjacent columns or rows, you can have Excel AutoSum to automatically make an appropriate SUM formula for you.
 
When you use AutoSum, in most cases, MS-Excel selects the correct range to total. In a rare case when a wrong range is selected, you can correct it manually by typing the desired range in the formula or by dragging the cursor through the cells you want to sum.
 
The AutoSum is a function in Microsoft Excel and other spreadsheet programs that automatically enters the appropriate formula or function into your spreadsheet. For example, if you wanted to add the values of cells A1 through A4, highlight cells A1 through A4 and click the AutoSum button, as shown in the picture to the right. Clicking this button after highlighting the cells creates the formula =SUM(A1:A4) in cell A5 (first cell after last highlighted cell) and gives you the total of all those cells.
 
The AutoSum feature makes entering formulas easy without the need to memorize the syntax for each formula.
 
How to use AutoSum tool to calculate values from selected cells?
Keep the cursor point in a cell that you want to get calculated value =>
Select Home Menu =>
Click AutoSum =>
Give the range of calculating area and press Enter key.
 
For more understanding, look at the screenshot please:
Picture
0 Comments

    Archives

    December 2017

    RSS Feed

​WELCOME TO WWW.COMTEACHERS.COM and We Would Love To Have You Visit Next Time Too! FOR MOBILE USERS, TO READ THE NOTES PLEASE CLICK MENU ICON, IT SHOULD BE EITHER ON TOP LEFT OR RIGHT CORNER OF YOUR SCREEN AND THEN CLICK MENU BY MENU TO CONTINUE READINGS...
  • HOME
  • INTRO & WINDOWS
    • INTRODUCTION >
      • FUNDAMENTAL OF IT
      • TYPE OF COMPUTER DEVICES
      • COMPUTER GENERATION
      • SYSTEM COMPUTER
      • TYPE OF COMPUTERS
      • NUMBERING SYSTEM
      • TYPE OF MOUSE
      • KEYBOARD
      • DATA PROCESSING
      • OPERATING SYSTEM
      • HISTORY OF COMPUTER
    • MS WINDOWS >
      • ABOUT MS WINDOWS
      • WINDOWS DESKTOP
      • Win Control Activation
  • MS OFFICE
    • ABOUT MS-OFFICE
    • MS WORD >
      • INTRO TO MS-WORD
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • CUT, COPY, PASTE, FORMAT PAI
        • FONT
        • STYLES
        • FIND, GO TO, REPLACE
      • INSERT >
        • PAGES -COVER, BLANK, BREAK
        • TABLES
        • ILLUSTRATIONS >
          • PICTURES, ONLINE PICTURE
          • SHAPES, ICONS, 3D MODELS
          • SmartArt
          • CHART, SCREENSHOT
        • LINK, BOOKMARK, CROSS-REF
        • COMMENT, HEADER/FOOTER
        • TEXTS >
          • TEXT BOX, WORDART, DROP CAP, OBJECT
        • SYMBOL
      • DRAW >
        • PENS
      • DESIGN >
        • DOC STYLES, WATERMARK
        • PHARAGRAPH
        • PAGE COLOR, BORDERS
      • LAYOUT >
        • PAGE SETUP, SPACING
        • ARRANGE OBJECTS
      • REFERENCES >
        • TABLE OF CONTENTS
      • MAILINGS >
        • ENVELOPES
      • REVIEW >
        • DOC REVIEWS
      • VIEW >
        • WEB LAYOUT, NEW WIN, SPLIT
        • SWITCH WINDOWS, MACROS
    • MS EXCEL >
      • INTRO TO MS-EXCEL
      • FILE >
        • INFO, NEW, OPEN
        • SAVE/SAVE AS, PRINT
        • SHARE, EXPORT
      • HOME >
        • ALIGNMENT >
          • CELL ALIGN, ORIENTATION
          • INDENTS, MERGE & CENTER
        • NUMBER, COND FORMAT
        • TABLE, INSERT, DELETE
        • FORMAT >
          • ROW HEIGHT, COLUMN WIDTH
          • HIDE, RENAME, MOVE OR COPY
        • PROTECT SHEET, FILL
        • SORT & FILTER, AUTOSUM
      • FORMULAS >
        • INTRO TO FORMULAS
        • MATH & TRIM >
          • ABS( ), COMBIN( )
          • SUM FUNCTIONS( )
          • COS( ), SIN( )
          • BASE( )
        • STATISTICAL >
          • AVERAGE FUNCTIONS( )
          • MAX FUNCTIONS( )
          • MIN FUNCTIONS( )
          • COUNT FUNCTIONS( )
          • MODE FUNCTIONS( )
        • ENGINEERING >
          • BIN2DEC
          • CONVERT
        • TEXT FUNCTIONS >
          • LEFT( ) RIGHT( ) MID( )
          • FIND( ) LEN( ) PROPER( )
          • TRIM( ) EXACT( ) FIXED( )
          • REPLACE, UNICHAR, UNICODE
          • CODE( ) CHAR( ) REPT( )
        • DATE & TIME FUNCTIONS >
          • TODAY( ) YEAR( ) DAYS( )
        • LOGICAL >
          • IF( ), IFERROR( )
          • IFS( ), SWITCH( )
          • AND( ), OR( )
          • IFNA( ), XOR( )
      • INSERT >
        • CHARTS, SPARKLINES
      • PAGE LAYOUT >
        • PRINT TITLES, SHEET OPTION
      • DATA >
        • GET DATA, DATA VALIDATION
        • CONSOLIDATE
      • VIEW >
        • WORKBOOK VIEWS
      • Excel Functions Exercises >
        • Exercises 1 and 2
        • Exercises 3 and 4
    • MS POWER POINT >
      • INTRO TO MS-POWERPOINT
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • NEW SLIDE, STYLES, FILL
      • INSERT >
        • PHOTO ALBUM, VIDEO, AUDIO
        • SCREEN REC, SHOT, SLIDE NUM
      • DESIGN >
        • THEMES, SLIDESIZE, FORMAT
      • TRANSITION >
        • TRANSITION, SOUND
    • MS ACCESS >
      • INTRO TO MS-ACCESS
      • FILE >
        • HOME, NEW, OPEN
    • OFFICE QUESTION & ANSWER
  • VISUAL STUDIO
    • VISUAL BASIC .NET >
      • INTRODUCTION
      • .NET FRAMEWORK
      • OPERATORS IN VB.NET
      • DATAYPES IN VB.NET
      • VB.NET KEYWORDS
      • VARIABLE AND CONST
      • INTRO TO VB.NET PLATFORM
      • INTRO TO PROGRAMMING
      • OBJECTS USAGE IN WIN-FORM
    • Python >
      • Introduction
    • C++
  • GOOGLE TIPS
    • GMAIL ACCOUNT >
      • Email Forwarding
      • Setting up Authenticator App
      • SIGNATURE SET UP
    • GOOGLE WORKSPACE
  • INVENTS
    • NEW INVENTS
  • ABOUT ME