Need Help? Chat with us

By

Yoda Learning

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 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

Copy Text from Image Using Microsoft OneNote

Tired of typing text from the image. Then stop this time-consuming task. Learn awesome techniques to copy text from image in three simple Copy+Pasting steps using Microsoft OneNote. Try this step by step technique to copy text from images – No more re-typing pages after pages: Copy & Paste the image on Microsoft OneNote Right-click on...
Read More

VBA Code to password protect excel for a shared Excel file

In this blog, we will try to cover how to 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...
Read More

Selecting Multiple Options in Dependent Drop Down List Box using VBA

In our earlier blog we have already discussed how to create a dependent drop down list box in Excel and as well as in VBA when we are using the list box in VBA. Now in this blog, we will discuss how to select multiple options from the dependent drop down list Box as it...
Read More

Quarterwise Sales Comparison Dashboard with Charts in excel using VBA

Thanks for your feedback on our earlier blogs. We have already covered how to create a summary report quickly via Excel VBA. In this blog, we will cover the charts in excel. If you have not gone through the earlier blog, then please go through this link: Create Summary Reports Quickly via Excel VBA. In this...
Read More

Top 10 Best Practices – Effective email subject lines

One of my clients recently asked if I had any good write-up on best practices on how to write professional & effective email subject lines. I was surprised and I thought who would need a write-up or a guideline on a topic as simple as writing effective email subject lines. I mean, did we ever went...
Read More

If you use ALT + TAB to toggle, read these 6 lines…

We all use Alt-Tab to toggle different windows of applications. Even though we use this key shortcut to do our daily job yet we don’t know this tricks. Alt-Tab ↹ is the common name for a keyboard shortcut that has been in Microsoft Windows since Windows 3.0. This shortcut switches between top-level windows without using...
Read More

What can you do on a date… err… with a date in excel ?

Dates are one category of information that is found in ALMOST ALL Excel reports. You can maneuver with them like a Maverick (Read: Tom Cruise’s starrer movie – Top Gun) These are the things you can do with a date in excel: You can find which day of the week it is (e.g. Sunday, Monday…)...
Read More

Excel VLOOKUP Function

Before we learn how to use Excel VLOOKUP function, we must learn when do we use Excel VLOOKUP function? Task: Imagine if you have to find when does train no. 6948 departs in the schedule chart above? Your approach: You will scan the first column top to bottom. When you find the same train no.,...
Read More
1 11 12 13