F4 shortcut

How to use the powerful COUNTIF function in Excel

How to use the powerful COUNTIF function in Excel

In this update, discover simple steps to split data in to different Excel column using Text to columns, using F4 to switch between the reference types and the powerful COUNTIF function in Excel that counts cells based on one criteria.

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 group and ungroup data in Excel

How to group and ungroup data in Excel

Welcome to your weekly Excel tips from DataMinded. This Friday I’ll show you quick steps to group and ungroup data in Excel, what to use F4 shortcut for and the OFFSET function which returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells.

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