dataminded

How to turn off automatic calculations in Excel

How to turn off automatic calculations in Excel

If you are using Excel 2010 or 2007, calculations can slow down workbooks, so read about an option to turn off automatic calculations. We also wrote about keyboard shortcut Ctrl + P and the REPT function.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

How to create Christmas tree charts in Excel

How to create Christmas tree charts in Excel

This week, to carry the Christmas theme, we’ll cover Christmas Tree Charts, inserting and deleting rows, and the LEFT & RIGHT functions.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

How to create a custom cell style in Microsoft Excel

How to create a custom cell style in Microsoft Excel

This Friday, learn about creating custom cells, how to use Ctrl + O shortcut in Excel and functions LARGE and SMALL.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

How to use conditional formatting in Excel

How to use conditional formatting in Excel

In this week’s Excel 3 Tip Friday we take a look at conditional formatting, opening a new workbook using a keyboard shortcut, and the COMBIN function.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

How to format a table using a neat keyboard shortcut

How to format a table using a neat keyboard shortcut

In this week’s Excel tips we cover the format painter, how to format a table using a neat keyboard shortcut, and different ways to round numbers using the CEILING function.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

How to paste a table as a picture in Microsoft Excel

How to paste a table as a picture in Microsoft Excel

Martyn Blything of DataMinded this week brings you three new Microsoft Excel tips and tricks - how to create images of tables, a shortcut to close Excel, and how to extract text from the middle of a cell.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

How to use the macro recorder to automate simple tasks in Excel

How to use the macro recorder to automate simple tasks in Excel

In the newest DataMinded blog post, learn how to save time and use the macro recorder to automate simple tasks in Excel, what is ALT+F1 shortcut and how to combine a VLOOKUP with the COLUMNS function.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

How to ‘super hide’ a sheet in Excel

How to ‘super hide’ a sheet in Excel

This Friday learn some tips that are fairly unknown, but extremely actionable, like ‘super hiding’ an Excel sheet, Ctrl+W shortcut and SUBTOTAL function.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

How to insert current date and time into any Excel cell

How to insert current date and time into any Excel cell

This week you can learn how to get everything to display in the right order, what to use CTRL + R for and how to to insert the current date, and current date/time into any Excel cell.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

How to set your Excel options to only create a single sheet

How to set your Excel options to only create a single sheet

In this week's 3 tip Friday we cover how to set the number of sheets Excel adds to new files, the Ctrl + A Shortcut and how to calculate standard deviation in Excel.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit