Warning: This article contains spoilers from BH90210 season. [Shannen] was fully on board with poking fun of that. I think.Once you get the hang of creating simple formulas and adding up numbers in Excel, the next big thing to learn is the difference between relative and absolute references in Excel formulas. It can take a bit of time to get your head around, but understanding how relative and absolute references work in Excel, and when to use them, is essential to becoming an Excel ninja.Who said Excel takes lot of time / steps do something? Here is a list of 15 incredibly fun things you can do to your spreadsheets and each takes no more than 5 seconds to do. Happy Friday 1. Change the shape / color of cell comments Just select the cell comment, go to [.]There comes a time when you are slapped with a sheet of data and need to sum every other row in it (dont ask me why, it happens, for eg. when you copy paste your credit card statement in excel), Ofcourse, we can always type the sum function with all those arguments, but we would rather chomp on that donut while excel does the dirty work for us.excel possesses formidable database. relational databases is to create queries and filters that can extract specific information and print reports. Say your boss wants a report that shows everyone.Note. For your Excel IF statement to return TRUE and FALSE as the logical values (boolean values) that other Excel formulas can recognize, make sure you don’t enclose them in double quotes. A visual indication of a Boolean is middle align in a cell, as you see in the screenshot above.To check if a cell contains specific text, you can use the SEARCH function together with the ISNUMBER function. In the generic version, substring is the specific text you are looking for, and text represents text in the cell you are testing. In the example shown, the formula in D5 is:Start studying Excel chapter 5 Creating, sorting, and Querying a Table. Learn vocabulary, terms, and more with flashcards, games, and other study tools.
This video, https://www.youtube.com/watch?v=vXx1Wl3O6T4, can also be seen at https://www.youtube.com/channel/UCjduAdv4y4QnyfjIYbSMKyg.