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.
..
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...
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 2019 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 2019: 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 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 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 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 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 have introductory experience with Excel.
..
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.
..
30 Bird’s full-color, 4-page Quick Reference Card (QRC) provides the basic concepts and skills to start being productive with Office 2019. 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 Office 2019 New Features QRC provides an overview of the new features and changes in Office 2019, such as:
Scalable vector graphics Inserting icons LaTeX equations Drawing and writing with ink Inserting 3D modelsMorph in PowerPointZoom in PowerPointFocused Outlook Inbox New Excel chart types New Functions in Excel Personalizing the default PivotTable layout
..
Outlook 2019 Level 1 by 30 Bird Media is an instructor-led course manual that covers the basic concepts and skills to begin using Microsoft Outlook 2019: 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 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 accomplish basic workplace tasks in Outlook 2019, 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 2019 Level 2 provides more advanced concepts and skills for Microsoft Outlook 2019 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 2019. 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 2019 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 2019 Level 1 course, or have equivalent knowledge
..
Outlook 2019 Complete provides the concepts and skills to be productive with Microsoft Outlook 2019, 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 2019. Objective coverage is marked throughout the course, and you can download an objective map.
..
PowerPoint 2019 Level 1 provides the basic concepts and skills that you need to start being productive with Microsoft PowerPoint 2019: 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 2019. 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 2019, 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 2019 Level 2 provides advanced concepts and skills for PowerPoint 2019 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 2019. 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 2019 Level 1 or have equivalent knowledge in the core skills of using Microsoft PowerPoint 2019.
..
Our PowerPoint 2019 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 2019. 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 2019. 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 2019 Level 1 Provides the basic concepts and skills to start being productive with Microsoft Word 2019: 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 2019. 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 2019, 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 2019 Level 2. This course will provide the concepts and skills to use some more advanced features of Microsoft Word 2019, 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 2019. 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 2019, 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 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.
..
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.
..
30 Bird’s full-color, 8-page ShortTrack card provides the basic concepts and skills to start being productive with Project 2019. ShortTrack cards provide easy-to-follow instructions 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.The Project 2019 ShortTrack card will show you how to:
Open, create, and save projects.Project views.Entering standard and summary tasks.Entering milestones.Inserting a recurring task.Task dependencies.Linking tasks.Changing the timescale.Working with the timeline.Understanding task types.Setting a task constraint.Entering resources.Assigning resources to the project schedule.Displaying the critical path.Setting the project baseline.Updating tasks.Splitting tasks.Report types.Creating and printing a report.About the ShortTrack series30 Bird’s full-color, 8-page
ShortTrack Training Cards are a new approach in training and support.
No time for a 2-, 4-, or 8-hour class? No problem. These cards are
designed to make it easy to lead students through the basics they need
to get their jobs done in the shortest time possible. Or just hand them
out and let your people use them for reference. The choice is yours with
ShortTrack Training Cards.
..
30 Bird’s full-color, 8-page ShortTrack card provides the basic concepts and skills to start being productive with Visio 2019. ShortTrack cards provide easy-to-follow instructions 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.The Visio 2019 ShortTrack card will show you how to:
Open, create, and save diagrams.Work with the Shapes pane.Place shapes on a page.Align shapes using a guide.Use the Dynamic Grid for placing items.View and add connection points.Work with dynamic connectors.Add arrows and other line ends to a connector.Use AutoConnect to link shapes.Add text to shapes.Move or rotate text on a shape.Create a text box.Format a line.Apply a theme or QuickStyle.Create a layer on a page.Change layer properties.Work with pages.Set the drawing scale for a page.Work with comments.Save a diagram in another file format.Add data to shapes.Create a custom data set.Create a shape report definition.About the ShortTrack series30 Bird’s full-color, 8-page
ShortTrack Training Cards are a new approach in training and support.
No time for a 2-, 4-, or 8-hour class? No problem. These cards are
designed to make it easy to lead students through the basics they need
to get their jobs done in the shortest time possible. Or just hand them
out and let your people use them for reference. The choice is yours with
ShortTrack Training Cards.
..
30 Bird’s full-color, 8-page ShortTrack card provides the basic concepts and skills to start being productive with Word 2019. ShortTrack cards provide easy-to-follow instructions 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.The Word 2019 ShortTrack card 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.
About the ShortTrack series30 Bird’s full-color, 8-page
ShortTrack Training Cards are a new approach in training and support.
No time for a 2-, 4-, or 8-hour class? No problem. These cards are
designed to make it easy to lead students through the basics they need
to get their jobs done in the shortest time possible. Or just hand them
out and let your people use them for reference. The choice is yours with
ShortTrack Training Cards.
..
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
..
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 2019 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...
30 Birds’s full-color, 8-page Microsoft Access 2019 ShortTrack provides the skills needed to be able to get started using Access 2019. ShortTracks provide easy-to-follow instructions and are perfect for on-location and remote office workers, virtual classroom students, and home users.The Microsoft Access 2019 ShortTrack card will show you how to:Navigate the Access 2019 interfacePlan a databaseApply normalization rulesOpen a databaseChange an object's viewCreate a databaseCreate a tableSet multiple primary keysCreate unique indexesAdd data validationCreate a field or record validation rulesCommon validation operatorsCreate relationships between tablesWork with relationshipsCreate a queryAdd records to a tableEnter data in a table or formCreate a formAdd controls to a form or reportCreate calculated controlsCreate a report with the Report WizardFilter data in a reportImport data from an Excel spreadsheetConvert a report to a Word documentExport a database object as an XML fileFind and replace data in a tableCompact and repair an Access fileBack up an Access databaseUse keyboard shortcutsAbout the ShortTrack series30 Bird’s full-color, 8-page ShortTrack Training Cards are a new approach in training and support. No time for a 2-, 4-, or 8-hour class? No problem. These cards are designed to make it easy to lead students through the basics they need to get their jobs done in the shortest time possible. Or just hand them out and let your people use them for reference. The choice is yours with ShortTrack Training Cards.
..
30 Bird’s full-color, 8-page ShortTrack card provides the basic concepts and skills to start being productive with Excel 2019. ShortTrack cards provide easy-to-follow instructions 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.The Excel 2019 ShortTrack card 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.About the ShortTrack series30 Bird’s full-color, 8-page ShortTrack Training Cards are a new approach in training and support. No time for a 2-, 4-, or 8-hour class? No problem. These cards are designed to make it easy to lead students through the basics they need to get their jobs done in the shortest time possible. Or just hand them out and let your people use them for reference. The choice is yours with ShortTrack Training Cards.
..
30 Bird’s full-color, 8-page ShortTrack card provides the basic concepts and skills to start being productive with Outlook 2019. ShortTrack cards provide easy-to-follow instructions 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.The Outlook 2019 ShortTrack card 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.About the ShortTrack series30 Bird’s full-color, 8-page ShortTrack Training Cards are a new approach in training and support. No time for a 2-, 4-, or 8-hour class? No problem. These cards are designed to make it easy to lead students through the basics they need to get their jobs done in the shortest time possible. Or just hand them out and let your people use them for reference. The choice is yours with ShortTrack Training Cards.
..
30 Bird’s full-color, 8-page ShortTrack card provides the basic concepts and skills to start being productive with PowerPoint 2019. ShortTrack cards provide easy-to-follow instructions 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.The PowerPoint 2019 ShortTrack card will show you how to:Open. Create, and save presentations.Working with slides.Working with slide masters.Changing bullet formatting in a list.Inserting icons.Inserting lines, shapes, pictures, screenshots, and SmartArt graphicsInserting videos and 3D modelsInserting tables and charts.Adding slide transitions.Adding Zooms.Rehearsing a presentation.Running a presentation.Printing slides, handouts, notes, or an outline.Creating a video of a presentation.Packaging a presentation for a CD.About the ShortTrack series30 Bird’s full-color, 8-page ShortTrack Training Cards are a new approach in training and support. No time for a 2-, 4-, or 8-hour class? No problem. These cards are designed to make it easy to lead students through the basics they need to get their jobs done in the shortest time possible. Or just hand them out and let your people use them for reference. The choice is yours with ShortTrack Training Cards.
..