9780955459931

Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques

Smart, Mike

ISBN 10: 0955459931 / 0-9554599-3-1
ISBN 13: 9780955459931
Publisher: Smart Method, Limited, The
Publication Date: 2009
Binding: Softcover
Editorial Reviews:
Synopsis:

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.


Review:
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

 

Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques: Search Results

1.
Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques (ISBN: 9780955459931)
Smart, Mike
ISBN 10: 0955459931
ISBN 13: 9780955459931
Bookseller: Better World Books Ltd (Dunfermline, FIF, United Kingdom)
Bookseller Rating: 5-star rating
Quantity Available: 7

Book Description: Smart Method, Limited, The, 2009. Book Condition: New. 1st Edition. N/A. Ships from the UK. BRAND NEW. Bookseller Inventory # GRP76323860

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 14.32
Convert Currency
Shipping: US$ 11.20
From United Kingdom to U.S.A.
2.
Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques (ISBN: 0955459931 / 0-9554599-3-1)
Smart, Mike
ISBN 10: 0955459931
ISBN 13: 9780955459931
Bookseller: ExtremelyReliable (Richmond, TX, U.S.A.)
Bookseller Rating: 5-star rating
Quantity Available: 1

Book Description: Smart Method, Limited, The. Paperback. Book Condition: New. Bookseller Inventory # DADAX0955459931

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 23.69
Convert Currency
Shipping: US$ 3.99
Within U.S.A.
3.
Learn Excel 2007 Expert Skills With The Smart Method (ISBN: 0955459931 / 0-9554599-3-1)
Smart, Mike
ISBN 10: 0955459931
ISBN 13: 9780955459931
Bookseller: GreatBookPrices (Westminster, MD, U.S.A.)
Bookseller Rating: 5-star rating
Quantity Available: 5

Book Description: Book Condition: New. This item is printed on demand. Bookseller Inventory # 7780375-n

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 25.31
Convert Currency
Shipping: US$ 2.64
Within U.S.A.
4.
Learn Excel 2007 Expert Skills with the Smart Method (ISBN: 9780955459931)
Smart, Mike
ISBN 10: 0955459931
ISBN 13: 9780955459931
Bookseller: Paperbackshop-US (Secaucus, NJ, U.S.A.)
Bookseller Rating: 5-star rating
Quantity Available: > 20

Book Description: SMART METHOD LTD 01/07/2014, 2014. Paperback. Book Condition: New. New Book. This item is printed on demand. Shipped from US This item is printed on demand. Bookseller Inventory # IH-9780955459931

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 23.97
Convert Currency
Shipping: US$ 3.99
Within U.S.A.
5.
Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial Teaching Advanced Techniques (Paperback) (ISBN: 9780955459931)
Smart, Mike
ISBN 10: 0955459931
ISBN 13: 9780955459931
Bookseller: The Book Depository (Gloucester, UK, United Kingdom)
Bookseller Rating: 5-star rating
Quantity Available: 10

Book Description: The Smart Method Ltd, United Kingdom, 2009. Paperback. Book Condition: New. 297 x 210 mm. Brand New Book ***** Print on Demand *****.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.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.From the Back CoverAmongst other things you ll learn how to: Master Excel 2007 s new Fluent User Interface and RibbonUnderstand the new Excel 2007 file formats and when to use them Create your own formulas with the new Formula AutoComplete featureCreate cross worksheet formulas Understand absolute, relative and mixed cell referencesCreate stunning, professional, presentation-quality chartsUse the new Themes feature to create visually excellent worksheets Use Excel 2007 s new Trend Line featureBring your data alive with Excel 2007 s stunning VisualizationsCreate custom conditional formatting rules with the new Rules ManagerAdd a professional sheen to your work with 3-D ElementsUnderstand and work with three-dimensional worksheet groupsCompanies 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. Bookseller Inventory # AAV9780955459931

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 30.05
Convert Currency
Shipping: US$ 0.00
From United Kingdom to U.S.A.
6.
Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial Teaching Advanced Techniques (Paperback) (ISBN: 9780955459931)
Smart, Mike
ISBN 10: 0955459931
ISBN 13: 9780955459931
Bookseller: The Book Depository US (Gloucester, ., United Kingdom)
Bookseller Rating: 5-star rating
Quantity Available: 10

