Computer Training and Support
“Do you know Pivot Tables?”
The Pivot Table is probably the most powerful feature of Microsoft Excel, yet it is surprisingly easy to use — IF you know how to play with them. To learn how, watch my new YouTube video:
https://www.youtube.com/watch?v=84_eqAd6tEU.
And please be sure to subscribe!
I’ve created a new video showing Excel beginners how to create a checkbook register. If you follow along with the video, you will end up, not only with a simple but useful spreadsheet, but also with a grasp of some fundamental Excel skills.
For this video I used Excel 2016 running in Windows, but the procedure outlined here can be performed in all recent versions of Excel. If you are an Excel beginner, watch the video, open a blank workbook, and have fun!
https://youtu.be/KtovaP-5NDU
The Excel class this spring at Norwalk Community College will be taught by Rich Malloy. The six-session course is generally taught in the spring, summer, and fall. For information on registering for the course, click: norwalk.edu/extended-studies/.
Date/Time: Mondays, Feb. 25 – April 8, 6-9 pm
For the course syllabus, Click here.
The Excel class this summer at Norwalk Community College will be taught by Rich Malloy. The six-session course is generally taught in the spring, summer, and fall. For information on registering for the course, click: norwalk.edu/extended-studies/.
Date/Time: Tuesdays, June 12 – July 17, 6-9 pm
For the course syllabus, click here.
A budget is probably the most important spreadsheet you can create. A good budget will keep you focused on your ultimate financial goal and help you avoid pitfalls like that adorable timeshare in Aruba. Budgets are also surprisingly popular among rich people, which may partially explain how they became rich.
In this class, we are going to set up two valuable spreadsheets using Microsoft Excel for Windows. First, there’s the all-important budget, but then we are also going to set up an equally valuable ledger to keep track of expenses. In creating these two spreadsheets, we’ll be taking advantage of some of the amazing and powerful features of Excel.
The 90-minute hands-on class will be taught by Rich Malloy and will meet at the Greenwich Public Library on Tuesday, April 24 at 2 pm. All are welcome, but some familiarity with Excel will make the session more rewarding.
For more information, click here.
As part of its Extended Studies division, Norwalk Community College is again offering an Advanced Excel class taught by Rich Malloy. Most people who use Microsoft Excel are familiar with only a few features of this amazingly powerful application. In this hands-on course, students will learn how to use the more robust features of this vitally important business tool.
The course includes a review of Excel’s database features such as Pivot Tables along with the powerful Lookup functions. Students will then learn how to automate data input with Data Validation, how to check formulas with auditing tools, how to use Excel’s new tables and slicers, and how to take advantage of the power of macros and the Visual Basic for Applications (VBA) programming language.
The four-session course will be held on Wednesday evenings from 6 pm to 9 pm. The first session is scheduled to start on March 21. Tuition is just $229. Go to www.norwalk.edu to sign up, or visit the campus (directions). The CRN number for the course is: 4644.
Here is a list of my training courses that will be available here in southwest Connecticut in the Spring of 2018. If you are not in the area, and would like further information on these subjects, please let me know.
— Rich Malloy
| Course | Date | Location |
|---|---|---|
| Computer Security Update | Feb. 12, 2:00 pm | Greenwich Library |
| One-Hour Website | Feb. 28, 6:00 pm | NCC |
| Advanced Excel | Mar. 21, 6:00 pm | NCC |
| Microsoft Access | Apr. 2, 6:00 pm | NCC |
NCC = Norwalk Community College
As part of its summer session, Norwalk Community College is again offering an Advanced Excel class taught by Rich Malloy. Most people who use Microsoft Excel are familiar with only a few features of this amazingly powerful application. In this hands-on course, students will learn how to use the more robust features of this vitally important business tool.
The course includes a review of Excel’s database features such as Pivot Tables along with the powerful Lookup functions. Students will then learn how to automate data input with Data Validation, how to check formulas with auditing tools, how to use Excel’s new tables and slicers, and how to take advantage of the power of macros and the Visual Basic for Applications (VBA) programming language.
The four-session course is being made available by the college’s Extended Studies & Workforce Education Division. The first session starts at 6 pm on Tuesday, June 6. Tuition is just $229. Go to www.norwalk.edu to sign up, or visit the campus (directions). The CRN number for the course is: 6871.——————–—————————
Congratulations! You are part of the 25% of computer users who back up their data. Unlike most people, you will not lose all your precious pictures and documents when your computer suddenly breaks down.
Or will you?
The fact is that many backup systems stop working for one reason or another: A software upgrade causes compatibility issues, the backup drive fails, or the credit card for the cloud backup account expires. For all these reasons, people who thought they had a good backup found out too late that the backup system had stopped working
So, whenever we change the clocks, it is a good idea to check not only the smoke alarms, but also our backup systems. You never know.
— Rich Malloy