By

Yoda Learning

Remove Password from Excel Using VBA [Macros] Tutorial

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

I was recently invited to hold a 1 day workshop on “Excel for Data Analysis”

I was recently invited to hold a One day Excel workshop on “Excel for Data Analysis” in Baroda Chapter of Institute of Chartered Accountants of India (ICAI). Baroda (Vadodara) is the third largest city in the western Indian State of Gujarat. I was almost half asleep while waiting to board a Sunday morning flight (6:35...
Read More

Find that rascal cells asap – IN EXCEL

  How many cells in your Financial Model have been left blank? Which cells have been fraudulently “modified” or hard-coded after you wrote the formula? How do I delete or color all error laden cells – all in one go? E.g. #N/A! How do I play FreeCell Solitaire? FreeCell Solitaire?! Ignore that. It’s a classic...
Read More

Life is full of What Ifs … (So is Excel!)

What If I were a Baseball Superstar… Also what If I could teleport myself from my office to Miami beach… What If I perform Excel What If Analysis with scroll buttons to do a collar-up in office… Price Sensitivity Analysis using Excel What if: We can’t fulfill the first two wishes. However, our latest course...
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. The blog relates with how to search data in Google using Excel VBA and take how many search result it is fetching: For example: Write “Apple” in Google search box Press Enter↵ It will show...
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

Objective of this article: 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 Majority of Cells Unlocked...
Read More

Find or Remove Duplicates in Excel – 3 Simple Ways

Remove Duplicate in Excel with these 3 Simple Ways In Microsoft Office Excel 2007 and in any subsequent versions, you have several ways to filter for unique values or remove duplicates in Excel: Use the Remove Duplicates command in the Data Tools group on the Data To filter for unique values, use the Advanced Filter...
Read More

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

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. 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 in each sheet. What if you enter a proper date in one sheet and...
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? 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 the elapsed...
Read More

Excel VLOOKUP Function: Why and How? | Excel Tips & Tricks

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 Through Multiple Sheets and Merge Data using Excel VBA

In this blog article, we will be covering how to loop through multiple sheets and merge data as per our requirement. Just imagine you have a lot of files in a folder and for each file, you have 3 sheets. Let me explain you how to merge data with an example. Now If I ask...
Read More

Text to Columns in Excel | Split cells in excel

Text to Columns in Excel or Split Cells in Excel is used in data cleaning and data re-arrangement. Excel text to columns formula technique is used for following: Splitting text of one cell in multiple columns (opposite of Concatenate) Changing the data format of a column (General, Text, Date) Converting numbers with trailing minus sign into negative numbers...
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. Download it now! If you found...
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

I saved a board meeting…using Powerpoint Graphs | Powerpoint tips

What you can do with PowerPoint graphs ? One day I received a call from one of my client companies (a prominent non-banking financial service,) which receive applications for loans and processes it for further action – approved & disbursed vs. rejected. Learn how to use PowerPoint graphs based on real-life cases: Situation: A senior level meeting had been...
Read More

Excel Security | How to lock cells in excel | Protect Sheet

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 to crack. However, the latest versions have fortified the security and...
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
1 2 3 4 5 6