Excel tips

How to quickly display the macro run box in Excel

How to quickly display the macro run box in Excel

In this week’s 3 tip Friday we cover more useful Excel tips and tricks - organizing information in Excel spreadsheets, how to return the week number of a date, and how to quickly display the macro run box with a shortcut.

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 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 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 show all formulas on the Excel sheet, and learn the HLOOKUP function

How to show all formulas on the Excel sheet, and learn the HLOOKUP function

In our newest blog post, we will teach you how to see which Excel cells are fixed numbers and which are functions, without clicking into each one, F2 shortcut and HLOOKUP 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 name tables to make Excel functions easier, and powerful function to combine multiple criteria

How to name tables to make Excel functions easier, and powerful function to combine multiple criteria

Three tips you will learn this Friday on your way to becoming an Excel pro are using Named Ranges, Ctrl + . (Full stop/period) shortcut and AND 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 protect your work in Excel

How to protect your work in Excel

This week we cover protecting your work in Excel spreadsheets so that it can be viewed but not edited, using Ctrl + Page Up / Ctrl + Page Down to move to the next sheet and SUMIF 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