Learn Excel 2007 Expert Skills with The Smart Method – Review and Bonus

Experienced Excel Trainer Reveals The Secret to Creating Microsoft Excel Experts.  

Find Out Below How You Could Be The Next Excel Expert

Once you know this training secret and have access to the “Learn Excel 2007 Expert Skills with The Smart Method” video training you will become an Excel Expert in Excel 2007 or Excel 2010.  Let me explain ….

I have taught hundreds of people to use Excel over the years on face to face courses and I have always adopted a simple, four step, approach.   I am going to tell you about this approach and let you try it for yourself with 3 free 1st class training videos and I am going to give you 47 free videos and example files for giving the method a go today.




The secret to learning Excel
Follow these 4 simple steps


Show You learn much faster when you know what the end goal is. The first thing an Excel trainer should do is show you what the end result is.  Once you know why you are being taught something the next step will be much easier for you and the trainer

Teach The “Show” part is usually too fast for you to pick up all the detail and remember it.  So now the Excel trainer should return to the example and show you a lot slower and include much more detail. This is the most important stage as it is the part where the knowledge is transferred from the trainer to you.

Practice The more you practice after you have learnt something the more you will remember afterwards.  If you don’t repeat what the trainer does then your retention of information will be around 20% – So if the trainer tells you 5 important things you will only remember 1 of them!  If you repeat what is taught once then this will rise to around 50% – repeat it 2 or 3 times and you will be amazed at how much you remember.

Test The final step is for you to complete a task that is slightly different from what was taught. This ensures that you have understood the techniques that were taught and not just memorised the steps need to copy the instructor! Once you can complete the test unaided you will feel confident and will retain the knowledge you have learnt.

This process works 98% of the time.

How do I know this secret works?

I run face to face courses that cost students $500 (£300) for a day of expert Excel training.  In the courses I follow the exact step by step approach outlined above with excellent success rates.  I don’t advertise the courses as I fill two courses a year from referrals by previous students simply by emailing them the dates of the next course.

The founder of this website, Clayton Lock, worked on a very similar principle and he has added a number of videos to this site that allow you to download the spreadsheet that is used in the video.  With these videos and files you can try the techniques shown and it is no coincidence that his videos on this website have the most comments.  Clayton  made 40 videos using this method and further down this page you will find out how you can download all 40 videos as a special bonus.

Try it yourself

Before I go any further have a go using this technique. Below is a fantastic starter video about Pivot Tables. Pivot tables are very underused in Excel as no one really knows what “Pivot” actually means!

Check out the training below and in around 8 minutes time you will understand why Pivot Tables are one of the most important things an Excel Expert must master.
Download the Excel file


How did you get on?

There are more training videos further down this page but before you scroll down to find them remember the 4 steps I talked about?  Show, Teach, Practice and Test.  Using Videos like the one above you use this method to teach yourself :-

Show Watch the video once without Excel open so you know what you are going to learn to do

Teach Watch it again with the spreadsheet in front of you following what is being shown. Repeat this until you are happy with what to do.

Practice Stop the video and repeat the steps described without the video playing.

Test More on how you can test yourself later


Imagine what you could do with Expert Excel training…

Imagine having a trainer at your computer for 2 days who knows how to train Expert Excel users and uses this very simple secret

How much better do you think your Excel knowledge
would be at the end of the two days of Expert Excel training?

During those two days you would learn techniques that will make your spreadsheets a lot more professional, potentially save you hours each week and make you look better in front of your boss or even help you in your next job interview…

Time for another quick training  video.  This time we are going to show you some of the data validation techniques that you should be applying to your spreadsheets to ensure the data entered into them is correct.

Download the Excel file

Pretty cool video I hope you will agree.  I love the way the trainer is talking so clearly and at just the right pace to learn and understand.  In case you are wondering I am not the trainer on these videos!

2 Days of Expert Excel Training

The two videos you have watch so far are from the “Learn Excel Expert Skills with The Smart Method” video training course and allows you to have access to a first class trainer for a small fraction of the cost I charge my students. This is great news for you but maybe not such good news for me!

The training is downloadable from the internet and installs on your computer.  The entire course consist of 154 videos covering 15 hours of hand on learning and an incredible 196 example spreadsheets for you to practice with.

I hope you have learnt something already from the two videos above – but they are only 2 out of 154!  It would take you two working days if you simply sat and listened to the course.

