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.
Excel filters can help isolate certain values in large lists of numbers or text values. This video shows basic filtering plus custom filters. The sorting 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.
In 5 minutes, learn how to convert Microsoft Excel 2016 to PDF in Windows. It also shows common problems including cut-off columns and missing gridlines in the PDF, and how to fix them. Narrated by the author of Excel Basics In 30 Minutes.
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.
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.
Which is better, Google Sheets or Excel Online (Microsoft’s free online spreadsheet program)? The Excel Online vs. Google Sheets differences are narrowing, but there is one clear winner. Most of the features are compared side by side in the first six minutes of the video. The video is narrated by Ian Lamont, author of Google Drive & Docs In 30 Minutes and Excel Basics In 30 Minutes.
If you don’t own Microsoft Excel, it is still possible to perform limited editing of MS Excel spreadsheets inside of Google Sheets using Office Compatibility Mode. This short video (less than 5 minutes) explains the special Chrome Extension required to use Office Compatibility Mode, and then shows how to edit Excel files in Sheets, using as an example an .xlsx file inside of Google Sheets. The narrator is Ian Lamont, author of the top-selling Excel Basics In 30 Minutes and Google Drive & Docs In 30 Minutes.
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!
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.)
- 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”.
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.