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
Business communication fundamentals
Professional writing and presentations
Verbal, nonverbal, and persuasive communication
Crisis, negative news, and intercultural communication
Module 2: Computer Fundamentals
Computer hardware and operating systems
Software and network basics
Technical terminology and troubleshooting
Module 3: Keyboarding and Typing
Keyboarding techniques and accuracy
Special characters and formatting
Typing speed, alignment, and calculations
Module 4: Microsoft Office 365
Office 365 overview
Word, Excel, PowerPoint, and Outlook fundamentals
Module 5: Excel – Formulas and Cell References
Formula creation and usage
Relative and absolute cell references
Intermediate Excel functions
Module 6: Excel – Formulas and Formatting
Data formatting techniques
AutoSum and essential functions
Formula application and efficiency
Module 7: Excel – Macros and Advanced Functions
Macros and automation basics
Lookup and advanced Excel functions
Hide Syllabus