Office 2019 eLearning Bundle Course



Course Details:

Length: 17 courses

Access Length: 6 months

Price: $900/person (USD)

Bulk Pricing: 10+ Contact Us

Course Features:

Instant Access After Purchase

Lecture by Recorded Video

Stop and Start as Needed

Certificate of Completion

Software Lab Included?: Yes

Delivery Method:

Self-Paced Online

Individuals and Groups
@ Your Location

 

Course Overview

This eLearning Bundle includes Microsoft Office 2019 courses. A comprehensive coverage of all Microsoft Office 2019 applications in an easy to follow video training format. These courses teach the student how to use all of the applications in Office 2019, moving from beginner to expert actions and techniques in Excel, Word, PowerPoint, Outlook and Access. If you want to learn about just one of the features in Microsoft Office 2019 check out one of our other course bundles: Microsoft Excel 2019, Microsoft Word 2019, Microsoft PowerPoint 2019, Microsoft Outlook 2019, and Microsoft Access 2019. These courses provide great examples of all of the features of Office 2019, and give the viewer time to try the actions on their own. After taking these courses you will be an expert user of Microsoft Office 2019!

Also Included - 4 Courses: An Essential Career Skills Pack with 4 courses in key areas for career management and growth, including Time Management, Digital Skills, Creativity and Soft Skills.


How it Works

This course is a self-paced learning solution to fit your own schedule. Certstaffix Training eLearning courses you take on your own schedule in a web browser.


  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screen shots
  • 6 month subscription length
  • Instant Access After Purchase

Have more than 10 students needing this course? Contact Us for bulk pricing.

 

Course Notes

Versions That Can Attend: Desktop Versions of Microsoft Windows PC or Macintosh
Course Taught With: Desktop Version of Microsoft Windows Software

 

Course Topics

Excel 2019: Beginner - 5 hrs 30 min

This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.

Excel 2019: Intermediate - 4 hrs 40 min

In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features.

Excel 2019: Advanced - 3 hrs 56 min

This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

 

Word 2019: Beginner - 3hrs 14 min

In this course, students will learn the basics of saving and opening documents and review the interface. Students will practice text navigation, selection, entry, and various other text formatting and editing commands and features. Additionally, students will work with bulleted and numbered lists, tables, and their various features and options. Students will also work with graphics and the various tools available in Word 2019 to format and edit them. Lastly, this course will cover various options for viewing documents, proofing options for documents, and settings to prepare documents for distribution and publication.

Word 2019: Intermediate - 5 hrs 56 min

This course expands upon the topics covered in the Word 2019 Introduction course. In this course, students will work with, create, manage, and customize Styles, Templates, and Themes. Students will also work with various types of data in Word using Tables, advanced Copy and Paste commands, and Charts. Students will then review advanced document layout options in Word and various collaboration tools. Lastly, students will work with graphic elements such as pictures, text boxes, shapes, the Drawing Canvas, SmartArt, Text Effects, Typography Effects, WordArt, and Equations. Additional graphic element features such as grouping, layering, and moving objects will also be covered.

Word 2019: Advanced - 5 hrs 52 min

In this course, students will automate with Microsoft Word 2019 through the use of building blocks, Quick Parts, fields, and Macros. Students will also utilize reference tools such as bookmarks, hyperlinks, cross references, footnotes, endnotes, bibliography tools, sources, and placeholders. Students will also learn techniques to manage long documents through a table of contents, indexing, and captions. Students will also work with Outline View and master documents, Mail Merge, and forms.

 

PowerPoint 2019: Beginner - 5hrs 2min

In this course, students will get started with PowerPoint 2019 and become familiar with the Ribbon, interface, and navigation options. Additionally, students will create a presentation and work with various features and commands to make it easier to work in PowerPoint. Students will also review presentation editing options, text formatting options, various graphic options and insertion methods, how to add, edit, and format tables and charts in a presentation, and various presentation preparation and delivery options.

PowerPoint 2019: Advanced - 4 hrs 42 min

