fbpx

By

Yoda Learning

249+ 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 the most used Excel shortcuts to use when you just begin working with...
Read More

How to Find Duplicate Values in Excel

You can Find duplicate values in Excel by reading this blog. An Excel sheet is a great way of packing lots of data into a dense area. But, these documents will become unmanageable and unwieldy when they’re in use for a long period of time. This example teaches you how to find duplicates in Excel....
Read More

How to Lock Formulas in Excel?

How to Lock Formulas in Excel? Protect formula in Excel? Confused? Here is the blog to know how to lock excel formulas. Imagine Your boss wants you to protect a workbook, but she also wants to be able to change a few cells after you are done. So, before you password protected the workbook (or...
Read More

Remove Password from Excel or Unprotected 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

Turn ON or Turn OFF Scroll Lock in Excel

Imagine your report is due in an hour. You are working along in Excel, everything is going well, but suddenly you notice that you can no longer move around properly in your spreadsheet. You press the arrow keys, but instead of the cursor moving to another cell, the entire worksheet seems to be moving. So,...
Read More

How to Split Cells In Excel

Merging and splitting cells in Microsoft Excel is very similar. Below are the steps required for merging and splitting cells in each of these programs. These steps help you with How to Split Cells in Excel. Follow the step by step process and split excel cells into multiple cells. This tutorial will help you to...
Read More

Strikethrough in Excel & Word | Strikethrough Shortcut

Strikethrough in Excel & Word helps to delete it (Strikethrough Shortcut in Excel). An example sometimes, while creating a document we don’t need a few texts we can just delete it. But when we want to show the unwanted text we used the Strikethrough text option. This option will let the text remain where it...
Read More

How to Display/Show Formulas in Excel

If you are working on an Excel worksheet with a lot of formulas in it, it may become difficult to follow and keep track of all your formulas. Excel provides a simple way of displaying formulas in the cells instead of the result. This Excel Trick will help you to Display/Show Formulas in Excel without any...
Read More

Excel Formulas & Functions in PDF List

Excel Formulas PDF and Functions: What do you Understand by the Advanced Excel Formulas and Basic Excel Functions? This Blog will give you the Excel formulas PDF/list of the Key Functions of Excel. Excel Formulas PDF is a list of most useful or extensively used excel formulas in day to day working life with Excel. These formulas, we...
Read More

How to delete rows in excel based on a condition?

In this blog, I will discuss how to delete rows in excel based on the condition. Sometimes we get the data set from another person and the need to do a lot of work to clean this data set. You need to delete a certain section of data that is not relevant or there are innumerable blank cells,...
Read More

Copy Text from PDF without Line Breaks & More Word Tricks

How to copy text from pdf without broken lines? We have been working on Excel, VBA & Powerpoint tutorial, and felt the need for exploring Word Tricks to enhance productivity and save a ton of time of professionals who use MS Word for multiple purposes like writing an idea, designing template, making a professional report...
Read More

Undo – Redo Shortcuts Keys in Excel

Undo, Redo shortcut keys for MAC & Windows and other foremost needed Functions: Easy and Essential keyboard shortcut functions of Excel you’ve been looking for. There is a list of essential Excel Shortcuts which will help you get in your Comfort Zone.  If you spend a lot of time in Excel then you must know about...
Read More

Unprotect Excel | Excel Password Remover Online

Open password-protected the file from this simple excel tips & tricks. Learn how to unprotect excel or remove password from excel. Let me warn you upfront – THE MOMENT you learn applying this trick on How to Unprotect Excel, you’ll JUMP in ecstasy. If you are ready, then read on. Almost ALL Excel users wish at...
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

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) Problem: When you try to insert rows or columns into a Microsoft Excel 2007 or higher version worksheet, you may...
Read More

Combine Text with Date or Time in Excel – Reporting Tips

Many times you prepare financial reports in multiple sheets where you have to mention the date of signing report along with the certain text. There are multiple ways to combine text with a date or time in excel. Combine text with a date by following these simple steps: Hence it increases responsibility to update the...
Read More

How to Find Circular Reference in Excel

In Excel, a Circular reference warning is received with raised eyebrows and terrified looks most of the time. But from our experience, we know it to be all smoke and no fire, which we will prove to you right here. So what really is a circular reference? It simply means that your formula includes a cell...
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 workbooks with the same data. I hope you have enjoyed our earlier blogs, revisit “How to split excel data into separate spreadsheets using VBA“....
Read More

[How to] Calculate Profit Margin in Excel | Profit Margin Formula

Struggling with profit and loss? Or still, figuring out how to calculate the profit margin in excel? Here is your answer, the Profit margin is an important figure for business because it tells the percentage of each profited sale. Profit margins are important when pricing products, pursuing financing and generating sales reports. If you create...
Read More

5 Easy Steps to Concatenate Data using ‘M’ in Power Query

How to use power query concatenate function? There are times when we want to perform such tasks that are not built in the user interface i.e. features that are not available on the ribbon. But still, this can be possible with Power Query’s programming language which is called M language. In this article, we going...
Read More
1 2 3 13