Welcome to Microsoft Excel 2021/365 Complete. This course starts with the basic concepts and skills in Microsoft Excel, then builds on these to provide more advanced tools to solve real-world problems and analyze and present complex, realistic data.You will benefit most from this course if you want to use Excel to perform real-world tasks, such as rearranging and presenting complex data, getting information from large amounts of data from sources inside and outside of Excel, creating output that varies according to conditions, manipulating dates and text, and automating repetitive tasks. If you intend to take a Microsoft Office Core or Expert exam for Excel, this course will prepare you for both, covering all the objectives for both exams.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 Excel or another spreadsheet program before.For more information and access to the PowerPoint files, please e-mail sales@30bird.com...
Our Microsoft Excel 2021/365 Level 1 courseware provides the basic concepts and skills students need to start being productive with Microsoft Excel: how to create, save, share, and print worksheets that contain various kinds of calculations and formatting. Students will benefit most from this course if they want to accomplish basic workplace tasks in Excel, or if they want to have a solid foundation for continuing on to become an Excel expert.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.For more information and access to the PowerPoint files, please e-mail sales@30bird.com.
..
Microsoft Excel 2021/365 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 Excel: 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.Students will benefit most from this course if they want to use Excel to perform real-world tasks such as rearranging and presenting complex data.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.For more information and access to the PowerPoint files, please e-mail sales@30bird.com...
Microsoft Excel 2021/365 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: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros.Students will benefit most from this course if they want to use Excel 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.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.For more information and access to the PowerPoint files, please e-mail sales@30bird.com...
This course provides the basic and advanced concepts for the use of Microsoft Access 2019: How to navigate the Access interface; how to create and modify tables, queries, forms, and reports; how to create advanced queries, forms, and reports; how to create macros; and how to manage your databases.You will benefit most from this course if you want to be an advanced user of Access 2019. 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 Access or another database system before...
This course provides the basic and advanced concepts for the use of Microsoft Access: How to navigate the Access interface; how to create and modify tables, queries, forms, and reports; how to create advanced queries, forms, and reports; how to create macros; and how to manage your databases.You will benefit most from this course if you want to be an advanced user of Access. 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 Access or another database system before...
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 Design provides the basic concepts and skills to start being productive with Microsoft Access: 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.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 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. ..
CompTIA Data+ Certification DA0-001 provides the knowledge needed to understand and implement data analysis and reporting techniques in support of organizational business requirements, in order to inform decision making. This includes mining and manipulating data, understanding and applying statistical methods, and analyzing complex data sets, all while following governance requirements and quality standards every step of the way.This course maps to the CompTIA Data+ DA0-001 certification exam. You can download an objectives map for the course by following this link. You will benefit most from this course if you intend to take the CompTIA Data+ exam. This course assumes that you have some applied knowledge of computers and database software, and basic cybersecurity principles. At the very least, it would be helpful for students to have knowledge of and experience with spreadsheet software (for example, Microsoft Excel) and basic data analysis functions.For more information and access to the PowerPoint files, please e-mail sales@30bird.com.Online Labs coming soon!..
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.
..
Our Excel 2019 Level 1 courseware provides the basic concepts and skills students need to start being productive with Microsoft Excel 2019: 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 2019. 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 2019, 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 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 2019 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 2019: 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 2019 courses map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2019. 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 2019 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 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.
..
Excel 2019 Complete provides the concepts and skills to be productive with Microsoft Excel 2019, 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 2019. 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 2019 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.
..
This course provides the basic concepts and skills students need to start being productive with Microsoft Excel Online: how to create and save worksheets that contain various kinds of calculations and formatting.Students will benefit most from this course if they want to accomplish basic workplace tasks in Excel Online. 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.
..
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 2019 Level 3 is an instructor-led course manual that covers advanced skills for Microsoft Word 2019 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 2019. 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 2019, 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 2019 Level 2 or have equivalent knowledge in the core skills of using Microsoft Word 2019.
..
Microsoft Word 2021/365 Level 3 covers advanced skills for Microsoft Word power users: advanced formatting features, document management, references, data fields and sources, macros, and forms.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.This course assumes that students have completed Microsoft Word 2021/365 Level 2 or have equivalent knowledge in the core skills of using Microsoft Word.For more information and access to the PowerPoint files, please e-mail sales@30bird.com.
..
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.
..
Word 2019 Complete provides the basic concepts and skills to be productive with Microsoft Word 2019, 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 2019. 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.
..
Microsoft Word 2021/365 Complete provides the basic concepts and skills to be productive with Microsoft Word, starting with fundamentals and working up to advanced tools and techniques.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.For more information and access to the PowerPoint files, please e-mail sales@30bird.com...
Excel 2013 Level 1 provides the basic concepts and skills to start being productive with Microsoft Excel 2013: 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 2013. 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 Excel 2013, 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 course is a good place to start their preparation, but they will need to contiue on to other courses in the series to be fully prepared for either 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 Excel or another spreadsheet program before.
..
Excel 2013 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 2013: 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 2013 courses map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2013. 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 these courses if they want to use Excel 2013 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 2013 Complete provides the concepts and skills to be productive with Microsoft Excel 2013, 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 2013. Objective coverage is marked throughout the course, and you can download an objective map from the downloads section of the product page.
Students will benefit most from this course if they want to use Excel 2013 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.
..
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 2019 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
..
Project 2021/365 Level 1 addresses the features of Microsoft's Project application, which is specifically designed to address the needs of project managers in corporate environments. Some of the topics covered are: navigating and understanding the important features of the Project environment; creating a new project schedule from scratch; understanding and working with task types, scheduling options, and task constraints; working with resources, including scheduling and assignment; managing the project schedule, in accordance with the critical path and project baseline; and printing project views, dashboards, and various other kinds of reports.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.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...
Project 2021/365 Level 2 addresses the features of Microsoft's Project application, which is specifically designed to address the needs of project managers in corporate environments. Topics covered are: working with the Quick Access Toolbar and advanced calendar topics; advanced task topics; advanced resource topics, including setting resource working-time exceptions, pooling resources for sharing, and creating resource budget cost items; advanced project management topics, such as working with multiple baselines and interim plans, updating a project schedule using a status date, and resolving resource conflicts and scheduling issues; advanced task form and resource form options, and understanding the Relationship Diagram and compound views; consolidating projects using Master projects and Subprojects; and advanced project sharing options, such as working with Project Server, Project Online, and SharePoint, using Project data in other applications, and creating final reports.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 2019 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...
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
..
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
..
Word 2013 Level 3 is an instructor-led course manual that covers advanced skills for Microsoft Word 2013 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 2013. 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 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 77-887 exam for Word, 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 77-881 exam.
This course assumes that students have completed Word 2013 Level 2 or have equivalent knowledge in the core skills of using Microsoft Word 2013.
..
Word 2013 Complete provides the basic concepts and skills to be productive with Microsoft Word 2013, 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 2013. 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.
..
Excel 2010 Level 1 provides the basic concepts and skills to start being productive with Microsoft Excel 2010: 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 2010. 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 courses if they want to accomplish basic workplace tasks in Excel 2010, 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 course 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 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.
..
Excel 2010 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 2010: 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 2010 courses map 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 for the series from http://www.30bird.com.
Students will benefit most from these courses if they want to use Excel 2010 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.
..
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.
..
Word 2010 Level 3 is an instructor-led course manual that covers advanced skills for Microsoft Word 2010 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 2010. 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 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 77-887 exam for Word, 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 77-881 exam.
This course assumes that students have completed Word 2010 Level 2 or have equivalent knowledge in the core skills of using Microsoft Word 2010.
..
Our Word 2010 Complete courseware covers the concepts and skills needed for maximum productivity in Word, 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 2010. Objective coverage is marked throughout the course, and you can download an objectives map from 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.
..