Excel tutorials: data used in examples have been added

Excel function tutorials

I received some very useful feedback from a reader who suggested that I make the data used in the examples in my available for users to copy into a spreadsheet so they can work through the examples practically.

So, I’ve added a table containing the data used in each tutorial at the beginning of the post. It’s in HTML table format, so you should just be able to just highlight the contents in the table and then copy into a blank Excel spreadsheet and then work through each step in the tutorial yourself. It does take a couple of extra steps though: you’ll need to copy the info below, then go to the Excel worksheet and select “Edit”, then “Paste Special”, then “Text”, and click “OK”. The detailed instructions have been added to each tutorial.

The reason I use JPG (picture) formats throughout my tutorials is that they’re easier to load and read than actually trying to upload a worksheet for each step.

Anyway, I welcome feedback and comments in all my posts. Thanks to Shakir for his comments on improving my tutorials!

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


***************************************************

6 Feedbacks on "Excel tutorials: data used in examples have been added"

Jon Peltier

Rather than jpg images for your screen shots, you should use gif or png images. These are better suited for the kind of images that you see in tables and charts, with large areas of constant color plus sharp transitions between regions of different color. JPG was designed for photographic work where colors generally change gradually from point to point, and sharp transitions lead to fuzzy edges and other artifacts.



veeromero

im researching on how to compute NPV on mining
can you please help me…
many thanks



V.KAUSHAL

USEFUL SITE & HELP
i COULDN’T FIND ANSWER ” IF I HAVE TO LOOK FOR eg NAMES WHICH ARE SAME BUT SY DIFFERENT VALUES – VLOOKUP PICKS UP THE FIRST VALUE
QES: ” HOW CAN I ASK FOR THE SECOND LOOKUP
PLEASE HELP
THANKS



Mark Tahu

Thanks for the nested If AND OR NOT, had a great deal of trouble finding a plain English version it works a treat.



omprakash

please give more information about vlookup and side also



Adil Pasha

God Bless u for this scholarly effort