You're browsing Tech Classes in Online

Master VLOOKUP, Pivot Tables, formulas and functions in this intermediate Excel course. Build on your basic Excel knowledge by learning more advanced techniques like Sort & Filter, logical functions, and time-saving tricks. The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter,...

Learn to create beautiful websites with engaging, expressive web typography for maximum impact. Provide the best reading experience using responsive typography to create better experiences for users on all sizes and resolutions. Explore great ways to work with new techniques such as how to spice up your type with CSS animations, when to use variable...

Database professionals in the labor economy are on the rise and are creating a surge for individuals who possess the right skills to store and query large data sets. This introductory course is designed for those who have some or no knowledge of databases. The goal is to teach participants how to query a relational database for information and analysis....

Create and document a design system by extending your designs and visual style to other products while keeping the cross platform experience consistent. Design systems includes style guides, pattern libraries, collections of reusable interface components, CSS frameworks, and repeatable design operations.  A robust design system serves as a critical...

In this hands-on graphic design bootcamp, you will expand your knowledge of design concepts and processes while producing portfolio projects. This class focuses on how to design and assumes knowledge of Photoshop, InDesign, and Illustrator. Throughout the course, you'll produce several portfolio projects, including logos, social media graphics, stationery,...

WorkShop Includes:  Logical Test  IF, AND, OR Functions  SUMIFS Function  INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data  Date Function Table Objects

Human-centered design for Emerging Platforms, includes developing strategies for smartphones, smart appliances, apps, Virtual Reality (VR), Augmented Reality (AR), digital assistant(AI), You will design compelling and useful products that span across digital platforms and include arrangements on tablet, smartphone, and emerging platforms and whatever...

Master basic calculations, formulas, and functions in this introductory Excel course. Beginners who take this course will learn tips and tricks to make navigating Excel easier and faster. Get the hang of Excel formulas, functions, charts, and workbook formatting. This beginner course is the perfect introduction to Excel for self-taught users and...

Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Class Outline: Lesson 1: Working with Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date & Time Functions Topic E: Work...

Java is one of the most widely used computer languages in the world. This course is designed to develop the fundamental skills and basic concepts needed to begin writing any code. Students will use the Java platform to create an assortment of programs and especially mobile and web applications. Sign up today! Note: This class is delivered virtually...

"Make your images match the moment". Adobe Lightroom makes photo editing easy, with simple, user-friendly steps that let you take control of your photographic workflow. Session 1: Learn how use the Library Module to import and organize your photos. Session 2: We'll introduce you to the Develop Module, with editing tools to reduce distortion, straighten...

WorkShop Includes: Filters, SUBTOTAL VLOOKUP Merge Data with Lookup Functions Error Handling Tables Pivot Tables Must-Know Keyboard Shortcuts Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work files after class. They serve as a great...

Learn how to build basics spreadsheets & get comfortable using Microsoft Excel in working environment. This workshop is best suited for those who have very little or no experience with Microsoft Excel. Workshop Includes: Overview Of Microsoft Excel User Interface Working with Workbook Working with Worksheets Working With Worksheet Tabs ...

This 20-hour Machine Learning with Python course covers all the basic machine learning methods and Python modules (especially Scikit-Learn) for implementing them.  The five sessions cover:  simple and multiple Linear regressions; classification methods including logistic regression, discriminant analysis and naive bayes, support vector...

From suggesting your next binge-watching spree to predicting the stock market, Python is used for analyzing data and automation tasks in practically every high-growth industry. In this fast-paced course, you’ll learn practical applications of Python so that you can start contributing valuable insights to your company or to land your first job in...