Excel Function Guide

-

A streamlined guide to Excel functions. Required arguments in dark gray, optional arguments in white. Also see our huge list of example formulas.

Thanks!

Comments

Post a Comment

Andika igitekerezo cyubaka gusa!

Popular posts from this blog

3 ways to message a number on WhatsApp without saving them as a contact first

-
Image
WhatsApp's own wa.me links WhatsApp provides an official way to contact an unsaved number, just not within the app. As explained in  this FAQ , you can start a chat with any number by going to the web address https://wa.me/ phonenumber . Replace the last part with the full number, with the country and region code, but without any  +  or  -  or  ()  or  00 . So for example, if you want to chat with the number +1-234-567-8900 in the US, you would go to the URL:  https://wa.me/12345678900 . Type it in the browser and you'll get the web page below with a big green  Message  icon. Tapping on it opens a conversation with that phone number in WhatsApp (if the number is registered on the service, obviously). Use an app to speed things up If the above method seems a little confusing or slow for you, you can use an app to speed things up. Several Android apps use these wa.me links but in a non-user-facing way — i.e. you don't have t...
Read more »komeza

Where to find Incomplete download files in IDM (Internet Download Manager)

-
Image
Traditionally all  temporary download files  are stored in %temp% folder in Windows. But it is different for  IDM  (Internet Download Manager) where temporary  Incomplete download files  are saved in  AppData folder. Location: C:\Users\username\AppData\Roaming\IDM\DwnlData\username To find Exact location of the  folder  or to change the location, Open  IDM and click  downloads  and then  Options  in the  Menu  bar. IDM >> Downloads >> Options . You will get a New Window. Here select  Saveto  Tab and in this Window you will see location of the Temporary file. Just Copy the location and Enter it in My Computer’s Address bar. see the Screenshot below:
Read more »komeza

Create a table of contents or update a table of contents

-
You create a table of contents by applying heading styles — for example, Heading 1, Heading 2, and Heading 3 — to the text that you want to include in the table of contents. Microsoft Word searches for those headings and then inserts the table of contents into your document. When you create a table of contents this way, you can automatically update it if you make changes in your document. Microsoft Word 2010 provides a gallery of automatic table of contents styles. Mark the table of contents entries, and then click the table of contents style that you want from the gallery of options. You can also create a custom table of contents with the options you choose and any custom styles that you’ve applied by using the Table of Contents dialog box. Or you can manually type a table of contents. Note This article explains how to add a table of contents. It does not cover tables of authorities or tables of figures. Type a table of contents manually You can type table of cont...
Read more »komeza