Advance Excel

Microsoft Excel

  • Create workbook & worksheets
  • Create a workbook
  • Import data from delimited text file
  • Copy & move a worksheet
  • Insert and remove hyperlink
  • 2. Format workbook & worksheets
  • Change worksheet color
  • Rename worksheet
  • Change work sheet order
  • Insert & delete columns or row
  • Changes workbook themes
  • Adjust row height & column width
  • Insert header and footer
  • 3. Customize option
  • Hide and unhide worksheet
  • Hide or unhide column & row
  • Customize the Quick access toolbar
  • Modify document properties
  • Display formulas
  • 4. Advanced conditional formatting
  • Custom conditional formatting rules
  • Conditional formatting rules and formulas
  • Manage conditional formatting rules
  • 5. Create table
  • Excel table from a cell range
  • Convert table cell range
  • Add or remove table row & column
  • Apply Styles to tables
  • Configure table style option
  • Insert total row
  • 6. Filter & sort a table
  • Filter record
  • Sort data by multiple column
  • Change sort order
  • Remove duplicate records
  • 7. Summarize Data Functions
  • Insert references
  • Calculation by SUM function
  • Calculation by MIN & MAX
  • Perform by COUNT functio
  • Perform by AVERAGE function
  • 8. Format & Modify Text function
  • Text by using RIGHT, LEFT & MID
  • Text by using UPPER, LOWER & PROPER function
  • Text by using CONVATENATE
  • 9. Create chart & Objects
  • Create new chart
  • Add additional data series
  • Analyze data by using Quick analysis
  • Resize chats
  • Add & modify chart elements
  • Apply chart layout & styles
  • Move charts to a chart sheet
  • Insert text boxes & shapes
  • Insert images
  • 10.Manage workbook option & setting
  • Save workbook template
  • Protect a worksheet
  • Configure formula calculation option
  • Some mathematics operation
  • 11.Create a document
  • Other Formulas
  • Mark sheet
  • Salary sheet
  • Data entry
  • Data formats
  • 12. Some Useful Shortcuts
  • 2. M.S Paint
  • Starting System
  • Show / Hide tools, color box, Status Bar
  • Saving your work
  • Open the stored file
  • Get new document
  • Importing exiting images
  • Flip or rotate
  • Edit color
  • Print
  • 3. WordPad
  • Start WordPad
  • Show/hide toolbar, format bar, Ruler, Status Bar
  • Save the Document first time
  • Methods for selecting the text
  • Deleting Required Text
  • Save Your Work
  • Close & Exit From WordPad
  • Open the stored file
  • Get new Document
  • Changing font size & font color
  • Change the text appearance / style
  • Undo / redo
  • Alignment
  • Methods
  • Replacing text
  • Cut / copy & paste
  • Print document
  • Some use full Shortcuts
  • Methods of typing Skills
  • 4. Notepad
  • Hindi typing Word With Shift
  • अ से ज्ञ तक
  • Alt key code chart
  • excise
  • Microsoft Office1. Create a blank document
  • Page layout
  • Page background
  • Insert header & footers
  • Insert page number
  • 2. Customize option & view Document
  • Change document view
  • View by using zoom setting
  • Customize the Quick Access toolbar
  • Add document properties
  • Show & hide formatting symbols
  • 3. Insert Text & paragraphs
  • Find & replace text
  • Cut, copy & paste text
  • Replace text by autocorrect
  • Insert characters spacing
  • 4. Format text and paragraphs
  • Apply font formatting
  • Apply formatting by format painter
  • Set line and paragraph spacing and indentation
  • Clear formatting
  • Text highlight color to text selection
  • Apply built – in styles to text
  • Change text to word Art
  • 5. Create table
  • Convert text to table
  • Table by specifying row & columns
  • Apply table style
  • 6. Modify table
  • Sort table data
  • Configure cell margins and spacing
  • Merge and split cells
  • Resize tables, rows and columns
  • Split tables
  • Configure a repeating row header
  • 7. Insert graphics elements
  • Insert shapes
  • Insert picture
  • Insert text box
  • 8. Format graphic elements
  • Apply effects
  • Apply picture effects
  • Remove picture backgrounds
  • Apply picture style
  • Wrap text around object
  • Position objects
  • 9. Insert & format Smart Art Graphics
  • Create smart art graphic
  • Format smart art graphic
  • Modify smart art graphic content
  • 10. Manage Document Changes
  • Track changes
  • Manage Tracked Changes
  • Lock or unlock tracking
  • Add Comment
  • Manage Comment
  • 11.Create format
  • Resume
  • Curriculum VITAE
  • Pumplates
  • 12. Create advanced reference
  • Mark index entries
  • Create indexes
  • Update indexes
  • Customize table contents
  • Insert and modify caption
  • 13. Some use full Shortcuts