On one hand MS Excel offers some advanced features. On the other hand, it may create some serious problems like file corruption. This problem becomes big if we do not take a corrective measures to handle the file corruption. There are several factors which are likely to be responsible for spreadsheet corruption: Virus infection and […]
Today let’s learn how to generate unique usernames in Excel, even when you have duplicates in your data. Formulas Used 1) IF( condition, [value_if_true], [value_if_false] ) Learn More about IF() Parameters or Arguments condition The value that you want to test. value_if_true Optional. It is the value that is returned if condition evaluates to TRUE. […]
This article will explore the Excel VLOOKUP Formula and show you how to combine it with an IF statement to flag if there are multiple lookup values matches in your data set. VLOOKUP is really great for pulling in data from a larger table in Excel, but sometimes in a larger data sets there may […]
10 Excel Tips and Tricks which are Incredibly Easy, Quick & Handy: Automatically SUM () with Alt + =: Did you know you could add an entire row or column by simply clicking the first empty cell? Click, press ALT + ‘=’ and simply add up the numbers in every above cell. Number Formatting Keyboard […]
In Excel 2010 onwards you can create your own Ribbon Tabs as well as add your own Macros to them!. Let’s learn how really easy this is to do. This is really useful if you have a set of commands you use on a regular basis and want to keep them on a totally separate […]
The whole idea of a Dashboard is to provide a graphical interpretation of the most relevant data, such as a balanced scorecard. Moreover, the updating of new data into the dashboard every week or month should be automated as much as possible. This is where the data model becomes crucial if you want to achieve […]
It is not breaking news, but something that anyone working on an Excel Report using formulas and functions, will know the keys of successfully using lookup formulas. They are vital for making almost any spreadsheet or dashboard. That is why when you learn how to extract information from Excel tables, you will be truly excited, […]
Today let’s look at 3 different ways to enter formulas into your Excel workbooks. Do you use the same method over and over again?. you may find a quicker method… read on with me. Let’s look at an example where want to find the Total Costs which we want to display in Column F, which […]
Here are some cool options for entering data quickly into an Excel worksheet…
When you spend a lot of time entering data in Excel it helps to understand the tools available to you to speed up data entry. Here, I’ll show you a range of Excel features which make entering repetitive data much easier.
Taking the time to learn some Excel tips and tricks will likely help you boost your productivity and streamline your spreadsheets.