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…

Printing the Basic Skills course

This article explains how to print and bind the Smart Method’s free Excel Basic Skills course along with the front cover graphics.

Excel crashes after refreshing data

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.

Refreshing Slicers in Excel

Refreshing slicers in Excel

This article explains how to change Excel’s Slicer settings to stop displaying items that have been deleted from the data source.

Missing Field List – Pivot Table

Missing field list in Pivot table

This article explains how to bring back the Pivot Table Field List if it has been closed or moved and explains a bug that can prevent it from appearing.

Calculating Loan Payment Dates

Calculating loan payment dates

This article shows how to calculate loan payment dates in Excel, using a formula that can calculate loans of any length and number of periods.

Changing dollar signs to GBP in Excel

Changing dollar signs to GBP in Excel

This article shows you how to change currency symbols in Excel, how to convert from one currency to another and how to get exchange rate data online.

Adding images to tables

Adding images to tables

This article explains how to insert pictures into Excel workbooks and Excel’s current image features, including cell backgrounds.

A cell won’t let me enter data

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.

Adding “+” between words in Strings

Adding + between words in strings

Code numbers such as product codes are common in Excel. When you work with codes like these you often need to join multiple pieces of text (or ‘strings’).

Changing cell padding in Excel

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.

Table Tools, Design Tools Group

Table tools design tools group

This article explains the Table Tools > Design tab on the Excel Ribbon, how to access it and how to reset the Ribbon if the tab has been disabled.

How to hide #N/A errors in Excel

How to hide NA Errors in Excel

This article explains the #N/A error code in Excel, why it occurs and how to hide it when it appears on your Excel worksheets.

How to use factorial (!) in Excel

Dice used to illustrate how to use factorial in Excel

This article shows how to calculate factorials and other combinatorials in Excel, showing how to calculate the probability of winning the lottery.

Working with HEX values in Excel

Working with HEX values in Excel

This article explains the Hexadecimal counting system and how to work with it in Excel, as well as the four different counting systems supported by Excel.

Which tutorial do you need?