Learn Atomically

*Note: This is a blog entry about another one of our classes I missed while I was on away for a religious holiday. My knowledge may not be as detailed as it should be. Please excuse that.

While I was away we were told to go to atomic learning, a site that Mr.Case has got access to for a few weeks, that has tutorials about using different functions in various applications. So Mr.Case gave us a few about Excel to look at.

Sorting Data: One of the tutorials went over how you can use the List function in Excel to sort Data. You go to Data>List>Create List. For this function it is not necessary to select ALL your data, instead just select one cell and Excel will locate the rest of the data for you (you can still customize the data selection after Excel selects for you). The list allows you to sort by a specific header in your data, or in ascending/descending order, or in alphabetical order.

Comparing Excel Workbooks: To compare two different excel books at once in the same window we can use Excel's Compare Side By Side function. To use this first open the excel workbooks you'd like to compare then go to the menu bar window>Compare side by side. It will ask you which two workbooks you want to compare if more than two are open at once. This is great for when you need to compare and see if two workbooks have the same data.

Until next time,

--Amna