To receive credit, the Excel Tips/Tools/Tricks (don’t choose NPV, IRR, Wrap text and others covered in class). Write your name and 3 chosen Excel topics under this thread. Double check what other students chose before you start working on this assignment and Avoid duplication.
You will also attach the electric version next to your name under the Discussions tab. All of us will have access to these wonderful resources.
Deliverables: a HARD COPY as well as an ELECTRONIC COPY of the Excel Tips/Tools/Tricks Workbook Report with 3 spreadsheets. On each sheet you will cover one chosen Excel topic: description, formula, syntax, worksheet example and interpretation of your result.
The Report (1 workbook with 3 spreadsheets) is DUE by the date posted in Blackboard or as instructed by your professor.
You will have to submit only one workbook with all 3 Reports saved under your last name and the names of your topics like this: Johnson_WrapText _XIRR_Solver.xls
PLEASE TAKE A LOOK AT THE EXCEL SAMPLE BELOW.
Here are some Excel topic ideas:
|
Name: |
Name: |
Name: |
|||
|
Placing images in comment cells |
Recording macros |
Conditional formatting |
|||
|
Freezing rows and columns, freezing titles |
Formulas – copy and paste special |
Solver and Goal Seek |
|||
|
Putting a secondary axis on a graph |
Wrap text .( I am joking, choose a different one) |
Random number generator |
|||
|
Lookup functions |
Protecting sheets, ranges, and workbooks |
Using the format painter |
|||
|
Match and Index functions |
Hyperlinks |
Using the Mid text function |
|||
|
Pivot Tables |
Moving and copying spreadsheets 9too easy) |
Watch boxes |
|||
|
Sort and Filter |
Use of templates for B/S and I/S |
Flow charts using textboxes and auto shapes |
|||
|
External queries |
XIRR functions (not this one) |
Matrix multiplication |
|||
|
Autofilter |
Refining graph formats |
Conditional formatting |
|||
|
PV function (too easy) |
Data validation w/range names |
Rate function |
|||
|
Macros |
NPV (not this one) |
Chart |
|||
|
Charts |
More charts |
||||
|
Etc |
Sample example is in the attachment.
Needs help with similar assignment?
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Order Over WhatsApp
Place an Order Online