# Yodalearning.com how to use exel, tips & tricks excel

### FREE Excel Course Training (15+ Hours) Learn Excel Basic

**Details: **Free **Excel** Course Training Online. Thus, to make it easy for you I have divided the FREE **Excel** Course into three parts, also you can directly navigate to a particular module by clicking on their name. Module 1: Formula and Functions – Get insights into all the formulas and functions. Module 2: Pivot Tables – Get to learn Pivot Table and its

› Verified *1 days ago*

› Url: https://yodalearning.com/tutorials/free-excel-course-beginner-advanced/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### [PDF] 400+ Excel Formulas List Excel Shortcut Keys PDF

**Details: ****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 can use in **Excel** 2013. 2016 as well as 2019. The **Excel** Functions covered here are: VLOOKUP, INDEX, MATCH, RANK, AVERAGE, SMALL, LARGE, LOOKUP, ROUND, COUNTIFS, SUMIFS, FIND, DATE, and many more.

› Verified *4 days ago*

› Url: https://yodalearning.com/tutorials/excel-formulas-pdf/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### 220+ Excel Shortcuts Keys for Windows & Mac Excel

**Details: **The following is the list of **Excel** Shortcuts. Shortcuts give the ease of working and improves the speed as well. To help with shortcuts we have brought it at one place for you to follow and placed it category wise to make it easy to remember and locate it easily.

› Verified *1 days ago*

› Url: https://yodalearning.com/tutorials/ms-excel-shortcut-keys-for-beginner/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### [Quick Way] to Display/Show Formulas in Excel Show

**Details: ****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 issues. Similarly, for more such tips & tricks you can follow our **Excel** …

› Verified *8 days ago*

› Url: https://yodalearning.com/tutorials/display-formulas-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### (Useful Trick) How to Attach File in Excel or Object in

**Details: **Insert Files into **Excel** 2016/2019 Worksheet. as we already see the different ways to insert files into an **excel** sheet. One more method to insert a file into **excel**, please follow the below steps, Step 1: Select **Excel** Cell into which you want to insert a file, Step 2: Click on Insert Tab; Step 3: Click on Object under the “Text” group

› Verified *4 days ago*

› Url: https://yodalearning.com/tutorials/how-to-attach-file-in-excel-or-object-in-excel-spreadsheet/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Create Formula in Excel

**Details: **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,

› Verified *7 days ago*

› Url: https://yodalearning.com/tutorials/create-formulas-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Unprotect Excel Sheet [Remove Excel Password in 5 Mins

**Details: **There are two ways to remove password from **Excel** file; the one has stated above and the other one is as follows: Step 1: Open the worksheet you want to unprotect. Step 2: Click on File > Info > Unprotect Sheet. Step 3: Or go to Review Tab > Changes > Unprotect Sheet. Step 4: If the worksheet asked the password for opening, enter the password

› Verified *1 days ago*

› Url: https://yodalearning.com/tutorials/unprotect-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### [How to] Calculate Profit Margin in Excel Profit Margin

**Details: **The **Excel** Profit Margin Formula is the amount of profit divided by the amount of the sale or (C2/A2)100 to get value in percentage. Example: Profit Margin Formula in **Excel** calculation (120/200)100 to produce a 60 percent profit margin result.

› Verified *5 days ago*

› Url: https://yodalearning.com/tutorials/calculate-profit-margin-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### {Quick Tips} Use Special Characters in Excel ︎ Complete

**Details: **224 rows · Press Alt key, and hold. While the Alt key is pressed, type the …

› Verified *Just Now*

› Url: https://yodalearning.com/tutorials/special-character-symbol-list-with-shortcodes-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Quick Way to Insert a Picture into a Cell in Excel Step

**Details: **In the recent versions of **Excel**, insert a picture in **Excel** Cell 2013, insert a picture in **Excel** Cell 2016. You get to add images from the Web-pages with the help of the Bing Image Search. This will let you insert an image in **Excel**. Let’s look at the steps: Step 1: In the Insert Tab, select Online Pictures; Step 2: Select the image that you

› Verified *3 days ago*

› Url: https://yodalearning.com/tutorials/insert-a-picture-into-a-cell-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### {Quick Way} How to Compare values in Excel Quickly

**Details: **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, misjudged trends, wrong decisions, and lost revenues.

› Verified *5 days ago*

› Url: https://yodalearning.com/tutorials/learn-compare-values-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Match Names in Excel Where Spelling Errors Using

**Details: ****Excel** Quartile Function Undo & Redo Shortcut **Excel** CHAR formula to inert degree symbol. Let us See How Fuzzy Lookup Comes in Handy in Such Cases. Step 1: Click on the Tab Fuzzy Lookup. Step 2: Click on Fuzzy Lookup button to get a toolbar on the right like shown above. Step 3: Now you need to feed tables in the toolbar on the right.

