Monday, October 25, 2010
MS Excel, Chapter 2 Formulas, Functions, Formatting and Web Queries
Of the Excel Chapter that we will be covering as part of this course, I find this chapter to be quite insightful and useful for a variety of applications. I would like you to pay close attention to the functions that you learn in this chapter and explain what features of Excel you find that would be useful to you in either your personal or professional life. If you are having trouble thinking of something, feel free to go online and search for examples that you find would be applicable to you.
Subscribe to:
Post Comments (Atom)
A good function for Excel would be once you have established the formula in a box you can drag that same formula across all boxes in the same line without doing all the formula's separately.
ReplyDeleteI like that function and we had to do it a lot for the homework SAM assignment !! I finished both assignments and noticed the second one is harder than the first. It took three submission for me to get everything correct but I learnt a lot.
ReplyDeleteI will definetly be using what I learned in my other accounting classes.
Kristin
I personally like the chart function on MS Excel. Charts are a good way of showing a company's statistics on profit, loss and general expenses throughout the year. I believe that after you have inserted a lot of data in the worksheet a chart can be very useful by giving a more understanding vision of what is going on. So this function will be useful for me as a future accountant.
ReplyDeleteI resubmitted the assignment 3 times and still was doing the same mistakes over and over again. The part I am having an issue is the functions. Even though I was surely correcting it so not sure what I was doing wrong.
ReplyDeleteI just finished both assignments... chapter 2 wasn't bad at all but I had a heck of a time trying to get SAM to accept the chart on week 9's assignment. It looked exact & I had been certain I had corrected the "data range" issue.
ReplyDeletethat was caused by my highlighting of a blank cell however I maxed out my submissions so I'm not 100% sure what went wrong.
If anyone is having problems otherwise I'd be happy to try to help.
I noticed chapter 3 was a little tricky and I used all my submissions too. But I think I got it the last time so I can help too...
ReplyDeleteKristin
I think the formulas are very useful, especially considering the fact that before I knew of the formulas, I did all the math calculations myself. Also considering that I want to be a account the use of the formulas is very convenient.
ReplyDeleteI found this weeks assignment to be very helpful. I am going to use Excel to make a spread sheet to calculate my commission and track my pay at work. The only question I have is the auto-correct feature. I have Office 2010, where the heck is that auto-correct button to turn it off? I ended up getting the accent of the title somehow but I just cant figure out where to find it.
ReplyDeleteI found that using Office 2010 is difficult since certain colors aren't available and other options,etc are a bit different. Since I had the option to borrow a friends 2007 disk I decided to do that (just to use to get through this class) & I haven't had a problem with autocorrect in Office 2007. I unfortunately have zero experience with 2010 (even though that is the version I had installed last semester I didn't do anything besides type essays).
ReplyDeleteWish I could be of more help but I can say that Googling any question I have for Office has always turned up a lot of relevant information from the web (a lot of the time it's directly from Microsoft's site).
I really like the formula option in Excel. Its great not to have to calculate every single entry which would be much more tedious. I don't need to use a computer at work, but I will use it to keep track of household expenses. It could be very useful to keep track of how much we are saving and also for holiday shopping and to keep track of our stocks.
ReplyDeleteHope,
ReplyDeleteIn addition to calculating household expenses, it's really great to set up a check register to balance your checkbook.
I'm going for accounting as well, and I use Excell a lot in BUS 111.
I use the dollar sign ($) to fix an array in a formula as it is quite usefull in large spread sheets where formulas are auto filled across a big range.
ReplyDeleteI got through Excel - Chapter 2 ok. The only problem I had in SAM was the Auto Correct - I couldn't find it in Excel.
ReplyDeleteThis is a very useful chapter - I can see how you can use this in an office to see customer's balances, what the lowest bill is, highest bill, average,etc. The calculations in Excel are so quick to do.
i liked chapter 2 assignment. Didn't have a problem with SAM! I liked determining the average,max and min function. Also I like the styles.
ReplyDeleteQuestion on chapter 3. I am having a problem with the Pie Chart title. Excel keeps closing when I click in the title box. Has anyone had this issue?
Hi Karolyn - I used the Help function in Excel. It works really well in getting to the exact issue you have.
ReplyDeleteWhen I did the Sam assignment for chapter 3 I did not get bounced out of excel for the title entry on the chart. Not sure what happened while I was doing the review in the book. Anyhow, I was getting nervous my chart was not looking like the example for the SAM assignment. The chart they show is the end result of the projection. I like how excel has the copy range function for formulas.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteDoes anyone know how to review any errors that SAM identifies and where to get SAMs corrections on any assignment that is submitted to SAM, also, does anyone know how to check the grade that SAM gives you on an assignment?
ReplyDeleteDid anyone else have a issue with arranging the words sales representatives just the way SAM wanted it to look? I was not sure how to use the max and min functions before this chapter. It was nice to learn some new things.
Hi Joe,
ReplyDeleteYou can find out the results by going to the report function in sam and click on project. It takes a couple of minutes for the report to become available. I have been printing the report and working off of that to make the corrections. I hope this helps.
Jen Medeiros
ReplyDeleteDid anyone else purchase the Student Addition Office 2010? I am having trouble with it? If you did could you email me @ Jmedeiros130@mail.bristol.mass.edu
Thank you
Jennifer
Wendy,
ReplyDeleteThank you so much. That was very helpful. Is anyone else having an issue with the formulas in week 9's assignment? I am not seeing any financial results after entering the formulas in the Salioto Auto Parts Financial Projection Assumptions worksheet we are working on
I copied the formulas directly from the instructions, then double clicked the cell, pasted the formula, then removed all the spaces & everything calculated properly for me.
ReplyDeleteHope that helps!
I will definitely be using the conditional formatting for some of the reports I do at work specifically for our labor costs analysis. I can format any huge variances resulting in increased labor costs to show up in a different color font than the others by using the conditional formatting. This way management can easily locate any areas that need researching.
ReplyDelete