The course is divided into 8 sessions covering the best techniques to learn if you want to Improve Your Excel.

Each session is divided into a number of lessons with each lesson being around 5-10 minutes long.  This is important as this is the optimum time for you to keep your concentration.  So many courses I have reviewed have 20 minute videos (one even had a video 30 minutes long) and this just makes it difficult to replay and re-review the material covered in the video.

Every spreadsheet used in the videos is downloaded with the course so you can open the one that is being worked and once you have watched the video once (the Show part) then you can watch it again, pausing it and carrying out each step for yourself (the Teach and Practice parts).  You have had a go at this using the videos above and there is one more below.

Where this course surpasses the others on the market is that at the end of each session there is an exercise for you to test your new skills.  There are even answers included in a separate file if you need hints and help to complete each exercise (The final Test Part!).

Worth a fortune but is it too expensive?

The entire course consist of 154 videos covering 15 hours of hands-on learning and an incredible 196 example spreadsheets for you to practice with.

You are probably thinking that a course that covers so much, which can be downloaded to your computer will expensive to buy?   I have reviewed similar courses over the last couple of months that cost between $100 – $200 – if I was teaching it face to face it would cost $1000 (2 days at $500 a day) however you will not pay anywhere near this price.


Yes you read that right!  Mike Smart charges just $9.99 for 15 hours of focused expert Excel training and 196 example spreadsheets.  He must be mad as this is less than half the price that the competition charges and his course is so much better and downloadable!  You can even choose which version of Excel you want the course for – Mike does one for Excel 2007 and one for Excel 2010.

Excel 2007 – $9.99

Excel 2010 – $9.99

Below is a complete list of all the videos that you will have on your computer 30 minutes after ordering at the end of the list you will find another free training video.


