fbpx
Email: [email protected] Call Now! +1 203-349-9909 / +91-8080042523

By

Yoda Learning

Remove Password from Excel Using VBA [Macros] Tutorial

How to remove password from Excel using VBA as part of our continued effort to give valuable resource of learning for Excel VBA Macros tutorial students. If you are following our blogs on a regular basis then probably you have gone through the blog where Rishabh have very clearly shown to us that how to...
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

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 protect cells and hide formula in excel ?

Investment banker protects the excel file by password and hide formula also hide formula in google spreadsheet, but anyone having access to the file can easily access the formulas used in the cell by having a cursor on the cell. As part of our continued Excel Training series,  you will learn how to protect cells...
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 version, 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 If You Want the...
Read More

How to Remove Duplicates in Excel

How to Find and Remove Duplicates in Excel In Microsoft Office Excel 2007, Excel 2010, Excel 2013, Excel 2016, 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...
Read More

Error in excel when you Insert Column or Row in Excel (Solved)

Are you fed up with the Errors in Excel while entering a row or column? Then you have come to the right place.  Error in excel when you Insert Column or Row in Excel (Solved) This blog will clear all your doubts and ensure that you will never have any errors next time you use...
Read More

Combine Text with Date or Time in Excel – Reporting Tips

  Many time you prepare financial reports in multiple sheets where you have to mention the date of signing report along with the certain text. Combine text with a date by following these simple steps: Hence it increases responsibility to update the date on each sheet. What if you enter a proper date in one sheet...
Read More

Calculate Elapsed Time in Excel

We want to calculate elapsed time in excel i.e. Add or Subtract hours, minutes and seconds to the time. How to calculate elapsed time in Excel? Use the following formula TIME (HOURS, MINUTES, SECONDS) to calculate elapsed time in excel. After entering the formula, you may require changing the cell format as per your requirement. In...
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

Loop Multiple Sheets and Merge Data using Excel VBA Worksheets

In this blog article, we will be covering how to loop through multiple sheets and merge data in Excel VBA Worksheets as per our requirement. Just imagine you have a lot of files in a folder and for each file, you have 3 sheets. Let’s Start how to merge data in VBA Worksheets. Now If I...
Read More

Excel Security | How to lock cells in excel

How to Keep my excel secured? Excel Security To lock cells How to lock cells in excel? while Maintaining the integrity of an excel file that has to be shared with peers is a challenging job? Earlier versions of MS excel had a password feature but they were widely criticized because they were pretty easy...
Read More

How to make original Good-looking Presentation slides

Guide to make original Good-looking Presentation slides. Today, if you want to succeed in your corporate job, you must know how to impress the ‘higher-ups‘ of your organization using your presentation slides.
Read More

How to Use Excel VLOOKUP Formula

What is Excel VLOOKUP & How to Use? Excel VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching. The “V” stands for “vertical”. Lookup values must appear in the first column of the table, with lookup columns to the right. you will...
Read More

What-if Analysis using Excel Dashboard, Indirect Function & more

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

Create Magnifier Glass Effect in Powerpoint Picture

I frequently visit “Investor Relations” section of numerous companies. On one such occasion, I stumbled upon an Investor PowerPoint Presentation of a Global Auto major (BMW Jan 2014). I was mesmerized by the look of a Powerpoint picture in certain slides and started exploring techniques on how to highlight in powerpoint slides. The following picture...
Read More

Drag and Drop: 5 Simple MS Excel Shortcuts that really Work

Working on your Excel spreadsheets can be much faster than you think if you use this 5 Simple drag and drop MS Excel Shortcuts: 1. MS Excel Shortcut for Copying and Moving: Excel has a unique feature hidden somewhere in the “Paste Special” column which many people don’t know about. Values can be added, subtracted,...
Read More

PowerPoint Tips on converting text to graphics using Smartart

MS Word & PowerPoint Tips on how to convert a simple ordered or unordered List like converting text to graphics. Microsoft Word & PowerPoint has built-in shapes and designs in SmartArt Tool which can be used directly; while preparing project report or presentation you may need to design some charts, lists, graphs, shapes etc. In order to...
Read More

Create report in excel using Pivot Table Techniques

Create report in excel using a pivot table for sales data analysis is an important aspect of any business. Unless you are able to measure and analyze 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...
Read More
1 8 9 10 11 12