Category Archives: Office

How To Use Vlookup To Compare Two Spreadsheets?

VLOOKUP Formula to Compare Two Columns in Different Sheets! We shall compare these two worksheets using the Excel VLOOKUP formula. Input this formula in D2: =VLOOKUP(A2, mongabay_data, 1, FALSE) Double click on the Fill Handle to fill all the cells with the formula of cell D2. How do I compare two Excel spreadsheets for matches? […]

How To Use Vlookup To Compare Two Lists?

Compare Two Lists and Highlight Missing Records Select all the cells of the table except the header row. Click Conditional Formatting on the Home tab of the Ribbon and select New Rule. Select Use a Formula to determine which cells to format from the top half of the window. How do I compare two lists […]

How To Find Home Folder On Mac?

To find your Home folder, open Finder and use the keyboard shortcut Command-Shift-H. You can use the Go pull-down menu from the menu bar to go to the Home folder. (Oddly, the home folder is called Home in this menu.) What is the Home folder on Macbook Pro? Your home folder is named with your […]

How To Calculate Geometric Rate Of Return?

What is the geometric average rate of return? The geometric mean, sometimes referred to as compounded annual growth rate or time-weighted rate of return, is the average rate of return of a set of values calculated using the products of the terms. What does that mean? Geometric mean takes several values and multiplies them together […]

How To Calculate Average Return?

An average return is calculated the same way that a simple average is calculated for any set of numbers. The numbers are added together into a single sum, then the sum is divided by the count of the numbers in the set. How do I calculate average return in Excel? Average Rate of Return = […]

Where Is The Scribble Tool On Google Docs?

Hovering on ‘Line’ will give you all the types of lines you can add. At the bottom, you can see the ‘Scribble’ option. Simply click on that and Google slides will take you to scribble mode. How do you scribble on Google Docs? Here’s how: Open your Google Doc as normal. Click “Insert” then “Drawing”. […]

How To Create Rss Feed Url?

Creating RSS feed from social networks is even simpler. Just enter a URL you want to get RSS from and get your XML file URL immediately. This URL can be a link to any user or page from major social networks like Facebook, Twitter and so on. Two simple steps: enter a URL and click […]

How To Add Tax Percentage?

How do you add tax to a price? Multiply the cost of an item or service by the sales tax in order to find out the total cost. The equation looks like this: Item or service cost x sales tax (in decimal form) = total sales tax. Add the total sales tax to the Item […]

Things To Do That Start With M?

M. Activities: Magic Show (or Magic Castle), Mahjong, Mail, Make, Makeover, Marina, Market, Massage, Masquerade, Meadow, Meal, and Medieval Festival. Memoir, Mess, Meteor Shower, Mine, Mini Golf, Mixed Tape, Mixology, Mosaic, Morning, Movies, Mud Run, Murals, Museum, and Musical. What can you make with the letter M? Read on for 11 fun projects for letter […]

How Do You Spell The Letter M?

M, or m, is the thirteenth letter of the modern English alphabet and the ISO basic Latin alphabet. Its name in English is em (pronounced /ˈɛm/), plural ems. M Type Alphabetic and Logographic Language of origin Latin language Phonetic usage [m] [ɱ] [n] [n̼] /ɛm/ Unicode codepoint U+004D, U+006D How do you spell M? How […]