09:46
09-06 Use Excel CheckBox values in formulas without VBA
03:45
09-05 Add an Excel check box form control to a worksheet without VBA
06:33
09-04 Use the Excel PMT function to create a mortgage calculator
08:24
09-03 Set Cell Links for Excel Combo Box & Group Box (Option Buttons)
16:40
09-01 Add Group Box and Option Button form controls without VBA
11:11
03-07 Excel Date and Time - Everything you need to know.
06:51
Lesson 03-06 Use the Excel SUMIF and COUNTIF functions
05:37
03-24 Use a VLOOKUP function for an inexact lookup
07:37
03-22 Use a VLOOKUP function for an exact lookup.
08:41
03-05 Use the Excel IF function
10:46
09-17 Run an Excel macro from a button control
10:54
09-13: Implement Macro Security
05:17
09-12 Understand Macro Security, Trusted Folders and Trusted Documents
06:30
4-1: Change Date Format in Excel (Apr-10-21, 04/10/21, 10/4/21 etc)
07:44
7-10: Print Selected Cells from an Excel Worksheet (Set Print Area)
05:39
7-11: Print Row and Column Titles on Every Page and Print Gridlines
02:50
7-13: Hide Error Messages in Excel Printouts, but Still Show on Screen
05:31
7-12: Change The Excel Print Order (Down Then Over or Over Then Down)
06:15
Excel Essential Skills Course - Session 4: Making Your Worksheets Look Professional
07:33
8-6: OneDrive, Share Microsoft Office Files as Read Only or Read/Write
05:05
8-5: Open a File Using Office Online (the FREE Office Version)
08:23
8-3: A Simple Guide to Operating systems, Devices and Office Versions
02:00
8-2: Open an Excel Workbook From a OneDrive
07:06
8-1: Save an Excel Workbook to a OneDrive
11:00
6-8: Excel Find and Replace - Expert Guide Covering All Features
10:01
6-7: Select Multiple Worksheets to Create Excel 3-D Worksheet Groups
09:06
6-6: How To Create Formulas That Reference Other Excel Worksheets
04:38
6-5: Hide and Unhide Excel Worksheets
05:06
6-4: Move and Copy Worksheets Between Workbooks (Merge and Combine)
06:51
6-3: Split a Large Excel Worksheet Into Multiple (Separate) Worksheets
05:50
6-2: View Two Excel Workbooks Side By Side With Synchronous Scrolling
04:47
6-1: View the Same Excel Workbook in Two Side-by-Side Windows
08:07
7-9: Different Excel Headers and Footers for First, Odd and Even Pages
09:10
7-8: Add Custom Headers and Footers to a Printed Excel Worksheet
05:15
7-6: Insert, Move & Remove Excel Page Breaks Using Page Break Preview
07:03
7-5: Insert and Delete Page Breaks without using Page Break Preview
05:15
7-4: Fit All Excel Columns on One Printed Page with Excel Scale To Fit
05:42
7-3: Perfectly Center an Excel Printout and Set Custom Margins
04:05
Excel Essential Skills - Session 8: Cloud Computing - Introduction
05:53
Excel Essential Skills Course - Session 7: Printing Your Work - Introduction
04:04
Essential Skills - Session 6: Working With Multiple Worksheets and Workbooks
05:59
7-1: Excel Paper Orientation (Portrait or Landscape) and Print Preview
08:54
Excel Essential Skills - Session 5: Charts and Graphics
05:07
5-27: Create an Excel Chart Template
03:49
5-26: Add a Gradient Fill to an Excel Chart Area Background
04:58
5-23: Add A Second Vertical (Y) Axis to an Excel Chart (Combo Chart)
05:24
5-22: Excel Pie Chart Features - Rotate, Perspective, Pull Out Slice
05:27
5-21: Change Excel Chart Scale - Vertical (Y) Axis Start & End Values
06:50
5-20: Add an Excel Text Box and Arrow Shape to an Excel Chart
05:45
5-19: Add Data Labels to an Excel Chart From a Cell Range
05:50
5-18: Add and Format Data Labels and add a Data Table an Excel Chart
02:45
5-17: Connect Empty Data Points or Show as a Gap in Excel Charts.
03:49
5-16: Use Numbers on the X Axis of an Excel Chart
04:03
5-15 Chart Non-Adjacent (Non Contiguous) Data by Hiding Columns & Rows
04:00
5-14 Change Excel Chart Source Data using the Select Data Source dialog
04:13
5-13: Understand Excel Chart Data Series and Excel Chart Categories
05:12
5-12: Assign Data From Multiple Ranges (Non-Contiguous) to a Chart
05:15
5-11: Change an Excel Chart Source Data (Select Data Source Dialog)
03:35
5-10: Apply an Excel Chart Filter
06:46
5-9: Move, Re-Size, Add, Position and Delete Excel Chart Elements
X
About
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.
Tags