This week’s email newsletter articles are:
- Adventures With Excel:
How to Use the VLOOKUP Function
When I got started originally with spreadsheet software, I was using an Apple //e computer and Apple’s AppleWorks software. For those not familiar with the software, it was a combination word processor, spreadsheet, and database. This was back in 1975.
I knew that, one day, I would have an IBM PC at work and I wanted to understand how the software worked, having learned the basic concepts, so that I could hit the ground running.
In using the spreadsheet, I could easily do the cell calculations for plus, minus, division, group calculations by parentheses, etc. But, I wanted to learn more about the capablities.
I decided that, in order […]
- Make Excel Easier by Using Notepad++
Which of the folllowing Excel formulas looks easier to understand?
They’re both the same formula — the second one just has some line breaks inserted to make understanding it easier. Excel will evaluate them the same way, too!
If you picked the second one, […]
This Week Online — Blast From The Past
A Look at Articles from Past Newsletters
- Unable to Run Downloaded File in Firefox
Subscriber Evelyn Summers was having problems finding and opening her downloaded files, so she wrote me for help:
I have a problem with when I download. I can down load and it goes on my computer BUT it doesn’t show up on my screen so I can run it. Can u help me. […]
- Helpful Tech Support Disables Computer From Booting
New subscriber David Hazel wrote with an unusual problem — with Tech support from his ISP, his Windows 7 computer will no longer boot!
[The article is continued below...]
I am really at a loss on this one and it is probably an easy boot file edit if I knew how to do that. I recently called my [fiber optic Internet Service Provider name removed] tech support for the first time in the 15 months I have had their, so far, flawless internet service.
I had upgraded the previous evening to a higher speed online (50/20) and wasn’t getting the new speed. We were able to quickly resolve the issue and […]
- Email Security When Using Wireless Networking
Email security is critical when you use wireless networking.
When you use wireless networking at home, if you haven’t set your wireless router and wireless adapters to use the best encryption they will support (currently WPA2 for most personal wireless devices), you don’t have a secure system. You are broadcasting your data unencrypted or with a inadequate encryption method.
That means that anyone who "sniffs" the broadcast signals can read your data.
That data includes web site addresses, passwords […]
- What Does Chkdsk Do in Windows?
Long-time subscriber Rudy wrote this week to ask a question about the Windows program "chkdsk." The name alone tells me that Rudy isn’t running Windows 7, as it’s no longer known by that name (it’s found via Computer (My Computer) > selecting the hard drive to check > Properties > Tools > Error Checking).
When running chkdsk you are given the options to "Fix" or "Repair" I understand that "Fix" rearranges confused data,and "Repair" handles physical damage.
My question is: How is (physical damage repair) accomplished?
Not a subscriber? It’s easy to get my newsletter!
Subscribe to my free Terry’s Computer Tips email newsletter and then use the automatic responder to get the last two email issues!
I love the redesign of my Terry’s Computer Tips web site — it makes article posting and maintenance much easier than before. I’m glad I switched to WordPress and the Genesis Framework. On my Terry’s Computer Tips site, I’m using the base Genesis Framework with a child theme of my own to customize it.