Upon review of this chapter, identify what chapter specific skills you find useful and how you could apply these skills in your personal, educational and/or professional life.
Some of you are working with MS Excel 2010 instead of MS Excel 2007. For those of you that fall into this category, I would like you to clearly identify any issues that you run into due to the difference in look-and-feel and/or functionality. In addition to identifying the problem, I would like you to identify the solution that you have discovered. You are welcome (encouraged) to look online for additional support. For those of you that find the support online, I would like you to post link(s) that outline the appropriate steps to accomplish the task at hand.
I really find the Min, Max, & Average formulas to be helpful. I had always found these values manually in spreadsheets used for budgets and financial forcasting(both personal & professional).
ReplyDeleteI do not understand how to use the what-if analysis function. I have used a spreadsheet and continue to do so for my own financial status. I can now add the average,min and max functions for future calculations.
ReplyDeleteI do not understand how SAM can have a test question asking you to protect the worksheet, however won't let you right click to do so & still after I use the other method it says that I am incorrect?
ReplyDeleteI also really dislike the fact that I know the formula for subtraction, however I need to find the formula through the massive Insert Function method.
I'm already on question 6 and I've had 2 answers marked incorrect for seemingly no reason.
If anyone else is having this issue please let me know I am not alone....
I was impressed by the "what if" function. At first when doing the homework, my chart didn't look right. When I used the "what if" function and it changed the chart, I felt better. It's a great function to use when you're looking at different results you may want to achieve without redoing everything all over again.
ReplyDeleteI don't use any of these programs at work but I can use them at home to keep track of spending and saving. I can help friend and family members keep tract of this as well. I didn't have any trouble with the SAM assignment except in making the whole thing bold, for some reason it said I didn't when I did. I do have Office 2010, but I haven't had a problem so far with excel as far as look/feel or functionality is concerned. I had trouble with the word chapter 5 in the lab assignment.
ReplyDeleteI had the same issue with questions 6 and 12.
ReplyDeleteWhen I was asked to change the cells containing consultant. Wouldn't let me do the way the book and the training section teach us. I haven't learned another method so I got those questions wrong. Not fair I would say.
(I wrote this post in the other blog)
ReplyDeleteHowever, after doing all the labs in excel I realize I can use almost everything for my future accounting career.
I like the fill option so that the can save time. When I didn't know how to do something I used the book and then Microsoft Office help. It seemed useful but I find most information from our text book.
(I also use excel when I go on my strict diet for counting calories, adding foods, and changing diet options. It has always helped me)
Kristin Cunha
I can see how trying to make projections cold be useful in the business world but most companies use a specific software to manage their operations that would have all of the functions needed to perform it already. Personally I found the first chapter of Excel to be the most useful for me.
ReplyDelete