› Verified *3 days ago*

› Url: https://yodalearning.com/tutorials/how-to-match-names-in-excel-where-spelling-differ-or-vary/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Best 5 Ways to insert Degree Symbol In Excel in Windows

**Details: **Degree Symbol Insert / Type in **Excel**. What if you’re working on a Temperature Data? Here, you must learn how to use the degree symbol in the **Excel** data to show the numbers in Celsius and Fahrenheit.. For this, one of the most important things is to use the degree symbol in data to show numbers in Celsius and Fahrenheit.

› Verified *Just Now*

› Url: https://yodalearning.com/tutorials/how-to-type-degree-symbol-in-excel/ Go Now ^{}

› Get more: How to useGo Now ^{}

### Excel Advanced Filter

**Details: **Subtotal **Excel** formula of **excel** advanced filter is a definite hit, both for beginners and experienced users who haven’t seen this feature in action before. If you work with large data set and often arrange your data for analysis, It’s practically impossible for someone to make a conclusion by sampling looking at this massive data.

› Verified *6 days ago*

› Url: https://yodalearning.com/tutorials/subtotal-excel-formula-excel-advanced-filter-trick/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### ︎[Solved] Error in Excel Insert Column or Row in Excel

**Details: **Press and hold down CTRL+SHIFT, and then press the RIGHT ARROW key to select all of the columns to the right of the first column that you clicked. On the Edit menu, click Clear, click Clear All. Click the first blank row below the last row in your data. Press and hold down CTRL+SHIFT, and then press the DOWN ARROW key to select all of the rows

› Verified *8 days ago*

› Url: https://yodalearning.com/tutorials/error-excel-insert-column-row-excel-solved/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### (Step By Step Guide) How to use Flash Fill in Excel

**Details: **Flash Fill is normally activated by default in **Excel**. If not; you can do so in the below manner: Click File -> Options. Check Automatically Flash Fill. Checkbox under Editing Options group inside Advanced tab and click Ok. Now to execute the function manually: After Step 2, Start the function manually by clicking Data -> Flash Fill.

› Verified *6 days ago*

› Url: https://yodalearning.com/tutorials/how-to-use-flash-fill-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Create Drop Down List in Excel using Conditional

**Details: **Best features of conditional formatting in **excel** which if coupled with drop down data validation list gives you wonderful reports.. Let me show you an example: In this case, I want to allow divisions to these particular newly joined employees. Whenever I want to select a drop down value which says HFD, it should then get colored according to the predefined color …

› Verified *8 days ago*

› Url: https://yodalearning.com/tutorials/conditional-formatting-excel-w-drop-list-based-input/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Create Horizontal Bar Chart in Excel (Step-By-Step

**Details: **Follow the below steps to create a Horizontal Bar Chart in **Excel**. You need to give the table a Name. To do so follow these steps: Click on any cell in the table. Go to Table Tools in Ribbon then Click on the Design tab; Type the name for Table for future reference to create the horizontal bar chart. Check the below image for reference

› Verified *2 days ago*

› Url: https://yodalearning.com/tutorials/horizontal-bar-chart-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Use Excel's Right Function With 'M' To Extract Left Side

**Details: **Use **Excel’s** Right Function With **‘M’** To Extract Left Side Data. But there is an alternate way for using the LEFT Function in M which is explained below. Step 1: Select the Column for Extracting Left Side Data. Load the data in Power Query and select the ‘Month of …

› Verified *4 days ago*

› Url: https://yodalearning.com/tutorials/use-excels-right-function-with-m-to-extract-left-side-data/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### [Excel Tricks] Create Hyperlink in Excel Hyperlink

**Details: **Create a new file using Hyperlink in **Excel**: Think: Imagine that you need to create a doc file and the next few days will work on that continuously.You can create this new file with a hyperlink easily! Step 1: Type a value under the New File column.Here we typed Word File.. Step 2: Open Hyperlink for this cell. Insert Hyperlink Dialog box will appear.. Under Link to, click …

› Verified *5 days ago*

› Url: https://yodalearning.com/tutorials/tricks-create-hyperlink-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Turn ON/OFF Scroll Lock in Excel Enable/Disable Scroll

**Details: **What is Scroll Lock in **Excel**? The Scroll Lock is a setting that determines what happens when you use the Arrow Keys on your keyboard in **Excel**. When Scroll Lock is off (It is a default setting), the Arrow Keys allow you to navigate and select different cells within a worksheet.

› Verified *8 days ago*

› Url: https://yodalearning.com/tutorials/enable-disable-scroll-lock-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How To {Quickly} Create Reports In Excel Using Pivot Table

