Need Help? Chat with us
[email protected] +1 203-349-9909 / +91-8080042523

By

Yoda Learning

MS Excel Shortcuts Keys in PDF | Excel Keyboard Shortcuts

MS Excel Shortcuts Keys, when starting with Microsoft Excel, knowing a few ms excel shortcuts keys will reduce your work time and make it easier to work on Excel. Using the mouse to do all the task reduces your productivity. Here are a few shortcuts to use when you just begin working with Microsoft Excel....
Read More

Learn how to compare values in Excel

Comparing values in Excel is something that we all do once in a while. Microsoft Excel offers a number of options to compare and match data, but most of them focus on searching in one column. When using Excel for data analysis, accuracy is the most vital concern. Incorrect information may lead to missed deadlines,...
Read More

Time Travel with PowerPoint tricks – Smart Art for Powerpoint

Time travel has been a core theme for many Hollywood science fiction flicks. Well, let me make it a reality for you. You can zoom past an hour in less than five minutes with these special power point tricks. 1) Convert boring bullet points in attractive SmartArt in 5 seconds – I borrowed some text...
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 remove password from Excel or Unprotect an Excel

How to remove password from excel spreadsheet or Unprotect Excel Spreadsheet without using any software or Password Remover. So what it includes? This includes changing the file extension and manipulating its constituents to get an unprotected excel file or unlock an excel file. Almost ALL Excel users wish at some point or the other felt the...
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

9 Excel Error in Formula and How to correct it

Do you feel agitated when you are engrossed in setting up formulas in your EXCEL and suddenly you see jargon of excel error like #NAME, #REF appearing in your excel spreadsheet? Here’s a list of top 9 mistakes that one makes while entering an Excel formula + tips on how to avoid them: 1. Excel Error –...
Read More

Export data from SQL to Excel spreadsheet using VBA

In this blog, we will Import data from SQL to Excel spreadsheet using VBA. Assuming that you have a little bit of knowledge on SQL server. Now if you are preparing reports in Excel and the data is on your SQL server then you don’t need to copy the data first from SQL server to...
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

Password protect excel using VBA for a shared Excel file

Password protect Excel Sheet based on the User as part of excel vba tutorial. For Example, you have a master excel sheet in your centralized location. Now everyone can access the same file and if someone changes something on that it is very difficult or hard to track who has modified the same. Password protect excel sheet...
Read More

Learn how to use SUMIF Excel Function

The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet. You can try the SUMIF function to add...
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

Learn how to create or make excel scatter plots

In this blog, learn how to create excel scatter plots and you will able to make excel scatter plots at the end of the blog. Choosing the right type of chart or graph can be key to convey the most important insights of your data—on sight. When you want to dig a little deeper into...
Read More

How to Merge Excel Files in to one Or into a Spreadsheet using Excel Macro

How to merge excel files or combine excel files into a single sheet from a different workbook using excel macro is the topic of this blog. But in the earlier blog, we have covered how to merge data in a single sheet when the data are coming from the same sheet. We are trying to cover...
Read More

How to split spreadsheet into separate workbooks using Excel VBA?

Earlier we have split our data into separate excel sheet but this time, we will split spreadsheet records into a new workbook. It’s useful and reduces our effort in making different workbook with same data. Hope you have enjoyed our earlier blogs, revisit “How to split excel data into separate spreadsheets using VBA“. Split spreadsheet...
Read More

Excel Advanced filter technique using the Subtotal excel function

Subtotal Excel formula of excel advanced filter is a definite hit, both for beginners and experienced users who haven’t seen this feature in action before. If you work with large data set and often arrange your data for analysis, It’s practically impossible for someone to make a conclusion by sampling looking at this massive data....
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

Merge excel files into a single excel spreadsheet

In a continuation Excel VBA tutorial series of data manipulation using Macros; Today, we will try to merge excel files in a single excel spreadsheet. The source of the data may be from the same worksheet or from the closed workbook. We will merge excel files into a single sheet. For example, individual states data...
Read More
1 9 10 11 12