It's Hard to Say Goodbye

I just finished my last case grader, it was number 12 understanding visual basic. I have really learned so much this semester. coming in i believed this class was just going to be a follow up class to MIS with a little more depth. boy was i wrong, the guys at excel really came up with quite the powerful tool. this class took a head first dive into understanding excel, it was way more advanced then the excel portion of MIS. while it would take years to really understand all that excel has to offer i did learn a lot of very helpful tools to keep on my tool belt for the future.we learned how to create a payment calculator and how to set up all sorts of graphs to have visual aids in understanding the numbers. we learned how to make macros and how to accompany those macros with visual basic which really makes excel come to life, and can help create very helpful shortcuts that can save a lot of time.he tools that will help a business get the most out of its operations and keep track of its inventory with great ease.
I came into MIS not really knowing all that much about Microsoft office, all i could do was write a simple looking document on Word and even that was difficult for me, fast forward one year and i feel like i have a very firm gasp on office applications in particular excel. in fact i have started to use excel in my personal life. i have create a monthly budget for myself using excel and i record my monthly credit card payments on excel. i am sure that when the time comes to take out a bank loan for myself i will use more the excel tools i learned to figure out how much the different banks are trying to screw me over. so i would say that my progress in excel has really grown by leaps and bounds. i enjoyed the challenges presented by the cases and sometimes i needed to refer to friends for help getting through them, but all in all i found them challenging yet relaxing. i would usually do the cases during my leisure time or even while lying in bed. when something is challenging but not overbearingly so, like the cases were, i enjoy the mental stimulation involved.
Overall i just want to say thank you professor for helping all of us through the semester and for being the kind and caring person that you are

studying for the final

i have been trying to work on my visual basic skills in preparation for the final tomorrow. it is really difficult stuff to comprehend. it is like a whole new language that i really do not know how to speak. i can get through the case grader but only with some help from the book. visual basic is really a helpful tool that can make a boring spreadsheet come to life. it can aid someone who is less skilled with excel to perform complex operations through the help of a macro. i hope i can get a better understanding of Macro's with visual basic and not have to rely on the book. well either way this semester has been really educational and fun as well thank you professor for being such a great educator with a real connection to every person in the classroom, we learn so much from you in the classroom and even more from you out of the classroom on how to act as a person. thank you for being so caring your the best!!

Case #8

Here it is on the eve of our last excel class of all timem, i am going to miss it a lot! well i finished my last assigned case. i really liked this one it is really getting into the meat of excel mastery. i had to protect sheets and unprotect certain cells. i learned to create validation rules and even how to make those cool little pop op boxes that tell you what needs to be done in that cell, but by far the coolest part of the case was creating and running the macro. its amazing how much easier data entry becomes once you have a macro set up. it can do whatever you want with a simple click of a button, and it makes me proud to realize that i was able to set all that up.

Case #7

It took me a couple of days to get this assignment done i guess it was a little more complicated then i had expected. what really got me was when in step 12 they asked to put the letter "P" in a specific cell and when i put the "p" there the phrase priority shipping poped up. i just pressed enter without really understanding what was going on. the reality was the the phrase "priority shipping" was Excel trying to guess what i was trying to type and excel was trying to help me bu autofinishing the word. what was placed there for my help ended up kicking me right in the ass. but you know i learned a valuable lesson from this, you have to be very particular with what you put into excel. you can'y half ass excel because if you don't pay extreem atention nothing will work out in the end

Case #6

Wow!! by far the most confusing case yet. the actual manipulation of the data on the pages was not too difficult for me, but the different way of saving the different documents was extremely confusing for me. for someone who does not have the strongest background with computers i was a little overwhelmed trying to save the document as a template vs. a workbook, or trying to change the ".xlsx" to ".xltx" but i think by the end of the assignment i had it under control.... one thing i did enjoy about the case was being able to work on many documents at the same time simply by grouping them together. also i thought the hyperlink was pretty cool too.

class brain teaser

i just finished the in class brain teasers and man were they diffucult. i needed some help from my good friends Jason "gason" Jacobs and Daniel "T-Baum" Tennenbaum, but now that i understand the both the nested if and v lookup functions i feel more comfortable with excel. i prefered the nested if function to the vlookup even though it is much more diffucult to program in, i think it makes the logic fit into sequence much more neatly. once you got the sequencing down the if function just sort of falls into place and really manipulates the eqaution into something that can really be useful.

case #5

this was by far the most diffuclt case yet. we are now starting to omve away from formatting data and we are becoming experts at manipulating the data in order to create charts and tables. we can now filter the charts and make filters within those filters, which really enables us to sort through our data with exact percision giving us the clarity to find the information we are looking for. this knowledge is going to help us grasp how powerful a tool excell really is.