The Smart Method

The Smart Method

Latest Videos

09-06 Use Excel CheckBox values in formulas without VBA
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-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-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-03 Set Cell Links for Excel Combo Box & Group Box Option Buttons
09-01 Add Group Box and Option Button form controls without VBA
09-01 Add Group Box and Option Button form controls without VBA
03-07 Excel Date and Time - Everything you need to know.
03-07 Excel Date and Time - Everything you need to know.
Lesson 03-06 Use the Excel SUMIF and COUNTIF functions
Lesson 03-06 Use the Excel SUMIF and COUNTIF functions
03-24 Use a VLOOKUP function for an inexact lookup
03-24 Use a VLOOKUP function for an inexact lookup
03-22 Use a VLOOKUP function for an exact lookup.
03-22 Use a VLOOKUP function for an exact lookup.
03-05 Use the Excel IF function
03-05 Use the Excel IF function
09-17 Run an Excel macro from a button control
09-17 Run an Excel macro from a button control
09-12 Understand Macro Security Trusted Folders and Trusted Documents
09-12 Understand Macro Security Trusted Folders and Trusted Documents
09-13 Implement Macro Security
09-13 Implement Macro Security
4-1 Change Date Format in Excel Apr-10-21 041021 10421 etc
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-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-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-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
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
Excel Essential Skills Course - Session 4 Making Your Worksheets Look Professional
8-6 OneDrive Share Microsoft Office Files as Read Only or ReadWrite
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-5 Open a File Using Office Online the FREE Office Version
8-3 A Simple Guide to Operating systems Devices and Office Versions
8-3 A Simple Guide to Operating systems Devices and Office Versions
8-2 Open an Excel Workbook From a OneDrive
8-2 Open an Excel Workbook From a OneDrive
8-1 Save an Excel Workbook to a OneDrive
8-1 Save an Excel Workbook to a OneDrive
6-8 Excel Find and Replace - Expert Guide Covering All Features
6-8 Excel Find and Replace - Expert Guide Covering All Features
6-7 Select Multiple Worksheets to Create Excel 3-D Worksheet Groups
6-7 Select Multiple Worksheets to Create Excel 3-D Worksheet Groups
6-5 Hide and Unhide Excel Worksheets
6-5 Hide and Unhide Excel Worksheets
6-6 How To Create Formulas That Reference Other Excel Worksheets
6-6 How To Create Formulas That Reference Other Excel Worksheets
6-4 Move and Copy Worksheets Between Workbooks Merge and Combine
6-4 Move and Copy Worksheets Between Workbooks Merge and Combine
6-2 View Two Excel Workbooks Side By Side With Synchronous Scrolling
6-2 View Two Excel Workbooks Side By Side With Synchronous Scrolling
6-3 Split a Large Excel Worksheet Into Multiple Separate Worksheets
6-3 Split a Large Excel Worksheet Into Multiple Separate Worksheets
6-1 View the Same Excel Workbook in Two Side-by-Side Windows
6-1 View the Same Excel Workbook in Two Side-by-Side Windows
7-9 Different Excel Headers and Footers for First Odd and Even Pages
7-9 Different Excel Headers and Footers for First Odd and Even Pages
7-8 Add Custom Headers and Footers to a Printed Excel Worksheet
7-8 Add Custom Headers and Footers to a Printed Excel Worksheet
7-6 Insert Move & Remove Excel Page Breaks Using Page Break Preview
7-6 Insert Move & Remove Excel Page Breaks Using Page Break Preview
7-5 Insert and Delete Page Breaks without using Page Break Preview
7-5 Insert and Delete Page Breaks without using Page Break Preview
7-4 Fit All Excel Columns on One Printed Page with Excel Scale To Fit
7-4 Fit All Excel Columns on One Printed Page with Excel Scale To Fit
7-3 Perfectly Center an Excel Printout and Set Custom Margins
7-3 Perfectly Center an Excel Printout and Set Custom Margins
Excel Essential Skills - Session 8 Cloud Computing - Introduction
Excel Essential Skills - Session 8 Cloud Computing - Introduction
Excel Essential Skills Course - Session 7 Printing Your Work - Introduction
Excel Essential Skills Course - Session 7 Printing Your Work - Introduction
Essential Skills - Session 6 Working With Multiple Worksheets and Workbooks
Essential Skills - Session 6 Working With Multiple Worksheets and Workbooks
7-1 Excel Paper Orientation Portrait or Landscape and Print Preview
7-1 Excel Paper Orientation Portrait or Landscape and Print Preview
Excel Essential Skills - Session 5 Charts and Graphics
Excel Essential Skills - Session 5 Charts and Graphics
5-26 Add a Gradient Fill to an Excel Chart Area Background
5-26 Add a Gradient Fill to an Excel Chart Area Background
5-27 Create an Excel Chart Template
5-27 Create an Excel Chart Template
5-23 Add A Second Vertical Y Axis to an Excel Chart Combo Chart
5-23 Add A Second Vertical Y Axis to an Excel Chart Combo Chart
5-22 Excel Pie Chart Features - Rotate Perspective Pull Out Slice
5-22 Excel Pie Chart Features - Rotate Perspective Pull Out Slice
5-21 Change Excel Chart Scale - Vertical Y Axis Start & End Values
5-21 Change Excel Chart Scale - Vertical Y Axis Start & End Values
5-20 Add an Excel Text Box and Arrow Shape to an Excel Chart
5-20 Add an Excel Text Box and Arrow Shape to an Excel Chart
5-19 Add Data Labels to an Excel Chart From a Cell Range
5-19 Add Data Labels to an Excel Chart From a Cell Range