M.

No-9911919231

SKILL TECH COMPUTER CENTRE

BASIC COMPUTER
COURSE
Microsoft Word+ Advance
Word
o Add images or illustrations to the
document.
o Insert links to websites or files.
o Add headers, footers, and pages
o Cut, Copy, and Paste text or object numbers.
o Change font style, size, and Color. o Insert shapes like arrows, circle,
o Apply bold, italics, underline, or and boxes.
strikethrough. o Insert watermarks for document
o Highlight text with different colors. branding.
o Align text (left, center, right, or justify). o Adjust page margins and
o Adjust line spacing and paragraph orientation.
spacing. o Zoom in and out to change
o Add bullets or numbered lists. document view.
o Create multi-level lists.
o Apply predefined styles for heading
and text.
o Search for specific text or words.
o Replace text throughout the
document.
o Insert and format tables for organizing
data.
 Microsoft Excel+ Advance
Excel
o Use auto fill for repetitive data entry.
o Perform basic statistical analysis
(COUNT, MAX, MIN)
o Format Cells for dates, currency, and
percentage.
o Create and Format spreadsheets easily. o Create hyperlinks to other sheets or
o Use basic formulas like SUM and files.
AVERAGE. o Use Comments for Collaboration and
o Apply filters to sort data Quickly. notes.
o Create various charts for data
visualization.
o Use Conditional formatting to highlight
trends.
o Merge cells for better layouts.
o Insert tables for structured data
management.
o Utilize VLOOKUP for searching data.
o Freeze panes to keep headers visible.
o Protect sheets from unauthorized edits.

o Sort data alphabetically or

numerically.
o Use the format Painter for
consistent formatting.
o Apply data validation rules for input
control.
o Create and manage named ranges
for Clarity.
o Use Keyboard Shortcuts for
efficiency.
 Advance Excel
o Use Pivot Tables for dynamic
summaries.
o Create Pivot Charts for Visualizing
Pivot Table data.
o Apply advanced formulas like INDEX
and Match.
o Create macros to automate
repetitive tasks.
o Use Power Query to transform data
from multiple sources.
o Analyze data with statistical functions
o Perform What-if-analysis with
(STDEV, VAR).
Scenario Manager.
o Create and use dynamic named ranges.
o Utilize Goal Seek for target Value
o Use Array formulas for complex
Calculations.
calculations.
o Use advanced conditional formatting
o Apply advanced charting techniques
with formulas.
(Combo Charts).
o Create dropdown lists using data
o Connect to external data sources
validation.
(databases, web).
o Implement sparklines for data
o Use the solver add-in for Optimization
validation.
problems.
o Track changes and comments for
collaboration.
o Create user forms for data entry.
o Utilize 3D references for multi-sheet
calculations.
o Use advanced filtering techniques
(criteria range).
 MS Power Point
▪ Add speaker notes for guidance
▪ Create a table of contents.
▪ Apply slide masters for
uniformity.
▪ Collaborate using shared editing

▪ Create and format slides easily.

▪ Use slide layouts for design
consistency.
▪ Add text boxes for content.
▪ Apply transitions between slides.
▪ Add animations for effects.
▪ Use themes for a unified look.
▪ Insert images, videos, and audio.
▪ Create charts for data visualization.
▪ Export slides as PDFs.
▪ Use Smart Art for diagrams.
▪ Use Presenter View for Control.
▪ Add hyperlinks for navigation.
▪ Insert tables for structured info.
▪ Add shapes for diagrams.
▪ Create custom Slideshows.
▪ Practice with rehearshal tools.
 ❖ Undo and redo actions for flexibility.
MS PAINT ❖ Print images directly from paint.
❖ Use the line tool for straight lines.
❖ Draw freehand with the brush tool.
❖ Insert images from other files.
❖ Use the spray can tool for texture.
❖ Create and save templates for reuse.
❖ Share images via email or social
media.

❖ Create and edit images easily.

❖ Use basic drawing tools (pencil, brush)
❖ Apply shapes like rectangle and
circles.
❖ Fill areas with color using the bucket
tool.
❖ Crop images to desired dimensions.
❖ Resize canvas to fit artwork.
❖ Use Zoom for detailed editing. CHAT GPT AI
❖ Save images in various formats (JPEG, ➢ Introduction to Chat GPT and it’
PNG) purpose.
❖ Use the color palette for custom ➢ How to access and use Chat GPT
colors. Effectively.
❖ Print images directly from paint. ➢ Tips for asking clear and concise
❖ Use the color palette for custom questions.
colors. ➢ Understanding Chat GPT’s Capabilities
and limitations
➢ Examples of practical uses in daily
tasks,