Mastering Microsoft Office Suite
Course Description
In this comprehensive MS Office course, you will learn everything you need to know about MS Office, with a focus on MS Office Accounting. We'll start with a 30-day free trial of the software and guide you through step-by-step instructions on how to navigate and set up MS Office. You will experience every common transaction type and learn how to manage and customize reports, fix data entry errors, and review all entries in your MS Office account.
What You Will Learn
- MS Office Accounting: Master the key features of MS Office Accounting, including customer invoices, sales receipts, payments, and supplier accounts.
- Data Entry & Error Fixing: Learn to enter transactions accurately and how to find and fix errors in your data.
- Report Management: Customize and manage important reports in MS Office.
- MS Office Tips & Tricks: Gain practical tips to enhance your MS Office proficiency.
- Excel 2013 (Beginner/Intermediate): Create basic spreadsheets and use formulas for expense tracking.
- Excel 2013 (Advanced): Use complex formulas and perform data analysis on revenue and expense models.
- Word 2013: Create professional documents, embed videos, and collaborate online.
- Outlook 2013: Manage your inbox efficiently and avoid missing important emails.
- PowerPoint 2013: Create polished presentations with animation, audio/video, and collaboration tools.
- Office Productivity: Increase your office productivity by mastering Microsoft Office tools.
Who This Course Is For
- Individuals new to Microsoft Office who want to gain expertise.
- Office workers looking to enhance their skills and efficiency using the latest version of Microsoft Office.
- Anyone interested in mastering MS Office 2013 to make their office work more efficient and productive.
- Batch Duration:2 to 4 Months
- Who can Join:Only Pakistan Residents
- Certificate Eligibility:Pass Final Exam
- Video Medium:Urdu & English
What you will learn
- Microsoft Office Basics: Master the essentials of Excel, Word, PowerPoint, and Outlook.
- Excel Productivity: Use Autofill and Flash Fill to work more efficiently.
- Charts and Graphs in Excel: Learn to create stunning visual data representations.
- PowerPoint 2019 Features: Explore new features, including icons and 3D models.
- Enhanced PowerPoint Presentations: Add charts, graphs, and tables in non-text formats.
- Presentation Tips: Practical advice for delivering effective PowerPoint presentations.
- Word Mastery: Master the most commonly used applications in Microsoft Word.
- Mail Merge in Word: Learn how to create and execute mail merges.
- Document Protection: Protect your Word documents from unauthorized changes.
- Tables in Word: Insert and edit tables to enhance your documents.
- Excel Data Backup: Learn practical methods to back up and restore spreadsheets without data loss.
- Formulas and Functions in Excel: Understand the basics of using formulas and functions.
- Data Sorting and Filtering in Excel: Efficiently sort and filter data in Excel.
- PowerPoint Design Elements: Insert shapes, graphics, and pictures to enhance your slides.
- PowerPoint Media: Keep your audience engaged by adding animation, audio, and video.
- Time-Saving Techniques in PowerPoint: Copy slides and export presentations quickly.
- Advanced Word Tools: Use columns, indentations, footers, frames, and watermarks effectively.
- Printing in Word: Learn to print envelopes and labels correctly.
- Enhancing Word Documents: Add professional photos and graphics to your Word documents.