**Details: **Create a 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 to reach the next level.

› Verified *6 days ago*

› Url: https://yodalearning.com/tutorials/create-report-in-excel-using-pivot-table/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### 4 Easy Steps to Merge Excel Files into One Spreadsheet

**Details: **How to merge **excel** files or combine **excel** files into a single sheet from a different workbook using **excel** macro is the topic of this blog. But in the earlier blog, we have covered how to merge data in a single sheet when the data are coming from the same sheet.We are trying to cover techniques to combine **excel** files in a single sheet when the data is saved in separate …

› Verified *8 days ago*

› Url: https://yodalearning.com/tutorials/merge-excel-files-into-spreadsheet-using-excel-macro/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Make a Scatter Plot in Excel (Step-By-Step

**Details: **To create or make Scatter Plots in **Excel** you have to follow below step by step process, Select all the cells that contain data. Click on the Insert tab. Look for Charts group. Under Chart group, you will find Scatter (X, Y) Chart. Click the arrow to see the different types of scattering and bubble charts. You can pause the pointer on the icons

› Verified *2 days ago*

› Url: https://yodalearning.com/tutorials/create-scatter-plots-excel/ Go Now ^{}

› Get more: Step by stepGo Now ^{}

### [Fixed] Remove Password from Excel Sheet Using VBA [Micros

**Details: **You can also learn **Excel** Macros Tutorial to know the below code. Learn **Excel** VBA (Beginner To Advanced) If you want to be a master at **Excel** VBA Programming language for **Excel** 2007, then our **Excel** VBA macros tutorials will make it easier for you to access it in applications such as Microsoft Office. Come create your own Macros and rule in **excel**.

› Verified *4 days ago*

› Url: https://yodalearning.com/tutorials/remove-password-excel-using-vba-macros/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### [Ultimate Guide] of Excel Advanced Filters with Examples

**Details: ****Excel** Advanced filters technique are useful when you deal with a large dataset. In this blog, we will try to cover one of **Excel** Advanced filter techniques to understand how to split data into a separate sheet through VBA code (it’s a part of our **Excel** VBA tutorial program).. For instance, we have a huge list of U.S. records and we need to split the data as per state.

› Verified *1 days ago*

› Url: https://yodalearning.com/tutorials/excel-advanced-filter-to-split-data/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Split Excel Sheet into Multiple Workbooks Using VBA

**Details: **Step by Step guide on how to split the **excel** sheet: Step 1: Press Alt + F11 to open VBA editor. Step 2: Insert a Module from Insert module. Step 3: Copy the below code and paste in the code window. Step 4: Press F5 to execute the below VBA code.

› Verified *Just Now*

› Url: https://yodalearning.com/tutorials/how-to-split-spreadsheet-into-separate-workbooks-using-excel-vba/ Go Now ^{}

› Get more: GuideGo Now ^{}

### {Tricks} How to combine text with Date or Time in Excel

**Details: **How to Combine Date & Time in **Excel**. to merge/combine the date & time in **excel** cells, follow below steps, Step 1: Here is the simple formula to combine Date & Time in **Excel**. Step 2: A2 indices the first date in Date Column & B2 is for Time Column. Step 3: Type this formula = TEXT(A2,”m/dd/yy “)&TEXT(B2,”hh:mm:ss”) into next column.

› Verified *9 days ago*

› Url: https://yodalearning.com/tutorials/combine-text-date-time-excel-reporting-tips/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Create Sparklines in Excel (Full Guide) What is

**Details: ****Excel** 2010, 2013 and 2016 have a cool feature called sparklines that basically lets you create sparklines i.e. mini-charts inside a single **Excel** cell called ‘Sparklines’. You can add sparklines to any cell and keep it right next to your data. In this way, you can quickly visualize data on a row by row basis.

› Verified *9 days ago*

› Url: https://yodalearning.com/tutorials/create-sparklines-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Create Histogram in Excel using Add-Ins { Step-By-Step }

**Details: **Installation of Histogram in **Excel** using Data Analysis Toolpak add-in: Click on the File tab and then select the ‘Options‘. **Excel** Options dialog box, select the Add-ins from the navigation pane. In the Add-ins dialog box, you have to select Analysis Toolpak and then click OK; This will help you install the Analysis Toolpak.

› Verified *3 days ago*

› Url: https://yodalearning.com/tutorials/how-to-use-the-histogram-tool-in-excel-step-by-step-guide/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### [Quick Tip!] How to Delete Rows in Excel Based on Condition

**Details: **Here are the simple steps to delete rows in **excel** based on cell value as follows: Step 1: First Open Find & Replace Dialog. Step 2: In Replace Tab, make all those cells containing NULL values with Blank. Step 3: Press F5 and select the blank option. Step 4: The Right Click on active Sheet and select delete rows.

