Publishers of the world’s most comprehensive and up-to-date Excel tutorials

## Excel tutorials

The only Excel books you will ever need

• The only constantly updated Excel 365 titles more…
• Thoroughly covers Power Pivot and Power Query more…
• Covers business intelligence and OLAP features more…
• Simple, easy, understandable, 2-page lessons more…
• Available as both printed books and e-Books more…
• Used by schools, colleges and universities  more…
• Available for 365, 2021, 2019, 2016 and Mac versions more…

Search again:

## Excel protected view warning

Excel protected view: Be careful â€“ files from the Internet can contain viruses. Unless you need to edit itâ€™s safer to stay in Protected View. This article explains what this error message means.

## Microsoft Office update channels

Microsoft Office update channels are explained in this article. Beta, Current, Monthly Enterprise and Semi-annual enterprise are all covered.

## Every lesson is presented on two facing pages

This article explains how Smart Method books efficiently transfer information by presenting every lesson on two facing sheets of A4 paper.

## Excel linear and exponential series

Linear and exponential series are explained in this short tutorial that also shows how to model them using Excel. Sample file included.

## Kindle e-book format features

Our e-books are now published in Kindle e-book print replica format. This article explains why this e-book format is optimal for learning and includes screen grabs from the Kindle PC reader application.

## Audio Problems and Solutions

This article explains the many reasons why you may not be able to hear audio when playing videos in a web browser.

## Excel 2019 for Mac vs Excel 2019 for Windowsâ€‹

The most complete existing list of the differences between Excel 2019 for Windows and Excel 2019 for Mac. The Windows and Mac versions are very different.

## Horizontal scrolling with the mouse in Excel

Most users know how to use the “mouse wheel” to scroll in a vertical direction.This article explains how you can also scroll horizontally using Auto Scroll.

## How to split delimited data in Excel

This article describes three different ways of splitting delimited data in Excel, including Flash Fill, Text to Columns and formulas.

## Keyboard shortcut for autofill in Excel

This article explains several different ways to carry out an AutoFill using the keyboard in Excel and explains Flash Fill and the Repeat command.

## Privacy Warning on a macro-enabled workbook

This article shows how to prevent a privacy warning being displayed whenever a workbook is saved by changing Excel’s Trust Center settings.

## How to consolidate data and automatically keep it up to date in Excel

This article shows several different ways of consolidating data in Excel, including the Consolidate tool and the new Get & Transform feature.

## Forcing Solver to return whole numbers

This article explains what the Excel Solver add-in does and how to create a constraint that will force it to return whole numbers.

## Excel crashes after refreshing data

This article explains several reasons why Excel may crash after refreshing data and how to resolve these issues if they are affecting you.

## Can Excel Slicers be used in PowerPoint?

This article discusses Excel Slicers and how to integrate them with PowerPoint presentations and other Office applications.

## A cell won’t let me enter data

This article explains several reasons why Excel may not allow you to enter data into cells, along with solutions that will enable you to fix the problem.

## Macro buttons suddenly stopped working

This article explains why Excel macros can seem to suddenly stop working and suggests several possible solutions to the problem.

## Why you canâ€™t effectively learn Excel 2016/365 using a Video Tutorial

This article explains Microsoft’s new Sofware As A Service strategy for Excel 2016 via Office 365, as well as the future of Excel 2019 and beyond.

## Why are the sort and filter options greyed out?

Sometimes Excelâ€™s sorting and filtering options become grayed-out and unusable for no apparent reason. This article explains how to fix the problem.

## Why does Excel say “The value you entered is not valid”?

This is happening because the cell has a Validation that only allows certain values to be entered. You can remove it by following these steps.

## A Keyboard Shortcut for Merge and Center

You can create keyboard shortcuts to any command in Excel 2016 without needing any external tools or macros. This article will show you how.

## Excel Versions Explained

This article describes the history of Microsoft Excel, from its earliest versions to the most recent, and the best ways to learn how to use each version.

## Excel 2016 for Mac vs Excel 2016 for Windowsâ€‹

The most complete existing list of the differences between Excel 2016 for Windows and Excel 2016 for Mac. The Windows and Mac versions are very different.

## Why was my credit card not authorized?

There are many reasons why a credit card payment can fail. This article explains most of the possible reasons and how to resolve them.