PowerPoint Advanced Concepts: Looped presentations, additional animation, inserting links and sound In this 90-minute webinar we'll talk about looped presentations, discuss how to insert objects from other programs like Word and Excel, and take a deeper look at using sound and animation in PowerPoint. Registration ends by 5pm the day prior to the Webinar. Once...
Excel Focus on Functions- Work with Text and Dates: CONCATENATE, TODAY, Flash Fill and Delimited Text Text strings and dates can cause big problems in a spreadsheet if you're not aware of how to identify and manipulate them! In this 90-minute webinar we'll talk about basic text functions like CONCATENATE and date functions like TODAY....
Word tables are an underrated tool available in Word! We'll look at how to identify tables, table options, and how they can be used. This 90-minute webinar looks at additional Word tools like mail merge, tables, track changes and AutoCorrect. These are useful tools for anyone who wants to expand their Word skills. Word tables...
Excel Advanced Concepts - Additional Data Analysis tools - Data validation, Subtotal and What-Ifs This 90-minute webinar focuses on some of the additional tools available in Excel that are very useful but often overlooked. We'll talk about data validation, the Subtotal feature (an alternative to pivot tables), Find & Replace, and Conditional Formatting. Additional Data...
Google Docs and Sheets Basics: Get started with Google's popular text and spreadsheet applications In this 90-minute webinar we'll explore Google's online alternatives to MS Word and Excel. Google Docs can be used to create letters, reports, resumes and other text-based documents. Google Sheets allows you to create spreadsheets using many of the same functions...
Excel Advanced Concepts - Get Started with Excel Tables You've heard of Excel tables but never had a chance to use them? Learn how to structure Excel tables, understand the differences between normal ranges and tables, and the advantages of using tables to create more complex pivot tables. Registration ends by 5pm the day prior...
Excel Advanced Concepts: Customize your spreadsheet with Conditional Formatting, Links, Protection and basic macros This 90-minute webinar focuses on some of the additional tools to help you customize your spreadsheet. We'll look at Conditional Formatting, different types of protection, link options and how to get started with VBA macros. Registration ends by 5pm the day...
Excel Advanced Concepts - Dashboards: Use PivotTables, Sparklines, Charts, VLOOKUP to create Excel Dashboards Dashboards are at-a-glance summaries that use graphics to illustrate progress towards a goal. Excel has a number of features like PivotTables, PivotCharts, Sparklines, and Functions that can be combined to create surprisingly robust dashboards. We highly recommend you have some familiarity...
Canva Basics - Create content for print, presentations and social media with this free online graphic design app You don't need to be a graphic designer to produce professional looking designs! By utilizing Canva's built-in templates, photo and font options anyone can create exciting content to be shared online, posted on social media site, or...
Excel Basics (Part 1): How spreadsheets work, basic formulas, functions, and formatting This webinar is part 1 of a 3-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this webinar we'll talk about the Excel environment, explore basic formulas and functions, and discuss spreadsheet formatting options....
Word Basics: Basic editing and formatting: fonts, bulleted lists, indentation, and line spacing This 90-minute webinar is designed to introduce key concepts crucial to building a working knowledge of MS Word. In this webinar we'll talk about the Word environment, and explore the essential editing/formatting tools necessary to create basic documents. Preregistration is required to...
Excel Basics (Part 2): Sort and filter data, work with columns, rows, sheets, and copy/paste This webinar is part 2 of a 3-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this 90-minute webinar we'll learn to sort and filter, work with columns, rows and sheets,...
