Knowing how to work with databases, analyze spreadsheets, and design presentations are essential in the modern workplace. These courses can help you develop these skills for the first time or build on those you already have. You can choose which courses to take based on your skill level. If you are a beginner, or looking for a refresher course online, start with the basic lessons and work your way up. If you have some prior knowledge and want to further your skills, jump right into intermediate or advanced courses.
To View these Webinars: visit MyPLN at achieve.lausd.net/mypln. Select the search button and search for a course using a keyword from the course title.
ACCESS
| Access 365 Beginner | This course is an introduction to Microsoft Access 365. In this course, students will become familiar with various database components, concepts, and terminology. | 280 minutes |
| Access 365 Intermediate | This course is designed to teach students intermediate-level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. | 257 minutes |
| Access 365 Advanced | Access 365 Advanced will further build upon the topics covered in the Access 365 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create and modify Switchboards, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), and use Table Events. | 105 minutes |
EXCEL
| Excel 365 Beginner | This course is designed specifically to teach the fundamentals of Excel and provide the skills needed to begin to create and manipulate worksheets. Viewers will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. They will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. They will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing workbooks. | 288 minutes |
| Excel 365 Intermediate | In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features. | 272 minutes |
| Excel 365 Advanced | This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. | 261 minutes |
| Excel Tutorial: Learn Excel in 30 minutes | This is a YouTube video introduction to Excel. | 30 minutes |
GOOGLE DRIVE
| Google Drive - dummies | Follow the basic instructions in these micro-learning videos to master the use of Google Drive. Beyond the basics, this course teaches cool tips to use with Drive and common errors to avoid. Understand how to sync and use the application across all types of mobile devices. | 19 minutes |
| Google Drive: Getting Started | Google Drive is a cloud-based storage solution that allows one to store and access files. Explore Google Drive, and discover how to work with its storage tools. | 71 minutes |
| Google Drive: Organizing Documents | Explore methods of keeping organized with Google Drive, including how to sort, filter, and search for files. Also, discover how to use and manage folders for better organization. | 45 minutes |
| Google Drive: Working More Efficiently | Participants learn how to speed up document creation with the new domain name shortcuts, get access to other Google services without leaving the Drive interface, and use Offline mode to edit documents, even when the connection drops. Participants will also discover the new Priority view and workspaces, giving intelligent suggestions on documents that are most relevant, and helping manage work more efficiently. | 34 minutes |
| Mastering Google Drive | Learn to collaborate and store, share, and access your files any time from any device. | 71 minutes |
OUTLOOK
| Outlook 365 Beginner | This course is designed to teach students the basics of Microsoft Outlook 365 and help them gain familiarity with the Outlook environment and basic functionality. Students will learn the basics of email, how to use the Help feature, how to create and send messages, and how to work with attachments. Students will also learn organizational techniques through the use of folders, views, categories, flags, and searching. Additionally, students will review printing options, automatic replies, contact creation and management, calendar use and management, task and note creation and management, message options, and email signatures. | 283 minutes |
| Outlook 365 Advanced | In this course, students will expand upon their existing knowledge and learn and use advanced features of Microsoft Outlook 365. Students will modify and manage message options, track and delivery options, voting options, contact options, calendar options, and other advanced Outlook features. Students will also review rules and automation, cleanup commands, sharing options, advanced graphic options, junk mail options, import and export features, and how to back up their Outlook data. | 134 minutes |
POWERPOINT
| PowerPoint 365 Beginner | In this course, students will get started with PowerPoint 365 and become familiar with the Ribbon, interface, and navigation options. Additionally, students will create a presentation and work with various features and commands to make it easier to work in PowerPoint. Students will also review presentation editing options, text formatting options, various graphic options and insertion methods, how to add, edit, and format tables and charts in a presentation, and various presentation preparation and delivery options. | 283 minutes |
| PowerPoint 365 Advanced | Learn the various collaboration tools in Microsoft PowerPoint 365. | 180 minutes |
| PowerPoint Office 365 (Windows): Adding Animations | This 8-video course explores how to use animation to create a visually interesting presentation by using PowerPoint for Office 365. | 38 minutes |
WORD
| Word 365 Beginner | This course is designed to introduce students to the basic functionality and user interface of Microsoft Word 365. In this course, students will learn the basics of saving and opening documents and review the interface. Students will practice text navigation, selection, entry, and various other text formatting and editing commands and features. Additionally, students will work with bulleted and numbered lists, tables, and their various features and options. Students will also work with graphics and the various tools available in Word 365 to format and edit them. Lastly, this course will cover various options for viewing documents, proofing options for documents, and settings to prepare documents for distribution and publication. | 246 minutes |
| Word 365 Intermediate | This is the intermediate course in the Microsoft Word 365 series. This course expands upon the topics covered in the Word 365 Introduction course. In this course, students will work with, create, manage, and customize Styles, Templates, and Themes. Students will also work with various types of data in Word using Tables, advanced Copy and Paste commands, and Charts. Students will then review advanced document layout options in Word and various collaboration tools. Lastly, students will work with graphic elements such as pictures, text boxes, shapes, the Drawing Canvas, SmartArt, Text Effects, Typography Effects, WordArt, and Equations. Additional graphic element features such as grouping, layering, and moving objects will also be covered. | 387 minutes |
| Word 365 Advanced | In this course, students will automate with Microsoft Word 365 through the use of building blocks, Quick Parts, fields, and Macros. Students will also utilize reference tools such as bookmarks, hyperlinks, cross-references, footnotes, endnotes, bibliography tools, sources, and placeholders. Students will also learn techniques to manage long documents through a table of contents, indexing, and captions. Students will also work with Outline View and master documents, Mail Merge, and forms. | 342 minutes |