BUSN 250 American Public University System Excel Discussion Replies In need of a 125 response/discussion to EACH of the following forum posts. There are (2

BUSN 250 American Public University System Excel Discussion Replies In need of a 125 response/discussion to EACH of the following forum posts. There are (2) different Forum posts. Agreement/disagreement/and/or continuing the discussion.The two interactive posts should each be substantial, relevant, and engaging. Original forums discussion/topic post is as follows: (Use/Cite references to support your ideas)

***Excel is a basic software package in business today.

Don't use plagiarized sources. Get Your Custom Essay on
BUSN 250 American Public University System Excel Discussion Replies In need of a 125 response/discussion to EACH of the following forum posts. There are (2
Just from $13/Page
Order Essay

What are three of the spread sheet capabilities, or three excel functions discussed in the chapter this week? What can be some uses or applications of each at your work or personal life? Explain what you think is an advantage or a disadvantage of using your selected capabilities or functions.***

FORUM POST 1:

Hi class,

Excel really helps me organize my work. In fact, just today I used it to make another spreadsheet for a big project I have coming up. There weren’t many bells and whistles when it comes to function, it was more of an organizational excel sheet, but still helpful.

This week, Ill start out with a common function I use which is the SUM function. So basic, yet so useful when I have to account for how much each project is actually costing. When I was in the Navy, I did everything by hand or calculator. It took me a while to add up hundreds of thousands of gallons of diesel that we were burning on the ship for my reports. These days, I simply make a column of projects costs and sum them up when I want to see a status or totally complete. The usefulness of the SUM feature is only a click away.

The SUMIF function is where a person can find a certain criteria in a selected amount of cells and add it up. I use a lot of piping to repair boilers and it is called P91. In my spreadsheets, I can account for all the work orders that I have used P91 and how many feet were used. This can quickly search and add up the total amount of feet used so it can be subtracted from the original purchase order amount. Instead of going out and measuring the remaining pipe, this can give me the answer as I account for the used amount.

The AVERAGE function can be used to find the average values of the selected cells. This can be very useful when it comes to comparing the actual cost of different contractors doing the same job. Each contractor will charge by an hourly basis and invoice me at the end of the project. After about 5 projects for each contractor, I can average the cost of each one and decide who I should continue to do business with based on past performance. This is extremely helpful with future budgeting of jobs.

There are so many uses and ways to bring light to information that is input in the spreadsheets. Functions so small as changing the color of cells that exceed a certain price range is essential for making a person aware of the current status of what they are working on.

FORUM POST 2:

Good Evening Class,

Thank you for choosing to read my post!

I use Excel daily, I work on the F-35 and we have to track stealth degrading damages and repairs to ensure the aircraft can accomplish its mission.

Most of the functions are pretty straight forward but some can be overwhelming. After watching a bunch of “How To Excel” YouTube videos a while back, I really started to get the hang of all of its capabilities. People actually come to me when they have Excel questions. It made this week’s homework a breeze!

At the same time, I did learn about a couple functions that I have never utilized before. Like the IF Function, Logical function, and Insert Function. The IF Function is an awesome tool to now have in my Excel tool bag! On the other hand, the Logical & Insert Functions are still a little confusing but after watching a couple more YouTube videos and practicing, the function is pretty easy to use but I don’t see myself using it.

One Excel trick I love to use at work and I sometimes use it to mess with my co-workers is “Conditional Formatting.”

If you have some free time, check it out! If not, no biggie…

While on the top left tab “Home,” click on “Conditional Formatting.” You should explore the drop down, there is so many cool things you can do to your Excel product.
Click on “New Rule.” From there you can format based on Values, Wording, and Duplicates or even create custom formulas to do wild things!
For now click on “Format Only Cells That Contain” Say you have 5 distributors that you receive products from “Coke, Pepsi, Bang, Monster, and 7up.
Click on “Specific Text” in the left side drop down.
Next click on “Beginning With.”
In the right box on the same line, type in “Coke.”
Next lick n “Format,” from there you can change what color the cell gets filled, what type of font/size that is used, every time the word Coke is the first thing inputted into that cell.

If you can dream it, Excel can do it!

For me I see mostly advantages with using more advanced Excel Functions. It can save so much time once your product is built and Excel doesn’t forget to carry the one while doing multiplication.

I have ran into a couple disadvantages also. For example, I have experienced other users destroy the Excel products that I have spent so much time and thought into creating, simply because they didn’t know how to navigate the product well enough to use it. The other drawback I have experienced is, my ADHD doesn’t allow me to just be okay with the product. I am always updating formulas and inserting new conditioning codes. That constant change can be overwhelming to the end user.

Have a great night and sorry my post was so long! ?
?
?
Many commercial software packages can be used
for Business Analytics.
Spreadsheet software, such as Microsoft Excel, is
widely available and used across all areas of
business.
Spreadsheets provide a flexible modeling
environment for manipulating data and
developing and solving models.
?
?
Mac versions of Excel do not have the full
functionality that Windows versions have –
particularly statistical features which are important
to this book.
The Excel add-in that we use in later chapters,
Analytic Solver Platform, only runs on Windows.
Thus, if you use a Mac, you should either run
Bootcamp with Windows or use a third-party
software product such as Parallels or VMWare.
?
?
?
?
?
?
?
?
?
?
Opening, saving, and printing files
Using workbooks and worksheets
Moving around a spreadsheet
Selecting cells and ranges
Inserting/deleting rows and columns
Entering and editing text, data, and formulas
Formatting data (number, currency, decimal)
Working with text strings
Formatting data and text
Modifying the appearance of a spreadsheet
?
?
?
Tabs – Home, Insert, Page Layout, Formulas, …
Groups – Font, Alignment, Number, Styles, …
Buttons and Menus
– Buttons appear as small icons.
– Menus of additional choices are indicated by
small triangles.
?
?
Common mathematical operators are used.
For example:
a?
bP5
c
+ would be entered into Excel as:
d
=a? b*P^5 + c/d
?
Cell references can be relative or absolute. Using a dollar sign
before a row and/or column label creates an absolute reference.
? Relative references: A2, C5, D10
? Absolute references: $A$2, $C5, D$10
?
?
?
Using a $ sign before a row label (for example, B$4) keeps the
reference fixed to row 4 but allows the column reference to
change if the formula is copied to another cell.
Using a $ sign before a column label (for example, $B4) keeps
the reference to column B fixed but allows the row reference to
change.
Using a $ sign before both the row and column labels (for
example, $B$4) keeps the reference to cell B4 fixed no matter
where the formula is copied.
Two models for predicting demand as a function of price
Linear
D = a – bP
Formula in cell B8:
=$B$4-$B$5*$A8
Nonlinear
D = cP-d
Formula in cell E8:
=$E$4*D8^-$E$5
Note how the absolute addresses are used so that as these formulas
are copied down, the demand is computed correctly.
Formulas in cells can be copied in many ways.
? Use the Copy button in the Home tab, then use
the Paste button
? Use Ctrl-C, then Ctrl-V
? Drag the bottom right corner of a cell (the fill
handle) across a row or column
?
?
?
?
?
?
Split Screen
Paste Special
Column and Row Widths
Displaying Formulas in Worksheets
Displaying Grid Lines and Column Headers for
Printing
Filling a Range with a Series of Numbers
?
?
?
?
?
?
=MIN(range)
=MAX(range)
=SUM(range)
=AVERAGE(range)
=COUNT(range)
=COUNTIF(range,criteria)
? Excel has other useful COUNT-type functions: COUNTA counts
the number of nonblank cells in a range, and COUNTBLANK
counts the number of blank cells in a range. In addition,
COUNTIFS(range1, criterion1, range2, criterion2,… range_n,
criterion_n) finds the number of cells within multiple ranges that
meet specific criteria for each range.
=MIN(F4:F97)
=MAX(F4:F97)
=SUM(G4:G97)
=AVERAGE(H4:H97)
=COUNT(B4:B97)
=COUNTIF(D4:D97,”=O-Ring”)
=COUNTIF(H4:H97,” greater than
>= greater than or equal to
< less than =10000, “Large”, “Small”) ? Suppose that large orders with a total cost of at least $25,000 are considered critical. ? Cell L4: =IF(AND(K4=“Large”, G4>=25000),“Critical”,“”)
?
These functions are useful for finding specific data
in a spreadsheet.
? =VLOOKUP(lookup_value, table_array, col_index_num, [range lookup]) –
?
?
?
looks up a value in the leftmost column of a table and returns a value
in the same row from a column you specify
=HLOOKUP(lookup_value, table_array, row_index_num, [range lookup]) looks up a value in the top row of a table and returns a value in the
same column from a row you specify.
=INDEX(array, row_num, col_num) – returns a value or reference of the
cell at the intersection of a particular row and column in a given
range.
=MATCH(lookup_value, lookup_array, match_type) – returns the relative
position of an item in an array that matches a specified value in a
specified order
?
?
?
?
In the VLOOKUP and HLOOKUP functions, range lookup is
optional. If this is omitted or set as True, then the first column
of the table must be sorted in ascending numerical order.
If an exact match for the lookup_value is found in the first
column, then Excel will return the value the col_index_num of
that row. If an exact match is not found, Excel will choose the
row with the largest value in the first column that is less than
the lookup_value.
If range lookup is False, then Excel seeks an exact match in
the first column of the table range. If no exact match is found,
Excel will return #N/A (not available).
We recommend that you specify the range lookup to avoid
errors.
=VLOOKUP(10007, $A$4:$H$475,3) returns the payment type
Credit.
=VLOOKUP(10007, $A$4:$H$475,4) returns the transaction code
80103311
?
=INDEX(array, row_num, col_num)
?
The INDEX function works as a lookup procedure
by returning the value in a particular row and
column of an array. For example, in the Sales
Transactions database,
INDEX($A$4:$H$475, 7, 4) would retrieve the
transaction code 80103311, which is in the 7th row
and 4th column.
?
?
=MATCH(lookup_value, lookup_array, match_type)
?
In the MATCH function, lookup_value is value that you want to
match in lookup_array, which is the range of cells being searched.
The match_type is either -1, 0, or 1. The default is 1.
If match_type = 1, then the function finds the largest value that is
less than or equal to lookup_value.
?
? The values in the lookup_array must be placed in ascending order.
?
If match_type = 0, MATCH finds the first value that is exactly equal
to lookup_value.
? The values in the lookup_array can be in any order.
?
If match_type = -1, then the function finds the smallest value that is
greater than or equal to lookup_value.
? The values in the lookup_array must be placed in descending order.
Suppose we wish to design a simple query application to
input the month and product name, and retrieve the
corresponding sales. The three additional worksheets in
the workbook show how to do this in three different ways.
The Query1 worksheet uses the VLOOKUP function with
embedded IF statements. The formulas in cell I8 is:
=VLOOKUP(I5,A4:F15,IF(I6=”A”,2,IF(I6=”B”,3,IF(I6=”C”,
4,IF(I6=”D”,5,IF(I6=”E”,6))))),FALSE)
The formula in cell I8 is:
=VLOOKUP(I5,A4:F15,MATCH(I6,B3:F3,FALSE)+1,FALSE)
In this case, the MATCH function is used to identify the column in the
table corresponding to the product name in cell I6. Note the use of
the “+1” to shift the relative column number of the product to the
correct column number in the lookup table.
The formula in cell I8 is:
=INDEX(A4:F15,MATCH(I5,A4:A15,FALSE),MATCH(I6,B3:F3,FALSE)+1)
The MATCH functions are used as arguments in the INDEX function
to identify the row and column numbers in the table based on the
month and product name. The INDEX function then retrieves the
value in the corresponding row and column.
?
Microsoft Excel provides a number of add-ins for Business Analytics
(Windows only), which will be used in subsequent chapters:
– Analysis Toolpak
– Analysis Toolpak VBA
– Solver
? To install them, click the File tab and then Options in the left column. Choose AddIns from the left column. At the bottom of the dialog, make sure Excel Add-ins is
selected in the Manage: box and click Go. In the Add-Ins dialog, if Analysis
Toolpak, Analysis Toolpak VBA, and Solver Add-in are not checked, simply check
the boxes and click OK.
?
Frontline Systems provides:
– Analytic Solver Platform
? See the Preface for installation instructions

Purchase answer to see full
attachment

Homework On Time
Calculate the Price of your PAPER Now
Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional academic writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

You are welcome to choose your academic level and the type of your paper. Our academic experts will gladly help you with essays, case studies, research papers and other assignments.

Admissions

Admission help & business writing

You can be positive that we will be here 24/7 to help you get accepted to the Master’s program at the TOP-universities or help you get a well-paid position.

Reviews

Editing your paper

Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.

Reviews

Revising your paper

Our academic writers and editors will help you with unlimited number of revisions in case you need any customization of your academic papers