fbpx

Tag

Excel

Working with Excel Formula Shortcuts | Excel tips & tricks

What will you get in excel formula shortcuts? You will come to know every single excel formula shortcuts and how to use it. You can use this shortcuts you optimize your daily work. With the help of this tutorial, I had helped almost 10000+ visitors to improve the skills and save time at the office....
Read More

How to create Icons in PowerPoint

Think sometimes you need an icon to be pasted or used somewhere that is not available in your system. In such cases, it is better to Create your own PowerPoint Icon using PowerPoint tools. It is much easier than it seems. Imagine the number of possibilities that you can unlock by using this tool to...
Read More

How to compare two lists in Excel

In the tutorial, we will learn: How to compare two columns in Excel. We use various ways to compare two cells using functions in Excel. Some of these ways are: Comparing two columns row-by-row. Comparing many columns for row matches or differences. Highlight matches or differences between two columns. Highlight row matches and differences. Compare...
Read More

INDIRECT Function with SUM, MAX, MIN & Independent Cell Value

Indirect Function in Excel returns a reference to a range. Excel Indirect functions are useful to create a reference that won’t change if columns or rows are inserted in a worksheet. There are a number of indirect functions in excel such as SUM, MAX, MIN & Independent Cell Value. In this tutorial, we explain one...
Read More

Find & Replace – using wildcard Character (*)

This time we’ll talk about “Find and Replace” and we’ll see its importance in the context of data cleaning. In fact, I have to start with the data which is going to illustrate how is this going to be used. For example, if I have a set of names with certain extra data with respect...
Read More

10 Ninja Tips in Excel

Excel Tips We have made this infographic on Top 10 useful Ninja Tips in Excel. A quick reference point for busy professional working on big financial Data models. Take a look at these Excel Shortcuts to improve your efficiency and productivity in excel. Subscribe now and Get a handbook on Excel Tips and Tricks: I...
Read More

What is Flash Fill ? How to use flash fill in Excel ?

Before we learn how to use flash fill in Excel, there are some questions we need to address first. These questions are: What exactly is Flash fill? Why should we use it? And what can it do for you? What is Flash Fill? Let’s say there is a pattern evident in the cells. Flash fill...
Read More

Create a report in excel for sales data analysis using Pivot Table Techniques

Create a report in excel for sales data analysis is an important aspect of any business. Unless you are able to measure and analyse data, how can you improve your performance? It’s true that improving performance is a whole new story, but unless your data measurement isn’t accurate, you can never hope to reach the...
Read More

Add sizzle to your presentation with PowerPoint special effects

People ask me often – “Where did you learn all the PowerPoint special effects from?” I answer – “Investor Relations!” I frequently visit “Investor Relations” section of numerous companies. They contain Annual Reports, Quarterly Reports, and Investor Presentations, etc. I am always keen to go through their “Investor Presentations” reports. A few of them use...
Read More

Top 3 Ninja level charts for EVERY business…PowerPoint Tips

If my friends ask me my top three picks of the best charts that I use frequently, I will share these: Waterfall 2-axis Stacked Combo Thermometer Waterfall charts have few advantages: A: It can depict sequence in which an activity must be construed. Watch this chart as used in one of the presentations (publicly available)...
Read More

Create a Dependent Combobox in Excel and VBA

In this blog, we will discuss how to create a Combobox in Excel and as well as through VBA. List box & a Combobox are similar but have slightly different controls, to let users make multiple choices of items or to enter their own value in a list. Typical examples of items in these types...
Read More

Unprotect Excel | Excel Password Remover Online

Open password-protected the file from this simple excel tips & tricks. Learn how to unprotect excel or remove password from excel. Let me warn you upfront – THE MOMENT you learn applying this trick on How to Unprotect Excel, you’ll JUMP in ecstasy. If you are ready, then read on. Almost ALL Excel users wish at...
Read More

5 Powerful Tricks to Format cells in Excel

In this article, you will learn 5 Excel tricks on how to format cells in Excel. Applying these
Read More

How to Find Duplicate Values in Excel

You can Find duplicate values in Excel by reading this blog. An Excel sheet is a great way of packing lots of data into a dense area. But, these documents will become unmanageable and unwieldy when they’re in use for a long period of time. This example teaches you how to find duplicates in Excel....
Read More

Perform Google Search on Internet Explorer using Excel VBA | Excel VBA

First time in my life I have come across to create this type of automation and finally, I got success. How to search data in Google using Excel VBA: For example: Write “Apple” in Google search box Press Enter↵ It will show you the statistics that how many records it has populated and also how...
Read More

How to create sparklines in Excel

Sparklines in Excel Imagine you have a result sheet for your students over the last 5 years and want to create a chart in Excel, which takes time. In that case, you are thinking if only there were some small mini-charts in a single cell. Well here is the solution. Ever had a worksheet of...
Read More

Undo – Redo Shortcuts Keys in Excel

Undo, Redo shortcut keys for MAC & Windows and other foremost needed Functions: Easy and Essential keyboard shortcut functions of Excel you’ve been looking for. There is a list of essential Excel Shortcuts which will help you get in your Comfort Zone.  If you spend a lot of time in Excel then you must know about...
Read More

How to unlock or lock cells in excel- Single or multiple

How to lock or unlock cells in Excel? In Microsoft Excel 2007 or later versions like Excel 2019, we want to protect few cells only in a worksheet, then how to do it? Solution: There are two situations to lock cells in excel depending on these reasons. If You Want the Majority of Cells Locked...
Read More

How to Remove Duplicates in Excel | Find & Delete Duplicates

How to Find and Remove Duplicates in Excel In Microsoft Office Excel you have several ways to filter for unique values or find and remove duplicates in Excel. Now, you will learn how to find & remove duplicate values in excel. Use the Remove Duplicates command in the Data Tools group on the Data To...
Read More

Combine Text with Date or Time in Excel – Reporting Tips

Many times you prepare financial reports in multiple sheets where you have to mention the date of signing report along with the certain text. There are multiple ways to combine text with a date or time in excel. If you want to learn more, please check our latest Excel Ninja Course for such type of...
Read More
1 2 3 9