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

FORMAT AS TABLE, INSERT, DELETE

17/12/2017

0 Comments

 
Format as Table:
Let me explain about tables in MS-Excel, once you've entered information into your worksheet, you may want to format your data as a table. Just like regular formatting, tables can improve the look and feel of your workbook, and they'll also help you organize your content and make your data easier to use. Excel includes several tools and predefined table styles, allowing you to create tables quickly and easily.

MS-Excel provides numerous predefined table styles that you can use to format a table. If the predefined table styles don't meet your needs, you can create and apply a custom table style. Although you can delete only custom table styles, you can remove any predefined table style so that it is no longer applied to a table.

You can further adjust the table formatting by choosing Quick Styles options for table elements, such as Header and Total Rows, First and Last Columns, Banded Rows and Columns, as well as Auto Filtering.

When you have a data range that is not formatted as a table, Excel will automatically convert it to a table when you select a table style. You can also change the format for an existing table by selecting a different format.

How to Create a Pivot Table with dropdown buttons to selected columns and filter the students record in the data Worksheet into a conditional “Ex: in English =>50”?
Select your records table =>
Select Home Menu =>
Click Format as Table Tool =>
Click a Table style that you like =>
Select My Table has Header check box =>
Click OK =>
Click on dropdown button on the English field =>
Select Number Filters =>
Click Greater Than or Equal To =>
Type “50” in the first blank box in English section =>
Click OK.

For more understanding, look at the screenshot please:

Picture

Insert:
While you are working in Worksheet, may need to insert a new row or a column in between the data that you have already entered in, so, you can insert rows above a selected row and columns to the left of a selected column. Similarly, you can insert blank cells above or to the left of the active cell on a worksheet. Cell references automatically adjust to match the location of the shifted cells.

How to insert a new row in between row number 9 and 10?
Keep Cursor point in a cell in the row 10 =>
Select Home Menu =>
Click Insert Tool =>
Click Insert Sheet Rows.

For more understanding, look at the screenshot please:

Picture

Delete:
Once you entered data into the Worksheet, may be needed to delete some of the specific columns or rows without deleting all the data and that’s so simple to do, if you follow up this tutorial will be guided you to do in easy ways.

How to delete selected rows?
Select the rows that you want to delete =>
Select Home Menu =>
Click Delete Tool =>
Click Delete Rows.

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