All Posts By

Ian Lamont

How to export an Excel chart as a JPG, PNG, or GIF image file

By Blog, Video

If you’ve ever wondered how to export an Excel chart to a JPG, PNG, GIF, or other file format, the following two-minute video shows how, using a simple right-click over the image and selecting “Save As”. Note that if you don’t see the “Save As” option, select “Copy” instead. Then, open up Paint or any other image editor and paste the image, then save it as a JPG, PNG, GIF, etc.

Exporting images from Excel is useful for people who need to bring the image into other applications, such as:

  • WordPress or other blogging software
  • Email programs (Outlook, Gmail, etc.)
  • Word processors (Microsoft Word, Apple Pages, Google Docs, Scrivener, etc.)
  • 93
  • Photo software (iPhoto, Picasa, Flickr, etc.)
  • Presentation software (Microsoft PowerPoint, Google Presentations, etc.)

The narrator of the video is the author of “Excel Basics In 30 Minutes”, a guide that contains many more tips and how-to instructions that will get you up to speed with Excel in no time. Visit this page to see purchasing options for “Excel Basics In 30 Minutes”.

How To Convert CSV Files In Excel

By Blog, Video

If you work with data, you’ll eventually have to deal with CSV files. This short video explains what comma-separated value files are, and how to convert CSV files in Excel. Several examples containing text data (in the form of a list of first and last names, as well as a CSV download from a banking site) are shown being imported into Excel and flowed into the spreadsheet cells. The narrator is Ian Lamont, author of Excel Basics In 30 Minutes and other In 30 Minutes™ titles.

Press the icon in the lower right-hand corner of the screen to see the video in all of its full-screen glory.

The Goodreads Giveaway Effect For Excel Basics

By Blog No Comments

Earlier this month, the Goodreads Giveaway for Excel Basics In 30 Minutes was officially launched. As of this writing, the registration is still open. For the next two weeks, you can sign up for the giveaway and have a chance at winning one of 25 free copies of the paperback (126 people have already signed up). The details to join the giveaway are at the bottom of this page.

However, one thing I wanted to highlight about the giveaway was the impact of the listing on the sales and marketing of the book. I track marketing data very carefully. Shortly after the Goodreads Giveaway was launched, there was a measurable increase in the number of books sold on Amazon and iTunes. In addition, I saw on the Goodreads Giveaway listing page that about 30 or 40 people had listed it as “to-read”. My hypothesis: People who saw the giveaway wanted to mark it for future reference, and in a few cases they wanted it right away — and went to Amazon or iTunes to buy the ebook version. Several people also bought the paperback version.

This is not a best-selling In 30 Minutes™ title, but the boost was welcome. I’m looking forward to the end of the promotion, and sending out the free copies to 25 lucky winners (selected by Goodreads). I’m also looking forward to getting feedback from those readers.

Goodreads Book Giveaway

Excel Basics Giveaway

Excel Basics In 30 Minutes

by Ian Lamont

Giveaway ends April 11, 2013.

See the giveaway details
at Goodreads.

Enter to win

How to convert .xlsx files to Google Sheets

By Blog, Video

In six minutes, learn how to convert .xlsx files to Google Sheets, a free online spreadsheet program that is part of the Google Drive office suite. If you have Excel 2010 or 2013, this is a way to get the files into Google Drive. The technique also works with .xls files in older versions of Microsoft Excel. Three examples are given, with step-by-step instructions of how to handle the conversion process. There are also some warnings about formatting problems which can occur when the Microsoft Excel documents are imported into Google Drive.

Start the video below. To see the video full-screen, press the icon on the bottom bar of the video.

The narrator of the video is the author of Excel Basics In 30 Minutes, which you can buy here for the Kindle, iPad, or Nook, or download as a PDF. There is also a paperback edition available.