Description
This course introduces the fundamental concepts of computers, including hardware, software, operating systems, file management, internet usage, email, and basic office applications like Word and Excel. Ideal for beginners, it builds essential digital skills for personal or professional use. No prior experience required.
Course Outline
- Navigation in Microsoft Word
- Create and Save Word Document
- Manage Your Workspace
- Edit Document
- Preview and Prints Documents
- Apply Text Formatting
- Control Paragraph Layout
- Align Text Using Tabs
- Display Text in Bulleted or Numbered format Lists
- Apply Borders, Shading & Sorting
- Make Repetitive Text
- Apply Repetitive Formatting
- Use Styles & Create heading Style
- A Sort a List
- Format a List
- A Insert a Table
- Modify a Table
- Format a Table
- Convert Text to a Table
- Insert Symbols, Special Characters & Smart Graphics
- Add Images to a Document
- Linking of files
- Apply a Page Border, Page Color & Watermark
- Add Headers & Footers
- Control Page Setup before print
- Check Spelling, Grammar, and Reading
- Use Research Tools
- Comments & Tracking
- Introduction of Excel
- Navigation in Microsoft Excel
- Create and Save Worksheet
- Manage Your Workspace
- Preview and Prints Worksheet
- Tab & Ribbons
- Apply Character Formatting
- Control Paragraph Layout
- Align Text Using Tabs
- Apply Borders and Shading
- Cut copy paste & Paste Special
- Skip Blanks, Add, Subtract, Divide, Multiply with paste special
- Moving finding & Replacing a Value
- Tab & Ribbons
- Cell Styles
- How to use Number Format
- Format Painter
- Formatting Dates
- Custom & Special Formats
- How to sort & filter Data
- Naming & Moving worksheet
- Copying worksheet
- Adding & Deleting Worksheet
- Hiding & Showing Worksheet
- Inserting & Deleting Row & Columns
- Insert & Delete Cells
- Inserting Multiple Row & Columns
- Modifying Cells Width & Height
- Hiding & Un hiding Row & Columns
- Highlight Cells & Rules
- Top & Bottom Rules
- Data Bars & Color Scales
- Custom Formatting Rules
- Insert a table and style option
- Add row and Column
- Apply Design & Layout in Table
- Add Shapes & Modify
- Add Pictures & Clip Art & Modify
- Add Smart Art
- Header & Footer
- Create Hyperlink in files
- Chart Style
- Chart Layout
- Add Level
- Axis Option
- Chart Title
- Legends
- Data Labels
- Create Pivot Table
- Create Pivot Chart
- Modifying Pivot Table
- Choosing Field
- Group & Ungroup
- Sort Data
- Filter Data
- Subtotal
- Using Operations with Mathematical Formula (Sum,Power,Int,Sqrt,Round,Mod,Abs)
- Using Operations with Statistical Formula (Count,Counta,Countblank,Countif,Countifs,Sumif,Sumifs,Max,Min,Average,Small,Large)
- Working of Text Function (Left,Right,Mid,Replace,Len,Exact,Concatenate,Trim,Upper,Lower,Proper)
- Working of Date & Time Function (Today,Now,Date,Day,Year,Month,Hour,Minute,Second)
- Working with Lookup Functions (Lookup,Vlookup,Hlookup)
- Working with Financial function for Loan (PV,PMT,NPER,RATE)
- Use of Logical Functions (IF,AND,OR,NOT)
- Workbook Views
- Show & Hide
- Zoom Features
- Freeze panes
- Split Window
- Viewing Multiple Windows
- Minimize The ribbons
- Worksheet with Background
- Data Validation
- Drop Down List
- Remove Duplicates
- Text To Columns
- Scenario Manager
- Goal Seek
- Introduction multiple sheets
- Consolidating data
- Trace Precedents & Dependent
- Using a watch window
- Making New Slide Show in Power point
- Add transition to Power point
- Text Animation in Power point
- Add Animation to the Power point
- Create Custom Animation
Computer Basic
3 Months OR 75 Hours
This course introduces the fundamental concepts of computers, including hardware, software, operating systems, file management, internet usage, email, and basic office applications like Word and Excel. Ideal for beginners, it builds essential digital skills for personal or professional use. No prior experience required.
Write your feedback
Your rating