So, today, I am sharing my experience with you. My Atlassian interview was nothing short of a thrilling ride

Remember to save your work regularly, especially if you're making significant changes to your data. Fill Series: You can use the Fill Series feature to quickly populate cells with a series of numbers, dates, or other data.Īlso check the video attached here for more. Paste Special: You can use 'Paste Special' to perform various operations when pasting, like values, formatting, or calculations.ġ0. Flash Fill: Excel can automatically recognize patterns in your data and suggest formatting changes. Data Validation: You can use Data Validation to create drop-down lists and set rules for data entry, ensuring data accuracy.Ĩ. Alt+Enter: To add a line break within a cell.ħ. Ctrl+R: To copy the value from the cell to the left of the active cell into the current cell.Ħ.

Ctrl+D: To copy the value from the cell above the active cell into the current cell.ĥ. Ctrl+Shift+ (Semicolon): This keyboard shortcut inserts the current time.Ĥ. Ctrl+ (Semicolon): This keyboard shortcut inserts the current date in a cell.ģ. AutoFill: To quickly fill a series of numbers, dates, or text, enter the first value, select it, and drag the fill handle (a small square at the lower-right corner of the selection) to extend the series. Here are some quick tricks to add data in Excel:ġ. Quick tricks to add data in Excel in seconds!! I've spent thousands of hours trying to find the best Resource & Youtube Channels to Learn SQL.

Java 6 black book pdf download