Other Archives - TheSmartMethod.com

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…

Category: Other

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.

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.

How to save and view a PDF e-book on an iPad

This article describes how to save PDF files to your iPad and add it to your iBooks library. You can then view the PDF offline.

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.

Horizopntal scrolling with the mouse in Excel

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.

Changing cell padding in Excel

This article explains how cell padding is implemented in Excel and how to resize and format cells to achieve padded layouts.

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.

The value doesn't match the data validation restrictions defined for this cell

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.

Office 365 Updates

This article describes the new features added to Excel 365 for each new semi-annual 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.

Excel tutorials

Category: Other

Categories

Recently added articles

Excel Tutorials

Articles

Downloads

Policies

About

Which tutorial do you need?

Which Excel Essential Skills version do you need to learn?

Excel 365 for Windows

Excel 2021 for Windows

Excel 2019 for Windows

Excel 2019 for Mac

Excel 2016 for Windows

Excel 2016 for Mac