Book Description: The Smart Method Ltd, United Kingdom, 2009. Paperback. Book Condition: New. 297 x 210 mm. Brand New Book ***** Print on Demand *****. 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.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.From the Back CoverAmongst other things you ll learn how to: Master Excel 2007 s new Fluent User Interface and RibbonUnderstand the new Excel 2007 file formats and when to use them Create your own formulas with the new Formula AutoComplete featureCreate cross worksheet formulas Understand absolute, relative and mixed cell referencesCreate stunning, professional, presentation-quality chartsUse the new Themes feature to create visually excellent worksheets Use Excel 2007 s new Trend Line featureBring your data alive with Excel 2007 s stunning VisualizationsCreate custom conditional formatting rules with the new Rules ManagerAdd a professional sheen to your work with 3-D ElementsUnderstand and work with three-dimensional worksheet groupsCompanies 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. Bookseller Inventory # AAV9780955459931

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 30.07
Convert Currency
Shipping: US$ 0.00
From United Kingdom to U.S.A.
7.
Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques (ISBN: 9780955459931)
Smart, Mike
ISBN 10: 0955459931
ISBN 13: 9780955459931
Bookseller: Firehouse Liquidation (Vancouver, WA, U.S.A.)
Bookseller Rating: 4-star rating
Quantity Available: > 20

Book Description: Smart Method, Limited, The. Book Condition: New. Ships next business day! Brand New!. Bookseller Inventory # ING-9780955459931

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 26.88
Convert Currency
Shipping: US$ 3.25
Within U.S.A.
8.
Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques (ISBN: 0955459931 / 0-9554599-3-1)
Smart, Mike
ISBN 10: 0955459931
ISBN 13: 9780955459931
Bookseller: Russell Books (Victoria, BC, Canada)
Bookseller Rating: 5-star rating
Quantity Available: > 20

Book Description: Smart Method, Limited, The. PAPERBACK. Book Condition: New. 0955459931 Special order direct from the distributor. Bookseller Inventory # ING9780955459931

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 29.39
Convert Currency
Shipping: US$ 4.99
From Canada to U.S.A.
9.
Learn Excel 2007 Expert Skills with the Smart Method (ISBN: 9780955459931)
Smart, Mike
ISBN 10: 0955459931
ISBN 13: 9780955459931
Bookseller: Books2Anywhere (Fairford, GLO, United Kingdom)
Bookseller Rating: 5-star rating
Quantity Available: > 20

Book Description: SMART METHOD LTD 01/08/2014, 2014. Paperback. Book Condition: New. New Book. This item is printed on demand. Shipped from UK. This item is printed on demand. Bookseller Inventory # IQ-9780955459931

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 21.99
Convert Currency
Shipping: US$ 14.96
From United Kingdom to U.S.A.
10.
Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques (ISBN: 9780955459931)
Smart, Mike
ISBN 10: 0955459931
ISBN 13: 9780955459931
Bookseller: BuySomeBooks (Las Vegas, NV, U.S.A.)
Bookseller Rating: 5-star rating
Quantity Available: 20

Book Description: Paperback. Book Condition: New. This item is printed on demand. Paperback. 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 Excels 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. Heres just four of the many ways in which the book is unique: This book wont waste your time by teaching basic Excel skills that you already know. All of that material is covered already in our beginners Essential Skills book. By assuming that you are already able to use Excels 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. Youll 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 Excels most advanced features. This item ships from La Vergne,TN. book. Bookseller Inventory # 9780955459931

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 39.25
Convert Currency
Shipping: US$ 4.50
Within U.S.A.
View All Listings for this Book