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: accessindia@accessindia.org.in <accessindia@accessindia.org.in> On Behalf Of RONAK KOTAK Sent: 14 January 2024 02:13 PM To: accessindia@accessindia.org.in 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/accessindia@accessindia.org.in/ --- 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 accessindia+unsubscr...@accessindia.org.in <mailto:accessindia+unsubscr...@accessindia.org.in> . 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/accessindia@accessindia.org.in/ --- 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 accessindia+unsubscr...@accessindia.org.in. 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.
