Computer Basics

Fast English Typing Practice

  • Increase typing speed with accuracy
  • Full version of typing master for best practice
  • Typing speed improvement
  • Preparation for typing exams
  • Fast key pressing
  • Fast text inputs
  • Correction in typing all types of data: letters, numbers, symbols, and many more

MS WORD

  • All Tabs Information: Home, Insert, Page Layout, References, Review, View
  • Document formatting
  • Styling
  • Word processing
  • Tables
  • Shapes
  • Header & Footer
  • Symbols
  • Themes
  • Page setups
  • Page backgrounds
  • Data proofing
  • Comments
  • Data protection
  • Data correction
  • Data arrangements
  • Macros
  • File conversion
  • Advanced Options: Watermark, Hyperlinks, etc
  • Advanced Options: Bibliography, Encryption etc
  • And Many More...

MS EXCEL

Home

  • Clipboard: Cut, Copy, Paste
  • Font: Style, Size, Border, Color
  • Alignment: Position, Merge, Wrap
  • Number: Cell, Format
  • Styles: Conditional Formatting, Table & Cell Style
  • Cells: Insert, Delete, Format
  • Editing: Auto Sum, Sort, Filter, Find, Select, Clear

Insert

  • Table: Pivot Table, Normal Table
  • Illustrations: Pictures, Clipart, Shapes, Smart Art
  • Charts: Column, Line, Pie, Bar, Area, Scatter, Others
  • Hyperlink: Within Sheet, Outside Sheet
  • Text: Text Box, Header, Footer, Word Art, Signature Line, Object, Symbols

Page Layout

  • Theme: Colors, Font, Effect
  • Page Setup: Margin, Orientation, Size, Print Area, Breaks, Background
  • Scale To Fit: Width, Height, Scale
  • Sheet Option: Gridlines, Headings
  • Arrange: Align, Rotate, Order

Formulas

  • Functions: Functional, Logic, Lookup Etc...
  • Define Name: Name Manager, Define Name
  • Formula Auditing: Show Formula, Evaluate, Error Checking
  • Calculations: Method – Automatic, Manual

Data

  • External Data: From Various Sources
  • Connections: Correction In Existing Data
  • Sort & Filter: A To Z, Z To A
  • Data Tools: Text To Columns, Data Validation
  • Outlines: Group, Ungroup

Review

  • Proofing: Spelling, Thesaurus
  • Comment: New, Previous, Next
  • Changes: Lock, Password, Securities

View

  • Workbook View: Normal, Full Screen
  • Show/Hide: Formula Bar, Headings, Gridlines
  • Zoom: 100%, Selection
  • Window: New, Arrange All, Freeze Panel, Split, Hide Book
  • Macros: View, Record

Advanced Excel

All Tabs information: Home, Insert, Page Layout, Formulas, Data, Review, View, Developer. Clipboard, Font, Alignment, Number, Styles, Cells, Editing, Tables, Illustration, Charts, Links, Text, Themes, Page Setup, Scale to Fit, Sheet options, Arrange, Function library, Defined names, Formula auditing, Calculation options, Get External Data, Connections, Sort and Filter, Data tools, Outline, Analysis, Proofing, Comments, Changes, Workbook Views, Show / Hide, Zoom, Windows etc
Advance Features like: Vlookup, Hlookup, Pivot Table, Data Validation,Charts, Macros, Conditional Formatting,Hyperlink, Filters, Password, Text to columns, Freeze Panel, ada-ons and many more