Ultimate MS Office with AI – Excel, Word, PowerPoint | සිංහල මාධ්‍යය

artificial intelligent රජ කරන ලෝකයේ ඔබේ MS office package පිළිබඳ හැකියාව අත්‍යවශ්‍ය සාධකයක් බවට පත් වී හමාරය.

එබැවින් පාසලේ දී විශ්වවිද්‍යාලයේදී රැකියා ස්ථානයේදී එදිනෙදා ජීවිතයේදී ඔබට මුහුණ දීමට සිදුවන අපහසුතාවයන් බොහොමයක් ඇති.
එනිසා ඔබ විවිධ ක්‍රම ඔස්සේ අත්හදා බැලීම් ද සිදුකරන්නට ඇති.නමුත් ඒ කිසිදු ක්‍රමයක මුල සිට සරලව ඔබව මෙහෙයවන Road map එකක් නොමැති බවද අප දනිමු

එම අඩුව පුරවනු වස් අප විසින් සකස් කළ පාඨමාලාවේ පහත Learning point අඩංගු වෙයි.

ඊට අමතරව AI for office package,Money earning tips,Internet pluggings,Sinhala typing පිලිබදවද අප බොහෝ කරුනු ඇතුලත් ලකර ඇත.

Microsoft Word

Beginner Level:

1. Introduction to Microsoft Word
2. Getting Started: Interface Overview
3. Creating and Saving Documents
4. Formatting Text: Fonts, Sizes, Styles
5. Paragraph Formatting: Alignment, Spacing
6. Working with Lists: Bullets and Numbering
7. Adding and Formatting Images
8. Inserting Headers and Footers
9. Spell Check and Grammar Check
10. Printing Documents

Intermediate Level:

1. Tables and Borders
2. Working with Templates
3. Using Styles for Consistency
4. Track Changes and Comments
5. Mail Merge: Creating Form Letters
6. Creating and Formatting Tables of Contents
7. Advanced Page Layout: Sections, Columns
8. Inserting Hyperlinks
9. Managing Long Documents: Navigation, Indexes
10. Collaboration Tools: Sharing and Reviewing Documents

Advanced Level:

1. Advanced Formatting Techniques: Themes, Styles
2. Macros and Automation
3. Customizing Word: Options and Add-Ins
4. Mastering Document Security: Permissions, Passwords
5. Document Automation with Fields
6. Advanced Mail Merge: Labels, Envelopes
7. Cross-Referencing and Citations
8. Accessibility Features
9. Version Control and Document Comparison
10. Advanced Printing Options

Microsoft PowerPoint

Beginner Level:

1. Introduction to Microsoft PowerPoint
2. Understanding PowerPoint Interface
3. Creating New Presentations
4. Adding and Formatting Slides
5. Inserting Text and Images
6. Working with Shapes and SmartArt
7. Applying Themes and Backgrounds
8. Adding Transitions between Slides
9. Basic Animation Effects
10. Saving and Printing Presentations

Intermediate Level:

1. Customizing Slide Masters
2. Using Slide Layouts Effectively
3. Inserting Charts and Graphs
4. Incorporating Audio and Video
5. Creating Custom Animations
6. Adding Speaker Notes
7. Collaborating on Presentations
8. Using Presenter View
9. Rehearsing and Timing Presentations
10. Package for CD: Distributing Presentations

Advanced Level:

1. Advanced Animation Techniques
2. Working with Multimedia Embedding
3. Customizing PowerPoint Ribbon and Options
4. Creating Interactive Presentations
5. Mastering Slide Show Settings
6. Advanced Collaboration Tools
7. Integrating with Excel and Word
8. Macros and VBA in PowerPoint
9. Using PowerPoint for Web Presentations
10. Advanced Printing and Export Options

Microsoft Excel

Beginner Level:

1. Introduction to Microsoft Excel
2. Understanding Excel Interface
3. Creating Workbooks and Worksheets
4. Entering Data and Formulas
5. Formatting Cells: Number, Alignment
6. Working with Rows and Columns
7. Basic Functions: SUM, AVERAGE, MAX, MIN
8. Introduction to Charts: Bar, Pie, Line
9. Sorting and Filtering Data
10. Saving and Printing Workbooks

Intermediate Level:

1. Working with Functions: IF, VLOOKUP, COUNTIF, SUMIF
2. Conditional Formatting
3. Data Validation and Drop-Down Lists
4. Using Tables for Data Management
5. PivotTables: Creating and Customizing
6. Advanced Charting Techniques
7. Using Sparklines for Data Visualization
8. Data Analysis Tools: Goal Seek, Solver
9. Protecting Worksheets and Workbooks
10. Sharing and Collaboration Features

Sinhala typing and Artwork

Internet plugins and web application