› Verified *4 days ago*

› Url: https://yodalearning.com/tutorials/how-to-delete-rows-in-excel-based-on-a-condition/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Undo Redo Shortcuts Key in Excel Top 5 Ways to Undo Last

**Details: **A Quick Recap of Undo & Redo Shortcut Keys in **Excel**:. The shortcut key for the Undo option is Ctrl + Z on Windows and Command + Z on a Mac.Each and every time I use this shortcut, **Excel** will move back one step. The shortcut for Redo is Ctrl + Y on Windows and Command + Y on the Mac.. Just like Undo, the times you’ll use this shortcut, you are definitely …

› Verified *4 days ago*

› Url: https://yodalearning.com/tutorials/undo-redo-shortcuts-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Save Each Worksheet as a Separate PDF Excel VBA Code

**Details: **Save Each Worksheet as a Separate PDF. Step 1: Press the Shortcut keys Alt + F11 to open the Visual Basic for Application window. Step 2: In the Visual Basic for Applications window, Click Insert > Module, then Copy the below VBA code into the code window. Application.ScreenUpdating = False. strFileName = objWS.Name & ".pdf".

› Verified *3 days ago*

› Url: https://yodalearning.com/tutorials/save-each-worksheet-as-a-separate-pdf/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Perform Google Search on Internet Explorer using Excel VBA

**Details: **Please follow the below steps to get the result: Open VBA page by pressing ALT + F11. Go to Insert and then Module. Copy the below code and paste in the Module. Go to Tools and then Reference and select all the reference as shown in Picture 5. Run the code by pressing F5 or from Run button. (Picture 5) google search using **Excel** VBA.

› Verified *1 days ago*

› Url: https://yodalearning.com/tutorials/perform-google-search-internet-explorer-using-excel-vba-excel-vba/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Free Course Access

**Details: **Free Online Courses & Case Study. YOU’LL LEARN COMPLETE GUIDE ON FREE **EXCEL**, VBA, POWER BI.

› Verified *4 days ago*

› Url: https://yodalearning.com/free-course-access/ Go Now ^{}

› Get more: GuideGo Now ^{}

### Steps to Create a List #Query From A Table Column

**Details: **Learn to [Analyse], [Visualise] and [Automate] using the most commonly used tools in organisations globally i.e. **Excel** & Power BI. Recent Posts Alteryx Hotkeys – Alteryx Keyboard Shortcuts

› Verified *4 days ago*

› Url: https://yodalearning.com/tutorials/steps-to-create-a-list-query-from-a-table-column/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Best Ways to Add Column in Power Query with Example

**Details: **Follow the below steps to add a column from example by power query. Step 1: Select the column on which you want to apply changes. Step 2: Add Column from examples using from Selection Options. Step 3: Make changes to the selected column using Add Column from Example. Step 4: Close & Apply.

› Verified *2 days ago*

› Url: https://yodalearning.com/tutorials/best-ways-add-column-from-examples-power-query/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Learn How to Merge Columns in Power Query

**Details: **Step 3: Add Separator to the Merged Column. After you click on Merge Columns option, a Merge Columns window gets open. In this window, you have to add a separator in the** Separator** option from the dropdown list. Here, we have selected the Space option as the separator between two texts. Another option is to add a new column where you have to

› Verified *7 days ago*

› Url: https://yodalearning.com/tutorials/learn-how-to-merge-columns-in-power-query/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Learn How to Filter Records Using Power Query

**Details: **Step 1: Load Data in Power Query. Sometimes the data table is too huge and you do not want to view or access the entire data table. Therefore, the best way is to filter out data and keep only the desired data. Load the data in Power Query as shown in the picture below. Go through the table and check what data you want to keep and decide

› Verified *8 days ago*

› Url: https://yodalearning.com/tutorials/learn-how-filter-records-using-power-query/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Thank You for Joining Yoda Learning Confirm your email id

**Details: **Learn to [Analyse], [Visualise] and [Automate] using the most commonly used tools in organisations globally i.e. **Excel** & Power BI. Recent Posts Alteryx Hotkeys – …

› Verified *5 days ago*

› Url: https://yodalearning.com/thank-you/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Top Categories

### Recently Searched

› Link data to access from excel

› Excel insert variable in text

› Edexcel past papers 2020 january

› Find hours between 2 times excel

› Pokemon go list excel spreadsheet

› Download word excel powerpoint free

› Export access files to several excel

› Change in payment terms excel calculator

› Excel compare and merge disabled

### Trending Searches

› How to use the sumif function

› How to use the countif function

› How to use the excel time function

› How to merge data tables in excel

› How to fix a circular reference error

› Mathematical formulas in excel