Description
&nbsp;
🟦 MS Word &ndash; Main Topics
Introduction to MS Word Interface
Creating, Saving &amp; Opening Documents
Typing, Editing, Copy, Cut, Paste, Undo, Redo
Font Formatting (Bold, Italic, Underline, Color, Size, etc.)
Paragraph Formatting (Alignment, Line Spacing, Indentation)
Bullets and Numbering
Page Setup (Margins, Orientation, Paper Size)
Headers, Footers, and Page Numbering
Insert Tab:
Pictures, Shapes, Icons, WordArt, Tables, Charts, Symbols
Table Creation and Formatting
Convert Text to Table &amp; Table to Text
Mail Merge (Letters, Labels, Envelopes)
Proofing Tools (Spelling, Grammar, Thesaurus)
Find and Replace
Watermark, Page Border, and Background
Shortcuts &amp; Customization
Printing and PDF Export
🟧 MS PowerPoint &ndash; Main Topics
Introduction to PowerPoint Interface
Creating &amp; Managing Slides
Slide Layouts and Design Themes
Adding Text, Images, Shapes, and Icons
SmartArt and Charts
Slide Master and Templates
Transitions and Animations
Adding Audio and Video
Hyperlinks and Action Buttons
Custom Slide Shows
Slide Timing and Rehearsal
Printing Handouts
Presenting Slide Show (F5, Presenter View)
Design Tips for Professional Presentations
🟩 MS Excel &ndash; Main Topics
Excel Interface and Navigation
Workbook, Worksheet, Row, Column, Cell
Data Entry and Editing
Formatting Cells (Number, Font, Borders, Color)
Formulas and Functions (SUM, AVERAGE, COUNT, MIN, MAX)
Cell Referencing (Relative, Absolute, Mixed)
Sorting and Filtering Data
Conditional Formatting
Charts and Graphs
Page Layout and Printing Options
Data Validation
Protecting Worksheets and Workbooks
Excel Shortcuts
🟨 Advanced Excel &ndash; Main Topics
Logical Functions: IF, AND, OR, IFERROR
Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
Text Functions: LEFT, RIGHT, MID, LEN, CONCATENATE, TEXTJOIN
Date &amp; Time Functions: TODAY, NOW, DATEDIF, NETWORKDAYS
Statistical Functions: COUNTIF, SUMIF, AVERAGEIF, SUMIFS
Data Analysis Tools:
Pivot Table &amp; Pivot Chart
Data Consolidation
What-If Analysis (Goal Seek, Scenario Manager)
Data Cleaning Techniques (TRIM, CLEAN, SUBSTITUTE)
Dashboard Creation Basics
Named Ranges and Dynamic Ranges
Conditional Formatting (Advanced Rules)
Power Query Introduction
Macro Recording and Basic VBA&nbsp;Introduction

Ms Office Course from Basic to Advanced

Accounts Advisor

All Courses

Ms Office Course from Basic to Advanced

MS Excel Advance LIVE Course (Basic to Advance)