Language: English
Short Description: This multimedia-rich course is designed for administration professionals to enhance their skills and acquire command over Microsoft Office 2019. It will allow them to leverage their cutting-edge skills in the job market and increase their worth.
This course offers training in useful tools and powerful strategies to help you deal with your job responsibilities more efficiently.
This course contains two modules:
• Administrative Assistant
• Microsoft Office 365 Training Bundle Suite 2019
This course covers the following applications of Microsoft office 2019:
• Microsoft Word 2019
• Microsoft Excel 2019
• Microsoft PowerPoint 2019
• Microsoft Outlook 2019
• Microsoft Access 2019
• Microsoft Publisher 2019
After completing this course, you’ll be able to:
? Type quickly and effectively
? Identify the steps to complete general office procedures
? Comprehend the basics of working within Microsoft® Office
? Identify the steps for creating business documents using professional language
? Identify the basic requirements for bookkeeping and accounting in the office
? Recall ways to create, edit, and print documents in Word
? Recognize how to create and manage worksheets in Excel
? Identify the steps to develop presentations in PowerPoint
? List how to create and manage databases in Access
? Identify the steps to manage email and calendars in Outlook
Instructor Description: This class is supported by an Educational Mentor. Educational mentors have worked or are working in the subject they mentor. Educational Mentors review student work, student progress, and interact with students as needed. They respond to any questions or concerns you might have, as well as encouraging and motivating you to succeed.
Certification: Upon successful completion of our Administrative Assistant course, students will be prepared to sit for the NCCB national certification exam to become a Certified Administrative Assistant (CAA). Upon successful completion of our Microsoft® Office 2019 course, students will be prepared to sit for the Microsoft Office 2019 exams. Each state may have additional licensing requirements, be sure to research your states requirements for employment by visiting your states occupation board.
Requirements
All required reference materials are provided with this program. NOTE: This course does NOT include the MS Office programs themselves.
Technical requirements:
Internet Connection
• Broadband or High-Speed (DSL, Cable, Wireless)
Hardware Requirements
• Processor - 2GHz Processor or Higher
• Memory - 1 GB RAM Minimum Recommended
Software Requirements
• Operating Systems - Windows 7, 8 or 10; Mac OS x 10 or higher
• Internet Browsers - Google Chrome is highly recommended
• Cookies MUST be enabled
• Pop-ups MUST be allowed (Pop-up Blocker disabled)
Hide Syllabus
Lesson 1
Module 1: Business Communication and Writing
• Effective Business Communication & Understanding your Audience
• Effective Business Writing
• Business Writing and Presentations
• Verbal and Nonverbal Deliveries
• Presentation to Inform and Persuade
• Business Presentations and Types of Communication
• Negative News and Crisis Communication
• Intercultural and International Business Communication
Module 2: Computer Fundamentals
• Computer Equipment
• Operating System Fundamentals
• Computer and Network Terminology
• Working with Software and the OS
• Troubleshooting
Module 3: Keyboarding and Typing
• Basic Keyboard Positions
• Special Characters, Correcting, and Improving Yourself
• Alignment and Calculations
• Putting the Strokes Together
Module 4: Microsoft Office 365
• Office 365
• Word
• Excel
• PowerPoint
• Outlook
Module 5: Excel - Formulas and Cell References
• Using Formulas
• Using Cell References
• Intermediate Formulas
Module 6: Excel: Formulas and Formatting
• Formatting Data
• AutoSum Functions
• Using Formulas
Module 7: Excel: Macros and More
• Macros
• Lookup Functions
Hide Syllabus