A customized data entry form not only encourages accuracy for data entry, but it looks better and can provide more functionality with push buttons to print a record, add a record, etc. A logo can be incorporated into the design. Many of the features are quickly done so the video doesn’t run TOO long – it can be a bit tricky in the beginning as you have to observe the shape of the mouse when doing certain actions.
Using the “stack” function in design view is critical when moving fields around the sheet. Take it slow and you’ll do great. It is not an instant function when customizing.
80% of success is being on time. (Woody Allen)
Countif allows you to count either a text or numeric string to determine the number of occurrences. COUNTIFS allows youto count either text or numbers to determine the number of occurrences, allowing you to find numbers with a specific range, i.e. 100 – 200 in a data set range.
Although a pivot table can do this, it is often easier (quicker?) to uses these functions as demonstrated in this video.
Done in Word 2016, most of the tips in this video work with more current versions of Word.
Whether you’re doing a term paper, a research document, or a thesis, the tips shown in this video show you how to do the following:
- Footnote
- Comment
- Citation
- Footer
- Table of Contents
- Bibliography
- and a few extra tips
Excel tables are relatively simple to create yet can provide powerful methods of analyzing data. Filter data, get statistics, obtain totals, and format the table in minutes. This example has been used in classes to demonstrate its many features.
Photoshop Elements 2018 has about the same features…and then some! of the Photoshop of not so long ago. Best thing….you can OWN it…not rent…in a few months you’ll be ahead of the game. Retouch a photo using layers, quick selection tool, cloning, healing brush, and a few extra features so you can turn a photo with improper exposure or delete someone (or something) who “bombed” your photo.
Done in Creative Cloud, the skills apply to newer versions of Elements. Using layers and the quick selection tool, a backlit photo’s over and under exposure is fixed so it has a natural look.
The quick selection tool becomes much easier with practice.
Classes starting this fall include many topics including:
click here for full schedule
To work with your schedules, sessions are offered both evenings and afternoons
A summary of classes offered:
- Adobe software including
- Photoshop Elements (Stamford)
- Photoshop in Adobe Creative Cloud (Yonkers library)
- InDesign (Yonkers library)
- Social Media including methods on protecting your privacy.
- Create a facebook page for your business or nonprofit
- MS Office – Excel, Word, PowerPoint, with special classes on Excel pivot tables and charts
Students can now bring their own fully charged laptops to hands-on sessions. Classes are taught on PCs, instructor is familiar with Mac. - Buying and selling on eBay
- Android and iPhone/iPad
- Optimizing your Windows 10 computer
Looking forward to seeing you starting in September!
