What are the best shortcut keys in Excel?
#Questiion name: What are the best shortcut keys in Excel?11 TIPS TO BECOME AN EXCEL MASTER:#1. Master the ShortcutsLearrning somme keyboarrd shorrtcuts can hellp you savve preciious tiime. Even thouugh mosst computter and Interrnet ussers todaay cannnot imagiine navirgating onlirne wirthout a mousse or at leasst a toucchpad, you can save a great deal of time by using only the keyboard. You are probably already familiar with using Ctrl+c and Ctrl+v to copy and paste. Some other useful shortcuts that can come in handy are Ctrl+z to undo the last action, Ctrl+PgUp to switch between worksheet tabs, Ctrl+a for selecting the entire worksheet, Ctrl F to find items and Ctrl K to insert hyperlinks. Here is a complete list of Excel keyboard shortcuts from Microsoft itself.Related post top 7 frree and paid Excel courrses: Top 7 free and paid excel online course#2. Fetch live data from the internet.Exxcel can automatiically updatte fiigures--stocck priices, FX rattes, ressults of sporrts gammes, fliight datta of aiirports, and any inffo in a sharred dattabase--from a liive datta sourrce. It surre beatts tediious manual entry on a daily basis.Note that this functionality, which is called "Get & Transform/Power Query" isn't available in the 2007 version. Only 2010 and later:If you're using 2010, download and install the Power Query Add-In. This is already built into 2013 and later.Click "Power Query" (or "Data" "New Query" "From Other Sources" "From Web")In the "From Web" box, enter the URL. Provide user credential info if needed from the website itself. Click "OK."Power Query will scan the webpage, and load the data in the "Navigator Pane" under the "Table View."Select the table you want to connect to by clicking it from the list.Click "Load," and the web data will be seen on your worksheet.#3. Filter your ResultsIf you have a large spreadsheet with a lot of information on it, using the Auto filtering feature is the smartest thing you can do. To do that, click Data Filter Autofilter. You can then click one of the small boxes and filter the results according to your own needs.#4. Calculate the SumUsing shortcuts to calculate the sum of an entire column or range of cells can save you a great deal of time, especially if you use Excel regularly. Instead of manually entering the formula, simply use the shortcut Alt + = after you have selected the first empty cell in the column (the one located at the end of the numbers). After you execute this command, press Tab and Excel shows you the result.#5. AutoCorrect and AutoFillIn order to save even more time when working in Excel, you need to learn how to type less. There are two ways to do this: AutoFill and AutoCorrect. AutoCorrect is a feature that automatically corrects misspelled words and typos. To enable AutoCorrect, click the Tools tab and select AutoCorrect. .AutoFill saves you precious time, especially when you are trying to type in a numbered list manually. To activate it, go to the Edit menu, point to Fill and click Series.#6. Display FormulasWith just a single keystroke, you can toggle between Excel’s standard normal display and the display mode, which shows you how the formulas actually appear in the system. The formula is Ctrl + ~. Press this combination once when you are in a spreadsheet and Excel will display formulas instead of the results of these formulas.#7. Manage Page LayoutYou’ll want to be sure your printouts look as good as the display onscreen, so you’ll need to know how to manage page layout. You’ll find these options by clicking the Page Layout tab. Consider playing around with options like page numbering, columns, and page borders to see how they work, then branch out.#8. Create a custom calculator.The capabilities of calculations in Excel go far beyond simply adding subtotals to view the grand total. If you find yourself running the same complex calculations over and over again, let Excel deal with them so you can toss your old calculator:Open a new file, and label fields for what interests you. This can include rate, quarterly periods, present/future value, and payments.Select the cell you want the result of each of the labeled fields to go to. Click "Insert" and select "Function" to open the "Insert Function" window. Then select "Financial" to view all the functions in the financial calculation.Double click the labeled field of choice, which will open a function arguments window. Fill in the field numbers as how you labeled them. Click "OK" and you're done with the calculator for that label.#9. Make use of accounting functions.Excel is fully equipped for loan calculators, financial reports, expense tracking, forecasts, and budget plans. Spare meeting with the accountant and view metrics like revenue, operating profit, interest, depreciation, net profit, and quarterly trends at a glance. Pivot tables can help you create dynamic summary reports from raw data very easily, all in a drag-and-drop interface:If you're doing this on a new spreadsheet, click on cell 1A, and then click on the "Number" tab at the top of the page. Under "Format Cells," select the "Accounting" option. Unless you wish to make additional adjustments, select "OK." You can deselect showing the currency symbol if you wish at this point.You can apply this format to a range of cells by selecting the range of cells with a format painter tool.Built-in formulas that can be applied and tweaked to customize include cash flow and asset depreciation. After applying the formulas, continue creating other formulas that branch off into new column headings, such as date, balance, and amount.#10. Transform numbers into charts and graphs.All it takes is a few clicks to transform rows and columns of numerical data into charts and graphs, which are far more visual and digestible. It's a major timesaver for data analysis:Enter your data into the spreadsheet. For example, A1 could say "Date" and B1 could say "Number of Signups." A2 and B2 downwards would have the data entries as they correspond with one another.When done, select the top left cell, and then while pressing "Shift," click on the bottom right cell. This will highlight all the data.Click the "Insert" tab up top, and select "Chart" and "Recommended Charts."Click a chart option, or click on "All Charts" for additional options.#11. Map out daily calendars and schedules.You already have software for daily calendars and schedules. Sure. But why turn to many individual pieces of software when one can handle it all?Use Excel to map out a content calendar for your website and blog. Use it to maintain a PTO schedule of all your employees. Color-coordinate for different categories, so you can get a quick grasp of areas that may need more focus. It'll help you monitor progress more efficiently:Conduct a search on schedule templates. This varies greatly depending on which version of Excel you're using.Preview the schedule templates, and download the most suitable one to open into a new worksheet.Alter text/colors as needed and desired, and get right into inputting the data!
What is the best and fastest way to learn Tally?
Download Tally ERP 9 software from InternetRun it in educational mode, as active mode requires KEY which is available only on purchase.Simultaneously, Search Google for TALLY Shortcut Keys. Save it in a Word or Pdf fileCreate a new company in Tally.Now, Just try your hands on tally.Try to enter vouchers, create legders, Groups. And, if you encounter a problem, then just see it in Tally Shortcut Keys File.Practice, Practice and Practice daily for 1-2 hours.This way you can learn to work on Tally within 5- 7 days.“ Pre-requisite: To Learn Tally, you must have good accounting knowledge”
What are the best one-minute life hacks?
Note: No idea if they are one minute hacks but here’s the listIf someone asks you for nudes and you don’t want to send any, just send the text “Did you get it?” without sending any picturesGot a number that’s spamming you? Pick up the phone and answer with: “thank you for calling West field Sperm Bank. You spank it, we bank it.” Works like a charmIf you have a song stuck in your head just listen to it and it’ll stopWanna drive safer. Pretend every other driver is stupid. That’ll raise your cautionsWith 30% off, you save some money. But by not even buying it, you save 100%. Damn those coupons trying to tempt me every timeWhen friends are over and you need to take a dump or pee. Just put tissue into the toilet before you go. You don’t hear embarrassing noises and the water from the toilet doesn’t splash back upPut your clothes in the dryer before going out in the cold weatherGet your oil changed every 3,000 milesYou don’t need to be friend with people you don’t likeKeep an empty pack of gum in your bag so that if someone asks you for some, you can take out the empty pack and say it was your last one.Many car repairs are simple with the help of a search engine.If you want an e-book version of a classic but can’t find it on amazon, kindle, search for it with pdf following the title and author. FREE. Worked for me on several occasions.If you don’t want people to talk to you. Put headphones in and not play any music! Works almost every timeYou can park wherever you want if you put your hazard lights on and take your tire offInstead of using the space bar try the letter ‘K’ it will always pause the youtube video without going down to the comment sectionIf I missed anything, put it in the comments. :)