Thank you so much. On Sun, 14 Jan, 2024, 15:06 , <[email protected]> wrote:
> Hi Ronak, > > > > Use *INSERT+H* and *INSERT+W* for learning about Excel shortcuts. In > fact, these keystrokes can be used to find about shortcuts in any > application. > > > > For Excel formulae, you can leverage the Insert Function dialog box. It > appears upon pressing ALT+I followed by F. > > - If you know the name of the function then type it in the Search edit > field and hit the Go button. > - If not then TAB to the Categories list and select one from the list. > - TAB to the next list that lists the functions under that Category. > - Select the desired function and hit Enter to navigate to the next > screen > - This screen allows you to specify parameter values for the selected > function. > - You can access help on the selected function by activating the link > labelled *Help on this function*. This link is one TAB next to the > list of functions. > > > > You can enter a formula directly by keying in the = (equals to) sign at > the beginning of a cell content. The function names matching your input are > auto-populated as you type. Hit the TAB key to select one from the > auto-populated list. The parameter list for a function are enclosed in > parentheses (). For example, =Today() returns current date while =sum(2, 5) > returns the value 7. The value of a function can be found by hitting > CTRL+ENTER after keying in the formula and its corresponding parameter > values. Hitting ENTER also calculates the formula value however, the cursor > navigates to the cell below the one in which formula was keyed in. > > > > Believe it helps! > > > > *Best Regards,* > > *Zujar…* > > > > *From:* [email protected] <[email protected]> *On > Behalf Of *RONAK KOTAK > *Sent:* 14 January 2024 02:13 PM > *To:* [email protected] > *Subject:* [AI] Excel formulas and shortcuts > > > > Hello team, > > > > Anyone have the formulas and the shortcuts of excel including basic and > advance level which we use in corporate if yes can you please share with me > or from where I can get that advice. > > > > Regards > > Ronak kotak > > -- > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of > the person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > --- > You received this message because you are subscribed to the Google Groups > "AccessIndia" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CAPH37pBBDBde738fN0_Q8h_7q%3D5GvVQQaX6dEjQTHVatCnoLrg%40mail.gmail.com > <https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CAPH37pBBDBde738fN0_Q8h_7q%3D5GvVQQaX6dEjQTHVatCnoLrg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > -- > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of > the person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > --- > You received this message because you are subscribed to the Google Groups > "AccessIndia" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/000001da46cd%242aa9c4e0%247ffd4ea0%24%40gmail.com > <https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/000001da46cd%242aa9c4e0%247ffd4ea0%24%40gmail.com?utm_medium=email&utm_source=footer> > . > -- Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Search for old postings at: http://www.mail-archive.com/[email protected]/ --- You received this message because you are subscribed to the Google Groups "AccessIndia" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CAPH37pCaChoMeau%2BOUdB0XdE-MK3rf2njJ4vJfM_yQrAG4MgZg%40mail.gmail.com.
