Course Overview
This eLearning Bundle includes 13 Microsoft Office 2013 courses. A comprehensive coverage of all Microsoft Office 2013 applications in an easy to follow video training format. Go from “Oh no” to “Office Pro” in no time. These courses teach the student how to use all of the applications in Office 2013, 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 2013 check out one of our other video bundles: Microsoft Excel 2013, Microsoft Word 2013, Microsoft PowerPoint 2013, Microsoft Outlook 2013, and Microsoft Access 2013. These courses provide great examples of all of the features of Office 2013, 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 2013! You may just be the “Office Superstar!”
Course Topics
Microsoft Access 2013: Getting Started (Level 1) – 4:00 hours
The first level in a series of three, Microsoft Access 2013: Getting Started gives you a detailed introduction to the layout and features of this powerful database management program. The course starts by outlining some of the new features of Access 2013 that users upgrading from a previous version may be unfamiliar with. It then launches right into the basics of using Access, including how to create and modify tables, forms, and reports. It also shows you how to use advanced queries like parameter and action queries to make your database more efficient.The comprehensive beginner course takes approximately 4 hours to complete. It consists of a series of engaging videos, with clear narration and screen recordings that walk you through each process step by step. The course includes 6 sections that each contain practice files and a quiz to assess your knowledge.
Microsoft Access 2013: Intermediate (Level 2) – 5:00 hours
Once you’ve mastered the basics of the program, this Microsoft Access 2013: Intermediate course will teach you more advanced ways of designing and working with relational databases. The course starts by outlining some best practices for designing databases in Access before explaining how you can optimize your data by using tools like the Table Analyzer and junction tables. It also demonstrates how to import and export data and how to create customized reports featuring eye-catching formatting and functional details like data bars and calculated fields.The second level in a series of 3, this course takes approximately 5 hours to complete. It consists of a series of engaging videos, with clear narration and screen recordings that walk you through each process step by step. The course includes 5 sections that each contain practice files and a quiz to assess your knowledge. To continue building upon your new skills, you can move on to the third level course Microsoft Access 2013: Advanced.
Microsoft Access 2013: Advanced (Level 3) – 5:00 hours
The Microsoft Access 2013: Advanced course equips you with the tools to craft a database that will stand out for its efficiency, style, and overall performance. The course first explains how to create advanced forms that use features like sub-forms and tab pages to make your database more accessible for your clients and coworkers. It then delves into different methods you can use to validate and restrict data entry to keep your information consistent. Finally, it touches on how to split or distribute your database, how to keep it secure, and how to use switchboards to control what different users can view. The comprehensive advanced level course takes approximately 5 hours to complete. It consists of a series of engaging videos, with clear narration and screen recordings that walk you through each process step by step. The course includes 6 sections that each contain practice files and a quiz to assess your knowledge.
Microsoft Excel 2013: Getting Started (Level 1) – 6:00 hours
This Microsoft Excel 2013: Getting Started (Level 1) takes you through the fundamentals tools and processes that allow you to create professional and effective spreadsheets. You’ll explore the Excel 2013 user interface, create and modify a worksheet, and perform basic calculations. Learn how format the look of your worksheet, and find out how to print the entire contents of your workbook. The course also shows you how to manage large workbooks more efficiently and how to customize the Excel environment to suit your preferences.This comprehensive 6-hour course is divided into 7 lessons that that you through the basics of this powerful spreadsheet program. The video course features engaging narration, step-by-step instructions, practice files, and post-assessment quizzes to help you discover time-saving tricks for managing workbooks and worksheets. Follow up with Level 2 intermediate Microsoft product training courses to continue to increase your knowledge and improve your skills.
Microsoft Excel 2013: Intermediate (Level 2) – 5:00 hours
Now that you’ve learned the basics and are comfortable using Microsoft Excel 2013, upgrade your skills with this intermediate course to get the most out of this powerful spreadsheet program. It takes you through more advanced formulas and lookup functions, allowing you to perform more complex calculations. You’ll learn to use tables, charts and graphics to visually display information. The course also demonstrates how to use Pivot Tables, Slicers and Pivot Charts to analyze your data.Using engaging narration, step-by-step instructions, in-line quizzes, practice files and a post-assessment quiz, this 5-hour video course teaches you some of the more advanced capabilities of Excel 2013 to give you a competitive edge in managing data. It is divided into 7 lessons for easy viewing. Follow up with Level 3 Microsoft product training courses to continue to increase your knowledge and improve your skills.
Microsoft Excel 2013: Advanced (Level 3) – 5:00 hours
This Microsoft Excel 2013: Advanced (Level 3) course will build on your basic knowledge of Excel by teaching you some of the more specialized capabilities in Excel 2013. The comprehensive course begins by looking at ways of streamlining your workflow by automating repetitive tasks using macros and applying conditional formatting. Next, you’ll learn how to audit your workbooks to ensure complete accuracy and avoid mistakes from human error. Excel 2013 offers powerful means of analyzing your data, and in this course you’ll learn how to perform complex statistical analyses using sparklines and scenarios. You’ll also learn how to work effectively with multiple workbooks at the same time, as well as how to import and export your Excel data. This 5-hour course is broken down into 5 lessons. Each section features engaging narration with easy-to-understand instructions and includes summaries and short quizzes to ensure comprehension.
Microsoft Outlook 2013: Getting Started (Level 1) – 5:00 hours
Master the essential functions of Microsoft Outlook 2013, including the core email, calendar, and contact management features, with this user-friendly training course appropriate for beginners. The Microsoft Outlook 2013: Getting Started (Level 1) course will familiarize you with the Outlook environment and basic commands. Learn to send and receive emails, organize your inbox, add and sort contact information, schedule appointments, manage meetings, and create tasks and notes with this popular workplace application. The 5-hour course includes 8 different lessons, which you can complete at your own pace. Each lesson contains a series of video modules featuring visual demonstrations paired with expert narration for clear, step-by-step instruction. Practice files and optional online quizzes come included for an interactive learning experience. To move beyond the basics, consider coupling this course with Microsoft Outlook 2013 Level 2, which covers some of Outlook’s more advanced features.
Microsoft Outlook 2013: Intermediate (Level 2) – 5:00 hours
Enrich your Microsoft Office 2013 skills with this instructive training course covering the popular workplace application’s advanced features for enhanced email, calendar, and contact management capabilities. The Microsoft Outlook 2013: Intermediate (Level 2) course will help you to customize Outlook settings and utilize worthwhile functions you may be overlooking. Learn to use Outlook to its fullest potential when it comes to email communication, organizing your messages and contacts, scheduling and managing workflow, collaborating with colleagues, and backing up your important data. This 5-hour course contains 7 different lessons, which you can complete at your convenience. The video modules feature step-by-step visual demonstrations with expert narration. Downloadable practice files and elective online quizzes are included for an interactive learning experience. If you’d like to brush up on Outlook basics, consider preparing for this course with Microsoft Outlook 2013: Getting Started (Level 1).
Microsoft PowerPoint 2013: Getting Started (Level 1) – 5:00 hours
Ideal for beginners, the Microsoft PowerPoint 2013: Getting Started (Level 1) training course gives you the resources and tools you need to make informative, professional and powerful presentations. Learn how to create a PowerPoint presentation, add graphics and tables, and modify objects. Insert charts to present your information in a more impactful way. Then prepare to deliver your presentation by reviewing, editing and printing your work. The 5-hour comprehensive video course is divided into 8 lessons and features engaging narration, step-by-step instructions, and a post-assessment quiz to help you successfully create and deliver a winning presentation. Complete Level 2 intermediate Microsoft product training courses to continue to increase your knowledge and improve your skills.
Microsoft PowerPoint 2013: Intermediate/Advanced (Level 2) – 5:00 hours
Take your Microsoft PowerPoint 2013 skills to the next level using advanced features and functions outlined in this course to create customized and professional presentations. Learn how to use tools to modify the user interface, create unique templates, add SmartArt and animations, collaborate with team members, and customize, secure and distribute a presentation. This 5-hour course is split into 7 different lessons that can be viewed individually at your own pace. Each task and function is outlined step-by-step to facilitate learning. The included practice files and lesson quizzes help reinforce learning of concepts and functions. The course is ideal for intermediate and advanced users.
Microsoft Word 2013: Getting Started (Level 1) – 5:00 hours
Learn about the basic tools and functions in Microsoft Word 2013 and discover how easy it is to create professional documents using this powerful word processing program. In this course, you’ll become familiar with the user interface and learn how to create a document and edit and format text. You’ll also discover how to create and format a table, add a list, insert graphics, modify pages and appearance, proof a document and customize options to save you time and effort.Ideal for those just starting out with Word 2013, this 5-hour course is divided into different sections that contain an introduction, summary, and optional quiz. Tasks and processes are presented in steps to make learning concepts easy, and practice files are included to help you gain practical experience.
Microsoft Word 2013: Intermediate (Level 2) – 5:00 hours
Upgrade your basic training and move to the next level of expertise by mastering the tools and functions outlined in this Level 2 training course. You’ll learn how to use charts and tables, customize styles and themes, work with images, create custom graphic objects, simplify content insertion, and master mail merges and macros to enhance your document and bring efficiency and convenience to your work.The 5-hour course is designed for intermediate users who want to take advantage of the more sophisticated features of Microsoft Word 2013. It is divided into different sections and step-by-step direction is provided to make learning easy. Each section also contains an introduction, summary, optional quiz and practice file.
Microsoft Word 2013: Advanced (Level 3) – 3:00 hours
In this advanced course, you’ll master the high-level tools and functions of Microsoft Word 2013 to create expert and professional-looking documents. Take advantage of tools that make collaborating on documents more efficient, add reference marks and notes to improve navigation, use tables and outlines to simplify documents, add security features, create forms and legacy form fields, and manage multiple versions of documents.The instructional course is 3 hours in length and divided into 7 lessons that can be viewed at your own pace. Each lesson includes an optional quiz for self-assessment. The lessons contained in this inclusive series are also available as stand-alone courses.