fbpx

By

Yoda Learning

How to password protect an Excel file?

When you share one Excel spreadsheet with multiple users, you may don’t want the spreadsheet to be modified arbitrarily by unauthorized persons. If you wish to restrict access to an Excel workbook or if you wish to deny editing privileges to other users, consider adding a password to the workbook as a security measure. Excel...
Read More

How to Create Formulas in Excel?

One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide. This tutorial explains how to write formulas in Excel, beginning with very simple ones. We will learn how to create a formula in Excel using three ways, Constants, Cell references and...
Read More

How to count text in Excel?

Imagine your team members have entered all their project hours in a worksheet and you need to count it. In other words, you also need to count the cells that have data. To complicate matters, the data may not be numeric. Some of your team members may have entered placeholder values such as “TBD”. So...
Read More

How to copy formulas in Excel?

  Before you start reading this blog, Checkout our top Selling Comics: Think: Sometimes we need to do same formulas in another cell or column, but can’t copy easily based on our requirements. There are many ways to copy formulas and its value from one cell to another or one sheet to another. Let’s see some...
Read More

Complete Guide on SQL and it’s Application

SQL which stands for Structured Query Language.  Well, SQL is the Primitive terminology solely responsible for handling the data. It does the styling and supervision of Data and data structures. These Data Structures are compiled together in the Relational database management system (RDBMS). Since SQL got introduced, it has been Celebrated as the language that...
Read More

How to sort in Pivot Table | Custom Sorting

Sorting data in alphabetical order is helpful when you have large amounts of data in a Pivot Table. Sorting lets you organize the data so it’s easier to find the items you want to analyze. You can sort Pivot Table in Excel horizontally or vertically. This allows you to see, at a glance, the rows or...
Read More

How to Search in Excel?

In this blog, you will learn how to search in excel? When working with a lot of data in Excel, it can be difficult and time-consuming to locate specific information. You can easily search your workbook using the Find feature, which also allows you to modify content using the Replace feature. There are many types of search option...
Read More

How to use Roundup Function in Excel

Roundup Function in Excel can use as a variety of formulas to round numbers in Excel depending on the situation. We have ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD and a few more. Here, we will learn how to Round up numbers in Excel. Before we start, we must know about...
Read More

What is Excel VBA? Excel VBA Macros

In this article, you will know what is Excel VBA? What is Excel VBA? Excel VBA Macros VBA which stands for Visual Basic for Applications is the programming language of Excel. You can create a Macro with Excel VBA Macros. Computers and technical devices have their own language to understand the data processing. Although it...
Read More

How to make Data Table in Excel: One-variable data table and Two-variable data table

Before start learning how to make a Data Table, it is essential to learn the basic about Data Table and when we can use Data Table. What is a Data Table? A range of cells in where values can be changed in some of the cells and use of the formula to get different answers...
Read More

How to Create a Line Chart in Excel?

Before we learn how to create a well designed line chart in Excel, we must know what is line chart and when we need this. What is a Line Chart? A linear graph which shows a series of data points connected by straight lines. Line chart is a graphical object used to represent the data...
Read More

How to use sparklines in Excel: Creating a Miniature Chart in a Cell

How to use Sparklines in Excel ? Imagine you have result sheet for your students over the last 5 years and instead of creating a chart in Excel, which takes time. In that case, you are thinking if some small mini-charts in a single cell would be better. Ever had a worksheet of data in...
Read More

Create Pivot Table in Excel | Pivot Table Tutorial

Before we start learning How to create a Pivot table in Excel, We must learn What is a Pivot Table. Pivot Table tutorials What is Pivot Table in Excel? A pivot table is for sorting information. It’s great for calculating and summarizing information that you can use to break down large tables into just the...
Read More

Export data from SQL to Excel spreadsheet using VBA

In this blog, we will Import data from SQL to Excel spreadsheets using VBA. Assuming that you have a little bit of knowledge on the 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...
Read More

Create sales dashboard in excel using VBA Codes

You may have heard about (or seen) sales dashboard in excel a lot of time. When I was a beginner, I used to wonder how to create a sales dashboard in excel using your actual data. I recently helped one of the students of Excel VBA tutorial on how to build one. This can be...
Read More

How to Calculate a Percentage Increase in Excel

Percentage increase calculator Sometimes percentages can be frustrating because it’s not always easy to remember what we learned about them in school. Let Excel do the work for you – simple formulas can help you find the percentage of a total and total cost after the discount. Let see how excel can help us to find...
Read More

How to add Error Bars in Excel: Standard Deviation

How to add Error Bars in Excel: Standard Deviation? Imagine that if all data was perfect, absolute and complete. Although actually, it isn’t, Excel gives us some useful tools to convey margins of error and standard deviations.  If you work in a field that needs to reflect an accurate range of data error, you can...
Read More

Converting trailing minus sign into negative numbers. (Text to Column)

Converting numbers with trailing minus sign into negative numbers. There are series of numbers, wherein some of the numbers are ending with minus sign (-). Now, if you want to apply sum, min, max or average functions, it will not work correctly as Excel cannot read 3789- as a negative. Now Splitting name into two...
Read More

Top 10 keyboard shortcuts that will help you master Microsoft Excel

Top 10 keyboard shortcuts that will help you master Microsoft Excel Top 10 keyboard shortcuts that will help you master Microsoft Excel. Print and Pin it on your board. Stay speedy with these keyboard shortcuts all the time. It’s a good source of revision of shortcuts at once glance. If you found this post helpful,...
Read More

How to freeze rows in Excel | Freeze Column in Excel

How to Freeze row and column in Microsoft Excel? is one of the most used and useful while working on large data as well as while making a dashboard. To freeze panes, freeze rows, freeze columns and freeze cells you can follow the tutorial below. How to freeze rows in Excel? Select a cell for which every row or column preceding...
Read More
1 9 10 11 12 13