Category Archives: Software Tips

How to check WiFi speeds in Windows 10 [Solved]

4 comments

Question. How can I check wifi speeds in Windows 10 Pro? Answer. Here are two methods to check Windows 10 wifi connection speeds: #1 Graphical User Interface (GUI) method Press Windows Key + R and type ncpa.cpl Press Enter Double-click the WiFi adapter that you want to check The Wi-Fi Status window will display: #2 Command Prompt text method Open a Command Prompt (or Press Windows Key + R and type cmd) Type netsh wlan show interfaces and press Enter You will

Read more computer tips, Networking, Software Tips, Windows

EXCEL: How to extract text before a comma, space or period [SOLVED]

Leave a comment

Excel tip:  If you try to extract text before a space ” “, comma “,” or period “.” in Excel you may try something along these lines: =LEFT(A2,(FIND(” “,A2,1)-1)) However, if you have non-matching records, i.e. something without a space in the previous example then you will get the following result: #VALUE! Since that is probably not what you wanted, try the following: =IFERROR(LEFT(A2,(FIND(” “,A2,1)-1)),A2) Which will result in either (A) the shortened result (where applicable) or (B) the original

Read more Software Tips

Adjust WordPress Divi theme footer text [SOLVED]

Leave a comment

Question: I am trying to adjust the footer text on a Divi based theme but cannot find it anywhere in the PHP code! How do I adjust the footer text in a Divi (child) WordPress theme? Answer: Good question! You can adjust the footer text via the theme customizer: #1 Login to the WordPress admin area and go to Divi -> Theme Customizer #2 Choose: Footer #3 Choose: Bottom Bar Voila, your theme’s footer text has been edited. I hope this helps! 🙂

Read more Software Tips, WordPress tips

How to adjust Picasa collage output size [SOLVED]

Leave a comment

Question: I am creating a collage in Google’s Picasa application and I cannot get it to be the right aspect ratio for my paper which is 8.5×11 inches. Can you help? Answer: If you go to collage settings in Picasa, you can select the “Page Format” and choose something other than the default HDTV. Please see this screenshot for an example: I hope this helps 🙂

Read more photography, Software Tips

Photoshop CC fix D3DCompiler_47.dll is missing from your computer… [SOLVED]

8 comments

A question from reader Henry: Hi. Today I did a fresh install of windows 7 pro on my lenovo thinkpad. Then I try to install adobe photoshop cc but I got an error when running the application: “D3DCompiler_47.dll is missing from your computer….” I reinstalled everything but that did not help. Can you help me with this dll problem? Thanks, –Henry Dear Henry, It looks like you are encountering the following error: Please find the following update for your Windows 7

Read more computer tips, Software Tips

Cinemagraph apps: Plotagraph, Zoetropic, Plotaverse +more

Leave a comment

If you are looking for an easy way to add some pizzazz to your still photos, you may want to try making a cinemagraph. In the past, it required quite a bit of time to craft a cinemagraph utilizing fairly expensive programs. Now, however, it can be done on your phone in just a few minutes (or your laptop, tablet, PC if you so desire) at minimal to no cost. As an example, I tried Zoetropic on my Note 8 (Android) and within about

Read more Android tips, iOS, Software Tips

Keep formatting in Excel when copying/pasting from web page

Leave a comment

Question from B.G.: Sorry to bother. How can I export and keep the integrity of the web page table columns? When I copy and paste to excel, it puts all data to 1 row. Answer:  Good question! Please find the steps below: Instructions In your web browser window showing the table/report, press CTRL+A (to select all) Then press CTRL+C (to copy) Switch to a blank spreadsheet in Excel, press CTRL+V (to paste) That should result in a nice separate set of

Read more company tips, Software Tips, Work

Fatal Error! PIL._imaging.pyd [SOLVED]

2 comments

Question. I recently had the following popup unexpectedly on my Windows laptop: Fatal Error! PIL._imaging.pyd could not be extracted! I was surfing the internet on my laptop and I am worried that I might have a virus 🙁 Can you help me identify what caused that error? Thx! -Josh Silvija Answer. Hi Josh! Thank you for your question. Fortunately, that “fatal error” should not be an issue. Specifically, I have seen that error occur when Google Drive (now Google Backup and

Read more computer tips, Software Tips