In this course, students will learn the various collaboration tools in Microsoft PowerPoint 2019 such as reusing slides, creating slides from Word, and working with Excel. Students will learn to utilize the power of Slide Masters, create custom themes, and design custom templates. In addition, students will learn to create exciting presentations by animating text and objects, add slide transitions, and use advanced graphic features including SmartArt, and audio and video. Finally, students will present like a pro by using advanced presentation features including annotations, hyperlinks and action buttons, timings, recordings, and creating videos, and review additional advanced slideshow options.

 

Outlook 2019: Beginner - 3hrs 46min

This course is designed to teach students the basics of Microsoft Outlook 2019 and help them gain familiarity with the Outlook environment and basic functionality. Students will learn the basics of email, how to use the Help feature, how to create and send messages, and how to work with attachments. Students will also learn organizational techniques through the use of folders, views, categories, flags, and searching. Additionally, students will review printing options, automatic replies, contact creation and management, calendar use and management, task and note creation and management, message options, and email signatures.

Outlook 2019: Advanced - 2hrs 20min

In this course, students will expand upon their existing knowledge and learn and use advanced features of Microsoft Outlook 2019. Students will modify and manage message options, track and delivery options, voting options, contact options, calendar options, and other advanced Outlook features. Students will also review rules and automation, cleanup commands, sharing options, advanced graphic options, junk mail options, import and export features, and how to back up their Outlook data.

 

Access 2019: Beginner - 4hrs 27min

This course is an introduction to Microsoft Access 2019. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2019 Intermediate course.

Access 2019: Intermediate - 4hrs 11min

This course is designed to teach students intermediate level skills in Microsoft Access 2019. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 2019 Advanced course.

Access 2019: Advanced - 1hr 24min

Access 2019 Advanced will further build upon the topics covered in the Access 2019 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create backups, create and modify Navigation Forms, set startup options, split a database, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), convert macros to VBA, and use Table Events.




Essential Career Skills Pack:

Productivity and Time Management - 30 minutes

It seems that there is never enough time in the day. But, since we all get the same 24 hours, why is it that some people achieve so much more with their time than others? This course will explain how to plan and prioritize tasks, so that we can make the most of the limited time we have. By using the time-management techniques in this course, you can improve your ability to function more effectively – even when time is tight and pressures are high. So, by the end of the course you will have the knowledge, skills and confidence to be an effective manager of your time.

Basic Digital Skills - 13 minutes

With the rise of digital transformation and technology, having a basic digital literacy is essential for all types of jobs, regardless of the industry. To stay competitive and be successful in the workplace, enhancing your digital skills should be a top priority.

4 Ways to Boost Creativity - 30 minutes

The digital economy is opening up ways for everyone to be creative. It doesn’t just mean being artistic – it’s more about ideas, solutions, alternatives, incremental improvements. Peter Quarry and Eve Ash discuss ways that mental capacity can be developed, perspectives changed, group power leveraged and making things actually happen.

The 11 Essential Career Soft Skills - 1 hour 10 minutes

Soft Skills are the traits, characteristics, habits, and skills needed to survive and thrive in the modern work world. Soft skills aren't usually taught in school, but you will learn them all here in this course. Are you someone that other people in your organization and industry like to work with, collaborate with and partner with? Are you seen as a valuable asset to any new project that comes along?

This soft skills training course will teach you how to develop the skills that can make the difference between a lackluster career that tops out at middle management versus one that lands you in the executive suite. Or to wherever you define career success. So many soft skills seem like common sense at first glance, but they are not commonly applied by most workers. This soft skills training course will give you an edge over your competitors. It will also make your job, your career and your life more rewarding and enjoyable.







Related Microsoft Office Information:

How Much Do Microsoft Office Training Courses Cost?

Public instructor-led Microsoft Office course prices start at $275 per student. Group training discounts are available.

Self-Paced Microsoft Office eLearning courses cost $125 at the starting point per student. Group purchase discounts are available.

What Microsoft Office Skills Should I Learn?

A: If you are wondering what Microsoft Office skills are important to learn, we've written a Microsoft Office Skills and Learning Guide that maps out Microsoft Office skills that are key to master and which of our courses teaches each skill.

