Sort Stats In Class assignmet

Today's class was REALLY enjoyable.
I learnt how to use a Macro button in a very practical way... what a useful tool!
This function is really powerful and definitely something that I'm happy to have in my excel skills portfolio, for job interviews and future personal use.
The best part was, I even had fun learning how to use it.
-Adam

The Homerun Incentive- a reflection

I really liked this assignment. It was nice to take a class off from being told how to do things and be given the opportunity to try to figure things out on your own. Not only was this enjoyable, I thought it was a great educational technique that should be used more often in this class and in all classes in all educational institutions.
About the actual assignment... I found it intriguing. While neither method was exceptionally easy to figure out... I much preferred the NestedIF function. I found it easier to use and more logical (despite the insane amount of parentheses needed!).
-Adam

Case #5- Reflections

I found this case to be a little challenging, but very rewarding. When first encountering the step that asked me to do "multi-level" filtering, I wasn't really sure how to do it. I managed to figure it out by highlighting things and just 'winging it'. While this did get me a perfect score, when I later sat down with the Prof., he showed me that Excel has a built in function that helps you sort things in a "multi-level" type way. I knew there had to be a better way to do it then the way I had used, and was very please to find out my inclination was correct. Once again, Microsoft proved there is always multiple ways to accomplish a task, the key is to find the most efficient way that works for you!
-Adam

Case #4- Reflections

I just finished case #4 and thought it was really cool. All the different types of charts available on excel is really mind boggeling. While i felt that not all of them were super useful in being accurate in their visual representation of the data (especially the pie chart), in general the charts and graphs helped make lots of data more easily accessible to the the average user. A great way to get an superficial understanding of lots of data at once!
-Adam Frieberg

Case #3- Relections

This case was like a whole new world. The case was a lot more challenging than the previous two, and quite fun. The exercise really made me recall ALL of what we had learned to date... and that was a great review.
Also, it was REALLY cool to see how much money you can save just by saving 1cent a min.
--Adam

case #2- Reflections

Case #2 was a little bit better than Case #1. I still felt like the case grader was spoon feeding me too much information, but I have some hope as I feel like it is slowly waning us off the spoon feeding and into the realm of thinking.
Lets see what happens in the next case...
Adam

Case #1- Reflecetions

While I was looking forward to finally working with the case grader, honestly, I found the experience a little bit disappointing. Thought the case was easy (and a decent refresher), I felt that the whole exercise was spoon-fed and that the book took away any opportunity you may have had to think by spoon feeding you the answers. I would have preferred had the case grader told you what to do and let you figure out what cells needed to be used and what function needed to be applied to reach your desired results.
Moreover, I entered the date and I was docked 5 points because I didn't enter the date in a format that the program liked, though no date format was specifically requested. That was rather annoying and petty.

Hopefully the upcoming cases will prove to be more challenging and intellectually stimulating.

Adam

Bean Bag Quarterly Income Statement and Break-Even Analysis

Today's exercise in class was quite enjoyable. It served as a nice refresher after being away from excel (and school in general) for quite a while. (While it's always hard to leave vacation, this exercise was definitely a nice way to ease my way back into school!!) I really liked using the Data Table. i had forgotten what a powerful tool it was. While I still don't totally understand how it figures out the necessary info, I find it super cool and really convenient. WHAT A POWERFUL FUNCTION!

Adam

An Overview of Basic Operations: An Excel Online Tutorial

Assingment #2-
I found this tutorial to be a great review of what I learnt with an outstanding professor (Prof. Jorisch) in MIS.

I remembered most things and was therefore able to go through the tutorial very quickly.
The only thing that I hadn't remembered was how to use 'absolute' and 'reference' cells and that part of the tutorial was extremely valuable.

Also I liked the part where it explained what the different common error values are and how to fix them. If you don't know what those funny symbols mean, they can be very frustrating to deal with while trying to get work done, especially when a timeline is involved. Knowing how to act efficiently and effectively to deal with the error is a great skill to have.

-Adam

September 11 Reflections

I remember being in school on the morning of Sept 11. I heard the news and didn't really know what it meant. Living and growing up in Toronto, I didn't really know what the WTC was or how important of a building it was. It took until that night when I got home from school and saw the news reports for me to fully comprehend what was going on.
However, on Thursday September 11th of this year, I went down to ground zero. The scene down there was pretty intense. I was there at 11pm and there were still thousands of people there, mourning, praying, rallying and reflecting. It was a very intense emotional time and I made sure to take out my tehillim (psalms) and say a few chapters. It was my first time at ground zero and I'm glad I finally made my way down there, especially on Sept 11th.

Excel Tutorial Session Additional Comment

I just wanted to add on to my previous comment by saying that although the tutorial was good, the fact that they used pictures instead of video to explain what they were talking about was a major setback. If the picture would have been replaced by a video that showed what the audio was discussing, then the tutorial would have been way more beneficial to its listeners (and unfortunately not watchers!)
-Adam

Excel Tutorial Session

The Excel tutorial session was very informative and really gave me a great 'heads up' as to what to expect from the semester. I'm not so familiar with excel so it is rather hard for me to say whether I think the improvements are positive or negative, but it seems like the thinking that Microsoft had behind their decisions was logical and creative. I'm excited to go ahead and use this new program, especially considering that it will be the 'way of the future'. I also think that it was a great idea to assign this tutorial before we got to class because now we don't have to waste time figuring out where things are on the ribbon and can jump right into the program and 'get our hands dirty'.
-Adam

My First Post

My name is Adam Frieberg
My email address is frieberg@yu.edu
My blogspot address is excel-for-business-blog.blogspot.com
I am a senior in Sy Syms.