Skip to main content
All Posts By

Ian Lamont

How to alphabetize a list of words in Excel

By Video

A quick explanation of how to alphabetize a list of terms in an Excel spreadsheet (Excel 2019 for Windows or Excel 2019 for macOS). Narrator Ian Lamont is the author of EXCEL BASICS IN 30 MINUTES.

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

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.

Excel 2019 vs. Excel Online – what are the main differences?

By Video

In 14 minutes, learn the main differences between the powerhouse spreadsheet program Excel 2019 and Excel Online, Microsoft’s free online alternative. Topics and timecodes are listed below, and include interfaces, features, examples, storage, 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 Excel 2019 and Excel Online – how they work
01:45 Excel 2019 ribbon interface
02:15 How Excel Online ribbon interface is similar
03:00 How the Excel Online ribbon interface is different
03:30 Making a chart in Excel 2019 and selecting options
05:15 Making the same chart in Excel Online – different options
07:00 Comparing the View and Page Layout tabs in Excel 2019 and Excel Online
08:25 OneDrive and collaboration in Excel Online
09:15 Excel 2019 collaboration and local storage
10:30 Converting files to PDF, .csv, .html in Excel 2019 and Excel Online
11:15 Comparing cost of Excel 2019 and Excel Online
12:50 Microsoft Accounts

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

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.

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 cheat sheets 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 use addition in Excel

By Video

There are several ways to perform addition in Microsoft Excel 2016. In this short video, a sample spreadsheet of three salespeople’s monthly salaries and commissions is used to demonstrate how to add cell values, how to use the SUM function, and how to use AutoSum. The tutorial applies to Excel 2016, Excel 2013, Excel 2010, Excel Online, and Google Sheets. The narrator is the author of Excel Basics In 30 Minutes.

How to compare Excel and Excel Online

By Video

What is the difference between Excel 2016 and Excel Online, Microsoft’s free online spreadsheet program? In about 10 minutes, learn how they compare, including:

00:00 – Overview of both tools
01:45 – OneDrive requirements
02:20 – Excel Online vs. Excel 2016 comparison of ribbon interface (Home, Insert, Layout, Data, and Review) and basic features on each.
05:10 – How features are implemented – Insert / Chart example
07:45 – OneDrive and Collaboration
08:15 – Cost differences and Microsoft Accounts, Excel Functions

This video is narrated by the author of Excel Basics In 30 Minutes.

How to export a PDF from Excel

By Video

In less than 3 minutes, learn how to take an .xls or .xlsx file and export a PDF from an Excel 2016 for Windows and macOS (part of the Microsoft Office 365 suite) using two export methods. This can be useful for restricting editing on a spreadsheet or sharing an Excel file with someone who does not have Excel 2016 or the Excel app for Android or iOS. The Excel 2016 PDF export tutorial can help Excel power users, accountants, bookkeepers, MBA students, and others save time using Excel. The video is narrated by the author of Excel Basics In 30 Minutes.