Loading...

Follow Excel Rush on Feedspot

Continue with Google
Continue with Facebook
or

Valid
Very often, confusion prevails when it comes to calculations based on Time in Excel. Any calculation gives out seemingly random numbers and you don’t know what to do with it. Read on to really understand how Time works in Excel.
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Whether you are a Freelancer, a StartUp, an Established Business, or even if still working on a new Business Idea, Pivot Tables can do brilliant magic for you! Decision making will become so much easier and faster! In this course, learn how to use Pivot Tables & Charts Super Effectively and create meaningful, actionable Reports for your Business, in a flash! What […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
A range of cells filled with data is generally called a table. So, you put ‘All Borders’ around your data and think it is a table no? Maybe also format the headers a bit. But, this is just formatting applied to a normal Excel data range. Sure, when you print it out, it looks like […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Excel Rush by Jeet Shah - 1y ago
The if function allows you to give a condition to Excel. Based on this condition, many other things can be done. The default output for this function is just true or false. The key here is that you can define an action if the output is true; or another action if the output is false. […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Whether it’s delivery date, payment date or a followup date, you want Excel to tell you when it’s overdue. Use this simple method to highlight (color) all cells that are overdue. The best part is, it is dynamic in nature, meaning it will check automatically on a daily basis whether a particular item is overdue ‘today’ […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Mobile numbers are always numeric and of a certain length. You want to ensure data entered is exactly as per that. In India, mobile numbers are 10 digits. Meaning if any mobile number that’s entered isn’t exactly 10 digits, it’s not a correct data entry. Similarly, in other countries, mobile number length’s vary. Whether you’re […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Whenever you type =SUM in a cell in Excel, you get a lot of functions starting with Sum… In this blog post, we will be focussing on 4 of them – SUM, SUMIF, SUMIFS, DSUM. Each of these functions has its own capability for Summing up numbers. Let’s go one by one. We will be using […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
When Google came up Google Docs and Google Sheets, it started a completely new way people collaborate online to create and work on documents and sheets in groups. The extremely user-friendly interface for collaborating completely changed the way people work today. A lot of StartUp businesses today manage all their data using Google Sheets. Mainly […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
You will save a lot of time on a daily basis by using the Enter key in these 4 ways. You may think, what is more to learn in using the Enter key in Excel? Read further to know what are the 4 ways and what they can do for you. Enter (Normal) When you […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
When you work with Excel, you must avoid using the mouse as much as you can. Using the keyboard only will help enhance your speed a lot, and you will start saving a ton of time! I understand that remembering Excel shortcuts is a pain, so I have listed below 10 shortcuts which can be […]
Read Full Article

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview