Master the essential tools used in workplaces around the world
Our MS Office course is designed to make you proficient in Microsoft Word, Excel, PowerPoint
Ms Word Course Content
Basics of computer :
- About Computer H/W & S/W
- Creating of Folder,Files
- Different fileformats
- About Browsers
- About Notepad,MS-Dos,Paint
- About Calculator,Word pad
Microsoft Word :
- Introduction to Ms – Word
- File Opening ,Saving, Closing
- Print, Page Setups, page Layouts
- Page Numbers, Date & Time
- Drawing the Pictures ,Shapes
- Bullets & Numbering, Hyperlinks
- Borders & Shading, Themes
- Borders & Shadings, BG colors
- Mail Merge, Envelops & Labels
- Creating Tables
- Creating of ressumes
Advanced Excel Course Content
Microsoft Excel :
- Introduction to Excel Sheets
- Functional Formula
- Create Macros, Validation
- Create Payrolls, Tables
- Create Accounts Using Formula
- Graphs , Charts
Advanced Excel :
- V Look up, H Look Up
- Sum If, Count If functions
- Index & Match Functions
- Pivot Tables Charts
- Filters. Adv Filters
- Paste Links
- Paste Special
- Import Tables Excel To Word
- Custom List, Data Functions
- Logical Functions Name Define
- Data Functions
- text Functions
- Conditional Formatting
- Sub Total Functions
- Goal seek, pmt Functions
- Protect Book & Sheet
- Scenarios, number series
- Sheet Breaks
- formula Auditing
- Hide And Unhide Sheets, Object
- Columns And Rows, Print Titles
- Smart Art, watch windows
Ms Power Point Course Content
Microsoft Power Point :
- Introduction to Ms-power point
- Create Designing Slides
- Create Custom Animations
- Sound effects & BG Design
- Create Timing Presentation
- Slide Shows Presentation
- Creating of business power point with brief explanation
MS Word
1. Document formatting and styles
2. Working with templates and themes
3. Creating tables, columns, and lists
4. Inserting images, hyperlinks, headers, and footers
5. Mail merge for mass communication
Microsoft PowerPoint
1. Slide creation and layout design
2. Using themes, templates, and slide masters
3. Animations and slide transitions
4. Adding charts, SmartArt, and multimedia
5. Building impactful business presentations
Microsoft Excel (Basic to Advanced)
1. Basic formulas and functions
2. Creating and formatting spreadsheets
3. Charts, graphs, and data visualization
4. Pivot tables and data summarization
5. Conditional formatting and data validation
6. Lookup functions: VLOOKUP, HLOOKUP, INDEX-MATCH
7. Advanced formulas: IF, IFS, TEXT, DATE, COUNTIFS, SUMIFS
8. What-If Analysis: Goal Seek, Scenario Manager
9. Power Query basics for data transformation
10. Macros (Intro) for automating repetitive tasks
11. Creating interactive dashboards and reports
