APCUG 2018 Fall Virtual Technology Conference (VTC29)

Welcome to our last 2018 VTC. Please go to Eventbrite to register. You don’t need an Eventbrite account to attend the event.

November 3, 2018

TRACK 1

1:00 PM ET

If it’s Connected, it needs to be Protected!

Bob Gostischa, Avast Evangelist

Learn why and how things that are connected to the Internet need to be secured and protected. Bob will explain how the current dangers that face us every day can affect the device itself, our privacy, network, and more. He will also share what he uses to keep his computers, smart devices and other connected things that are a part of the IoT secure.

This presentation covers: Computers (Windows and Mac), Tablets, Phones and the IoT (Internet of Things).

2:00 PM ET

“Cut the Cord, Things to Consider Before Firing Your Cable Company”

Hewie Poplock, Central Florida Computer Society Windows SIG leader; APCUG Representative

There are many reasons to cut the cord. Most do so to save money. Others do it to have better choices and just to be able to fire their cable company. There are many choices of products and equipment, as well as services that are now available to let us change the way we have done things in the past. Hewie will talk about over the air and over the Internet services, including the many ways to fulfill your wants and needs as to TV viewing. He will include information about Broadband and even Internet home phones.

This presentation will help you understand many of the newest possibilities for TV viewing and what to look for to satisfy you and your family. Be prepared to have a lot of the confusion make some sense and to determine if it may be the move for you soon. TV, as we know it will disappear in the next few years and you will understand what is happening and what choices are available now and what to look for down the road.

3:00 PM ET

Excel Magic

Alan Salmon, ASc, FCPB, PHF, President, Alan Salmon & Associates Inc.

Founder, K2E Canada Inc.

Excel is the tool of choice for analyzing and reporting financial data, yet many use time consuming and error-prone processes to complete everyday tasks. In this webinar, you will learn countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency.

LEARNING OBJECTIVES

Upon completing this webinar, you should be able to:

  • Identify situations in which various Excel features can increase productivity and apply each of these techniques in context, such as Freeze Panes, Split Windows, selecting cells with special characteristics, AutoCorrect, the Office Clipboard, and Paste Special Implement tools and techniques for formatting data in Excel, including multiline column headings, the Accounting Format, custom date and number formats, and Conditional Formatting
  • Customize Excel’s user environment, including the Ribbon and the Quick Access Toolbar, adjust Excel’s Options to improve efficiency, and create and use Templates to increase efficiency and productivity
  • Utilize various formula building tools to create formulas more efficiently and create various types of formulas, including formulas, to manipulate text and dates, formulas containing VLOOKUP and HLOOKUP functions, formulas that contain conditional calculations, and formulas that contain circular references

TRACK 2

1:00 PM ET

Take Control of Your Passwords

Joe Kissell, Publisher, Take Control Books

Password overload has driven many of us to take dangerous shortcuts. If you think ZombieCat12 is a secure password, that you can safely reuse a password, or that no one would try to steal your password, think again! Learn how to overcome password frustration while keeping your data safe.

 2:00 PM ET

Hands-on Demo – Windows 10, October Release

Bill James, Vice President, Computer Club of Oklahoma City; Advisor, Region 8

From a rollout that was quickly pulled due to users missing data after the install, to the ‘fixed’ version being sent to the Insider community to see if they have any problems with the ‘fixed’ version, to the October version finally being released to the world, Bill, who has been part of Microsoft’s Insider program for many years, will give a hands-on demo of what’s new in version 1809.

3:00 PM ET

Digital Literacy with TechBoomers

Steve Black, TechBoomers Founder and CEO

Techboomers.com is a free educational website that teaches older adults and other inexperienced Internet users with basic computer skills about the most popular and useful Internet-based products available that can help improve their quality of life.

TechBoomers’ tutorials and articles cover: Shopping Online, Online Entertainment, Social Media Websites and Apps, Useful Websites and Apps, and Technology Basics.

Use the tutorials for SIG meetings, a hands-on presentation at your club meeting, turn the tutorial into a PowerPoint presentation to give at your user group meeting, etc.