Ⓝ𝗦𝘁𝗿𝗮𝘁𝗲𝗴𝘆 is offering Ms. Office Training Complete Course for young professionals who are seeking a job in the Office administration sector or want to join a professional organization. Microsoft Office Knowledge is essential across a large number of industries. You’ll learn exceptional skills that will benefit you in your professional life and also make your CV stand out from the rest.
Increase your confidence, skill, and chances of employability with the MS Office Course. Since Microsoft Office is a vital software for every industry with high demand for talented professionals, it will serve to objectively verify your IT skills and help you advance in your chosen career.
This course has four modules:
- MICROSOFT WORD
- MICROSOFT EXCEL
- MICROSOFT POWERPOINT
- MICROSOFT ACCESS
Module 1- Microsoft Word
- Formatting Content
- Create custom styles for text, tables, and lists
- Control pagination
- Format, position and resize graphics using advanced layout features
- Insert and modify objects
- Create and modify diagrams and charts using data from other sources
- Organizing Content
- Sort content in lists and tables
- Perform calculations in tables
- Modify table formats
- Summarize document content using automated tools
- Use automated tools for document navigation
- Merge letters with other data sources
- Merge labels with other data sources
- Structure documents using XML
- Formatting Data and Content
- Create and modify custom data formats
- Use conditional formatting
- Format and resize graphics
- Format charts and diagrams
- Protect cells, worksheets, and workbooks
- Apply workbook security settings
- Import data into Excel
- Export data from Excel
- Publish and edit Web worksheets and workbooks
- Create and edit templates
Module 2- Microsoft Excel
- Organizing and Analyzing Data
- Use subtotals
- Define and apply advanced filters
- Group and outline data
- Use data validation
- Create and modify list ranges
- Add, show, close, edit, merge and summarize scenarios
- Perform data analysis using automated tools
- Create PivotTable and PivotChart reports
- Use Lookup and Reference functions
- Use Database functions
- Trace formula precedents, dependents, and errors
Module 3- PowerPoint
- Creating Content
- Create new presentations from templates
- Insert and edit text-based content
- Insert tables, charts and diagrams
- Insert pictures, shapes and graphics
- Insert objects
- Formatting Content
- Format text-based content
- Format pictures, shapes and graphics
- Format slides
- Apply animation schemes
- Apply slide transitions
- Customize slide templates
- Track, accept and reject changes in a presentation
- Add, edit and delete comments in a presentation
- Compare and merge presentations
- Managing and Delivering Presentations
- Organize a presentation
Module 4- Microsoft Access
- Structuring Databases
- Create Access databases
- Create and modify tables
- Define and modify field types
- Modify field properties
- Create and modify one-to-many relationships
- Create and modify queries
- Create forms
- Add and modify form controls and properties
- Create reports
- Add and modify report control properties
- Entering Data
- Enter, edit and delete records
- Find and move among records
- Import data to Access
- Create and modify calculated fields and aggregate functions
- Modify form layout
- Modify report layout and page setup
- Export data from Access
- Backup a database
- Compact and repair databases
Key Features
- Step-by-Step complete Learning process of MS Office Course.
- From beginners to professionals. It caters to the needs of everyone.
- The Design of these applications considering the practical application.
- The knowledge gained during the course will help you enhance your job prospects.
- This Course is fully designed as per the need of day-to-day office workers.
- Learn all tips and tricks of Ms. Excel, Word, PowerPoint and Access in just One course
- State of the art classrooms, qualified teachers to ensure your career success