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.
TIME LIMITED SPECIAL OFFER – 60% OFF IN NOVEMBER
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.
TIME LIMITED SPECIAL OFFER – 60% OFF IN NOVEMBER – NOW ONLY $9.99
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 5 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
- Custom Chart Types
- Frequency Distribution Plots
- Introduction to Conditional Formatting
- Multiple Conditional Formating
- Using Pivot tables for counting
- Adding Comments to Cells
- conditional formatting
- Data Valiadation Options
- Double Dropdown lists
- Hiding Error Messages
- Understanding Autofill
- Using Checkboxes
- Using Option Buttons
- Creating a timesheet Part I
- Creating a timesheet Part II
- Working with Dates and Times
- Working with Dates Part I
- Advanced Filtering
- Filtering Data
- How to use the LARGE function
- INDEX and Match
- Introduction to IF Function
- Introduction to Vlookup
- Moving Average
- Using the OFFSET function
- absolute and incremental references
- Adding Carriage Returns
- Introduction to Named Ranges
- Introduction to pivot tables
- Splitting Text Data with Equations
- Splitting Text Data without Equations
- Consolidated Reports
- Goal Seeking
- Pulling data from different workbooks
- Creating User Defined Functions
- How to debug VBA
- Printing Via VBA
- VBA Cell Change Trigger
- Database Functions Part 1
- Database functions part 2
- Database Functions Part 3
- Descriptive Statistics
- Finding Duplicate Data
- Grouping and Outlines
- Removing Blanks from Data
- Tips for working with large sets of data
|Excel 2007 – $9.99
||Excel 2010 – $9.99