Can you please help answer this question?

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


Here are some Excel topic ideas:




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


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


Refining graph formats

Conditional formatting

PV function (too easy)

Data validation w/range names

Rate function


NPV (not this one)



More charts


Sample example is in the attachment.

What our clients say
Daphne Whitby
Daphne Whitby
My homework required that I use Java to produce a programming assignment. I’ve been running up and down with friends and workThank you for  your help 
Arnold M
Arnold M
This site did honor their end of the bargain. I have been searching for a college essay help services for a while, and finally, I found the best of the best.
Regina Smith
Regina Smith
I received my essay early this morning after I had placed an order last night. I was so amazed at how quickly they did my work. The most surprising thing is that I was not asked to pay for extra due to the short notice!! I am a happy student