Learn Computer Courses

Introduction to Microsoft Word

Understanding the Word interface: Ribbon, Quick Access Toolbar, Backstage view, File tab.

Creating and saving documents.
Opening and navigating documents.
Using the Tell Me feature to find commands.

Module 2: Basic Text Formatting

Formatting characters: font, size, bold, italics, underline, color, highlighting.

Copying and pasting text.
Using the Format Painter.
Clearing formatting.

Module 3:Paragraph Formatting

Alignment: left, center, right, justify.

Line spacing and paragraph spacing.
Indenting paragraphs.
Applying bullets and numbering.

Module 4:Document Formatting

Page layout: margins, orientation (portrait vs. landscape), paper size.

Inserting page breaks and section breaks.
Headers and footers: adding, editing, different headers/footers for odd and even pages.

Module 5:Styles and Themes

Understanding styles: paragraph styles, character styles.

Applying and modifying styles.
Creating custom styles.
Using themes for consistent document formatting.

Module 6:Inserting and Formatting Objects

Inserting images and screenshots.

Positioning and resizing images.
Adding shapes, SmartArt, and icons.
Formatting objects: borders, shadows, 3D effects.

Module 7:Working with Tables

Creating tables.

Inserting and deleting rows and columns.
Merging and splitting cells.
Applying table styles and formatting.

Module 8:Advanced Text Formatting

Applying text effects: shadow, reflection, glow.

Using WordArt for stylized text.
Drop caps and special text effects.

Module 9:Advanced Document Formatting

Customizing page borders and shading.

Creating and modifying cover pages.
Creating and modifying headers and footers.
Working with footnotes and endnotes.

Module 10:Collaboration and Review

Tracking changes and accepting/rejecting edits.

Adding comments and annotations.
Comparing and combining documents.
Protecting documents with passwords and permissions.

Module 11:Mail Merge

Understanding mail merge.

Creating a data source (Excel spreadsheet, Access database).
Inserting merge fields in documents.
Running a mail merge and generating multiple personalized documents.

Module 12:Advanced Document Elements

Adding and formatting text boxes.

Inserting symbols and special characters.
Creating and formatting hyperlinks.
Inserting and formatting equations.

Module 13:Advanced Layout Techniques

Working with multiple columns.

Using drop caps and pull quotes.
Creating and formatting text boxes.
Using section breaks for varied layouts.

Module 14:Templates and Building Blocks

Understanding templates.

Creating and customizing templates.
Using building blocks for quick document creation.

Module 15:Automation with Macros

Introduction to macros.

Recording and running macros.
Editing and managing macros.

Module 16:Document Proofing and Accessibility

Running spelling and grammar checks.

Using the thesaurus and translation features.
Ensuring document accessibility with Alt Text and other features.

Introduction to Microsoft Excel

Understanding the Excel interface: Ribbon, Quick Access Toolbar, Backstage view, File tab.

Creating and saving workbooks.
Navigating worksheets and cells.
Using the Name Box and Formula Bar.

Module 2: Basic Data Entry and Formatting

Entering data into cells.

Formatting numbers and text.
Adjusting column width and row height.
Using AutoFill for quick data entry.

Module 3: Formulas and Functions

Understanding formulas and calculations.

Basic arithmetic operators.
Using built-in functions: SUM, AVERAGE, COUNT, MAX, MIN.
Writing formulas for simple calculations.

Module 4: Cell References and Functions

Understanding cell references: relative, absolute, mixed.

Using functions like IF, SUMIF, COUNTIF.

Module 5: Formatting and Styling

Formatting cells: font, size, bold, italics, underline, color.

Applying cell borders and shading.
Using Cell Styles and Themes.

Module 6: Data Visualization with Charts

Creating charts: column, line, pie, bar.

Formatting and customizing charts.
Adding chart titles, labels, and legends.

Module 7: Data Manipulation

