Toledo Tech Events

Microsoft Excel 2016 Level 2 builds on skills learned in Level 1. This course offers lessons for Microsoft’s spreadsheet program, including:

Creating advanced formulas Analyzing data with logical and lookup functions Organizing worksheet data with Tables Visualizing data with Charts Analyzing data with PivotTables, Slicers, and PivotCharts Inserting graphics Enhancing workbook

Fee $135

Join Toledo VMUG for our first meeting of 2020!

Our meeting will cover various security threats that companies face every day when dealing with IT.

We're excited to have CentraComm as our event sponsor. They are a leader in IT Services for networking and cyber security.

Agenda

11:30 AM – Welcome, Announcements, and introductions

11:35 AM – 1:00 PM Security - CentraComm

Lunch for attendees will be provided by Shorty's Barbeque

Learn more about Excel's functions to work with data. Topics include IF, AND, OR, SUMIF, SUMIFS, VLOOKUP and HLOOKUP.

Fee $40

Don't miss our first ever (OH)NUG event in Toledo!

For our inaugural event in Toledo Ohio, we'll be at the Maumee Bay Brewing Company on Broadway. We will host a combination of individual speakers and panel discussions for this event, more information will be available soon.

The Ohio Networking User Group is: "A vendor neutral environment to talk networks. With beer."

We are engineers that can't wait to unbox that new router, firewall or switch. We have network virtual appliances running in virtual machines on our laptops. We follow network luminaries to learn where the network world is headed and where it's been. Wireshark is a 2nd language. If you do these things too, we're like you, lovers of all things networking!

Microsoft Excel 2016 Level 2 builds on skills learned in Level 1. This course offers lessons for Microsoft’s spreadsheet program, including:

Creating advanced formulas Analyzing data with logical and lookup functions Organizing worksheet data with Tables Visualizing data with Charts Analyzing data with PivotTables, Slicers, and PivotCharts Inserting graphics Enhancing workbook Fee $125

This course explores the advanced features in in Excel. Students will cover how to automate worksheet functionality, audit worksheets, analyze data, work with multiple workbooks, and export Excel data.

Fee $125

Trying to find trends in raw data can be difficult. Learn to create pivot tables from your data in Excel. In this course we will create pivot tables and pivot charts from data in Excel as well as external data sources. Learn how to manipulate the information and modify the pivot table to answer your important questions.

Fee $40

This summer 39 teachers from the Toledo area participated in a GenCyber Teacher Camp. This was our second year hosting the program thanks to a grant from the NSA and NSF. Participants learned about networking (wired and wireless), cyber security, coding, jobs in cyber, cyberbullying and more. They programmed a Sphero robot, set up a Raspberry Pi, connected to a router and prepared lesson plans to take back to their classrooms.

On February 12, 3:30 - 5:00 pm we are holding a resource fair for teachers who have participated or applied to these camps and would like to invite you to be involved. We will have a resource fair with tables for local IT organizations that provide services/resources for IT education (such as equipment, bootcamps, speakers, etc) along with a speaker on Cyber Security. The program will be held at our facility at UT Scott Park. There is no cost to participate, it is a great opportunity to network with others in IT and with K-12 educators with a goal of increasing awareness for the need for cyber awareness.

IT Professionals email tnorris@northweststate.edu to attend. Teachers may use the eventbrite link. This is a free event.

Snow date is 2/26/20

Join Spaceshop Commerce for the latest tips, tricks and trends in ecommerce. Come learn more about selling on Amazon, Shopify and Magento.

We're Toledo's only certified Amazon, Shopify and Magento ecommerce agency and we're hosting this event to help local brands and manufacturers learn more about the future of ecommerce, and how it can work for businesses large and small.

Join us at Souk Mediterranean Kitchen and Bar for cocktails, snacks, networking and insight from our leadership team, along with special guests to be announced.

Walk away knowing more about the latest trends, tools and techniques to take your ecommerce efforts to the next level in 2020 and beyond.

This session is designed for brands, manufacturers, retailers, creative agencies and any organization interested in expanding their ecommerce efforts.

The SQL Coding Boot Camp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. We will use a combination of lectures and hands-on exercises to ensure participants leave with a working grasp of SQL fundamentals. If you’re trying to learn more about your business or add more value to your company, learning SQL is a great place to start. SQL is a programming language that is used to manage information and data structures stored in databases. With SQL, you can order and sort your data in any manner you’d like.
Class meets Thursday nights 6-9 pm for 12 weeks.
Starts 2/27 - 5/14. Fee $500

The SQL Boot Camp is for you if: 1. You want to use SQL to store data or gather insights 2. You are new or need a refresher on SQL concepts 3. Want to learn relational database concepts, SQL fundamentals and compose basic queries. 4. Automate workflow with stored procedures 5. Create views, subqueries and conversion functions. 6. Create your own SQL database, manipulate tables and store advanced code. 7. Want to go beyond data kept in a spreadsheet that tracks one thing at a time.

PowerPivot is a free add-in that expands the features and capabilities of Pivot Tables with advanced calculations and data connections. It also includes the ability to work with large amounts of data from a variety of data sources. This course is intended to help new PowerPivot users get up to speed on how it works and its features.

Fee $40

You have created a basic pivot table, now let's learn to take it up a few steps. In this interactive webinar we will dig deeper into calculations, report filter pages, connecting multiple tables to one slicer, percentages of totals, grouping, pivot charts and connecting to external data sources.

Fee $40

Students will learn how to use stencils, scale and resize objects, draw basic shapes, and distribute and group objects. They will also learn how to create diagrams, work with text, format shapes and lines, and apply a background page.

Fee $40

E-Week | April 20-24, 2020

• Paul J. Hooker Center Hall of Fame (by invitation only) - April 22
• HatchTonight & The Hatch - April 23
• Sebo Series in Entrepreneurship - April 24