Welcome to Installation, Storage, and Compute with Windows Server 2016: Exam 70-740. This course provides the basic knowledge needed to perform installation, storage, and compute tasks with Microsoft Windows Server 2016; this includes installation and deployment, server storage, Hyper-V, containers, high availability systems, and server maintenance. This course maps to the MCSA 70-740 exam. You can download an objective map for the series from http://www.30bird.com.You will benefit most from this course if you intend to take an MCSA 70-740 exam. This course assumes that you have basic knowledge at using and maintaining individual Windows systems. Knowledge equivalent to the CompTIA A+ certification is helpful but not necessary. ..
Access 2016: Relational Database Design gives students a solid start in building and populating relational databases from the ground up. Topics covered in this two-day course include database fundamentals, relational database structure and normalization, and how to create tables, queries, forms, and reports. Both levels of our Access 2016 courseware map to the Microsoft Office Specialist exam for Access 2016. Objective coverage is marked throughout the course.Students will benefit most from this course if they want design and create relational databases in Access 2016, or if they want to have a solid foundation for continuing on to become an Access expert. If they intend to take a Microsoft Office Specialist exam for Access, this course is a good place to start their preparation, but they will need to continue both courses in the series to be fully prepared for the exam.The course assumes students know how to use a computer, and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Access or a similar database application before. ..
This course provides the basic concepts and skills to start being productive with Microsoft Access 2019: How to design and create a relational database, navigate the Access interface, and how to create and modify tables, queries, forms, and reports.Students will benefit most from this course if they want to gain a basic understanding of relational databases and be able to design and build a simple database in Access 2019. The course assumes students know how to use a computer, and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Access or another database system before.Which Access series is right for me?Our Relational Database Design and Relational Database Management courses are meant for students who want to build Access databases from the ground up. The first course is two days and includes in-depth, hands-on exercises that teach effective relational database development. Any student who completes these courses will be able to create and maintain a database for a small business or other organization.Level 1 and Level 2, on the other hand, are intended for students who will be working with existing databases rather than building them from scratch. In other words, these courses are best suited to database end users rather than database designers/managers...
Access 2019: Relational Database Management provides the
concepts and skills for the advanced use of Microsoft Access 2019: How to
create advanced queries, forms, and reports, how to create macros, how to
import and export data, and how to manage your databases.Students will benefit most from this course if they want to
be an advanced user of Access 2019.The course assumes students have completed Access 2019
Relational Database Design, or have equivalent skills in using Access.Which Access series is right for me?Our Relational Database Design and Relational Database Management courses are meant for students who want to build Access databases from the ground up. The first course is two days and includes in-depth, hands-on exercises that teach effective relational database development. Any student who completes these courses will be able to create and maintain a database for a small business or other organization.Level 1 and Level 2, on the other hand, are intended for students who will be working with existing databases rather than building them from scratch. In other words, these courses are best suited to database end users rather than database designers/managers.
..
Access 2021/365 Relational Database Management provides the concepts and skills for the advanced use of Microsoft Access. This includes how to create advanced queries, forms, and reports, how to create macros, how to import and export data, and how to manage your databases.Students will benefit most from this course if they want to be an advanced user of Access.The course assumes students have completed Access Relational Database Design, or have equivalent skills in using Access.Which Access series is right for me?Our Relational Database Design and Relational Database Management courses are meant for students who want to build Access databases from the ground up. The first course is two days and includes in-depth, hands-on exercises that teach effective relational database development. Any student who completes these courses will be able to create and maintain a database for a small business or other organization.Level 1 and Level 2, on the other hand, are intended for students who will be working with existing databases rather than building them from scratch. In other words, these courses are best suited to database end users rather than database designers/managers.
..
Access 2016: Relational Database Management is a one-day course for experienced users, covering advanced queries, forms and reports, and delves into application development, macros, and SQL. Student will also learn how to maintain a database and import and export data to other formats. Both levels of our Access 2016 courseware map to the objectives of the Microsoft Office Specialist exam for Access 2016. Objective coverage is marked throughout the course.You will benefit most from this course if you have a basic knowledge of Access 2016 and plan to continue on to become an Access expert. If you intend to take a Microsoft Office Specialist exam for Access, this course is a good place to complete your preparation, but you will need to complete both courses in the series to be fully prepared for the exam.The course assumes you know how to use a computer and that you're familiar with Microsoft Windows. It also assumes that you have completed the preceding Access 2016: Relational Database Design course, or have equivalent knowledge. ..
Our Excel 2016 Level 1 courseware provides the basic concepts and skills students need to start being productive with Microsoft Excel 2016: how to create, save, share, and print worksheets that contain various kinds of calculations and formatting. This course, and the two that come after, map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2016. Objective coverage is marked throughout the courseware, and you can download an objective map for the series from http://www.30bird.com.
Students will benefit most from this course if they want to accomplish basic workplace tasks in Excel 2016, or if they want to have a solid foundation for continuing on to become an Excel Expert. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this courseware is a good place to start their preparation, but they will need to continue on to other courses in the series to be fully prepared for either exam.
The courseware assumes students know how to use a computer, and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Excel or another spreadsheet program before.
..
Excel 2016 Level 2 builds on the basic concepts and skills of our Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel 2016: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users. The three levels of our Excel 2016 courses map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2016. Objective coverage is marked throughout the course, and you can download an objective map for the series from http://www.30bird.com.
Students will benefit most from this course if they want to use Excel 2016 to perform real-world tasks such as rearranging and presenting complex data. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this course will continue their preparation, but they will need to continue on to the Level 3 course, particularly to prepare for the Expert exam.
The course assumes students know how to use a computer, that they're familiar with Microsoft Windows, and that they've taken the Level 1 course or have equivalent introductory experience with Excel.
..
Excel 2016 Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel 2016: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros. The three levels of our Excel 2016 courses map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2016. Objective coverage is marked throughout the course, and you can download an objective map for the series from http://www.30bird.com.
Students will benefit most from this course if they want to use Excel 2016 to perform real-world tasks such as handling and getting information from large amounts of data from sources inside out and outside of Excel, creating output that varies according to conditions, manipulating dates and text, and automating repetitive tasks. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this course will complete their coverage of all the objectives for both exams.
The course assumes students know how to use a computer, that they're familiar with Microsoft Windows, and that they've taken the Level 1 and Level 2 courses or have equivalent introductory experience with Excel. The exercises are more detailed and complex than those in the previous levels.
..
Excel 2016 Charts and Pivots provides advanced tools for analysis and presentation of complex, realistic data in Excel. Courseware coverage includes how to build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users. The course assumes you know how to use a computer, that you're familiar with Microsoft Windows, and that you introductory experience with Excel.
..
Excel 2016 Complete provides the concepts and skills to be productive with Microsoft Excel 2016, starting with fundamentals and working up to advanced tools and techniques. This course maps to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2016. Objective coverage is marked throughout the course, and you can download an objective map from http://www.30bird.com.
Students will benefit most from this course if they want to use Excel 2016 to perform real-world tasks, from common workplace tasks to complex operations with large amounts of data. If students intend to take a Microsoft Office Specialist or Expert exam for Excel, this course offers complete coverage of all the objectives for both exams.
The course assumes students know how to use a computer, and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Excel or another spreadsheet program before.
..
30 Bird’s full-color, 4-page Quick Reference Card (QRC) provides the basic concepts and skills to start being productive with Excel 2016. QRCs provide easy-to-follow instructions and keyboard shortcuts and are perfect for office and home use. The cards can be used as a job aid, desk reference, or to lead quick training sessions. Contact us to learn about surprisingly affordable branded cards.
The Excel 2016 QRC provides an overview of the Excel 2016 interface and will show you how to:
Open. Create, and save workbooks.
Manage workbooks and worksheets.
Work with columns, rows, and ranges.
Move and copy data.
Use AutoFill to complete a series.
Recognize and apply data types.
Enter formulas and functions.
Create charts.
Use Quick Analysis to perform data analysis.
..
Outlook 2016 Level 1 by 30 Bird Media is an instructor-led course manual that covers the basic concepts and skills to begin using Microsoft Outlook 2016: How to read and send e-mail, manage contacts, track tasks, and schedule appointments. This course, and the following one, maps to the Microsoft Office Specialist exam for Outlook 2016. Objective coverage is marked throughout the course, and you can download an objective map for the series from http://www.30bird.com.
Students will benefit most from this course if they want to accomplish basic workplace tasks in Outlook 2016, or if they want to have a solid foundation for continuing on to become an Outlook expert. If they intend to take a Microsoft Office Specialist exam for Outlook, this course is a good place to start their preparation, but they will need to continue both courses in the series to be fully prepared for the exam.
The course assumes students know how to use a computer, and that they're familiar with Microsoft Windows . It does not assume that they've used a different version of Outlook or a similar desktop application before.
..
Outlook 2016 Level 2 provides more advanced concepts and skills for Microsoft Outlook 2016 productivity: how to organize Outlook items, use advanced message properties, and collaborate with others. This course and the previous one map to the objectives of the Microsoft Office Specialist exam for Outlook 2016. Objective coverage is marked throughout the course. You can download an objective map for the series from http://www.30bird.com.
You will benefit most from this course if you have a basic knowledge of Outlook 2016 and plan to continue on to become an Outlook expert. If you intend to take a Microsoft Office Specialist exam for Outlook, this course is a good place to complete your preparation, but you will need to complete both courses in the series to be fully prepared for the exam.
The course assumes you know how to use a computer and that you're familiar with Microsoft Windows. It also assumes that you have completed the preceding Outlook 2016 Level 1 course, or have equivalent knowledge
..
Outlook 2016 Complete provides the concepts and skills to be productive with Microsoft Outlook 2016, starting with fundamentals and working up to advanced tools and techniques. This course maps to the objectives of the Microsoft Office Specialist exam for Outlook 2016. Objective coverage is marked throughout the course, and you can download an objective map.
..
30 Bird’s full-color, 4-page Quick Reference Card (QRC) provides the basic concepts and skills to start being productive with Outlook 2016. QRCs provide easy-to-follow instructions and keyboard shortcuts and are perfect for office and home use. The cards can be used as a job aid, desk reference, or to lead quick training sessions. Contact us to learn about surprisingly affordable branded cards.
The Outlook 2016 QRC will show you how to:
Send, receive, and preview messages.
Reply to or forward messages.
Print messages.
View and save attachments.
Create signatures and electronic business cards.
Configure junk email settings.
Create and manage contacts and contact groups.
Schedule appointments and meetings.
Reply to meeting requests.
Create and assign tasks.
..
PowerPoint 2016 Level 1 provides the basic concepts and skills that you need to start being productive with Microsoft PowerPoint 2016: How to create, navigate, format, and customize PowerPoint presentations. This course and the Level 2 course map to the objectives of the Microsoft Office exams for PowerPoint 2016. Objective coverage is marked throughout the course, and you can download an objective map for the series from http://www.30bird.com.
You will benefit most from this course if you want to accomplish basic workplace tasks in PowerPoint 2016, or if you want to have a solid foundation for continuing on to master PowerPoint. If you intend to take a Microsoft Office exam for PowerPoint, this course is a good place to start your preparation, but you will also need to complete the Level 2 course to be fully prepared for either exam.
The course assumes you know how to use a computer, and that you're familiar with Microsoft Windows. It does not assume that you've used a different version of PowerPoint or any other presentation program before.
..
PowerPoint 2016 Level 2 provides advanced concepts and skills for PowerPoint 2016 power users: how to use advanced formatting features, and animation and transition techniques, add and format media, track corrections and work with multiple presentations, create custom slide shows, and work with security and sharing options. This course, along with the preceding one, maps to the objectives of the Microsoft Office Specialist exam for PowerPoint 2016. Objective coverage is marked throughout the course.
You will benefit most from this course if you want to build on fundamental PowerPoint skills to become a power user, or if you want to have a solid foundation in PowerPoint's advanced features.
This course assumes that you have completed PowerPoint 2016 Level 1 or have equivalent knowledge in the core skills of using Microsoft PowerPoint 2016.
..
Our PowerPoint 2016 Complete courseware covers the concepts and skills needed for maximum productivity in PowerPoint, starting with fundamentals and working up to advanced tools and techniques. This course maps to the objectives of the Microsoft Office Specialist exams for PowerPoint 2016. Objective coverage is marked throughout the course, and you can download an objective map for the series.Students will benefit most from this course if they want to start with the basics and become power users of 2016. The course covers how to create, navigate, format, and customize PowerPoint presentations, as well as advanced features such as animation, transition techniques, adding and formatting media, track corrections, working with multiple presentations, creating custom slide shows, and working with security and sharing options.The course assumes students know how to use a computer, and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of PowerPoint or any other presentation program before. ..
Word 2016 Level 1 Provides the basic concepts and skills to start being productive with Microsoft Word 2016: how to create, format, and set up a document, and how to add graphics and tables. This course, and the two that come after, map to the objectives of the Microsoft Office Specialist and Expert exams for Word 2016. Objective coverage is marked throughout the course, and you can download an objectives map for the series from http://www.30bird.com.
Students will benefit most from this course if they want to accomplish basic workplace tasks in Word 2016, or if they want to have a solid foundation for continuing on to become Word Expert. If students intend to take a Microsoft Office Specialist or Expert exam for Word, this course is a good place to start preparation, but they will need to complete the other courses in the series to be fully prepared for either exam.
The course assumes that students know how to use a computer, and that they are familiar with Microsoft Windows. It does not assume that they’ve used a different version of Word or another word processing program.
..
Welcome to Word 2016 Level 2. This course will provide the concepts and skills to use some more advanced features of Microsoft Word 2016, including enhanced formatting, references, editing, and sharing, and saving to various formats. This course, and the two others in this series, map to the objectives of the Microsoft Office Specialist and Expert exams for Word 2016. Objective coverage is marked throughout the course, and you can download an objectives map for the series from http://www.30bird.com.
Students will benefit most from this course if they want to accomplish advanced workplace tasks in Word 2016, or if they want to have a solid foundation for continuing on to become a Word Expert. If they intend to take a Microsoft Office Specialist or Expert exam for Word, this course provides and important part of their preparation, but they should also complete the other courses in the series to be fully prepared for either exam.
The course assumes that students know how to use a computer, and that they are familiar with Microsoft Windows and the basics of Microsoft Word.
..
Word 2016 Level 3 is an instructor-led course manual that covers advanced skills for Microsoft Word 2016 power users: advanced formatting features, document management, references, data fields and sources, macros, and forms. This course, and the two that precede it, maps to the Microsoft Office Specialist and Expert exams for Word 2016. Objective coverage is marked throughout the course, and you can download an objective map for the series from the downloads tab on the product page.
Students will benefit most from this course if they want to build on fundamental Word skills to become a power user, or if they want to have a solid foundation in Word's advanced features before continuing on to more complex document management or VBA programming topics. If they intend to take a MOS Expert exam for Word 2016, this course will teach them the necessary skills, but they will need to complete the first two courses in this series to successfully complete the Microsoft Office Specialist exam.
This course assumes that students have completed Word 2016 Level 2 or have equivalent knowledge in the core skills of using Microsoft Word 2016.
..
Word 2016 Complete provides the basic concepts and skills to be productive with Microsoft Word 2016, starting with fundamentals and working up to advanced tools and techniques. This course maps to the objectives of the Microsoft Office Specialist and Expert exams for Word 2016. Objective coverage is marked throughout the course, and you can download an objectives map from http://www.30bird.com.
Students will benefit most from this course if they want to accomplish basic tasks in Word and then build on fundamental skills to become a power user. The course also provides a solid foundation in Word's advanced features before continuing on to more complex document management or VBA programming topics.
The course assumes that students know how to use a computer, and that they are familiar with Microsoft Windows. It does not assume that they’ve used a different version of Word or another word processing program.
..
30 Bird’s full-color, 4-page Quick Reference Card (QRC) provides the basic concepts and skills to start being productive with Word 2016. QRCs provide easy-to-follow instructions and keyboard shortcuts and are perfect for office and home use. The cards can be used as a job aid, desk reference, or to lead quick training sessions. Contact us to learn about surprisingly affordable branded cards.
The Word 2016 QRC will show you how to:
Open, create, and save documents.
Select and format text.
Set paragraph alignment, line spacing, and indentation.
Create bulleted and numbered lists.
Apply Quick Styles and themes.
Setup document margins, layouts, hyphenation, and pagination.
Insert headers, footers, page numbers, and section breaks.
Insert and adjust pictures.
Insert screenshots
Apply picture styles and wrap text around pictures.
Insert and format tables.
Manage comments and track document changes.
..
Welcome to Microsoft Project 2016/2013 Level 1. This course addresses the features of Microsoft's Project application, which is specifically designed to address the needs of project managers in corporate environments.You will benefit most from this course if you have at least some prior knowledge of project management procedures and practices. It is intended to support you in applying this knowledge through the use of Microsoft Project as a project management tool.There are no specific prerequisites for this course. However, general computer user knowledge is assumed.Any additional experience having worked with forms and/or databases will be helpful.After completing this course, you will know how to:Navigate and understand the important features of the Microsoft Project environmentCreate a new project schedule from scratchUnderstand and work with task types, scheduling options, and task constraintsWork with resources, including scheduling and assignmentManage the project schedule in accordance with the critical path and project baselinePrint project views, dashboards, and various other kinds of reports
..
Welcome to Microsoft Project 2016/2013 Level 2. This course addresses the features of Microsoft's Project application, which is specifically designed to address the needs of project managers in corporate environments.You will benefit most from this course if you have at least some prior knowledge of project management procedures and practices. It is intended to support you in applying this knowledge through the use of Microsoft Project as a project management tool.To take this course, you should have successfully completed Microsoft Project 2016/2013 Level 1 or have equivalent knowledge, and general computer user knowledge is assumed. Any additional experience having worked with project management, forms, and/or databases will be helpful.After completing this course, you will know how to:Work with the Quick Access Toolbar and advanced calendar topicsAdd task notes; set task deadlines and priorities; and group, sort, filter, highlight, and add fixed costs to tasksGroup, sort, filter, and highlight resources; set resource working-time exceptions and pool resources for sharing; and create resource budget cost itemsWork with multiple baselines and interim plans, update a project schedule using a status date, and resolve resource conflicts and scheduling issuesUse the Task Form, Task Details Form, and Task Name Form; use the Resource Form and Resource Name Form; and understand the Relationship Diagram and compound viewsConsolidate projects using Master projects and Subprojects; and work with Project Server, Project Online, and SharePointUse Project data in other applications, and create final reports
..
Our Project 2016/2013 Complete courseware covers the concepts and skills needed for maximum productivity in Project, starting with fundamentals and working up to advanced tools and techniques.Students will benefit most from this course if they have at least some prior knowledge of project management procedures and practices. It is intended to support you in applying this knowledge through the use of Microsoft Project as a project management tool. Some of the topics covered are:Creating a new project schedule from scratchUnderstanding and working with task types, scheduling options, and task constraintsWorking with resources, including scheduling and assignmentManaging the project schedule in accordance with the critical path and project baselinePrinting project views, dashboards, and various other kinds of reports.Working with the Quick Access Toolbar and advanced calendar topicsSetting resource working-time exceptions, pooling resources for sharing, and creating resource budget cost itemsWorking with multiple baselines and interim plansResolving resource conflicts and scheduling issuesConsolidating projects using Master projects and SubprojectsWorking with Project Server, Project Online, and SharePointUsing Project data in other applicationsCreating final reportsThere are no specific prerequisites for this course. However, general computer user knowledge is assumed. Any additional experience having worked with forms and/or databases will be helpful...
Our Excel 2010 Complete courseware provides the concepts and skills to be productive with Microsoft Excel 2010, starting with fundamentals and working up to advanced tools and techniques. This course maps to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2010. Objective coverage is marked throughout the course, and you can download an objective map.
Students will benefit most from this course if they want to use Excel 2010 to perform real-world tasks, from common workplace tasks to complex operations with large amounts of data. If students intend to take a Microsoft Office Specialist or Expert exam for Excel, this course offers complete coverage of all the objectives for both exams.
The courseware assumes students know how to use a computer, and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Excel or another spreadsheet program before.
..