Office Applications   

Discover how to design creative and impactful training sessions. This course outlines several strategies you can use to elevate your trainings, such as designing interactive modules, incorporating gamification, adding visuals, and leveraging advanced tools and technologies. After this course, you'll be able to bring your training to life with creative strategies that will create an engaging learning environment for everyone.

Accurate data is the foundation of effective reporting and decision-making. This course teaches users how to leverage Excel’s powerful data validation tools and techniques to improve data quality, consistency, and reliability. Following the principle of “garbage in, garbage out,” learners will discover how properly validated data can prevent errors, reduce rework, and improve confidence in reports and analyses.

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.

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.

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.

Learn to create, format, and manage documents with confidence. This course covers core skills: text editing and movement, advanced text formatting (size, font, appearance), professional layout controls (margins, tabs, alignment), and productivity tools like the integrated spell/grammar check and thesaurus. You will also learn to work with multiple documents and efficiently save, retrieve, and organize your files.

Learn advanced techniques to create professional, visually rich documents and boost your productivity. This course covers everything from Headers and Footers to timesaving formatting tricks. You will master setting custom margins, tabs, indents, and spacing, and learn to effectively work with complex elements like Tables, Pictures, Shapes, and Hyperlinks. Transform your documents with professional design insight.