Sorting data: single-column and multi-column sorting.

Filtering data using AutoFilter.
Using Data Validation to restrict input.

Module 8: Working with Tables

Creating Excel tables for structured data.

Sorting and filtering within tables.
Using table features for easier data management.

Module 9: Conditional Formatting

Applying conditional formatting rules.

Highlighting cells based on values.
Using icon sets and color scales.

Module 10: Data Analysis Tools

Using Goal Seek for reverse calculations.

Introduction to Data Tables for multiple calculations.
Creating and interpreting simple PivotTables.

Module 11: Advanced Functions

Using logical functions: IF, AND, OR.

Working with text functions: CONCATENATE, LEFT, RIGHT, LEN.
Using lookup functions: VLOOKUP and HLOOKUP.

Module 12: Advanced Charts and Sparklines

Creating advanced charts: scatter plots, combo charts.

Adding trendlines and data labels.
Using Sparklines for visualizing trends.

Module 13: Data Validation and Protection

Creating drop-down lists.

Setting data validation rules.
Protecting sheets and workbooks with passwords.

Module 14: Collaborative Tools

Tracking changes and comments.

Sharing workbooks and using co-authoring.
Protecting cells and sheets.

Module 15: What-If Analysis

Using Scenario Manager for multiple scenarios.

Goal Seek for finding input values to reach a goal.
Data Tables for sensitivity analysis.

Module 16: Power Query and Data Cleaning

Introduction to Power Query for data extraction.

Importing data from various sources.
Transforming and cleaning data.

Module 17: Advanced PivotTables and PivotCharts

Creating PivotTables from multiple data sources.

Grouping and summarizing data within PivotTables.
Creating PivotCharts and slicers.

Module 18: Macros and Automation

Introduction to macros and VBA.

Recording and running macros.
Editing and managing macros.

Module 19: Advanced Data Analysis

Using Advanced Filter for complex criteria.

Consolidating data from multiple sheets.
Using Subtotals for hierarchical analysis.

Introduction to Microsoft PowerPoint.

Understanding the PowerPoint interface: Ribbon, Quick Access Toolbar, Backstage view, File tab.

Creating and saving presentations.

Choosing slide layouts and themes.

Navigating slides and slide views.

Moddetailse 2: Basic Slide Creation

Adding new slides.

Inserting and editing text boxes.

Formatting text: font, size, bold, italics, underline, color.

Moddetailse 3: Slide Formatting and Themes

Applying themes to maintain consistent design.

Customizing slide backgrounds.

Using Slide Master for global design changes.

Moddetailse 4: Adding Visual Elements

Inserting images and screenshots.

Formatting images: resizing, cropping, rotating.

Adding and editing shapes and icons.

Moddetailse 5: Charts and Graphs

Creating charts to visualize data.

Formatting and customizing charts.

Adding data labels and titles.

Moddetailse 6: SmartArt Graphics

Using SmartArt for process diagrams, organization charts, etc.

Formatting and customizing SmartArt elements.

Adding and editing text within SmartArt.

Moddetailse 7: Transitions and Animations

Applying slide transitions for smooth movement.

Adding animation effects to text and objects.

Customizing animation timings.

Moddetailse 8: Mdetailstimedia Integration

Embedding audio and video clips.

Adjusting mdetailstimedia playback settings.

Adding narration to slides.

Moddetailse 9: Slide Master and Layouts

Customizing Slide Master for consistent branding.

Creating custom slide layouts.

Applying different layouts to slides.

Moddetailse 10: Slide Show Techniques

Running slide shows.

Using Presenter View for better control.

Setting up slide show timings.

Moddetailse 11: Hyperlinks and Action Buttons

Adding hyperlinks to slides and external content.

Creating action buttons for navigation.

Linking to websites, files, and other slides.

Moddetailse 12: Custom Shapes and Effects

Creating custom shapes with the drawing tools.

Applying shape formatting and effects.

