In this article, you will learn 5 Excel tricks on how to format cells in Excel. Applying these in excel will make your worksheet or spreadsheets look attractive and easy to read. Almost all Microsoft Excel users know how to change date format, numbers and text formats using rows and columns. But very few know […]
The post 5 Powerful Tricks to Format cells in Excel appeared first on Yodalearning.
How to insert a Picture into a Cell in Excel? Supposedly, you wish to fit in the logos of the Companies in your Excel Sheet. How are you going to do this? You need to know, how to insert a Picture into a Cell in Excel. To show pictures in the adjacent Cell or any […]
The post Insert a Picture into a Cell in Excel appeared first on Yodalearning.
In our tutorial today, we will be looking at some new functions in Excel 2013, these are ISFORMULA and FORMULATEXT Functions. Let’s take them one after the other. The ISFORMULA Function Gone are the days when it is difficult to identify cells that contain formulas. Some time ago, we have to create a user-defined function […]
The post What is ISFORMULA Function and FORMULATEXT Function appeared first on Yodalearning.
Let’s first grasp what a Substitute Function is and when to use it. Before we figure out how to use the SUBSTITUTE function. What is a Substitute function? A Substitute is a person or a thing acting or serving in place of another. Substitute function replaces/swaps a set of characters with another in a text […]
The post How to Use SUBSTITUTE Function appeared first on Yodalearning.
In today’s tutorial, we will be looking at how to make a Table of Contents (TOC). A Table of Contents that can be updated at any time. With MS Word Heading Styles, this can be done. To achieve this, the document is first formatted using MS Word Heading Styles. In this heading style, Heading 1 […]
The post How To Make Table of Contents (TOC) appeared first on Yodalearning.
Before we proceed into the topic of the day, let’s understand the terms: Blank cells and Non-blank cells. Blank cells are empty cells in an Excel spreadsheet. They contain no parameter or data. Non-blank cells, on the other hand, contain parameters. They are not empty. Having blank cells in a spreadsheet is not inevitable. Sometimes, […]
The post How to Count Blank Cells in Excel appeared first on Yodalearning.
In the tutorial, we will learn: How to compare two columns in Excel. We use various ways to compare two cells using functions in Excel. Some of these ways are: Comparing two Columns row-by-row. Comparing many columns for row matches or differences. Highlight matches or differences between two columns. Highlight row matches and differences. Compare […]
The post How to compare two lists in Excel appeared first on Yodalearning.
Spotting the differences in two similar documents is not easy. It is not only taking, it is also tiring and time taking. we have to go through both documents line after line. Otherwise, have the review document underlined, italic, bold font to help spot differences. Comparing documents much easier with MS Word! MS Word has […]
The post How to Compare Documents appeared first on Yodalearning.
Chrome and Excel Shortcuts 1. #YodaHacks – 7 Killer Chrome Tricks: Ready to exercise your killer Chrome skills? Learn how to open your last link, pin your tab, toggle between tabs and more! a. Unable to connect to the Internet? Play the dinosaur game. b. Ctrl + W: closes the window c. Ctrl + Shift […]
The post Chrome and Excel Shortcuts appeared first on Yodalearning.
Imagine that when you are looking at a large list of numerical data, it’s useful to find largest and smallest value. Sometimes you need to find if a value is larger than a specific number. At times, the cell will be another color if the expected value is higher than a specific number. In a […]
The post Highlight a Row based on a Cell value appeared first on Yodalearning.
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. Go here to remove duplicates. In this tutorial, we will figure out […]
The post Find Duplicate Values appeared first on Yodalearning.
Special Character Letter, you need to use an Alt keyboard sequence: Num Lock key must be pressed, to activate the numeric key section of the keyboard (you can find on right top corner side). Press Alt key, and hold. While the Alt key is pressed, type the sequence of numbers which you required on the right side of the […]
The post Special Character Letter | Reference chart of Symbols appeared first on Yodalearning.
To activate the special character, you need to use an Alt keyboard sequence: Num Lock key must be pressed, to activate the numeric key section of the keyboard (you can find on right top corner side). Press Alt key, and hold. While the Alt key is pressed, type the sequence of numbers (on the numeric keypad) from the Alt […]
The post Special Character Symbol List with Shortcodes in Excel appeared first on Yodalearning.
MINIFS and MAXIFS are new functions in Excel 2016. These functions are advanced statistical functions. These are available only in the latest version of Microsoft Office (Excel) 2016. In this tutorial, we will explain how to use these functions. MINIFS and MAXIFS Functions The MINIFS Function returns the smallest value of a selected data range. […]
The post How to use MINIFS and MAXIFS appeared first on Yodalearning.
Today, we will be looking at How to Use Mail Merge in MS Word. What is Mail Merge? Mail merge is an automatic addition of names and addresses from a database to letters. It envelopes aim at simplifying mail, especially promoting goods/services to many addresses. Mail merge is used to make many documents without a […]
The post How To Use MAIL MERGE in MS Word appeared first on Yodalearning.
Excel PERCENTILE Function: Summary The Percentile Function in Excel will return the k-th percentile of values in a range. This implies that the value below the k% of the data values fall, while using the Percentile Function. This is for a Supplied range of values also for the supplied k. The Percentile Function in Excel […]
The post How to use the Excel PERCENTILE function appeared first on Yodalearning.
Excel PERCENTILE Function: Summary The Percentile Function in Excel will return the k-th percentile of values in a range. This implies that the value below the k% of the data values fall, while using the Percentile Function. This is for a Supplied range of values also for the supplied k. The Percentile Function in Excel […]
The post How to use the Excel PERCENTILE function appeared first on Yodalearning.
