 Trade In this Item for up to £3.65
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Learn Excel 2007 Expert skills With The Smart Method: Courseware Tutorial teaching Advanced Techniques for an Amazon.co.uk gift card of up to £3.65, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
This book is for users who want to upgrade their basic Excel skills to true expert level. It will teach you to master all of Excel’s advanced features. If you are an absolute beginner you need our Essential Skills book.
The 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 master advanced Excel features. Here’s just four of the many ways in which the book is unique:
• This book won’t waste your time by teaching basic Excel skills that you already know. All of that material is covered already in our beginner’s Essential Skills book. By assuming that you are already able to use Excel’s basic features, far more ground can be covered.
• 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 you learn.
Advanced concepts are explained without needless technical jargon. Everything is concisely described in a simple, no-nonsense way. No matter what your background is, this book will enable you to master Excel's most advanced features.
From the Back Cover
Amongst other things you'll learn how to:
• Master Excel 2007’s new dynamic tables
• Enforce complex business rules using function-driven custom validations
• Perform What-If analysis to model and compare business scenarios
• Use advanced functions to solve real-world business problems
• Eliminate errors using Excel’s advanced formula auditing tools
• Create intuitive user interfaces using form controls
• Use Excel’s three different file sharing methods for efficient teamwork
• Record macros and then execute them from button controls
• Understand and use all of Excel’s security features
• Design advanced Pivot Tables and Pivot Charts
• Use your Excel skills to publish a complete web site from a workbook
• Create and use dynamic and table-based range names
Companies who have taken Smart Method courses include:
AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS, Marks & Spencer, Virgin, O2, BMW... and many, many others.
The 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 master advanced Excel features. Here’s just four of the many ways in which the book is unique:
• This book won’t waste your time by teaching basic Excel skills that you already know. All of that material is covered already in our beginner’s Essential Skills book. By assuming that you are already able to use Excel’s basic features, far more ground can be covered.
• 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 you learn.
Advanced concepts are explained without needless technical jargon. Everything is concisely described in a simple, no-nonsense way. No matter what your background is, this book will enable you to master Excel's most advanced features.
From the Back Cover
Amongst other things you'll learn how to:
• Master Excel 2007’s new dynamic tables
• Enforce complex business rules using function-driven custom validations
• Perform What-If analysis to model and compare business scenarios
• Use advanced functions to solve real-world business problems
• Eliminate errors using Excel’s advanced formula auditing tools
• Create intuitive user interfaces using form controls
• Use Excel’s three different file sharing methods for efficient teamwork
• Record macros and then execute them from button controls
• Understand and use all of Excel’s security features
• Design advanced Pivot Tables and Pivot Charts
• Use your Excel skills to publish a complete web site from a workbook
• Create and use dynamic and table-based range names
Companies who have taken Smart Method courses include:
AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS, Marks & Spencer, Virgin, O2, BMW... and many, many others.
From the Back Cover
Amongst other things you'll learn how to:
- Master Excel 2007's new dynamic tables
- Enforce complex business rules using function-driven custom validations
- Perform What-If analysis to model and compare business scenarios
- Use advanced functions to solve real-world business problems
- Eliminate errors using Excel's advanced formula auditing tools
- Create intuitive user interfaces using form controls
- Use Excel's three different file sharing methods for efficient teamwork
- Record macros and then execute them from button controls
- Understand and use all of Excel's security features
- Design advanced Pivot Tables and Pivot Charts
- Use your Excel skills to publish a complete web site from a workbook
- Create and use dynamic and table-based range names
Companies who have taken Smart Method courses include:
AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS, Marks & Spencer, Virgin, O2, BMW... and many, many others.
Inside This Book
(Learn More)
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
17 of 17 people found the following review helpful
Format:Paperback
I needed to learn Excel 2007 in a rush for a new job; I bought Learn Excel 2007 Essential Skills and just skipped though it, it was so easy and straightforward. I was so impressed with the book (and myself I have to say!) that I had a go at 'Expert Skills'. I did not regret it, once again it was easy to follow and I got through it with ease and..........thanks Mike Smart, I got the job despite my advanced years.
With these two books on your shelves you will never be stuck for an answer to an Excel problem, and you will feel confident to tackle all those tricky tasks involving Excel 2007.
With these two books on your shelves you will never be stuck for an answer to an Excel problem, and you will feel confident to tackle all those tricky tasks involving Excel 2007.
10 of 10 people found the following review helpful
Format:Paperback
I have got plenty of benefit from this book. I had already completed the Essential Skills book in the same series about 6 months ago, but am a novice to more advanced Excel 2007 functions.
I so like the way the learning is divided up into bite sized portions. Each learning point fits onto 2 facing A4 pages, so there is never too much to take in. All the learning is done using examples, so you learn by doing, rather than reading which works really well for me.
The book is then divided up into 8 major topics. At the end of every major topic there is a short self test so you can check your progress and make sure you have learnt all the key points from that section. I used these too as a way to re-enforce my learning, so as I completed each section, I not only did that test but went back and did the previous one to make sure I was holding onto what I had learnt.
Overall there are lots of hints and tips in the book. Clearly it's a `technical' book, but the style is very friendly and approachable (this is not a book just for geeks). There are plenty of `ahhhhh' moments, when you discover a quick way to do something that has taken you ages to complete in the past, or suddenly have your eyes opened to something Excel is capable of that you never knew before.
There is no way I think I will retain all the learning in the book. But it has opened my eyes to what's possible and I will keep it close at hand as its bite sized learning format will make it very easy in the future to go back to, if I need to be reminded how to carry out a particular task.
Overall I think this is well worth buying if you are new to more advanced Excel 2007 functions or want a refresher. I would be very surprised if anyone works through this book and doesn't find at least one thing they can use to make them more efficient or effective in the future that more than justifies the cost.
I so like the way the learning is divided up into bite sized portions. Each learning point fits onto 2 facing A4 pages, so there is never too much to take in. All the learning is done using examples, so you learn by doing, rather than reading which works really well for me.
The book is then divided up into 8 major topics. At the end of every major topic there is a short self test so you can check your progress and make sure you have learnt all the key points from that section. I used these too as a way to re-enforce my learning, so as I completed each section, I not only did that test but went back and did the previous one to make sure I was holding onto what I had learnt.
Overall there are lots of hints and tips in the book. Clearly it's a `technical' book, but the style is very friendly and approachable (this is not a book just for geeks). There are plenty of `ahhhhh' moments, when you discover a quick way to do something that has taken you ages to complete in the past, or suddenly have your eyes opened to something Excel is capable of that you never knew before.
There is no way I think I will retain all the learning in the book. But it has opened my eyes to what's possible and I will keep it close at hand as its bite sized learning format will make it very easy in the future to go back to, if I need to be reminded how to carry out a particular task.
Overall I think this is well worth buying if you are new to more advanced Excel 2007 functions or want a refresher. I would be very surprised if anyone works through this book and doesn't find at least one thing they can use to make them more efficient or effective in the future that more than justifies the cost.
3 of 3 people found the following review helpful
Format:Paperback
I teach Excel, and found this book very useful. "Learn Excel 2007 Expert skills" is for those who know their way around in Excel. NOT for beginners! (As the title indicates.)
It's a great book for the right audience: to the point. It's up to you and your time schedule if you want to read the extra information. The "extras" and in-depth are placed so you may choose to read it.
If you complete each lesson, you'll become a resource for your company!
It's a great book for the right audience: to the point. It's up to you and your time schedule if you want to read the extra information. The "extras" and in-depth are placed so you may choose to read it.
If you complete each lesson, you'll become a resource for your company!
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
Excellent book...
A really excellent book for those who are already familiar with Excel (Intermediate standard). I was growing rather wary of the books prepared by John Walkenbach and Bill Jelen etc... Read more
Published 2 months ago by Mr. Richard R. Moore
Excel expert
Excellent book, with easy written steps on different functionality, wish I had bought it years ago. Good value for money.
Published 2 months ago by Paula
Another great work
Another excellent resource for anyone looking to advance their skills in excel. The DVD (download) is simply superb! Read more
Published 8 months ago by sos
Review of Excel 2007 Expert Skills with the Smart method
This beautifully crafted book has given me enormous insight into the subtle workings of Excel 2007.It is so well put together in eight sessions. Read more
Published 9 months ago by C. Clark
Hand on the grip
The tutorial was delivered step by step, easy to understand and to follow. Learning through practicing is always the best way to learn how to use computer software. Read more
Published 10 months ago by T. NG
One of the best excel tutorials in the market
This is by far the best excel tutorial I have come across..Its easy to learn with the help of sample files that can be downloaded from the book's website and works as an excellent... Read more
Published 11 months ago by Arjun
Excellent
If you wanted to understand really things you always pretended to then buy this book. Easy to use and understand. Highly recommended
Published 14 months ago by elizabeth
Excellent Book
I bought this book to help improve my Excel skills. This book is well written, instructions easy to follow, clear diagrams, uncomplicated and an excellent resource for improving... Read more
Published 17 months ago by Mairead Lowry
Excellent Book to learn the new versions of Excel
This book is easy to follow as the lessons are broken down into small chunks. The study material provided is relevant and accurate, would highly recommend to anyone wanting to get... Read more
Published 23 months ago by G. Sagoo
Brilliant
Yet another brilliant book. Working with both the book and the video together is a bonus..........a real must for anyone wanting to go further with Excel........... Read more
Published on 13 April 2010 by Mrs. R. J. Carder
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