Read Our Microsoft Office Skills and Learning Guide

Microsoft Office Suite Training by Certstaffix Training

Certstaffix Training offers three dynamic approaches to mastering Microsoft Office skills through our comprehensive Microsoft Office class. Our Microsoft 365 classes can be taken live online with expert instructors guiding you. For those who prefer to learn at their own pace, we offer Microsoft online courses which allow for self-paced eLearning. If you have a group of students, we offer a opportunity for corporate groups who want in-person onsite trainings through our mobile Microsoft Office 365 training center, brought to your office. We accommodate Microsoft 365 courses for every learning style and experience level, making us the ideal choice for Microsoft courses for beginners. Through our Microsoft training classes, you'll gain the competence needed to effectively navigate the Microsoft Office suite. Our Microsoft Office suite training is designed to equip you with the tools and knowledge necessary for business success.

Why Invest in Employee Training for HR Professionals?

A: Investing in employee training for professionals in human resource management (HRM) can be as important as obtaining training for your general workforce. In some ways, it can be even more imperative, as a fully functional and competent HR department can facilitate productivity among your staff. HR professionals can benefit from taking a number of courses, such as those that teach them how to work with common office software like Microsoft Office or skills like customer service. Adequate training for HR professionals can aid them in better identifying and addressing the needs of your employees.

More Information on Employee Training for HR Professionals

Why Take Microsoft Office Training Classes From Home?

A: Taking Microsoft Office courses online from home can be a convenient and easy solution to employee training needs when time, money, and space are limited in a physical work environment. These classes have the benefit of being tailored to different programs and skill levels, making it easy to choose which concepts you need to focus on. Choose live instruction and log into your course from anywhere, or opt for a class that's self-paced so you can complete it at your leisure. Either way, you'll get hands-on training that can help employees get the skills they need and even prepare for certification exams.

More Information on the Benefits of Taking Microsoft Office Training Classes From Home

How and Why Should I Get Microsoft-Certified?

A: In today's offices and work spaces, earning one or more Microsoft certifications can be essential for showcasing your skills, increasing your salary, and progressing in your career. The process of earning a certification, however, can vary depending on your existing knowledge of relevant software, your work experience, and the particular certification pathway. While each certification pathway can differ in duration, generally, employees may earn certifications within a few months. For some individuals, signing up for training courses can significantly reduce the amount of time that it takes to prepare for Microsoft's certification exams.

More Information on Getting Microsoft-Certified

What is the best way to learn Microsoft Office?

A: There is no one-size-fits-all answer to this question, as the best way to learn Microsoft Office will vary depending on your level of experience and expertise. However, some general tips can help you get the most out of your learning experience.

If you are a beginner, it is important to start with the basics. There are many resources available online and in libraries that can help you get started with the basics of Microsoft Office. For many beginners, taking a formal Microsoft Office course is the best route, as it offers a structured learning format with set topics. Once you have a good understanding of the basics, you can move on to more advanced topics.

If you are already familiar with Microsoft Office but want to improve your skills, there are also many resources available to help you do this. You can find targeted and smaller online courses, tutorials, and tips from experts to help you make the most of your already existing Microsoft Office skills.

Whatever your level of experience, taking the time to learn Microsoft Office can be a valuable investment. With so many resources available, there is no excuse not to get started today!

What is a Microsoft Office course?

A: A Microsoft Office course is a type of educational training that covers the various aspects of using the Microsoft Office software suite. This type of coursework can help users learn how to use the different features and applications within Microsoft Office, as well as how to optimize their workflows by integrating the tools in the suite. Microsoft Office courses can be taken online or in person, and typically cover the following topics:

  • Microsoft Word: Users learn how to create, format, and edit text documents using Microsoft Word.
  • Microsoft Excel: Users learn how to create and work with spreadsheets in Microsoft Excel.
  • Microsoft PowerPoint: Users learn how to create presentations and slideshows using Microsoft PowerPoint.
  • Microsoft Outlook: Users learn how to manage their email, calendar, and contacts using Microsoft Outlook.

