My name is Mike Smart and I've personally written and recorded every Excel video on this channel. I've devoted the last 20 years of my life working towards one objective: To create the world's best and easiest way to master Excel.

I'm the founder and CEO of The Smart Method. In my long career as an IT consultant, I specified, designed and delivered IT solutions for large corporations all over the world. In 2002 I decided to specialize in IT training and founded The Smart Method.

By carefully observing the areas that students find the most difficult to understand, I've constantly refined my Smart Method teaching technique over a period of more than twenty years.

In 2008 I realized that I could only ever teach a few thousand students in my classroom courses but could help millions of students by producing my Excel courses in book form. My first Smart Method Excel books (covering Excel 2007) rapidly became best sellers and my books have topped best seller lists ever since.

09-06 Use Excel CheckBox values in formulas without VBA
9:46
09-06 Use Excel CheckBox values in formulas without VBA
09-05 Add an Excel check box form control to a worksheet without VBA
3:45
09-05 Add an Excel check box form control to a worksheet without VBA
09-04 Use the Excel PMT function to create a mortgage calculator
6:33
09-04 Use the Excel PMT function to create a mortgage calculator
09-03 Set Cell Links for Excel Combo Box & Group Box (Option Buttons)
8:24
09-03 Set Cell Links for Excel Combo Box & Group Box (Option Buttons)
09-01 Add Group Box and Option Button form controls without VBA
16:40
09-01 Add Group Box and Option Button form controls without VBA
03-07 Excel Date and Time - Everything you need to know.
11:11
03-07 Excel Date and Time - Everything you need to know.
Lesson 03-06 Use the Excel SUMIF and COUNTIF functions
6:51
Lesson 03-06 Use the Excel SUMIF and COUNTIF functions
03-24 Use a VLOOKUP function for an inexact lookup
5:37
03-24 Use a VLOOKUP function for an inexact lookup
03-22 Use a VLOOKUP function for an exact lookup.
7:37
03-22 Use a VLOOKUP function for an exact lookup.
03-05 Use the Excel IF function
8:41
03-05 Use the Excel IF function
09-17 Run an Excel macro from a button control
10:46
09-17 Run an Excel macro from a button control
09-13: Implement Macro Security
10:54
09-13: Implement Macro Security
09-12 Understand Macro Security, Trusted Folders and Trusted Documents
5:17
09-12 Understand Macro Security, Trusted Folders and Trusted Documents
4-1: Change Date Format in Excel (Apr-10-21, 04/10/21, 10/4/21 etc)
6:30
4-1: Change Date Format in Excel (Apr-10-21, 04/10/21, 10/4/21 etc)
7-10: Print Selected Cells from an Excel Worksheet (Set Print Area)
7:44
7-10: Print Selected Cells from an Excel Worksheet (Set Print Area)
7-11: Print Row and Column Titles on Every Page and Print Gridlines
5:39
7-11: Print Row and Column Titles on Every Page and Print Gridlines
7-13: Hide Error Messages in Excel Printouts, but Still Show on Screen
2:50
7-13: Hide Error Messages in Excel Printouts, but Still Show on Screen
7-12: Change The Excel Print Order (Down Then Over or Over Then Down)
5:31
7-12: Change The Excel Print Order (Down Then Over or Over Then Down)
Excel Essential Skills Course - Session 4: Making Your Worksheets Look Professional
6:15
Excel Essential Skills Course - Session 4: Making Your Worksheets Look Professional
8-6: OneDrive, Share Microsoft Office Files as Read Only or Read/Write
7:33
8-6: OneDrive, Share Microsoft Office Files as Read Only or Read/Write
8-5: Open a File Using Office Online (the FREE Office Version)
5:05
8-5: Open a File Using Office Online (the FREE Office Version)
8-3: A Simple Guide to Operating systems, Devices and Office Versions
8:23
8-3: A Simple Guide to Operating systems, Devices and Office Versions
8-2: Open an Excel Workbook From a OneDrive
2:00
8-2: Open an Excel Workbook From a OneDrive
8-1: Save an Excel Workbook to a OneDrive
7:06
8-1: Save an Excel Workbook to a OneDrive
6-8: Excel Find and Replace - Expert Guide Covering All Features
11:00
6-8: Excel Find and Replace - Expert Guide Covering All Features
6-7: Select Multiple Worksheets to Create Excel 3-D Worksheet Groups
10:01
6-7: Select Multiple Worksheets to Create Excel 3-D Worksheet Groups
6-6: How To Create Formulas That Reference Other Excel Worksheets
9:06
6-6: How To Create Formulas That Reference Other Excel Worksheets
6-5: Hide and Unhide Excel Worksheets
4:38
6-5: Hide and Unhide Excel Worksheets
6-4: Move and Copy Worksheets Between Workbooks (Merge and Combine)
5:06
6-4: Move and Copy Worksheets Between Workbooks (Merge and Combine)
6-3: Split a Large Excel Worksheet Into Multiple (Separate) Worksheets
6:51
6-3: Split a Large Excel Worksheet Into Multiple (Separate) Worksheets