Business and Professional Microsoft Office 365-Training Bundle Suite 2019 135 Hours 3 Months Beginner English Overview Syllabus Objectives Requirement Certification Features If you’re looking for a way to get up to speed quickly on the newest version of Microsoft Office, this course offers step-by-step instructions to make it easy. Office 2019 has new features and tools to master, and whether you’re upgrading from an earlier version or encountering the Office applications for the first time, you’ll appreciate this simplified approach. This course covers: Microsoft Word 2019 Microsoft Excel 2019 Microsoft PowerPoint 2019 Microsoft Outlook 2019 Microsoft Access 2019 Microsoft Publisher 2019 Microsoft Office holds more than 90 percent of the market for Windows-based productivity suites. Our MS Office 2019 course makes this technology easy to understand, even for those who are new to computers. NOTE: This course does NOT include the MS Office programs themselves. Students will need to have Office 2019 already installed on their computers. Module 1: Office 365 Lesson 1: Common Office Tasks • All About Office 365 • Office Interface • Saving Your Files • Manipulating the Text • Handling Case or Capitalization • Entering Symbols and Foreign Characters • Undoing and Repeating Commands • Correcting Typos • AutoCorrect Command Lesson 2: One Step Beyond • Customizing the Ribbon • Customizing the Quick Access Toolbar • Ways of Distributing Your Work • Working with Publisher • Printing a Publication • Filing Sharing and Collaborating • OneDrive • Sharing Files and Folders with Other Lesson 3: Working with Charts and Graphs • Creating a Chart • Saving a Chart as a Template • Chart Tricks • SmartArt Diagram • Handling Graphics and Photos • Touching Up a Picture • Drawing and Manipulating Lines, Shapes and Objects • WordArt Lesson 4: Working with Publisher • Introducing Frames • Creating a Publication • Redesigning a Publication • Formatting Text • Text Wraps • Placeholder Pictures • Frames • Decorating the Text • Design Checker Lesson 5: Working with Access • Tables and Queries • Forms • Creating a Database File • Designing a Database • Field Properties • Entering Data • Sorting • Querying • Filtering for Data Lesson 6: SharePoint for End Users • SharePoint Overview • Creating Your First Site • Adding Content to the Team Site Module 2: Word Lesson 1: Working with Word Part I • Getting Started with Word 2019 • Formatting Text and Paragraphs • Working More Efficiently • Managing Lists • Adding Tables • Inserting Graphic Objects • Controlling Page Appearance • Preparing to Publish a Document Lesson 2: Working with Word Part II • Organizing Content Using Tables and Charts • Customizing Formats Using Styles and Themes • Inserting Content Using Quick Parts • Using Templates to Automate Document Formatting • Controlling the Flow of a Document • Simplifying and Managing Long Documents • Using Mail Merge to Create Letters, Envelopes, and Labels Lesson 3: Working with Word Part III • Manipulating Images • Using Custom Graphic Elements • Collaborating on Documents • Adding Document References and Links • Securing a Document • Using Forms to Manage Content • Automating Repetitive Tasks with Macros Module 3: Excel Lesson 1: Working With Excel Part I • Getting Started with Microsoft Office Excel 2019 • Performing Calculations • Modifying a Worksheet • Formatting a Worksheet • Printing Workbooks • Managing Workbooks • Adding Borders and Colors to Worksheets • Basic Excel Customization Lesson 2: Working with Excel Part II • Working with Functions • Working with Lists • Analyzing Data • Visualizing Data with Charts • Using PivotTables and PivotCharts • Working with Graphical Objects • Using Array Formulas Lesson 3: Working with Excel Part III • Working with Multiple Worksheets and Workbooks • Sharing and Protecting Workbooks • Automating Workbook Functionality • Using Lookup Functions and Formula Auditing • Forecasting Data • Creating Sparklines and Mapping Data • Importing and Exporting Data • Internationalizing Workbooks • Working with Power Pivot • Advanced Customization Options • Working with Forms and Controls Module 4: PowerPoint Lesson 1: Working With PowerPoint Part I • Getting Started with PowerPoint 2019 • Developing a PowerPoint Presentation • Performing Advanced Text Editing Operations • Adding and Arranging Graphical Elements • Modifying Graphical Elements • Preparing to Deliver Your Presentation Lesson 2: Working with PowerPoint Part II • Customizing Design Templates • Using Ink to Hand Draw Elements • Adding Tables • Adding Charts • Working with Media • Building Advanced Transitions and Animations • Finalizing a Presentation • Customizing Presentation Navigation • Securing and Distributing a Presentation Module 5: Outlook Lesson 1: Working With Outlook Part I • Getting Started With Outlook 2019 • Formatting Messages • Working with Attachments and Illustrations • Customizing Message Options • Organizing Messages • Managing Your Contacts • Working with the Calendar • Working with Tasks and Notes Lesson 2: Working with Outlook Part II • Modifying Message Properties and Customizing Outlook • Organizing, Searching, and Managing Messages • Managing Your Mailbox • Automating Message Management • Working with Calendar Settings • Managing Contacts • Managing Activities Using Tasks • Sharing Outlook Items • Managing Outlook Data Files After completing this course, you should be able to: 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 Describe ways to create professional publications with Publisher All required reference materials are provided with this program. 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 • Microsoft Office 2007, 2010 or 2013 or a Word Processing application to save and open Microsoft Office formats (.doc, .docx, .xls, .xlsx, .ppt, .pptx) • Internet Browsers – Google Chrome is highly recommended • Cookies MUST be enabled • Pop-ups MUST be allowed (Pop-up Blocker disabled) • Adobe PDF Reader Relevancy – With annual reviews and enhancements, this program guarantees accurate and relevant curriculum that meets employer requirements for the knowledge and skills demanded to successfully enter the workforce. Career Readiness – Our Career Kit is designed to provide students with the practical tools they’ll need to help find a job once they have completed training and earned their certification. With our Career Kit, students are sure to impress! Using our practical templates and prompts, students can present their BEST self to future employers. Curriculum Format – We believe career training should be engaging and fun, not exhausting, and boring. To achieve this, we have developed our program with a mix of formats including reading material, video lectures, procedure videos, interactive activities and games, knowledge check ins, and section assessments. By incorporating a balanced mixture of interactivity, engagement, and comprehension testing, this program ensures a well-rounded experience for students that will not only fully prepare them to enter the workforce but also provide a fun, entertaining way to learn. With real-life procedure videos, students are provided a combination of comprehensive instructions, visual and auditory demonstrations, and hands-on practice exercises. 6 Reasons to Complete Your Training With Us Flexibility With our programs, you can learn and study at your own pace with access 24/7/365 for the duration of your program. This means you can learn on your own terms and work around your own schedule. Support Our online training comes with access to real, live support personnel that will help you through every step from our admissions adviser who will assist you with selecting the right training for you, to our student adviser who will be there with you during your entire training journey. Relevancy We have tailored our programs to provide comprehensive training in the technical and soft skills employers are looking for. With direct input and feedback from industry leaders and hiring managers, our program aligns with exactly what you need to successfully enter the workforce. Certification Our career training not only gives you the knowledge you need but preparation for the certification exams relevant to your desired career path. If you are pursuing an exciting new career in a field with a national certification, our program will both prepare you to sit for the exam but will often include a voucher for the exam cost. Simulations and Case Studies Our training programs have been developed with real learners and professionals in mind, so our programs incorporate real-world case studies and virtual simulations that will provide examples and interactions with real-life situations you may encounter during your career. These allow you to learn by experience with circumstances similar to what will be your daily responsibilities on the job. Engaging and Interactive Our training curriculum was developed with you in mind, looking at modern day learners and their needs. Our curriculum contains a mix of formats including reading, listening, watching, and interacting that will immerse you into a fun and engaging learning experience you will not only enjoy but not want to end. Program Description Description Audience Learning Objectives Support Description Completion Time If you’re looking for a way to get up to speed quickly on the newest version of Microsoft Office, this course offers step-by-step instructions to make it easy. Office 2019 has new features and tools to master, and whether you’re upgrading from an earlier version or encountering the Office applications for the first time, you’ll appreciate this simplified approach. This course covers: Microsoft Word 2019 Microsoft Excel 2019 Microsoft PowerPoint 2019 Microsoft Outlook 2019 Microsoft Access 2019 Microsoft Publisher 2019 Microsoft Office holds more than 90 percent of the market for Windows-based productivity suites. Our MS Office 2019 course makes this technology easy to understand, even for those who are new to computers. NOTE: This course does NOT include the MS Office programs themselves. Students will need to have Office 2019 already installed on their computers. FAQ How do I request more information about a course? To request more information, you can contact us via online chat, our website contact form, or toll free at 1-855-201-6910. What is the difference between online courses and classroom courses? Online courses are accessible 24/7/365 and self-paced, allowing you to progress at your own pace on your own schedule. They can be taken from anywhere in the world from the comfort of your own home. Classroom courses have a set schedule of the days and times the courses will be held, and you must attend during those specific times. I’m not sure if I will be able to successfully take on online course, what should I do? Find out if online learning is right for you by contacting our team of registration advisers. Our team is available to answer any of your questions about taking an online course before you commit to enrolling. We will walk you through what to expect to ensure you are making the right decision. You can contact a registration adviser today via online chat, our website contact form, or toll free at 1-855-201-6910. Do I need a degree or high school diploma to take an online course? No, you are not required to have a diploma or higher education degree to enroll in an online course. However, some occupations may require minimum educational thresholds for employment or certification. For more information on your desired career requirements, please contact us via online chat, our website contact form, or toll free at 1-855-201-6910. What do I need to take an online course? To take an online course, you will need to have access to an internet connection and an internet ready device such as a laptop, PC, or tablet. For course specific requirements, please visit the course page or contact a registration adviser today. What format will my online course be in? Our courses are developed with multiple formats including text, audio, video, and interactivity. Our courses also include multiple resources and tools which can include flashcards, games, activities, and more. Do I have to be local to take a course? No, you can take the online courses from anywhere in the world. Do you offer or accept any financial assistance options? We participate in several financial assistance options including third party funding, both military and non-military. To request more information on the financial assistance options available and check your eligibility, contact us via online chat, our website contact form, or toll free at 1-855-201-6910. What does the course duration mean? Duration is the amount of time you will receive access to your course. Durations vary by course and range between 1 month and 12 months. If you complete your course before your duration ends you will continue to have access to your course until the duration period ends. What does “Certification Voucher Included” mean? Many of our career training programs include certification vouchers. This means that at the successful completion of your course, at no additional charge, you will receive an exam voucher for the corresponding industry certification. This voucher will allow you to register and sit for the appropriate certification exam to obtain your industry credential. When will I start my course? Our online courses are open enrollment, so you can start immediately. If you are using any third-party funding to cover your course tuition, your start date may be a future date determined by your funding program. What type of support will I receive during my course? Once enrolled, you will be assigned a client adviser who will provide you with customer and technical support. Your client adviser will supply you with your course access information, any needed materials, and be available to answer any questions you have during your training experience. They will regularly check-in with you to monitor your progress and assist you with staying on track. You will also be assigned to a course mentor who will provide curriculum support throughout your training. Your mentor is available to answer any questions you have on your course curriculum, will monitor your progress and understanding of the curriculum, and may give assignments or quizzes. Who do I contact if I cannot access my course? If you experience any trouble accessing your course including technical issues or lost login credentials, please contact your client adviser at Austin Peay State University. Who do I contact if I need an extension? Our goal for students is to successfully complete their training course and achieve their career goals. We understand that extenuating circumstances can interfere with your ability to complete your course in the duration given. Because of this we have free or low-cost extensions available for our courses upon request. To discuss or request an extension please contact your client adviser at Austin Peay State University. What do I receive when I complete my course? Upon successful completion of your course and fulfillment of any outstanding financial obligations, you will receive your certificate of completion. Certificates are provided to you within 30 days of completion. Your certificate will validate the training course you completed with a stamp of completion. Will I receive any job search assistance or externship opportunity after I finish my course? Students that successfully complete our career training programs are assigned a career development adviser who will coordinate placement at a local externship or hands on opportunity. These opportunities are optional and may vary based on availability and occupation. Your career development adviser will also provide job search services such as: resume building, mock interviews, job opportunity resources, and more. Our professional enrichment courses do not come with a career adviser or career services. $995.00 Enroll Now Overview Ready to dive in? Program Description FAQ Training Plan Any Questions? Start a Live Chat Call Us 1-855-201-6910
