fbpx

By

Yoda Learning

How to use the Histogram in Excel (Step By Step Guide)

In case, if you plan to use the Histogram tool, you need to keep in mind and you have to make sure that the Analysis Tool Pak Add-in is installed on your system. Using the Histogram in Excel: If you’re planning to use the Histogram tool, then there are certain things that you need to...
Read More

Alteryx Interview Questions and Answers | Alteryx Gallery – Public Gallery

Alteryx Interview Questions and Answers: Whether you are a fresher or an experienced professional, you need Alteryx Interview Questions and Answers to have a better understanding of Alteryx. Our real-time experts prepare these Top Alteryx Interview Questions and Answers, and this tutorial will help you to crack your next Alteryx job interview very quickly. With...
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

5 Excel Charts Hack to Make Your Boss Smile | Excel Tips

Doesn’t it feel great to get that approval from your boss that everyone around you is striving for? Of course, it does. After reading this article, that dream is going to come true really soon. In today’s tutorial, we going to learn top5 Excel Chart Hacks to make your chart sexy.   Here are some...
Read More

Macro to convert Excel to PDF file

Looking to convert Excel to PDF File? Don’t worry we offer you the best practice to create PDF Files from Excel using VBA Macro. Which of these tasks is part of your daily work life? To Convert Excel to PDF Sending PDF attachments via email How to Convert Excel to PDF File Using VBA Micro...
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

Power BI Architecture | Power BI Security

Microsoft Power BI is a self-service analytics tool. It is responsible for covering various topics of analytics such as data analysis, performing ETL, preparing datasets, modeling the data, report building, visualizations of the reports, and much more. To learn Power BI and deep dive into the possibilities, it is essential to learn its Architecture. This...
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

Keep Duplicate Records in Power Query

Power Query in Power BI allows you to perform a series of steps to transform your data. One of the steps amongst this is to keep duplicate records. Keep Duplicate Records In Power Query We generally take out duplicate lines but if we need to keep and check what the duplicates are, Power Query allows...
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 in excel will make your worksheet or spreadsheets look attractive and easy to read. Almost all Microsoft Excel users know how to change the date format, numbers and text formats using rows and columns.   But very few...
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

Tableau Interview Questions and Answers [Q&A]

Tableau software has become a basic need for any business as it helps to understand the growth and development of the company. Tableau is a data visualization tool that allows the user to develop an interactive Dashboard. In this article, we discussed the most important Tableau Interview Questions and Answers. Using Tableau software, any non-technical...
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

Power Bi Dax Deduplication Based On Column

To do Power BI DAX deduplication based on column or to eliminate the duplicate data from a data set, Power BI has a weapon called DAX. Data Analysis Expressions (DAX) is a library of functions and operators that can be united to create formulas and expressions in Power BI Desktop.     We can deduplicate...
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

Financial Analyst Interview Questions & Answers [Q&A]

Financial Analyst Interview Questions stated below is a boon for the individual going to face a business interview. We have gathered all the important points and questions asked in a financial interview by discussing with many interviewers and our experienced panel. Just go through the financial analyst interview questions before attending an interview to know...
Read More
1 2 3 4 5 13