 |
| Excel Shorts |
Excel Shorts
Lets continue our series with more interesting stuff which will help you.
Let's go.....
PivotTables
At 4 hours to urge to proficiency, you'll be postpone learning PivotTables but do not be . Use them to sort, count, total or average data stored in one large spreadsheet and display them during a new table, cut however you want. that is the key thing here. If you would like to seem only at sales figures surely countries, product lines or marketing channels, it's trivial. Warning: make sure your data is clean first!
Flash Fill
Excel developed a mind of its own in 2013. Say you've got two columns of names and you would like to construct email addresses from all of them . Just roll in the hay for the primary row and Excel will compute what you mean and do it for the remainder . Pre-2013 this was possible but relied on a mixture of functions (FIND, LEFT, &, etc). Now this is often much faster and can impress people. If Flash Fill is turned on (File Options Advanced) it should just start working as you type. Or catch on going manually by clicking Data > Flash Fill, or Ctrl E.
Basic Arithmetic
Add (+), subtract (-), multiply (*), divide (/). You'll also got to use brackets sometimes. for instance , if cell A1 is 35, cell A2 is 50 and you would like to calculate the half of increase from 35 to 50 in cell A3, it's '=(A2-A1)/A1'. Without the brackets your answer would be wrong. Remember BODMAS?
you have any query or want any help related to excel feel free to join our Telegram channel and message us..
Channel link :
0 Comments