Office Applications   

Spreadsheets are essential in today's workplace. Discover the fundamentals that will help you succeed. Explore the Excel Interface, Distinguish between various mouse pointers, employ efficient worksheet navigation, enter labels/values, edit and format a worksheet and even get an introduction to formulas.

Spreadsheets are essential in today's workplace. Discover the fundamentals that will help you succeed. Explore the Excel Interface, Distinguish between various mouse pointers, employ efficient worksheet navigation, enter labels/values, edit and format a worksheet and even get an introduction to formulas.

Large excel spreadsheets can quickly become difficult to translate. Learn to communicate information visually with the use of Excel Charts. Explore and fine-tune your chart elements with ease. Learn to manage workbooks, exploration of special formatting, advanced page layout and printing features. Also get an introduction to Excel functions to prepare you for Excel III & IV.

Learn to create date and text filters for viewing information more efficiently. Learn how to use subtotals, a powerful analyzing tool, and more for filling/copying data more efficiently. This class also serves as a formal introduction to formulas and functions, so you will walk away knowing how to create formulas and copy them correctly using relative and absolute referencing. Use statistical functions (Sum, Average, Min and Max) and logical functions (If, And, Or) and paste special options.

Review basic building-block functions and a few critical keyboard shortcuts that will speed up working with Excel data. Perform advanced searching and data retrieval with Lookup Functions, tabulate and sort data with counting and statistical functions, formulate data with text and math functions, and even work with financial data using advanced formulas. Practical examples that will help you transition to using these formulas and functions in real-world scenarios will be provided.

Learn even more advanced way to use Excel Pivot table reports! Find out how to use the PMT Function, Create What-If Data Table, Solve a Problem with Goal Seek, Use Solver to Resolve Problems, Create Lookup Functions, Create PivotTables and PivotCharts, and Use the PivotTable Field List.

Master the fundamentals of creating, editing, and sharing documents with Google Docs. Learn text formatting, inserting images, setting page layout, and organizing content with bulleted and numbered lists. The course emphasizes Docs' core strength: real-time collaboration using comments, suggested edits, and managing version history.

Elevate your documents with advanced features for professional-level results and efficiency. You will learn to work with sections, headers, and footers, create and modify tables, use the Explore tool for research and citations, and apply Styles to generate an automatic Table of Contents. We will also cover integrating other Google tools and using document add-ons.

Learn the essential skills to create and manage data with Google Sheets. This introductory, hands-on course covers navigating the Sheets environment, entering and formatting data, using basic formulas (SUM, AVERAGE), and organizing information with sorting and simple filtering. Discover the power of real-time collaboration and how to share your spreadsheets.

Move beyond the basics to unleash the full potential of Sheets for data analysis and visualization. This course focuses on intermediate functions (e.g., COUNTIF, SUMIF, VLOOKUP), conditional formatting to highlight key data, creating and customizing charts, and using Pivot Tables to summarize and analyze large datasets. We will also explore advanced collaboration and data validation techniques.

Get started creating compelling visual presentations with Google Slides. This class will teach you how to select themes, add and arrange text, insert images and video, and use basic transition and animation effects to enhance your slides. Learn to manage your slides, practice presentation basics, and utilize the built-in collaboration features for teamwork.

Take your presentations to the next level by making them dynamic and interactive. Learn to use the Master Slide to control design across the entire presentation, incorporate advanced animations and media, and use hyperlinks to create non-linear, "choose-your-own-adventure" style presentations. Discover how to effectively use the Q&A feature for audience engagement.

Welcome to Introduction to Windows 11. This course is intended to help new users get acquainted with Windows 11 by guiding them through the modern desktop interface and key navigational elements. You will learn essential tips, tricks, and keyboard shortcuts, as well as how to personalize and customize the Windows 11 environment to suit your workflow. This introductory course also covers important new features, including the voice assistant Cortana, the centralized Action Center, and the digital inking tool, Ink Workspace, ensuring you can confidently navigate and utilize your new PC.

Stop sending generic mass emails and letters! This course teaches you how to leverage Mail Merge to personalize bulk correspondence like letters, envelopes, and labels. You will learn the entire process, including creating a new data source (address list) and expertly placing merge fields to automate your documents and save significant time.

Get started with Microsoft PowerPoint and learn the fundamental skills for creating high-impact slide decks. You will master essential elements, including adding and formatting text, images, video, audio, and charts. Discover how to use animation and hyperlinks to engage your audience. Finally, learn how to properly save and distribute your presentations for easy sharing across the web or other media.

Dive deeper into the program's rich feature set to enhance your presentations and boost audience engagement. This course focuses on achieving Professional Design by utilizing Slide Masters for global consistency, mastering Visual Elements such as advanced text options, custom charts, pictures, and SmartArt, and adding Motion & Media through Custom Animations and integrated sound/movie clips for maximum impact. Furthermore, you will learn to build Interactivity by creating a non-linear presentation with Action Buttons for dynamic navigation.