Session 1: Tables, Ranges and Databases
1: Check your program and operating system version
2: Apply a simple filter to a range
3: Apply a top 10 and custom filter to a range
4: Apply an advanced filter with multiple OR criteria
5: Apply an advanced filter with complex criteria
6: Apply an advanced filter with function-driven criteria
7: Extract unique records using an advanced filter
8: Convert a range into a table with a total row
9: Format a table using table styles and convert a table into a range
10: Create a custom table style
11: Sort a range or table by rows
12: Sort a range by columns
13: Sort a range or table by custom list
14: Name a table and create an automatic structured table reference
15: Create a manual structured table reference
16: Use special items in structured table references
17: Understand unqualified structured references
Session 1: Exercise
Session 1 Exercise Answers
Session 2: Data Integrity, Subtotals and Validations
1: Split fixed width data using Text to Columns
2: Split delimited data using Text to Columns
3: Automatically subtotal a range
4: Create nested subtotals
5: Consolidate data from multiple data ranges
6: Use data consolidation to generate quick subtotals from tables
7: Validate numerical data
8: Create user-friendly messages for validation errors
9: Create data entry Input Messages
10: Add a formula-driven date validation and a text length validation
11: Add a table-based dynamic list validation
12: Use a function-driven custom validation to enforce complex business rules
13: Remove duplicate values from a range or table
14: Use a custom validation to add a unique constraint to a column
Session 2: Exercise
Session 2 Exercise Answers
Session 3: Advanced functions
1: Understand precedence rules and use the Evaluate feature
2: Use common functions with Formula AutoComplete
3: Use the formula palette and the PMT function
4: Use the PV and FV functions to value investments
5: Use the IF logic function
6: Use the SUMIF and COUNTIF logic functions to create conditional totals
7: Understand date serial numbers
8: Understand common date functions
9: Use the DATEDIF function
10: Use date offsets to manage projects using the scheduling equation
11: Use the DATE function to offset days, months and years
12: Enter time values and perform basic time calculations
13: Perform time calculations that span midnight
14: Understand common time functions and convert date serial numbers to decimal values
15 Use the TIME function to offset hours, minutes and seconds
16 Use the AND and OR functions to construct complex Boolean criteria
17 Understand calculation options (manual and automatic)
18: Concatenate strings using the concatenation operator (&)
19: Use the TEXT function to format numerical values as strings
20: Extract text from fixed width strings using the LEFT, RIGHT and MID functions
21: Extract text from delimited strings using the FIND and LEN functions
22: Use a VLOOKUP function for an exact lookup
23: Use an IFERROR function to suppress error messages
24: Use a VLOOKUP function for an inexact lookup
Session 3: Exercise
Session 3 Exercise Answers
Session 4: Using Names and the Formula Auditing Tools
1: Automatically create single-cell range names
2: Manually create, single cell range names and named constants
3: Use range names to make formulas more readable
4: Automatically create range names in two dimensions
5: Use intersection range names and the INDIRECT function
6: Create dynamic formula-based range names using the OFFSET function
7: Create table-based dynamic range names
8: Create two linked drop-down lists using range names
9: Understand the #NUM!, #DIV/0! and #NAME? Error Values
10: Understand the #VALUE!, #REF! and #NULL! Error Values
11: Understand background error checking and error checking rules
12: Manually check a worksheet for errors
13: Audit a formula by tracing precedents
14: Audit a formula by tracing dependents
15: Use the watch window to monitor cell values
16: Use Speak Cells to eliminate data entry errors
Session 4: Exercise
Session 4 Exercise Answers
Session 5: Pivot Tables
1: Create a one dimensional pivot table report from a table
2: Create a grouped pivot table report
3: Understand pivot table rows and columns
4: Use an external data source
5: Apply a simple filter and sort to a pivot table
6: Use report filter fields
7: Filter a pivot table visually using slicers
8: Use slicers to create a date-driven interface
9: Use report filter fields to automatically create multiple pages
10: Format a pivot table using PivotTable styles
11: Create a custom PivotTable style
12: Understand pivot table report layouts
13: Add/remove subtotals and apply formatting to pivot table fields
14: Display multiple summations within a single pivot table
15: Add a calculated field to a pivot table
16: Add a calculated item to a pivot table
17: Group by Text
18: Group by Date
19: Group by numeric value ranges
20: Show row data by percentage of total rather than value
21: Create a pivot chart from a pivot table
22:  Embed multiple pivot tables onto a worksheet
23: Use slicers to filter multiple pivot tables
Session 5: Exercise
Session 5 Exercise Answers
Session 6 What If Analysis and Security
1: Create a single-input data table
2: Create a two-input data table
3: Define scenarios
4: Create a scenario summary report
5: Use Goal Seek
6: Use Solver
7: Hide and unhide worksheets, columns and rows
8: Create custom views
9: Prevent unauthorized users from opening or modifying workbooks
10: Control the changes users can make to workbooks
11: Restrict the cells users are allowed to change
12: Allow different levels of access to a worksheet with multiple passwords
13: Create a digital certificate
14: Add an invisible digital signature to a workbook
15: Add an visible digital signature to a workbook
Session 6: Exercise
Session 6 Exercise Answers
Session 7:Working with the Internet,
plications and Workgroups
1: Publish a worksheet as a single web page
2: Publish multiple web pages as a web site
3: Hyperlink to worksheets and ranges
4: Hyperlink to other workbooks and the Internet
5: Hyperlink to an e-mail address and enhance the browsing experience
6: Execute a web query
7: Embed an Excel worksheet object into a Word document
8: Embed an Excel chart object into a Word document
9: Link an Excel worksheet to a Word document
10: Understand the three different ways to share a document
11: Share a workbook using the lock method
12: Share a workbook using the merge method
13: Share a workbook on a network
14: Accept and reject changes to shared workbooks
Session 7: Exercise
Session 7 Exercise Answers
Session 8:Forms and Macros
1: Add group box and option button controls to a worksheet form
2: Add a combo box control to a worksheet form
3: Set form control cell links
4: Connect result cells to a form
5: Add a check box control to a worksheet form
6: Use check box data in result cells
7: Add a temperature gauge chart to a form
8: Add a single input data table to a form
9: Improve form appearance and usability
10: Understand macros and VBA
11: Record a macro with absolute references
12: Understand macro security
13: Implement macro security
14: Understand Trusted Documents
15: Record a macro with relative references
16: Use shapes to run macros
17: Run a macro from a button control
18: Show and hide Ribbon tabs
19: Add custom groups to standard Ribbon tabs
20: Create a custom Ribbon tab
Session 8: Exercise
Session 8 Exercise Answers

The list above is pretty comprehensive I am sure you will agree. If you are still not convinced that this course is for you let me tell you a little more about Mike Smart.

Let me introduce you to Mike Smart

