Posts by Walker
    Posted March 13, 2015 by

    Analytics with the Excel Analysis Toolpack

    analytics with excel

    Many people talk about “Big Data” and analytics, yet few understand what it means. The term analytics basically refers to the application of math and statistics to data sets, and it is certainly not a new idea. However, certain aspects of it have changed over the past five years because of databases like Hadoop that make […]

    Category Microsoft Excel

    Posted March 6, 2015 by

    How to Resize Images from Your Camera or Smartphone

    how to compress pictures

    Most cameras and smartphones take pictures at a resolution that is far too high for everyday use, and storing these images uses far too much disk space.  Keep reading to find out how to compress pictures to reduce storage yet keep the same picture quality.

    Posted March 1, 2015 by

    How to Edit PDF Files with Microsoft Word 2013

    Untitled

    What do you do when someone sends you a PDF file?  In the past, you typically read it or printed it. You could only edit PDF files if you bought an expensive copy of Adobe Pro.  If you wanted to edit it without Adobe Pro, you had to ask the sender to resend it as […]

    Category Microsoft Word

    Posted February 25, 2015 by

    iPad: Camera Exposure and Resizing Photos

    how to resize ipad image

    Not many people think of using the iPad to take pictures. Some users even prefer to install third-party cameras, but the camera app that Apple provides gets the job done. In fact, anyone can take good photos with iPad. This tutorial explains the basics of using the iPad’s exposure setting and resizing iPad photos.

    Category Apple iPhone

    Posted February 22, 2015 by

    How to Add Fonts to Word 2013

    add fonts to microsoft word

    Calligraphy is a lost art for those who use computers and the Latin alphabet (e.g., English, French, and Spanish speakers). Nevertheless, creating electronic fonts for computers is still artwork. Here is how to add additional fonts to Microsoft Word so that you can use them with Word. Back when printing was done with printing presses […]

    Category Microsoft Word

    Posted February 16, 2015 by

    Set Up iCloud on Windows

    how to setup icloud on windows

    I already have Google Drive and Microsoft OneDrive set up on my computer, but I am reluctant to add Apple iCloud because I have lost documents with Microsoft OneDrive.  Will icloud work any better or be any safer? Despite some possible risks, I am going to add iCloud Drive to my Windows computer. In this […]

    Posted February 14, 2015 by

    How to Set Up iCloud Drive and Photos

    how to set up icloud

    Apple has cloud storage just like Microsoft (Microsoft One) and Google (Google Drive).  It is called iCloud. Setting it up can be quite an ordeal, and Apple only gives you 5 GB of free storage, which is enough for 1,000 5 MB photos. (Photos can be sized much smaller.) That is to be expected of […]

    Posted February 9, 2015 by

    How to Write a Custom Function in Microsoft Excel

    how to create custom excel function

    Microsoft products have always included Visual Basic. You can use it in Microsoft Word, Access, and Excel. One reason this is true is that Bill Gates and some of his friends wrote Visual Basic while Gates was still at Harvard.  Thus, he felt proud of his accomplishment and wanted to keep it. Gates wrote the floating […]

    Category Microsoft Excel

    Posted February 6, 2015 by

    Google Sheets: How to Work with Dates

    do date math with google sheets

    You can use some basic date functions in Google Sheets to work with dates and use date math. Dates in spreadsheets are numbers, which means you can add and subtract them.  Do not think of them as strings of text such as “10 January 2015.” If you treat dates as strings of text, then using […]

    Category Google Sheets

    Posted February 4, 2015 by

    How to Change Android Camera Settings

    how to change android camera settings

    People hardly need to buy cameras anymore as cell phones come with quite good quality cameras. People who are experts at photography can buy cameras, but the rest of us can use our cell phones. They are far less complicated than advanced cameras.  Lots of people buy fancy cameras and never learn to use all […]

    Category Android

    Posted February 2, 2015 by

    Create Citations, Endnotes, and Footnotes in Microsoft Word 2013

    how to create a footnote in word

    Citations, footnotes, and endnotes are important for academic writing.  Microsoft Word 2013 generates these items for the writer automatically. It can also make a table of figures and an index.  It would take much effort to do this manually, which is what publishers did for many years. Here is how to make a citation, footnote, and […]

    Category Microsoft Word

    Posted January 26, 2015 by

    How to Take Screen Shots and Edit Them with Gimp on Ubuntu

    ubuntu take screenshot

    With Ubuntu, you can use (-print-screen-) to take a screen shot and then use Gimp to crop it. The problem is that Gimp is not always easy to use. Part of the reason for this is working with a graphics editor is difficult if you have no knowledge of graphic design. Most of us do […]

    Category Linux