APCUG 2018 Fall Virtual Technology Conference (VTC30)

Thank you to all of the presenters – they were outstanding. Also, thanks to all who attended the last VTC of 2018. See you at the  2019 presentations.

SAVE THE DATES
February 9
May 4
August 17
November 2

Thanks to Leah for sending me a short review for each of the presentations she attended. I can always count on her to have something to add the VTC area post-conference. She includes longer reviews in her newsletter the month after the VTC. JT

From Leah Clark, President, Los Angeles Computer Society
I thank all the people who made the 2018 Fall Virtual Technology Conference such a wonderful learning experience. I attended three sessions, and plan to pick up the other three on YouTube.

Take Control of Your Passwords: Joe Kissell gave an excellent presentation on managing your passwords. He made me realize that I need to do something about my mess of passwords. That will be my New Year’s Resolution!

Excel Magic: Alan Salmon had many tricks for the accountant and other Excel users to save work and increase productivity. I didn’t know there were so many ways to customize Excel to make it more user friendly!

Windows 10 – October Release: Bill James introduced some of the new features in the latest Windows 10 version – there are a lot. He made it easier for me to know what to look for and how to take advantage of them.

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).

It_it’s_Connected_It_needs-to_be_Protected_BobG_ FOLLOW-UP_Info_

Equifax Video

YouTube Video

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.

Cut_The_Cord_HewiePoplock_11-3_APCUG_VTC)

Cut_The_Cord_REFERENCES_HewiePoplock_11-3_APCUG_VTC

Cutting the Cord in Canada

YouTube Video

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

YouTube Video

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.

Password_Managers_JoeKissell_11-3_APCUG_VTC

YouTube Video

 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.

Windows_10_1809_MadeEasy_BillJames_11-3_APCUG_ VTC

Windows_10_ v1809_ HANDOUT_BillJames_11-3_APCUG_VTC

YouTube Video

3:00 PM ET

Digital Literacy with TechBoomers
Kay Fleury, TechBoomers.com Content Manager & SEO Specialist

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.

Digital_Literacy_With_Techboomers_Kay Fleury_11-3_APCUG-VTC

Techboomers Relaunch Tour

YouTube Video