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...
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...
Microsoft Outlook 2021/365 Level 2 provides more advanced concepts and skills for Microsoft Outlook productivity: how to organize Outlook items, use advanced message properties, and collaborate with others.You will benefit most from this course if you have a basic knowledge of Outlook and plan to continue on to become an Outlook expert.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 Level 1 course, or have equivalent knowledge.For more information and access to the PowerPoint files, please e-mail sales@30bird.com...
Welcome to Microsoft PowerPoint 2021/365 Level 1. This course provides the basic concepts and skills that you need to start being productive with Microsoft PowerPoint: How to create, navigate, format, and customize PowerPoint presentations.You will benefit most from this course if you want to accomplish basic workplace tasks in PowerPoint, or if you want to have a solid foundation for continuing on to master PowerPoint.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.For more information and access to the PowerPoint files, please e-mail sales@30bird.com...
Welcome to Microsoft PowerPoint 2021/365 Level 2. This course provides advanced concepts and skills for PowerPoint 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.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 Level 1 or have equivalent knowledge in the core skills of using Microsoft PowerPoint.For more information and access to the PowerPoint files, please e-mail sales@30bird.com...
Welcome to Microsoft PowerPoint 2021/365 Complete. This course provides the basic and advanced concepts and skills that you need to be a power user of Microsoft PowerPoint: How to create, navigate, format, and customize PowerPoint presentations, 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.You will benefit most from this course if you want to build your PowerPoint skills to become a power user, or if you want to have a solid foundation in PowerPoint's advanced features.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.For more information and access to the PowerPoint files, please e-mail sales@30bird.com. ..
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 2021/365 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.
..
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...
30 Bird’s full-color, 4-page Quick Reference Card (QRC) provides the basic concepts and skills to start being productive with Office 365. QRCs 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. Contact us to learn about surprisingly affordable branded cards..
The Office 365 QRC provides an overview of the Office 365 apps and services and will show you how to:
Sign in to Office Online and navigate the Office 365 Home pageOpen OneDrive and upload files and foldersShare files and folders from OneDriveGet around OneNote and create a notebookWork with OneNote sections and pagesCreate a SwayShare a SwayShare your calendarGet around in SkypeSend a Skype instant messageCreate a contactCreate external guest groups..
30 Bird’s full-color, 8-page ShortTrack Training Card provides the basic concepts and skills to start being productive with Office 365 SharePoint Online as an end user. 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 Office 365 SharePoint Online (End User) ShortTrack Training Card provides an overview of SharePoint Online and will show you how to:
Access your organization's SharePoint Online portalCreate a new siteCustomize the Quick Launch barAdd, open edit, and delete pagesAdd, edit, move, and delete a web partAdd a News web partCreate News postsAdd a text, table or hyperlinkInsert an Image web partAdd a document libraryCreate, open, upload, and manage documentsCheck out and check in documentsSet and manage document alertsAdd a listCreate an appWork with discussion boards, surveys, and calendarsWork with announcements, contacts, tasks, and issuesCreate a linkAbout 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 2021/365 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.
..