Learn Any Area of Excel using these 80 Links

Last week I asked, What is one area of Excel you want to learn more?

More than 250 of you responded to this question. Many of you shared your areas of interest thru comments, quite a few of you also emailed me personally.

You told us what you want to learn, the next step is logical. We share some of the best tutorials & examples with you so that you can learn. In this post, we have presented more than 75 links, to help you learn your area of focus.

I have divided this in to 16 areas. In each area, we have identified (upto) 5 best links for you to learn more. I have also recommended 1 or 2 training programs that make you awesome in that area. Plus, if we found any excellent external resources, we have highlighted them as well.

So go ahead and learn Excel.

If you come across any good resource for learning Excel, please share it with us. I am always looking for ways to learn more. So go ahead and drop a comment.

Special thanks to Hui, for compiling the survey results & some of the links.

RSS feed for comments on this post. TrackBack URI

View the original article here

What is one area of Excel you want to learn more? [Survey]

AppId is over the quota
AppId is over the quota
Posted on December 2nd, 2011 in Learn Excel - 190 comments

It is almost weekend. Today we (Jo and I) are going to watch a cricket match being played in Vizag. We are pretty excited as this is the first time we are watching a match in stadium.

So, let keep this light and fun. I want to know What is one area of Excel you want to learn more?

I will go first. I want to learn more about Data Tables & Simulation.

What about you? Go ahead and tell us using comments.

Note: Here are a few choices if do not know what else is out there.

FormulasArray FormulasFormattingConditional FormattingChartingAdvanced ChartingPivot Tables & ChartsTablesData TablesValidationFilters & SortingVBA (Macros)Linking to Databases etc.SolverStatistical Analysis (regression, time series etc.)Scenarios, What if analysisDashboards

So go ahead and tell us.

RSS feed for comments on this post. TrackBack URI

View the original article here

Learn Excel 2007 Essential Skills with the Smart Method: Courseware Tutorial for Self-Instruction to Beginner and Intermediate Level

This book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel. Here are just five of the many ways in which this book is unique:

• The book will equip you with excellent Excel skills, good enough to impress any employer, but it doesn’t confuse by attempting to teach skills that are not common in the workplace. Only users who have advanced requirements need progress to the Expert Skills book.
• This is the only book that is also available as a low-cost video (DVD). Each can be used as a stand-alone product, but together they provide an incredibly powerful learning experience.
• Instruction is logically structured into sessions and lessons. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, adult training courses.
• Every lesson is presented on two facing sheets of A4 paper (the pages are much bigger than in any other Excel book).
• Each lesson has a sample file that models a real-world business problem. You’ll immediately appreciate the value and relevance of each skill as it is taught.

Both IT professionals and absolute beginners will love this book because it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way.

Price: $21.99

Click here to buy from Amazon

LEARN & USE MICROSOFT EXCEL IN YOUR BY SHELL EDUCATION

Seamlessly integrate technology into your classroom instruction with this new series. Provide a concise introduction to the software application, then use project-based learning lessons and activities to effectively orporate technology into grade-level content. Teacher Resource CD ludes collection grids, graphic organizers, sample projects, and rubric templates.

Price:

Click here to buy from Amazon

About Microsoft Excel beginners and advanced topics.

Many people learn Microsoft Excel to do their job. Raise your value at work need a complete novice or advanced skills to learn whether or not to upgrade knowledge of Excel and impress your boss because of can be a great way. This article illustrates basic software like some more advanced formulas, and may have interesting features, learning.

Excel is a spreadsheet program consisting of individual cells grid consists of thousands of rows and columns. Contains information that can be any number of individual cells, dates, formulas, or text. Model for other large projections, budgets, and complex business issues to resolve easily create formulas mathematical and other cell operation is used.

The basic comfort become more like Microsoft to learn excel formulas and more advanced features. You can determine the loan payments if you know the number of the most useful formulas I learned that interest payments, and loans first, the PMT formula is. Mortgage can help this formula, car loan, charts and other long-term financial arrangement, capital, etc.

Another more advanced features useful in Excel is known as the VLOOKUP. Corresponding data tables in any column, and then type the label value. For example, if you had a table of customer information by using the VLOOKUP table of phone numbers, customer ID number might be formula.

You should learn one Excel is without at least seeing charts and charting features. Excel provides a wizard to easily create a chart. Range to indicate where to find related data in the selector, charts, say that you should label the data points, and to create a chart type. Only you can place one or more of the worksheets directly in a few seconds, or with the fantastic and professional looking chart into another document such as Word documents, and then copy paste.

Some included in this way, Microsoft Excel may have threatened by trying to work, but they learn that complex. When you start getting a basic good tutorials that all functionality is displayed very quickly collaboration how. Most companies are basic or offers introductory and advanced courses your skill level is right get tutorials to make.

Thomas Richardson information best computer training classes run website dedicated to ComputerTrainingClasses4u.com on the web. Further, to find courses to help you advance your skills and see how page learn Microsoft Excel.