Mohamed Nada
  • Home
  • Blog
  • Resources
    • Pivot Tables e-Book
    • Excel Cheat Sheets
  • About Me
  • Contact
x
Get this eBook for FREE and learn all about Pivot Tables in just one hour!
Picture
Download free ebook

5 Basic Text Functions in Excel to Extract, Separate, Join and Clean text

10/22/2017

Comments

 
​​Most of the times, we use Excel to crunch numbers, but what a lot of people don’t know is that Excel is a very effective tool to crunch text as well.
​
We can use Excel to clean text fields, extract specific information from text fields, or join text fields together.

Read More
Comments

Working with errors in Excel using IFERROR and ISERROR functions (example with screenshots and video tutorial)

10/9/2017

Comments

 
We have previously seen the IF function and how it worked. Now we will talk about how to work with errors using IFERROR and ISERROR.
​
Let’s start with IFERROR. IFERROR is actually an extension to the IF function. It tells Excel what to do with other formulas when it can’t find the answer or when it returns an error. 

Read More
Comments

Using IF logical function in Excel (example with screenshots and a video tutorial)

10/2/2017

Comments

 
Today I’m going to talk about IF formulas. IF functions are logical functions, meaning that any formula you write with an IF function will return one value if a condition is true and another value if the condition is false.

Read More
Comments

How to use VLOOKUP in Excel? (Example with screenshots and a video tutorial)

9/24/2017

Comments

 
Today I’m going to cover one of the most important functions in Excel, and probably going to be one of your favorite functions as well. It is VLOOKUP.
​
What VLOOKUP allows you to do is that if you've got 2 tables and you got 1 common field in these 2 tables, you can pull data from one table into the other table. Meaning that you can look up this common field from table 1, find it in table 2 and return any other field from table 2.

Read More
Comments

8 functions that will transform how you work with "Dates" in Excel

8/14/2017

Comments

 
​Most of us are working with dates in Excel everyday, and knowing those useful functions will save you a lot of time and effort. 

​There are a lot of Date functions in Excel, but I will go through the most useful ones.

Read More
Comments
<<Previous
© 2017 Mohamed Nada. All Rights Reserved.
  • Home
  • Blog
  • Resources
    • Pivot Tables e-Book
    • Excel Cheat Sheets
  • About Me
  • Contact