Functions Archives | How To Excel

Everything You Need To Know About XLOOKUP

by John | Sep 24, 2019 | Functions | 0 |

There was big news in the Excel world recently. A new replacement for the most famous Excel...

6 New Functions in Excel 2019 and Office 365 You Must Learn

by Aprajita Sharma | May 7, 2019 | Functions | 5 |

Microsoft Excel is a Powerful Tool, Period. And once you are loaded with all the basics of...

5 Ways To Change Text Case In Excel

by John | Apr 30, 2019 | DAX, Functions, Power Pivot, Power Query, Tutorials | 0 |

Learn how to change text case between lower, upper and proper case in Excel using Excel functions, flash fill, power query, DAX and power pivot.

4 Ways to Remove Unwanted Space Characters

by John | Sep 27, 2018 | Functions, Power Query, Tutorials, VBA | 2 |

Learn how to remove unwanted space characters from text data in Excel using various methods.

The Ultimate Guide To VLOOKUP

by John | Sep 11, 2017 | Functions | 0 |

The VLOOKUP function allows you to search a value in the left most column of a range and return the corresponding value in a column to the right. The search is vertical from top to bottom and in fact, the “V” in VLOOKUP stands for vertical.

COUNTIFS function

by John | Jul 7, 2016 | Math | 0 |

This function will conditionally count items in a range based on given criteria. Syntax COUNTIFS(Range 1, Criteria 1, Range 2, Criteria 2,…) Range 1 (required) – This is the range to which the first criteria is...

INT function

by John | Jun 26, 2016 | Math | 0 |

This function will rounds a number down to the nearest integer. Syntax INT(Number) Number (required) – This is the number you want to round down to the nearest integer. Example In this example find the round down a few...

SUMIFS function

by John | Jun 19, 2016 | Math | 0 |

This function will conditionally sum up numbers in a range based on given criteria. Syntax SUMIFS(Sum Range, Range 1, Criteria 1, Range 2, Criteria 2,…) Sum Range (required) – This is the range of numbers to sum....