Microsoft Office courses can be beneficial for both beginners who are new to the software suite and experienced users who want to learn more about how to use the tools effectively. The courses can also be customized to fit the needs of any user, whether they are looking for a general overview of the software or more specific training on one particular application.

How can I improve my Microsoft Office skills?

A: If you're looking to improve your Microsoft Office skills, there are a few avenues you can explore. One option is to find online tutorials or courses that can help you learn the specific features and functions you're interested in. Another possibility is to seek out books or other resources that offer step-by-step instructions for using Microsoft Office applications. Finally, you could consider attending a formal Microsoft Office training class or workshop to get hands-on experience and guidance from an expert.

The route you choose depends on your experience level and learning preferences. Whichever route you choose, with a little effort you can soon be on your way to becoming a Microsoft Office pro!

What is the fastest way to learn Microsoft Office?

A: There is no single answer to this question as everyone learns at a different pace. However, some general tips can help you learn Microsoft Office quickly and effectively.

First, it is important to have a clear understanding of what you want to achieve with Microsoft Office. Whether you want to use it for work or personal purposes, it is important to set some goals so that you can focus on your learning.

Next, make use of all the resources available to you. Formal Microsoft Office classes are available online or in-person for groups by Certstaffix Training that start at 1 day in length. There are also many self-teaching methods such as tutorials and guides available online, as well as books and other materials. Utilize these resources to learn at your own pace and in a way that suits your learning style.

Finally, practice, practice, practice! The more you use Microsoft Office, the more comfortable and confident you will become using it. Do not be afraid to experiment and explore all the features and functions available; this is the best way to learn.

By following these tips, you can learn Microsoft Office quickly and effectively.

What are options for Microsoft Office training near me?

Are you looking to enhance your skills in Microsoft Office? Do you want to learn more about the various tools and features within this popular software suite? Look no further, as we have compiled a list of resources for Microsoft classes near me that will meet your training needs.

Finding the Right Training

When it comes to finding the right Microsoft training near me, there are a few factors to consider. First, you should think about what specific skills or tools you want to focus on. Are you interested in learning more about Excel functions or creating engaging presentations with PowerPoint? Once you have identified your training needs, it's time to research different options for in-person Microsoft Office training near me.

In-Person vs. Online Training

For some, attending a physical classroom setting for training may be the preferred method. Fortunately, there are many resources available for in person Microsoft Office training near me. These classes allow you to learn from an instructor face-to-face and interact with other students in real time.

On the other hand, online training options offer flexibility and convenience for those with busy schedules. Many online platforms offer Microsoft Office workshops near me that can be completed online either at your own pace or a public live schedule to register from. There 2 options for online training - 1.) Live Online and 2.) Self-paced.

Live Online

Live Online features a set date and time to attend like an in-person class. A live teacher leads the class with lecture and hands-on exercises to reinforce the lecture.

Self-Paced Online

Self-paced online is often called eLearning. You view recorded video lectures and often have hands-on assignments you can complete to reinforce the video lecture.

Microsoft 365 and Office 365 Training

As Microsoft continues to evolve its software offerings, it's important to stay up-to-date on the latest updates and features. This is where Microsoft 365 training near me and Office 365 training near me come into play. These courses are specifically tailored to teach users about the newest versions of Microsoft Office and how to effectively use them in your day-to-day tasks.

Classes for Microsoft Office Near Me

In addition to traditional classroom settings, there are many classes for Microsoft Office near me offered by local organizations and universities. These classes may vary in length and intensity, so be sure to research which option best fits your learning style and needs. Some classes may also offer certification upon completion, which can be a valuable addition to your resume.

Conclusion

In summary, there are plenty of resources available for MS Office course near me that will allow you to enhance your skills and become more proficient in using Microsoft Office. Whether you prefer in-person or online training, there is an option out there for you. Take the time to research and find the right training that will help you reach your professional goals.

Certstaffix Training offers 3 options to learn Microsoft Office training near me:

Reach out to us for more information, a quote or register on our website for a live online or self-paced class today!

What are options to learn Microsoft Office?

