fbpx

By

Yoda Learning

What-if Analysis using Excel Dashboard, Indirect Function

In this topic, I will try to cover the features of what-if Analysis. It is a tool that allows you to try to different formulas. If you apply what-if analysis you will notice changing the values in cells and how those changes will affect the outcome of the formulas in your spreadsheet. Before we start...
Read More

INDEX Formula in Excel

Excel Index Formula is probably one of the most favorite Excel Formulae of many. In my previous post, I had mentioned about my favorite Excel formula. And it was not INDEX(). In my excel training sessions, when I happen to ask my participants about their favorite Excel formula, I am not surprised to hear the answer...
Read More

PowerPoint Picture Tools to Create Magnifier Glass Effects

Learn a new PowerPoint trick using picture tools: Magnifier Case Study: Let’s say my company has launched a new water dispenser. I would like to highlight the new features of the product. To do so, I will like to use a magnifier like an effect to attract the viewers attention (Picture tools). This is a...
Read More

How to Customize PowerPoint Slides Only in 15 Minutes? | Powerpoint Presentation Tutorial

Is your boss constantly nagging your head to complete the PPT in few minutes? In such cases, use shortcuts to get your work done faster, smoother as well as qualitative. I exhibit five effective PowerPoint Presentation Tutorial that you wished you would know much before so that you would complete creating your presentation within no...
Read More

Excel Versions: Evolution of Spreadsheets [Infographic]

Excel versions aka Spreadsheets have a come a long way over the years and plenty of companies today are attempting to build the best one. Spreadsheets have been used by accountants for hundreds of years. Computerised or electronic spreadsheets are of much more recent origin. Information Systems oral history and some published newspapers and magazines...
Read More

Learn how to create a horizontal bar chart in Excel

Horizontal bar chart may look appealing, but to make it may be troublesome. This article shows a step by step process to make a percentage horizontal bar chart in Excel. Consider there are two tables i.e. Income and Expense Select the data with headers and Press Ctrl + T. Do it for both Income and...
Read More

Custom Autofilter In Excel | Create Advanced Excel Filters using Excel VBA

In this blog, I will try to cover how to use a custom Excel VBA autofilter in excel. This Advanced Excel filter technique is meant for Advanced Excel users.  We all know how to use a custom filter or advanced filter in Excel which is also knows as Excel VBA auto filter. Creating custom Excel VBA...
Read More

Advanced Excel Formula Auditing

Microsoft Excel has a lot of features one of it is excel formula auditing. It has a variety of powerful tools that allow checking what is happening in your spreadsheet. Today we will discuss on Advanced Excel formula. It helps you to get the relations between formula and your cells. Which cells are using the...
Read More

How to Calculate Ratio in Excel | Excel Formula

This article is been written to find calculate ratio in Excel Ratio: In simple mathematics, relationship or comparison between two more numbers is known as ratios. Ratios are normally written as “:” to show the connection between two numbers, for instance. You can learn such advanced excel tutorial in our advanced excel dashboard course. If...
Read More

Working with Excel Date Functions

What is Excel Date Functions? How is a date stored in Excel (Hint: Every valid date is a number) A data in Excel is not stored in Excel the way we see it. If you know how it is stored and read by Excel, it will help you write complex logical Excel date functions. It...
Read More

How to compare two columns in Excel?

How to Compare two Columns in Excel Step-By-Step. Find difficulty in finding the same text in Excel, you can have a look for comparing two columns for matches or differences in the same row Like a two-dimensional database. Excel is capable of storing many different types of data from small business contacts to personal income...
Read More
1 11 12 13