Mike has been writing books on Microsoft Excel and other Microsoft Office products since he first wrote an Access 2003 VBA book.  He runs a training company called The Smart Method Ltd in the UK but has recently reduced the amount of onsite training he does so he can focus on his books and video series on Microsoft Excel.

His books are extremely popular and currently top the Amazon charts for Excel 2007 and Excel 2010 – you can even check this out yourself if you want Search Amazon.com for Excel 2007 – Search Amazon.co.uk for Excel 2007

While you are there you may like to check out some of the Independent Reviews for his latest Excel 2010 book.  This book only has 5 star ratings and here are a selection of the headlines that people have written

  • “A total life and time saver! Best experience learning Excel I’ve had yet, July 20, 2012”
  • “Need to Learn Excel?? This is the book for you!!, July 21, 2012”
  • “Sucked into this book, couldn’t let it go, August 6, 2012”
  • “Excellent book, June 17, 2012”
  • “Most practical book I have used for Excel, July 14, 2012”
  • “Ease of Learning, August 3, 2012”

Please note that the books compliment the videos series so could could buy the book from Amazon and the Video series from here and have the best of both worlds.

Important – the bonus video offer below is only available for video courses purchased directly from this page and does not include the products sold from Amazon

Here are some of the customers that Mike Smart has personally trained.  You could receive the same level of training for a fraction of the cost.

Excel 2007 – $9.99

Excel 2010 – $9.99


Another Free Training Video

Data sorting is important in excel but what this next video will teach you will amaze you. Ever wondered how Excel knows that Tuesday follows Monday in a list when you drag it down the spreadsheet? The answer is Custom lists and this powerful feature of excel can be used to do some very clever sorting.

Download the Excel file

What do you get with this amazing course?

Let me quickly summarise what you will have access to in less than 30 minutes:-

  • 154 Videos to your computer
  • 196 Example spreadsheets
  • 15 Hours of expert Excel training from Mike Smart who would charge you $3000 to run this course at your office.

However you look at it this course is at such a crazy price that you think it is probably too good to be true. That was my first impression which is why I asked Mike Smart to let me have 3 videos to share with you on this page so you can see the quality of the training yourself. I have a copy of the whole training course on my computer and I can confirm that all 154 videos are of this quality.

I am so convinced that this is the best way to Improve Your Excel that I am going to offer you even more for your money.

Extra bonus for the next  50 23 copies

A good friend of mine, Clayton Lock, created a set of 47 videos and example files for Excel 2003 and he used to sell access to these videos for $47 a few years ago through as website called “The Tutorial Library”.

However if you purchase Learn Excel 2007 Expert Skills with The Smart Method using one of the links below and email the receipt number (shown in red below) to improveyourexcel(at)gmail.com then I will send you a download link to download all of these videos and example files free of charge.

You will get all these videos and example files free

  1. Custom Chart Types
  2. Frequency Distribution Plots
  3. Introduction to Conditional Formatting
  4. Multiple Conditional Formating
  5. Using Pivot tables for counting
  6. Adding Comments to Cells
  7. conditional formatting
  8. Data Valiadation Options
  9. Double Dropdown lists
  10. Hiding Error Messages
  11. Understanding Autofill
  12. Using Checkboxes
  13. Using Option Buttons
  14. Creating a timesheet Part I
  15. Creating a timesheet Part II
  16. Working with Dates and Times
  17. Working with Dates Part I
  18. Advanced Filtering
  19. Filtering Data
  20. How to use the LARGE function
  21. INDEX and Match
  22. Introduction to IF Function
  23. Introduction to Vlookup
  24. Moving Average
  25. Using the OFFSET function
  26. absolute and incremental references
  27. Adding Carriage Returns
  28. Introduction to Named Ranges
  29. Introduction to pivot tables
  30. Splitting Text Data with Equations
  31. Splitting Text Data without Equations
  32. Consolidated Reports
  33. Goal Seeking
  34. Pulling data from different workbooks
  35. Creating User Defined Functions
  36. How to debug VBA
  37. Printing Via VBA
  38. UserdefinedFunction
  39. VBA Cell Change Trigger
  40. Database Functions Part 1
  41. Database functions part 2
  42. Database Functions Part 3
  43. Descriptive Statistics
  44. Finding Duplicate Data
  45. Grouping and Outlines
  46. Removing Blanks from Data
  47. Tips for working with large sets of data


Excel 2007 – $9.99

Excel 2010 – $9.99

Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.