Microsoft Office is a suite of applications that are essential for any business, school, or individual. Many people use these applications on a daily basis but may not be utilizing all of their features and capabilities. That's why it's important to invest in training courses to become proficient in using Microsoft Office.

Benefits of Microsoft Office Training

There are several benefits to attending Microsoft Office training. The most obvious one is that you will become more efficient and productive in using the applications, which can greatly benefit your work or studies. By learning from a certified instructor, you will be able to fully understand the features and functions of each application, allowing you to use them to their full potential.

Types of Microsoft Office Training

There are various types of training for individuals and businesses alike. In-person training is a popular option, where participants attend classes physically and learn from an instructor in person. This type of training allows for hands-on experience and immediate feedback from the instructor. Live online instructor-led format is also very popular and is often the most available in your area. You attend a set date and time, like in-person, but you attend online from you location and interact with the instructor and other students live just like in person.

For those who prefer to learn at their own schedule, self-paced online Office classes are also available. These courses provide flexibility as they can be accessed anytime, anywhere. However, they may not offer the same level of interaction and practical experience as in-person or live online training.

Advanced Microsoft Office Training

While most individuals are familiar with the basics of using Microsoft Office, there is always room for improvement and learning advanced features. Advanced MS Office training teaches attendees how to use these applications at an expert level, allowing them to create professional and complex documents, spreadsheets, presentations, and more.

Microsoft Classes for Adults

Microsoft Office classes are not just for students or professionals. There are also courses specifically designed for adults who may want to learn how to use the applications for personal use. These classes can teach individuals how to organize their finances with Excel, create invitations and flyers with Publisher, or manage their schedule with Outlook.

Microsoft Office Classes in Person

For those who prefer a more traditional approach, in-person Microsoft Office training is available. These classes are led by certified instructors and offer hands-on experience with the applications. Participants can ask questions, receive immediate feedback, and network with other individuals attending the class.

Start Learning Office 365 Today

Investing in Microsoft Office training can greatly improve your proficiency and productivity in using these essential applications. Whether you prefer in-person classes or online courses, there are plenty of options available to suit your learning style. Don't miss out on the opportunity to enhance your skills and become an expert at using Microsoft Office.

It is always recommended to take up some sort of Microsoft training. With the availability of various types such as Microsoft in person training, Microsoft instructor led courses and online Office classes, it has never been more convenient to improve your skills.

Certstaffix Training offers live online, in person (corporate groups only) and self-paced Excel training formats. Sign up for a class today and take the first step towards becoming a Microsoft Office pro!

What are the top Microsoft Office skills?

A: To be proficient in Microsoft Office, there are certain skills you need to master. These skills include:

Top Microsoft Office Skills

1. Knowing how to use the various features in each of the programs.

2. Being able to create and edit documents, spreadsheets, and presentations.

3. Knowing how to manage files and folders.

4. Being able to collaborate with others using the various tools available.

5. Having a good understanding of how to troubleshoot problems that may occur.

6. Knowing how to customize the various settings to better suit your needs.

7. being able to use the different keyboard shortcuts available in each program.

8. Knowing how to use the various templates that are available.

9. Being able to create macros to automate tasks.

10. Knowing how to use the different add-ins that are available for the various programs.

These are just some of the skills that you need to master to be proficient in Microsoft Office. By taking the time to learn these skills, you will be able to use the programs to their full potential and get the most out of them.

Where Can I Learn More About Microsoft Office?

Microsoft Office Blogs

Microsoft Office User Groups

Microsoft Office Online Forums

Explore Microsoft Office Training Near Me:

Certstaffix Training provides Microsoft Office classes near me or online, depending on the number of students involved. We offer online courses for individual learners, as well as in person classes at your office for corporate groups. Our trainers are highly experienced professionals with the expertise necessary to help you gain a thorough understanding of Office 365 concepts and tools. With our courses available online for individuals or in person for corporate groups, it's easy to develop your Microsoft Office skills. Start learning today and see how Certstaffix Training can help you reach your goals.







Registration:

Have a Group?
Request Private Training


Online Class

Self-Paced eLearning

Start your training today!