How Time Formulas work in Excel
Excel Rush
by Jeet Shah
3y ago
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 more
Visit website
Master Business Reporting with Pivot Tables & Charts – Online Course
Excel Rush
by rushabhs
3y ago
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 more
Visit website
Excel Tables vs Excel Data Range
Excel Rush
by Jeet Shah
3y ago
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 more
Visit website
IF vs IFS
Excel Rush
by Jeet Shah
3y 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 more
Visit website
Highlight overdue items using Conditional Formatting
Excel Rush
by rushabhs
3y ago
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 more
Visit website
Allow only 10 digit numeric mobile number in Excel using Custom Data validation
Excel Rush
by rushabhs
3y ago
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 more
Visit website
Difference between SUM, SUMIF, SUMIFS, DSUM
Excel Rush
by rushabhs
3y ago
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 more
Visit website
5 Advantages of Google Sheets over Excel that you didn’t know
Excel Rush
by rushabhs
3y ago
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 more
Visit website
Four things you can do with Enter key in Excel
Excel Rush
by rushabhs
3y ago
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 more
Visit website
10 Excel Shortcuts that will change the way you work
Excel Rush
by rushabhs
3y ago
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 more
Visit website

Follow Excel Rush on FeedSpot

Continue with Google
Continue with Apple
OR