Category

Blog

Excel 2019 vs. Google Sheets: Which is better for you?

By Blog, Video

Updated! In 13 minutes, learn the main differences between Excel Online (Microsoft’s free online spreadsheet program) and Google Sheets (Google’s free online alternative). Topics and timecodes are listed below, and include interfaces, features, examples, collaboration, and more. Narrator Ian Lamont is the author of EXCEL BASICS IN 30 MINUTES and the publisher of the EXCEL 2019 REFERENCE AND CHEAT SHEET.

00:00 Basic comparison of Excel 2019 and Google Sheets
01:30 Excel Online registration requirements and OneDrive
02:20 Google Sheets registration and online storage in the cloud
02:45 Google Sheets offline compatibility mode
03:30 Excel Online cost vs Excel 2019
04:00 Feature comparison – Creating a chart I
05:20 Excel Online ribbon interface and features
05:45 Google Sheets toolbar
06:20 Functions comparison
07:40 Interface comparison
08:00 Creating a chart II – making modifications
11:20 Which one I use – Google Sheets or Excel Online?
11:45 Collaboration comparison

DISCLAIMER: This is not an official Microsoft video, nor do I represent Microsoft Corporation. Please review Microsoft’s terms of service before using this feature. i30 Media Corporation cannot be held liable for any direct, indirect, incidental, consequential, or special damages of any kind, or any damages whatsoever, arising out of or in connection with the use of this video.

Web: https://in30minutes.com/?y
Amazon: https://amzn.to/2DTPiG4
Twitter: https://twitter.com/@in30minutes
Facebook: https://www.facebook.com/in30minutes

How to convert Google Sheets to Excel on an iPhone

By Blog, Video

Learn how to convert Google Sheets to Microsoft Excel .xlsx using the iOS Google Sheets mobile app on an iPhone or iPad. In this 90 second video, learn how to convert between Sheets and Excel using your iPhone or iPad! This technique uses the Google Sheets mobile app for iOS, available for free on your iPhone or iPad. Narrated by the author of Google Drive & Docs In 30 Minutes and Excel Basics In 30 Minutes. https://in30minutes.com

DISCLAIMER: This is not an official Microsoft video, nor do I represent Microsoft Corporation. Please review Microsoft’s terms of service before using this feature. i30 Media Corporation cannot be held liable for any direct, indirect, incidental, consequential, or special damages of any kind, or any damages whatsoever, arising out of or in connection with the use of this video.

Web: https://in30minutes.com/?y
Amazon: https://amzn.to/2DTPiG4
Twitter: https://twitter.com/@in30minutes
Facebook: https://www.facebook.com/in30minutes

Excel 2019 Cheat Sheet

By Blog

Do you need a quick reference for Microsoft Excel 2019? The four-panel Excel 2019 Reference & Cheat Sheet contains tips, examples, and screenshots of basic Excel functions and features. A list of keyboard shortcuts for Windows and macOS is also included. Fully recyclable and designed for readability.

Excel 2019 printed cheat sheet

What’s Inside

  • New features of Excel 2019
  • An overview of Microsoft’s Ribbon interface.
  • Annotated list of Home tab features and settings with the new Excel 2019 icons.
  • Creating and saving workbooks.
  • How to add, edit, and hide data.
  • How to import and export .txt, .csv, .tsv, and .xls files.
  • How to use static cell references.
  • Setting the Excel print area.
  • Examples of basic formulas, functions, and AutoFill.
  • How to perform simple math and calculate averages.
  • How to sort and filter data.
  • How to create a chart or graph.
  • Universal keyboard shortcuts for Excel 2019.

How to buy the Excel 2019 Cheat Sheet

The four-panel reference is printed on 8.5 by 11 inch high-quality card stock, perfect for desks, walls, and shelves. It has holes for three-ring binders. Fully recyclable and designed for readability.

Purchase the Excel 2019 Cheat Sheet on the IN 30 MINUTES shop or Amazon, or download the PDF version which can be read on any screen or printed out.

The Excel 2019 Reference and Cheat Sheet was created by the publisher of the award-winning IN 30 MINUTES guides and is based on Excel Basics In 30 Minutes.

How to print gridlines on Excel 2016 for Windows 10

By Blog
A reader of my Excel book wrote to me about a problem he had to print gridlines for Excel 2016 on Windows 10, which he installed after purchasing an Office 365 subscription. It’s a common problem as many options are buried deep within Excel’s settings. Here’s how to print gridlines using Excel 2016 for Windows 10:
  1. Open the Excel document.
  2. Go to Backstage View by clicking File.
  3. You will see a list of different print options. Scroll to the bottom and click the link that says Page Setup.
  4. The Page Setup pop-up will appear. There are four tabs. Click the one that says Sheet.
  5. Select the checkbox that says Gridlines.

Here’s the location of the checkbox:

Excel 2016 print gridlines Windows 10

Excel 2016 Cheat Sheet

By Blog

Readers of Excel Basics In 30 Minutes may be interested to know that publisher i30 Media offers a product that can help them get the most out of Microsoft’s powerful spreadsheet program: The Excel 2016 Cheat Sheet. The printed version of the Excel 2016 Cheat Sheet is available for purchase on Amazon (or bulk order 20 copies here). It is also available as a downloadable PDF. Read on for a full description!

Excel 2016 Cheat Sheet: What’s inside?

Excel 2016 Cheat Sheet and reference

The four-panel Excel 2016 Reference & Cheat Sheet contains tips, examples, and screenshots of basic Excel functions and features. In addition to covering Excel 2016 for Windows and Macs, the reference also covers Excel Online, Microsoft’s free Web-based spreadsheet program. Almost all of the instructions and examples also apply to Excel 2013. Topics include:

  • Excel 2016 vs Excel Online.
  • An overview of Microsoft’s Ribbon interface.
  • Annotated list of Home ribbon features and settings.
  • Creating and saving workbooks.
  • How to add, edit, and hide data.
  • How to import and export .txt, .csv, .tsv, and .xls files.
  • How to use static cell references.
  • Printing basics.
  • Examples of basic formulas, functions, and AutoFill.
  • How to perform simple math and calculate averages.
  • How to sort and filter data.
  • How to create a chart or graph.
  • Universal keyboard shortcuts for Excel 2016.

Note that the Excel 2016 Cheat Sheet does not cover advanced features of Excel 2016, the Excel mobile apps for tablets and phones, or other Microsoft Office/Office 365 applications.

The four-panel reference is printed on 8.5 by 11 inch high-quality card stock, perfect for desks, walls, and shelves. It has holes for three-ring binders.

The Excel 2016 Cheat Sheet was created by 30 Media, the publisher of the top-selling guides Excel Basics In 30 Minutes, Google Drive & Docs In 30 Minutes, and Dropbox In 30 Minutes. i30 Media has also published a Google Sheets Cheat Sheet.

The Excel 2016 Cheat Sheet is an independent publication and is not affiliated with Microsoft Corporation.

How to order the Excel 2016 Cheat Sheet

To order a printed copy of the Excel 2016 Cheat Sheet, visit Amazon. The PDF can be downloaded using this secure order form. There is also an option to purchase 20 copies of the printed Excel 2016 Cheat Sheet at 25% off the retail price, ground shipping included!

PDF Amazon 20 copies (25% off!)

More sample spreadsheet files from the Excel book

By Blog

I am posting a bunch of new spreadsheet files (Excel .xlsx format) that I described in Excel Basics In 30 Minutes. The files are useful for recreating situations described in the Excel book, such as creating simple functions (chapter 1), projecting earnings scenarios for our three coworkers Jennifer, Curtis, and Kara (chapter 2), as well as the autofill and human resources sorting exercises.

The following Dropbox links will download to your computer (or prompt you to upload the .xlsx files to your own Dropbox account). If you are prompted to use a specific app to open them, choose Microsoft Excel 2016, Excel 2013, Excel 2010, Excel 2007, or any recent version of the Excel app or Excel for Mac. You can also upload the files to a Google Drive account to open/convert in Google Sheets.

Chapter 1: Autosum example

Chapter 1: Formula example

Chapter 1: Creating a function

Chapter 1: Jennifer, Curtis and Kara in January

Chapter 2: Static earnings values for all three workers

Chapter 2: Alternate earnings scenario

Chapter 2: Total earnings, fixed

Ninja chapter: Autofill for all team members

Chapter 3: HR sorting example

Sample spreadsheet excel book .xlsx

Sample spreadsheet: AutoFill

By Blog

The Second Edition of Excel Basics In 30 Minutes features a chapter on AutoFill, the Excel feature which lets users drag numbers, sequential text, or formulas across a row of cells to perform one of the following:

Copy the number (if one cell is selected). If a cell containing “3” is selected, AutoFill will place the number “3” in all cells which are included in the dragging action.

Increment the number or sequential text (if more than one cell is selected). If cell A1 contains “3”, and cell B1 contains “4”, AutoFill will place “5” in cell C1, “6” in cell D1, etc., until the mouse is released, ending the dragging action.

Repeat a formula but with shifted values relative to the cells which are included in the dragging action.

If this sounds confusing, or you want to try for yourself, open the following Excel spreadsheet (it will be downloaded from Dropbox), highlight a cell (or two adjacent cells), and then “grab” and drag the dot or square in the lower right corner of the cell to the right. Then let go to see the results.

You can also try the following Google Sheets version of the spreadsheet, right on the screen. Highlight cell B5 and drag to the right, and the monthly amounts will be totaled for each subsequent month!

How to sort in Excel: The five-minute tutorial

By Blog, Video

This short, five-minute tutorial will show you how to sort in Excel. It uses a simple, three-column spreadsheet file that shows the annual bonus amounts for employees in various departments.

The concept is covered in “Excel Basics In 30 Minutes”, but it’s also useful to see it being done on the screen, as the video below shows.

Sorting is a very useful way to alphabetize lists, rank lists from highest to lowest (or vice-versa), or sort by multiple criteria (in the video below, department is the key criteria, followed by amount of the bonus).

However, sorting can be a tricky thing, too. A common mistake is failing to “expand selection”, which means only one column will be selected for sorting. The result? The data will be mixed up because the other columns weren’t sorted at the same time. This type of mistake has led to people being sent the wrong mail, as well as financial errors. Don’t let it happen to you!

For more information about sorting and other basic Excel functions, read “Excel Basics In 30 Minutes”. It’s inexpensive — less than the cost of a pizza! Go to this page to see reviews, and this page to place your order.

Video tutorial: Sorting Please “Like” and share after you watch it!

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.