Dear all, We are excited to announce a comprehensive Microsoft Word and Excel course tailored for visually impaired individuals, brought to you by VisionAccess. Excel and Word are powerful tools widely used in education, professions, and everyday tasks. Mastering in these area can significantly enhance your productivity and analytical capabilities.
Course Details: Duration: 2 Months Fee: Rs 2000 Platform: Online Zoom Meetings Timings: Monday to Friday, 7:30 PM to 8:30 PM Course Highlights: Microsoft Excel: 1. File Management: Opening, saving, and managing Excel files. 2. Basic Functions and Formulas: SUM, AVERAGE, COUNT, IF statements. 3. Conditional Formatting: Highlighting cells based on criteria. 4. Data Validation: Creating drop-down lists and restricting input. 5. Sorting and Filtering: Organizing and filtering data efficiently. 6. Lookup Functions: VLOOKUP, HLOOKUP, and XLOOKUP for data retrieval. 7. Pivot Tables: Summarizing and analysing large datasets. 8. Concatenation: Combining text from different cells. 9. Subtotal Feature: Creating subtotals in data tables. 10. Goal Seek: Finding input values to achieve a desired result. 11. Scenario Manager: Comparing different data scenarios in a worksheet. 12. What-If Analysis: Using Goal Seek. 13. Macros: Recording and running macros to automate tasks. 14. Pivot Charts: Visualizing data from pivot tables. 15. Conditional Statements: Using nested IFs, AND, OR, and NOT functions. 16. Data Security: Protecting worksheets, cells, and entire workbooks. 17. Text Functions: LEFT, RIGHT, MID, TRIM, and TEXT for text manipulation. 18. Data Import/Export: Importing data from external sources like CSV or databases. Microsoft Word: 1. JAWS Navigation in Word: Navigating headings, lists, and links. 2. Basic Formatting: Applying character/paragraph styles and formatting. 3. Managing Tables: Creating, navigating, and formatting tables. 4. Find and Replace: Searching for text/formatting and replacing efficiently. 5. Track Changes and Comments: Reviewing edits and adding comments. 6. Footnotes and Endnotes: Inserting and navigating them using JAWS. 7. Hyperlinks and Bookmarks: Creating and managing links/bookmarks. 8. Mail Merge: Creating letters, labels, and envelopes using mail merge. 9. Table of Contents: Inserting and updating a Table of Contents. 10. Document Collaboration: Using track changes, comments, and sharing. 11. Advanced Navigation: Using the Navigation Pane and section breaks. 12. Advanced Styles: Customizing and applying document-wide styles. 13. Citations and Bibliography: Managing references and creating bibliographies. 14. Macros: Recording and using macros for automation. 15. Forms in Word: Creating and navigating fillable forms. 16. Advanced Tables: Modifying table structure and converting text to tables. 17. Recovering Documents: Recovering unsaved files and using AutoRecover. 18. Password Protection: Protecting documents and setting permissions. 19. Headers, Footers, and Sections: Creating different layouts and numbering. 20. Complex Objects: Managing graphics, charts, and SmartArt. 21. Microsoft Forms: Creating and filling out forms with JAWS. 22. JAWS Formatting Feedback: Verifying styles and formatting with JAWS. 23. Customizing Shortcuts: Assigning keyboard shortcuts for efficiency. 24. Speech and Sound Schemes: Adjusting JAWS settings for better Word navigation. 25. Checking Document Accessibility: Ensuring accessible document structure. Registration Details: Last Date to Register: 5th, November, 2024 Course Starts: 5th November, 2024, Monday Eligibility Requirements: Good internet connection Own desktop/laptop To register for this course and secure your spot, please fill out the registration form given below: https://forms.gle/gsvu3Q5VMm1kzUKC8 For any queries or further assistance, feel free to contact us at: Mobile: 7021030307 Email: [email protected] We look forward to embarking on this learning journey with you and equipping you with valuable Excel skills! Warm regards, VisionAccess Organization -- regards, Mukesh Jain [image: JAWS Certified, 2022] <http://www.freedomscientific.com/Training/Certification> [image: NVDA Certified Expert] <https://certification.nvaccess.org/> -- Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Search for old postings at: http://www.mail-archive.com/[email protected]/ --- You received this message because you are subscribed to the Google Groups "AccessIndia" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CALnxaCnHkZroieRO_hXtqPSLm1TEi9Y-gNTMbLNDcYkqJQUg_g%40mail.gmail.com.
