In this session you will learn additional basic functions, how to create worksheets within a workbook and copying a worksheet between workbooks, different paste option and how they can be useful. We will also cover conditional formatting with practical applications. This series is designed for those who are new to Excel or who have not worked with Excel for a while. We will start with the basics and take you to a place where you can comfortably work with and even create your own spread sheets. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.

This session will explore the many applications of Excel's powerful table function. We will begin by learning about text functions to clean up your data set then how to create a table, options for esthetics, table characterizes, sorting and filtering and using the powerful total functions. We will also look at how to create slicers This series is designed for those who are new to Excel or who have not worked with Excel for a while. We will start with the basics and take you to a place where you can comfortably work with and even create your own spread sheets. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.

This session will explore important text functions, splitting and combining text, criteria-based count functions, error checking, using AI features in flash fill and useful date functions. This series is designed for those who are new to Excel or who have not worked with Excel for a while. We will start with the basics and take you to a place where you can comfortably work with and even create your own spread sheets. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.

This session will explore creative ways to use free AI applications to automate routine tasks using a number of free AI applications and features of AI included in existing applications and how you can use them to time by automating many tasks including generating draft letters, tracking information, preparing schedules, writing procedures, performing tasks in Excel without needing to know functions, etc. We will be looking at the free version of Microsoft CoPilot, the Editor feature in word, the designer in PowerPoint and flash fills in Excel. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.

This workshop will explore practical ways that you can use two popular note taking applications. Google Keeps and OneNote. Many uses abandon these applications because the potential of these applications is not readily apparent. We will focus on practical and creative uses to organize ideas, create timelines and action plans and collaborate with others but most importantly free up your brain to focus on think work. We will explore ideas like parking lots, mind mapping, team sharing, project action items, fitness tracking, communication and collaboration. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.

This session will explore innovative ways to organize and manage your electronic folders and files in Google Drive. Topics will include How to upload and organize your folders, making priorities folders appear first, color coding folders, effectively organizing documents that are shared with you. Converting documents to word, excel or PDF. Sharing documents and folders and various sharing options. Advanced searching, creating tags, and using keyboard shortcuts. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.

This session will explore innovative ways to manage and organize your electronic folders and files in one drive. Topics will include how to upload and organizing your folders, launching online versions of applications using OneDrive. Accessing documents remotely on home computers that do not have desktop licenses for office 365 thru your school account, sharing documents and folders. Advanced searching and viewing modes also will be covered. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.

Whether you are a beginner to Excel or a seasoned pro. Excel tables are a powerful tool to help you organize, sort, and filter your information and generate beautiful reports without having to know or remember complex subtotaling functions. This session will explore how to convert Excel data into tables, Sort and Filter, including filtering by a logical operator, automatically totaling data, using slicers and easily creating multiple detailed reports from one set of data. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.

Participants will learn tips and strategies in Microsoft Outlook to quickly search and navigate through their inbox, create tasks and appointments from email messages, manage their calendar and meetings, work with notes and contacts, and be more productive overall. Topics will include: Creating folders, automatically filtering emails including retroactively, creating search folders, delayed delivery, muting reply all, using quick steps, and setting up reply to. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.

This session will explore ways that you can effectively manage your Gmail account. Topics will include creating filters, automatic filtering, using templates, archiving verses deleting old emails, priority inbox options, changing the esthetics, preview options, creating a calendar event from an email. Including a calendar in your outgoing email. Muting "reply all” emails to eliminate clutter. We will also explore tips and tricks in Google Calendars including calendar keyboard shortcuts different views setting multiple reminders, creating a deadline calendar. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.

This session will be a combination of general tips and tricks as well as cover the basics of importing and exporting existing spreadsheets, file management and document sharing. We will also explore important differences between sheets and Excel as well as look at way Sheets shines as an application especially for the beginner user. Assigning tasks, using checkboxes, dropdowns and smart chips also will be covered. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.

Microsoft spent over a billion dollars developing Word and the rest of the office suite, there are so many features, some that are well known and many that are not. We will dive deep exploring ways to create different types of documents and enhance all documents. Whether you are a beginner or a seasoned pro, you will come away with many new tools in your word toolbox. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.

When people think about google forms they usually think about surveys. In this workshop we will explore more creative ways to use the application including taking phone messages, planning and reflection, conducting inspections and audits, creating a work order system, help desk inquiries and routing, data entry, tracking inventory, logging usage of supplies, etc. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.

Yes, you can do presentations using Google Slides. In the session we will compare capabilities between Google Slides and PowerPoint and how to convert presentations between one application and another. Topics will include using themes and creating your own, using slides to create fliers and cover pages for reports, adding tables, images, etc. Plus, general tips for creating highly effective presentations. Please note: Cancellation policy: If a participant has registered for, but is unable to attend, a Nassau BOCES workshop, they are required to drop their workshop registration on Frontline/MLP at least 5 days prior to the start date of the workshop. In the event the participant does not cancel within this timeframe, the participant/district will be billed.