Mike Smart

OK
About Mike Smart
Mike Smart is the founder and CEO of The Smart Method. In Mike's long career as an IT consultant, Mike specified, designed and delivered IT solutions for large corporations all over the world. In 2002 Mike decided to specialize in IT training and founded The Smart Method.
Mike has personally taught classroom Excel courses to delegates from many of the world's largest companies in England, Europe and America. Mike has run courses for bankers, engineers, accountants, teachers, broadcasters, retailers, insurance brokers, aircraft manufacturers, government departments, on-line gaming companies, telecom workers, oil workers, car manufacturers, power companies... and for many other professions. This has given him a unique insight into the diverse ways in which Excel is used by both large and small businesses.
By carefully observing the areas that students find the most difficult to understand, Mike has constantly refined his Smart Method teaching technique over a period of more than ten years.
In 2008 Mike realized that he could only ever teach a few thousand students in his classroom courses but could help millions of students by producing his Excel courses in book form. His first Excel books (covering Excel 2007) rapidly became best sellers and his books have topped best seller lists ever since.
In his spare time, Mike enjoys playing jazz piano, riding his motorbike and sliding down snowy mountains on two wooden sticks.
Customers Also Bought Items By
Are you an author?
Author Updates
Titles By Mike Smart
This book is very, very different to any other Kindle book you have ever read. You'll notice the first difference as soon as you open it because it is published in Amazon's new Print Replica format. This full-color format preserves the beautifully crafted, rich graphical layout of each page.
The Smart Method provides an entirely new, easier and better way to learn Excel 2016. Here are just four of the many ways in which this book is unique:
- The book will equip you with excellent Excel 2016 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 pages. You can complete each self-contained lesson in a few minutes.
- Each lesson has a sample file that models a real-world business problem.
The advanced teaching method used in this book will enable you to master Excel in a fraction of the time needed when learning from conventional text books. 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.
Amongst other things you'll learn how to:
- Create stunning, professional, presentation-quality charts
- Use the Themes feature to create visually excellent worksheets
- Use Flash Fill to split, concatenate and format text and date values
- Use Cloud Computing features to share data
- Use the Versions feature to recover lost data
- Use AutoFill to create textual and numeric series
- Hide and show rows, columns and entire worksheets
- Create your own formulas
- Use Excel functions the professional way using Formula AutoComplete
- Understand absolute, relative and mixed cell references
- Create cross-worksheet formulas
- Add trend lines and moving averages to charts to forecast future values from non-cyclical data
- Use Forecast Sheets to forecast future values from cyclical data
- Use Sparklines to visually represent large data sets
- Bring your data alive with Visualizations
- Create custom conditional formatting rules with the Rules Manager
- Streamline your work by creating your own custom templates
- Create both textual and graphical cell comments
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 and Spencer, Virgin, O2, BMW... and many, many others.
This book is very, very different to any other Kindle book you have ever read. You'll notice the first difference as soon as you open it because it is published in Amazon's new Print Replica format. This full-color format preserves the beautifully crafted, rich graphical layout of each page.
This Excel 2016 book is for users who want to upgrade their basic Excel 2016 skills to true expert level. It will teach you to master all of Excel 2016’s advanced features. If you are an absolute beginner you need our Excel 2016 Essential Skills book.
The Smart Method provides an entirely new and better way to master advanced Excel 2016 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 2016 skills that you already know. All of that material is covered already in our beginner’s Excel 2016 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 pages. You can complete each self-contained lesson in a few minutes.
- 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 2016’s most advanced features in a fraction of the time needed when learning from conventional text books.
Here is a small selection from the many advanced Excel skills you will learn:
- Master dynamic tables using automatic, manual, qualified and unqualified structured table references
- Use advanced filters to apply complex logical criteria
- Use Excel's Subtotal feature to create both regular and nested subtotals
- Use formula-driven validations to enforce complex business rules
- Implement a hyperlink-based navigation system to allow users to easily navigate large workbooks
- Create beautiful interactive forms using checkbox, combo box, command button, text box and option button controls
- Record macros with both absolute and relative references
- Use slicers to allow touch-screen users to quickly filter Pivot Tables by multiple criteria
- Understand primary and foreign keys and use them to create both one-to-many and many-to-many relationships
- Understand OLAP pivot tables and use them to analyze data residing in a data model
- Create a 3D Map video tour with multiple scenes using both single and multiple visualization layers
- Use Get & Transform queries to extract, clean and combine data from Web Pages, Databases and Worksheets
- Use Get & Transform to create a de-normalized data extract from a multi-table relational database
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 Societ
This book is very, very different to any other Kindle book you have ever read. You'll notice the first difference as soon as you open it because it is published in Amazon's new Print Replica format. This full-color format preserves the beautifully crafted, rich graphical layout of each page.
This Excel 2010 book is for users who want to upgrade their basic Excel 2010 skills to true expert level. It will teach you to master all of Excel 2010’s advanced features. If you are an absolute beginner you need our Excel 2010 Essential Skills book.
The Smart Method provides an entirely new and better way to master advanced Excel 2010 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 2010 skills that you already know. All of that material is covered already in our beginner’s Excel 2010 Essential Skills book. By assuming that you are already able to use the Excel 2010 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 pages. You can complete each self-contained lesson in a few minutes.
- 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 2016’s most advanced features in a fraction of the time needed when learning from conventional text books.
Here is a small selection from the many advanced Excel skills you will learn:
- Visually filter data using Excel 2010's new Slicers
- Master dynamic tables using automatic, manual, qualified and unqualified structured table references
- Use advanced filters to apply complex logical criteria
- Use Excel's Subtotal feature to create both regular and nested subtotals
- Enforce complex business rules using function driven custom validations
- Implement a hyperlink-based navigation system to allow users to easily navigate large workbooks
- Create beautiful interactive forms using checkbox, combo box, command button, text box and option button controls
- 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
- Use Excel 2010's new ability to completely custom-design Ribbon tabs
- Record macros with both absolute and relative references
- Execute macros from button controls
- Understand and use all of Excel’s security features
- Design advanced Pivot Tables and Pivot Charts
- 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 Societ
This book is very, very different to any other Kindle book you have ever read. You'll notice the first difference as soon as you open it because it is published in Amazon's new Print Replica format. This full-color format preserves the beautifully crafted, rich graphical layout of each page.
This Excel 2013 book is for users who want to upgrade their basic Excel 2013 skills to true expert level. It will teach you to master all of Excel 2013’s advanced features. If you are an absolute beginner you need our Excel 2013 Essential Skills book.
The Smart Method provides an entirely new and better way to master advanced Excel 2013 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 2013 skills that you already know. All of that material is covered already in our beginner’s Excel 2013 Essential Skills book. By assuming that you are already able to use the Excel 2013 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 pages. You can complete each self-contained lesson in a few minutes.
- 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 2013’s most advanced features in a fraction of the time needed when learning from conventional text books.
Here is a small selection from the many advanced Excel skills you will learn:
- Master dynamic tables using automatic, manual, qualified and unqualified structured table references
- Use advanced filters to apply complex logical criteria
- Use Excel's Subtotal feature to create both regular and nested subtotals
- Use formula-driven validations to enforce complex business rules
- Implement a hyperlink-based navigation system to allow users to easily navigate large workbooks
- Create beautiful interactive forms using checkbox, combo box, command button, text box and option button controls
- Record macros with both absolute and relative references
- Execute macros from button controls
- Use slicers to allow touch-screen users to quickly filter Pivot Tables by multiple criteria
- Perform What-If analysis to model and compare business scenarios
- Use advanced functions to solve real-world business problems
- Understand and use all of Excel’s security features
- Completely understand Excel 2013’s new ability to create OLAP cubes
- Understand primary and foreign keys and use them to create both one-to-many and many-to-many relationships
- Use Excel 2013’s new OLAP Pivot Tables to present OLAP cube data
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
At long last there is now a professional Excel course available for Mac users.
This e-book is very, very different to any other Kindle book you have ever read. You'll notice the first difference as soon as you open it because it is published in Amazon's new Print Replica format. This full-color format preserves the beautifully crafted, rich graphical layout of each page.
By the end of the e-book you'll be able to use all of the power available from the world's most powerful business tool. Your Excel skills will be greater and broader than almost all other Excel users in the workplace. Mike Smart's revolutionary teaching method provides an entirely new, easier and better way to learn Excel 2016. Here are just five of the many ways in which this book is unique:
- This e-book won't waste your time by teaching basic Excel 2016 for Mac skills that you already know. All of that material is covered already in our beginner’s Excel 2016 for Mac Essential Skills book. By assuming that you are already able to use Excel 2016's basic features, far more ground can be covered.
- Each lesson is presented on two e-book pages. You can complete each self-contained lesson in a few minutes.
- Each lesson has a sample file that models a real-world business problem.
- The teaching method used in the book was developed and refined using over ten years of experience teaching real students Excel skills in classroom courses. The teaching method is fun, absorbing and virtually 100% effective.
- 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. This has made Smart Method books a popular choice for schools, colleges and universities all over the world.
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
Here is a small selection from the many advanced Excel skills you will learn:
- Master dynamic tables using automatic, manual, qualified and unqualified structured table references
- Use advanced filters to apply complex logical criteria
- Use Excel's Subtotal feature to create both regular and nested subtotals
- Use formula-driven validations to enforce complex business rules
- Use complex date & time functions to manage projects using the scheduling equation
- Use the VLOOKUP function to implement both exact and inexact lookups
- Automatically create both one and two-dimensional range names
- Create dynamic formula-based range names using the OFFSET function
- Create both single-input and two-input data tables
- Implement a hyperlink-based navigation system to allow users to easily navigate large workbooks
- Create beautiful interactive forms using checkbox, combo box, command button, text box and option button controls
- Record macros and then execute them from button controls
- Create single and two-dimensional pivot tables
- Use slicers to allow touch-screen users to quickly filter Pivot Tables by multiple criteria
- Perform What-If analysis to model and compare business scenarios
- Use advanced functions to solve real-world business problems
- Understand and use all of Excel's security features
At long last there is now a professional Excel course available for Mac users.
This e-book is very, very different to any other Kindle book you have ever read. You'll notice the first difference as soon as you open it because it is published in Amazon's new Print Replica format. This full-color format preserves the beautifully crafted, rich graphical layout of each page. Download the free sample and be amazed!
Mike Smart's revolutionary teaching method provides an entirely new, easier and better way to learn Excel 2016. Here are just five of the many ways in which this book is unique: :
- The e-book will equip you with excellent Excel 2016 for Mac 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 Excel 2016 for Mac Expert Skills book.
- Every lesson is presented on two e-book pages. You can complete each self-contained lesson in a few minutes.
- Each lesson has a sample file that models a real-world business problem.
- The teaching method used in the book was developed and refined using over ten years of experience teaching real students Excel skills in classroom courses. The teaching method is fun, absorbing and virtually 100% effective.
- 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, Excel 2016 for Mac adult training courses. This has made Smart Method books a popular choice for schools, colleges and universities all over the world.
You’ll immediately appreciate the value and relevance of each skill as it is taught. Both IT professionals and absolute beginners will love this e-book because it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way.
What you will learn
Amongst other things you'll learn how to:
- Create stunning, professional, presentation-quality charts
- Use the Themes feature to create visually excellent worksheets
- Use Cloud Computing features to share data
- Use AutoFill to create textual and numeric series
- Hide and show rows, columns and entire worksheets
- Create your own formulas
- Use Excel functions the professional way using Formula AutoComplete
- Understand absolute, relative and mixed cell references
- Create cross-worksheet formulas
- Add trend lines and moving averages to charts to forecast future values
- Use Sparklines to visually represent large data sets
- Bring your data alive with Visualizations
- Create custom conditional formatting rules with the Rules Manager
- Streamline your work by creating your own custom templates
- Create cell comments
- Master Excel 2016 for Mac’s Fluent User Interface and Ribbon
- Understand the different Excel 2016 for Mac file formats
- Add a professional sheen to your work with 3-D Elements
- Understand and work with three-dimensional worksheet groups
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, Unile
This book is very, very different to any other Kindle book you have ever read. You'll notice the first difference as soon as you open it because it is published in Amazon's new Print Replica format. This full-color format preserves the beautifully crafted, rich graphical layout of each page.
The Smart Method provides an entirely new, easier and better way to learn Excel 2010. Here are just four of the many ways in which this book is unique:
- The book will equip you with excellent Excel 2010 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 pages. You can complete each self-contained lesson in a few minutes.
- Each lesson has a sample file that models a real-world business problem.
The advanced teaching method used in this book will enable you to master Excel in a fraction of the time needed when learning from conventional text books. 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.
Amongst other things you'll learn how to:
- Create stunning, professional, presentation-quality charts
- Use the Themes feature to create visually excellent worksheets
- Use the new Excel 2010 Sparklines to visually represent large data sets
- Use the new Excel 2010 Versions feature to recover lost data
- Use AutoFill to create textual and numeric series
- Hide and show rows, columns and entire worksheets
- Create your own formulas
- Use Excel functions the professional way using Formula AutoComplete
- Understand absolute, relative and mixed cell references
- Create cross-worksheet formulas
- Add trend lines and moving averages to charts to forecast future values
- Bring your data alive with Visualizations
- Create custom conditional formatting rules with the new Rules Manager
- Streamline your work by creating your own custom templates
- Create both textual and graphical cell comments
- Add a professional sheen to your work with 3-D Elements
- Understand and work with three-dimensional worksheet groups
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 and Spencer, Virgin, O2, BMW... and many, many others.
This book is very, very different to any other Kindle book you have ever read. You'll notice the first difference as soon as you open it because it is published in Amazon's new Print Replica format. This full-color format preserves the beautifully crafted, rich graphical layout of each page.
This Excel 2007 book is for users who want to upgrade their basic Excel 2007 skills to true expert level. It will teach you to master all of Excel 2007’s advanced features. If you are an absolute beginner you need our Excel 2007 Essential Skills book.
The Smart Method provides an entirely new and better way to master advanced Excel 2007 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 pages. You can complete each self-contained lesson in a few minutes.
- 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 2016’s most advanced features in a fraction of the time needed when learning from conventional text books.
Here is a small selection from the many advanced Excel skills you will learn:
- 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 and Spencer, Virgin, O2, BMW... and many, many others.
This book is very, very different to any other Kindle book you have ever read. You'll notice the first difference as soon as you open it because it is published in Amazon's new Print Replica format. This full-color format preserves the beautifully crafted, rich graphical layout of each page.
The Smart Method provides an entirely new, easier and better way to learn Excel 2007. Here are just four 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 pages. You can complete each self-contained lesson in a few minutes.
- Each lesson has a sample file that models a real-world business problem.
The advanced teaching method used in this book will enable you to master Excel in a fraction of the time needed when learning from conventional text books. 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.
Amongst other things you'll learn how to:
- Master Excel 2007’s new Fluent User Interface and Ribbon
- Understand the new Excel 2007 file formats and when to use them
- Create your own formulas with the new Formula AutoComplete feature
- Create cross worksheet formulas
- Understand absolute, relative and mixed cell references
- Create stunning, professional, presentation-quality charts
- Use the new Themes feature to create visually excellent worksheets
- Use Excel 2007’s new Trend Line feature
- Bring your data alive with Excel 2007’s stunning Visualizations
- Create custom conditional formatting rules with the new Rules Manager
- Add a professional sheen to your work with 3-D Elements
- Understand and work with three-dimensional worksheet groups
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 and Spencer, Virgin, O2, BMW... and many, many others.
This e-book is very, very different to any other Kindle book you have ever read. You'll notice the first diference as soon as you open it because it is published in Amazon's new Print Replica format. This full-color format preserves the beautifully crafted, rich graphical layout of each page.
The Smart Method provides an entirely new and better way to learn Excel 2013. Here are just four of the many ways in which this book is unique:
- The book will equip you with excellent Excel 2013 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 pages. You can complete each self-contained lesson in a few minutes.
- Each lesson has a sample file that models a real-world business problem.
The advanced teaching method used in this book will enable you to master Excel in a fraction of the time needed when learning from conventional text books. 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.
Amongst other things you'll learn how to:
- Use the new Excel 2013 Flash Fill feature to split, concatenate and format text and date values
- Use the new Excel 2013 Apps to add new functionality to worksheets
- Use the new Excel 2013 Cloud Computing features to share data
- Create stunning, professional, presentation-quality charts
- Use the Themes feature to create visually excellent worksheets
- Use the Versions feature to recover lost data
- Use AutoFill to create textual and numeric series
- Hide and show rows, columns and entire worksheets
- Create your own formulas
- Use Excel functions the professional way using Formula AutoComplete
- Understand absolute, relative and mixed cell references
- Create cross-worksheet formulas
- Add trend lines and moving averages to charts to forecast future values
- Use Sparklines to visually represent large data sets
- Bring your data alive with Visualizations
- Create custom conditional formatting rules with the Rules Manager
- Streamline your work by creating your own custom templates
- Create both textual and graphical cell comments
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 and Spencer, Virgin, O2, BMW... and many, many others.