How to fix a VALUE error in Excel

Don't wait for your 2020 new years resolutions to start learning #EXCEL. Start learning with just 15 minutes a day, and by the end of the year you'll be awesome at Excel and start the new year running.

Our #excel Beginner to Advanced course covers everything from charts, functions, & pivot tables - giving you the skills to analyse data and become faster at Excel.

Here's a quick Excel shortcut for your Monday afternoon! Use Ctrl + D to copy down from the cells above. It's useful when you need to fill the same value instead of using flash fill, which can increment dates & numbers.

Here's a quick Excel shortcut for your Monday afternoon! Use Ctrl + D to copy down from the cells above. It's useful when you need to fill the same value instead of using flash fill, which can increment dates & numbers.

Welcome to Excel 3 tip Friday, your weekly dose of Excel tips and tricks. This week we cover how to add a calculated field to an Excel Pivot Table, shortcut to create a new sheet in Excel workbook and converting a date to text.

This week we cover more useful Excel tips and tricks - you will learn how to use Find and Replace in Excel, how to use shortcut keys to hide and unhide rows and the Excel LEN function returns the length of the specified string.

In our latest Excel tips and tricks update, discover simple steps to split data in to different Excel column using Text to columns, using F4 shortcut and the powerful COUNTIF function in Excel that counts cells based on one criterion.

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.

In our latest 3 tip Friday newsletter read about Excel's Flash Fill feature, shortcut which adds borders to the selected area and INDEX MATCH function, one of Excel's most powerful features.

In this week’s 3 Tip Friday from DataMinded, read about removing blank cells in Excel to keep your spreadsheet tidy, how to create a line break in a cell and learn to use the ROUND function. ⬇

What is the best Excel meme you've ever seen? Share below.

In our weekly Excel tricks and tips post, I’ll show you how to remove duplicate entries from a Microsoft Excel spreadsheet, what does Ctrl+Shift+F do and how to calculate the number of working days between two dates using the NETWORKDAYS function.

Tell your friends and colleagues about us and earn up to £200! You can find out more about it here -

In this week’s 3 Tip Friday from DataMinded, read about freezing rows or columns in Excel to keep them visible while scrolling, how to enter today’s date using a shortcut and learn to rotate data from rows to columns or vice versa.

This week we cover how to combine text from multiple cells, a refresher on some of the most commonly used keyboard shortcuts, and a function that will turn a table of web addresses into clickable links. Let’s get started! https://t.co/Yqm36YHTFa

To keep your skills sharp, this week we cover creating your own Excel shortcuts menu, an easy date formatting shortcut, and the CONCATENATE function which allows you to combine text from different cells into one cell.

Looking to train up your entire team? Get massive savings when you purchase multiple Excel courses for your team.

Check how to use functions MIN and MAX in out latest Excel tips & tricks post -

In this blog post, we cover 3 new Excel tips & tricks - the Select All button you maybe never knew existed, Shift+Space shortcut and functions MIN and MAX, MINIFS and MAXIFS. Read all about it here -