The Smart Method

22.4K subscribers

168 videos

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 o...

Latest Videos

09-06 Use Excel CheckBox values in formulas without VBA

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

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

03-07 Excel Date and Time - Everything you need to know.

Lesson 03-06 Use the Excel SUMIF and COUNTIF functions

03-24 Use a VLOOKUP function for an inexact lookup

03-22 Use a VLOOKUP function for an exact lookup.

03-05 Use the Excel IF function

09-17 Run an Excel macro from a button control

09-13 Implement Macro Security

09-12 Understand Macro Security, Trusted Folders and Trusted Documents

4-1 Change Date Format in Excel (Apr-10-21, 041021, 10421 etc)

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

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)

Excel Essential Skills Course - Session 4 Making Your Worksheets Look Professional

8-6 OneDrive, Share Microsoft Office Files as Read Only or ReadWrite

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-2 Open an Excel Workbook From a OneDrive

8-1 Save an Excel Workbook to a OneDrive

6-8 Excel Find and Replace - Expert Guide Covering All Features

6-7 Select Multiple Worksheets to Create Excel 3-D Worksheet Groups

6-6 How To Create Formulas That Reference Other Excel Worksheets

6-5 Hide and Unhide Excel Worksheets

6-4 Move and Copy Worksheets Between Workbooks (Merge and Combine)

6-3 Split a Large Excel Worksheet Into Multiple (Separate) Worksheets