Combining shapes and creating complex visuals.

Moddetailse 13: Advanced Chart Customization

Customizing chart elements: data labels, axes, legends.

Adding secondary axes to charts.

Creating combination charts.

Moddetailse 14: Advanced Animation Techniques

Using motion paths for complex animations.

Applying entrance and exit animations.

Using animation triggers for interactive presentations.

Moddetailse 15: Interactive Elements

Creating interactive quizzes with hyperlinks.

Using buttons and triggers for interactivity.

Creating clickable prototypes.

Moddetailse 16: Collaboration and Sharing

Collaborating on presentations with real-time co-authoring.

Sharing presentations through OneDrive and email.

Adding comments and tracking changes.

Moddetailse 17: Advanced Slide Show Features

Using custom slide shows for targeted presentations.

Using hidden slides for backup content.

Adding slide transitions and animations to enhance engagement.

Moddetailse 18: Accessibility and Compatibility

Ensuring presentations are accessible to all users.

Using the Accessibility Checker.

Saving presentations in different formats for compatibility.

Moddetailse 19: Macros and Automation

Introduction to macros and VBA in PowerPoint.

Recording and running macros.

Editing and managing macros.

Module 1

Module 2

Module 1

Module 2

HSCIT

Windows

Introduction to Mircosoft word

Understanding the Word interface: Ribbon, Quick Access Toolbar, Backstage view, File tab.

Formatting characters: font, size, bold, italics, underline, color, highlighting.

Alignment: left, center, right, justify.

Page layout: margins, orientation (portrait vs. landscape), paper size.

Understanding styles: paragraph styles, character styles.

Inserting images and screenshots.

Creating tables.

Applying text effects: shadow, reflection, glow.

Customizing page borders and shading.

Tracking changes and accepting/rejecting edits.

Understanding mail merge.

Adding and formatting text boxes.

Working with multiple columns.

Understanding templates.

Introduction to macros.

Running spelling and grammar checks.

Introduction to Microsoft Excel

Understanding the Excel interface: Ribbon, Quick Access Toolbar, Backstage view, File tab.

Entering data into cells.

Understanding formulas and calculations.

Understanding cell references: relative, absolute, mixed.

Formatting cells: font, size, bold, italics, underline, color.

Creating charts: column, line, pie, bar.

Sorting data: single-column and multi-column sorting.

Creating Excel tables for structured data.

Applying conditional formatting rules.

Using Goal Seek for reverse calculations.

Using logical functions: IF, AND, OR.

Creating advanced charts: scatter plots, combo charts.

Creating drop-down lists.

Tracking changes and comments.

Using Scenario Manager for multiple scenarios.

Introduction to Power Query for data extraction.

Creating PivotTables from multiple data sources.

Introduction to macros and VBA.

Using Advanced Filter for complex criteria.

Introduction to Microsoft PowerPoint

Understanding the PowerPoint interface: Ribbon, Quick Access Toolbar, Backstage view, File tab.

Adding new slides.

Applying themes to maintain consistent design.

Inserting images and screenshots.

Creating charts to visualize data.

Using SmartArt for process diagrams, organization charts, etc.

Applying slide transitions for smooth movement.

Embedding audio and video clips.

Customizing Slide Master for consistent branding.

Running slide shows.

Adding hyperlinks to slides and external content.

Creating custom shapes with the drawing tools.

Customizing chart elements: data labels, axes, legends.

Using motion paths for complex animations.

Creating interactive quizzes with hyperlinks.

Collaborating on presentations with real-time co-authoring.

Using custom slide shows for targeted presentations.

Ensuring presentations are accessible to all users.

Introduction to macros and VBA in PowerPoint.

Introduction of Typing

Introduction of Internet

Introduction of Resume Making

Introduction of Emails

Discussion

₹4500

This course includes

HKCL Authorized Govt. Learning Center

Contact for addmission