Канал: The Smart Method

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-13: Implement Macro Security

09-13: Implement Macro Security

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

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)

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-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 Read/Write

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)

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-6: How To Create Formulas That Reference Other Excel Worksheets

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

6-5: Hide and Unhide Excel Worksheets

6-5: Hide and Unhide 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-3: Split a Large Excel Worksheet Into Multiple (Separate) Worksheets

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

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-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-27: Create an Excel Chart Template

5-27: Create an Excel Chart Template

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

5-18: Add and Format Data Labels and add a Data Table an Excel Chart

5-18: Add and Format Data Labels and add a Data Table an Excel Chart

5-17: Connect Empty Data Points or Show as a Gap in Excel Charts.

5-17: Connect Empty Data Points or Show as a Gap in Excel Charts.

5-16: Use Numbers on the X Axis of an Excel Chart

5-16: Use Numbers on the X Axis of an Excel Chart

5-15 Chart Non-Adjacent (Non Contiguous) Data by Hiding Columns & Rows

5-15 Chart Non-Adjacent (Non Contiguous) Data by Hiding Columns & Rows

5-14 Change Excel Chart Source Data using the Select Data Source dialog

5-14 Change Excel Chart Source Data using the Select Data Source dialog

5-13: Understand Excel Chart Data Series and Excel Chart Categories

5-13: Understand Excel Chart Data Series and Excel Chart Categories

5-12: Assign Data From Multiple Ranges (Non-Contiguous) to a Chart

5-12: Assign Data From Multiple Ranges (Non-Contiguous) to a Chart

5-11: Change an Excel Chart Source Data (Select Data Source Dialog)

5-11: Change an Excel Chart Source Data (Select Data Source Dialog)

5-10: Apply an Excel Chart Filter

5-10: Apply an Excel Chart Filter

5-9: Move, Re-Size, Add, Position and Delete Excel Chart Elements

5-9: Move, Re-Size, Add, Position and Delete Excel Chart Elements

5-8: Format Excel 3-D Elements and Add Drop Shadows

5-8: Format Excel 3-D Elements and Add Drop Shadows

5-7: Manually format an Excel chart element

5-7: Manually format an Excel chart element

5-6: Use the Chart Styles Gallery to Apply a Chart Style and Color Set

5-6: Use the Chart Styles Gallery to Apply a Chart Style and Color Set

5-5: Add and Remove Chart Elements using Quick Layout

5-5: Add and Remove Chart Elements using Quick Layout

5-4: Create an Excel chart using Recommended Charts & Quick Analysis

5-4: Create an Excel chart using Recommended Charts & Quick Analysis

5-3: Change Chart Style and Move, Re-Size, Copy & Name an Excel Chart

5-3: Change Chart Style and Move, Re-Size, Copy & Name an Excel Chart

5-2: Create an Excel Chart with Two Clicks

5-2: Create an Excel Chart with Two Clicks

5-1: Understand Excel Chart Types, Chart Layouts and Chart Styles

5-1: Understand Excel Chart Types, Chart Layouts and Chart Styles

4 -23: How To Rotate Text in Excel (Vertical, Horizontal and Angled)

4 -23: How To Rotate Text in Excel (Vertical, Horizontal and Angled)

4-22: Two Ways to Use the Format Painter (Sticky and One-Time)

4-22: Two Ways to Use the Format Painter (Sticky and One-Time)

4-21: Apply a Date Axis Type to an Excel Sparkline group

4-21: Apply a Date Axis Type to an Excel Sparkline group

4-19: Insert Excel Sparklines - Line Type, Column Type and Win/Loss

4-19: Insert Excel Sparklines - Line Type, Column Type and Win/Loss

4-18: Conditional Formatting with Formulas - Defining Custom Rules

4-18: Conditional Formatting with Formulas - Defining Custom Rules

4-17: Insert Data Bars, Color Scales and Icon Sets into Excel cells.

4-17: Insert Data Bars, Color Scales and Icon Sets into Excel cells.

4-16: Advanced Conditional Formatting Using the Rules Manager

4-16: Advanced Conditional Formatting Using the Rules Manager

4-14: Use an Excel Master Style Book to Merge Custom Styles

4-14: Use an Excel Master Style Book to Merge Custom Styles

4-13: Create Excel Custom Cell Styles

4-13: Create Excel Custom Cell Styles

4-12: Create Your Own Excel Custom Theme

4-12: Create Your Own Excel Custom Theme

4-11: Apply or Draw Borders around Excel cells

4-11: Apply or Draw Borders around Excel cells

4-10: How To Add a Gradient Effect (Gradient Fill) to Excel Cells

4-10: How To Add a Gradient Effect (Gradient Fill) to Excel Cells

4-9: How To Use Excel Cell Styles to Create Beautiful Worksheets

4-9: How To Use Excel Cell Styles to Create Beautiful Worksheets

4-7: Vertical Alignment of Excel Cells. Top, Bottom, Middle, Justify

4-7: Vertical Alignment of Excel Cells. Top, Bottom, Middle, Justify

4-6: Join Two Cells into One With Excel Merge & Center (inc Wrap Text)

4-6: Join Two Cells into One With Excel Merge & Center (inc Wrap Text)

4-5: Excel Horizontal Alignment - Left, Right, Center, Justify, Fill

4-5: Excel Horizontal Alignment - Left, Right, Center, Justify, Fill

4-4: Use Excel Custom Number Formats to apply ANY number format.

4-4: Use Excel Custom Number Formats to apply ANY number format.

4-3: Solve Excel Rounding Errors with the ROUND function.

4-3: Solve Excel Rounding Errors with the ROUND function.

4-20: Apply a Common Vertical Axis and Formatting to a Sparkline Group

4-20: Apply a Common Vertical Axis and Formatting to a Sparkline Group

Excel Essential Skills Course - Session 2: Doing Useful Work with Excel

Excel Essential Skills Course - Session 2: Doing Useful Work with Excel

3-20: Check spelling in an Excel workbook

3-20: Check spelling in an Excel workbook

3-19: Split the Excel window into multiple panes

3-19: Split the Excel window into multiple panes

3-18: Freeze columns and rows (Freeze Panes)

3-18: Freeze columns and rows (Freeze Panes)

3-17: Add an Add-In (App) to an Excel workbook

3-17: Add an Add-In (App) to an Excel workbook

3-16: Use an Excel template

3-16: Use an Excel template

3-14: Understand Templates and Set a Custom Template Folder Location.

3-14: Understand Templates and Set a Custom Template Folder Location.

3-13: Understand mixed cell references (A&1, $A1).

3-13: Understand mixed cell references (A&1, $A1).

3-3: Cut, copy and paste includes Keyboard Shortcut Keys

3-3: Cut, copy and paste includes Keyboard Shortcut Keys

3-11: Print Excel Cell Comments at the End of, or Within a Worksheet

3-11: Print Excel Cell Comments at the End of, or Within a Worksheet

3-10: Show and Hide Excel Comments (Create Sticky Comments)

3-10: Show and Hide Excel Comments (Create Sticky Comments)

3-9: Insert cell comments

3-9: Insert cell comments

3-8: Use Undo and Redo (includes shortcut keys)

3-8: Use Undo and Redo (includes shortcut keys)

3-7: Use the Multiple Item Office Clipboard and Clipboard Task Pane

3-7: Use the Multiple Item Office Clipboard and Clipboard Task Pane

3-6: Transpose a range

3-6: Transpose a range

3 5: Use Paste Values and increase/decrease decimal places displayed

3 5: Use Paste Values and increase/decrease decimal places displayed

3-2: Use AutoComplete, Pick from Drop Down List and Fill Down features

3-2: Use AutoComplete, Pick from Drop Down List and Fill Down features

3-1: Insert and delete Excel rows and columns (inc shortcut keys)

3-1: Insert and delete Excel rows and columns (inc shortcut keys)

3 4: Cut, copy and paste using drag and drop (mouse & Ctrl key method)

3 4: Cut, copy and paste using drag and drop (mouse & Ctrl key method)

Excel Essential Skills - Session 3: Taking Your Skills to the Next Level

Excel Essential Skills - Session 3: Taking Your Skills to the Next Level

Excel Essential Skills Course - Session 1: Basic Skills

Excel Essential Skills Course - Session 1: Basic Skills

09-10: Record Your First Excel Macro (Short, Comprehensive Tutorial)

09-10: Record Your First Excel Macro (Short, Comprehensive Tutorial)

Excel Expert Lesson 5-8: Filter a pivot table visually using slicers

Excel Expert Lesson 5-8: Filter a pivot table visually using slicers

Excel Expert Lesson 6-9: Understand many-to-many relationships

Excel Expert Lesson 6-9: Understand many-to-many relationships

Excel Expert Lesson 6-1: Understand primary and foreign keys

Excel Expert Lesson 6-1: Understand primary and foreign keys

Excel Expert Lesson 8-10: Understand the three different ways to share a workbook

Excel Expert Lesson 8-10: Understand the three different ways to share a workbook

09-02: Add a Combo Box (Drop-Down List) form control without VBA

09-02: Add a Combo Box (Drop-Down List) form control without VBA

Excel Expert Lesson 6-3: Understand OLAP, MDX and Business Intelligence.

Excel Expert Lesson 6-3: Understand OLAP, MDX and Business Intelligence.

8-4: Microsoft Office Online (the FREE Office Version) 3 Minute Guide

8-4: Microsoft Office Online (the FREE Office Version) 3 Minute Guide

8-7: Edit a Workbook Simultaneously With Others Using Excel Online

8-7: Edit a Workbook Simultaneously With Others Using Excel Online

7-7: Insert an Excel Header and Footer With Page Numbers on Every Page

7-7: Insert an Excel Header and Footer With Page Numbers on Every Page

4-2: Understand Date Serial Numbers and Date Arithmetic

4-2: Understand Date Serial Numbers and Date Arithmetic

5-24: Create an Excel Custom Combo Chart Using Different Chart Types

5-24: Create an Excel Custom Combo Chart Using Different Chart Types

7-2: Use Page Layout view to adjust margins

7-2: Use Page Layout view to adjust margins

3-15: Create an Excel template

3-15: Create an Excel template

5-25: Add a Trend Line and Moving Average to an Excel Chart

5-25: Add a Trend Line and Moving Average to an Excel Chart

4-15: Use Excel Conditional Formatting based on Dates, Values and Text

4-15: Use Excel Conditional Formatting based on Dates, Values and Text

3-12: Understand Excel absolute ($A$1)and relative (A1) cell references

3-12: Understand Excel absolute ($A$1)and relative (A1) cell references

4-8: Excel Themes Tutorial (Font Set, Color Set and Effects Set)

4-8: Excel Themes Tutorial (Font Set, Color Set and Effects Set)

2-18: Use Excel Flash Fill to split Delimited Text

2-18: Use Excel Flash Fill to split Delimited Text

2-16: Use Excel AutoFill Date options - Days, Weekdays, Months & Years

2-16: Use Excel AutoFill Date options - Days, Weekdays, Months & Years

2-23: Printing in Excel (ALL Backstage Print Options inc. Scaling)

2-23: Printing in Excel (ALL Backstage Print Options inc. Scaling)

2-17: Create Custom AutoFill Lists (series) & other Autofill Pro Tips

2-17: Create Custom AutoFill Lists (series) & other Autofill Pro Tips

2-20: Use Flash Fill Artificial Intelligence (Expert Tutorial)

2-20: Use Flash Fill Artificial Intelligence (Expert Tutorial)

2-21: Use Excel Flash Fill to Solve Real-World Business Problems

2-21: Use Excel Flash Fill to Solve Real-World Business Problems

2-15: How AutoFill Adjusts Cell References in Excel Formulas

2-15: How AutoFill Adjusts Cell References in Excel Formulas

2-19: Use Flash Fill to Reformat A Phone Number (Expert Tutorial)

2-19: Use Flash Fill to Reformat A Phone Number (Expert Tutorial)

2-22: Zoom In and Zoom Out of an Excel worksheet

2-22: Zoom In and Zoom Out of an Excel worksheet

2-7: Select Non-Contiguous (Non-Adjacent) Cell Ranges

2-7: Select Non-Contiguous (Non-Adjacent) Cell Ranges

1-11: How to recover an earlier version of an Excel workbook

1-11: How to recover an earlier version of an Excel workbook

2-4: Select a range of cells and understand Smart Tags

2-4: Select a range of cells and understand Smart Tags

2-11: Use AutoSum to apply an AVERAGE, MAX, MIN or COUNT function.

2-11: Use AutoSum to apply an AVERAGE, MAX, MIN or COUNT function.

1-12: Show/Hide the Excel Ribbon and use Tabs, Groups and Commands.

1-12: Show/Hide the Excel Ribbon and use Tabs, Groups and Commands.

1-2: Check that your Excel version is up to date

1-2: Check that your Excel version is up to date

2-12: Create Excel formulas the correct, professional way

2-12: Create Excel formulas the correct, professional way

1-17: Use Full Screen Views by Hiding the Formula Bar and Ribbon

1-17: Use Full Screen Views by Hiding the Formula Bar and Ribbon

1-10: How to Recover a Deleted, Unsaved or Lost Excel file

1-10: How to Recover a Deleted, Unsaved or Lost Excel file

2-14: Use AutoFill Excel Series (Months, Days, Dates, Numbers & Text)

2-14: Use AutoFill Excel Series (Months, Days, Dates, Numbers & Text)

1-3: How To Change the Office Theme

1-3: How To Change the Office Theme

2-2: Open and view two Excel workbooks at the same time

2-2: Open and view two Excel workbooks at the same time

2-3: Use AutoSum to quickly calculate totals

2-3: Use AutoSum to quickly calculate totals

1-15: Use Keyboard Shortcuts for absolutely ANY Excel command.

1-15: Use Keyboard Shortcuts for absolutely ANY Excel command.

2-6: How To Select Multiple Excel Rows and Columns

2-6: How To Select Multiple Excel Rows and Columns

2-1: Enter and Edit Text and Numbers in an Excel Worksheet

2-1: Enter and Edit Text and Numbers in an Excel Worksheet

1-13: Understand Ribbon components

1-13: Understand Ribbon components

1-6: How to save an Excel workbook to a local file

1-6: How to save an Excel workbook to a local file

2-10: Use AutoSum to sum a non-contiguous (non adjacent) range

2-10: Use AutoSum to sum a non-contiguous (non adjacent) range

1-1: Open an Excel Workbook

1-1: Open an Excel Workbook

1-18: Use the help system * Now Deprecated *

1-18: Use the help system * Now Deprecated *

1-16: Excel Views - Normal, Page Break Preview and Page Layout

1-16: Excel Views - Normal, Page Break Preview and Page Layout

2-5: Speed Data Entry: Enter, Tab, Shift+Tab, Shift+Enter & Ctrl+Enter

2-5: Speed Data Entry: Enter, Tab, Shift+Tab, Shift+Enter & Ctrl+Enter

1-4: Maximize, minimize, re-size, move and close the Excel window

1-4: Maximize, minimize, re-size, move and close the Excel window

1-5: Navigate Large Excel Worksheets with Scroll Bars & Shortcut Keys

1-5: Navigate Large Excel Worksheets with Scroll Bars & Shortcut Keys

1-8: Pin an Excel Workbook & Organize Files (File & Folder Management)

1-8: Pin an Excel Workbook & Organize Files (File & Folder Management)

2-13: Create Any Excel Function Faster and Easier using AutoComplete

2-13: Create Any Excel Function Faster and Easier using AutoComplete

2-8: Keyboard Shortcuts to Select an Range Of Cells within a Block.

2-8: Keyboard Shortcuts to Select an Range Of Cells within a Block.

1-7: Understand Common Excel file formats (XLSX, XLSM, XLSB, XLS, PDF)

1-7: Understand Common Excel file formats (XLSX, XLSM, XLSB, XLS, PDF)

1-14: Customize the Quick Access Toolbar

1-14: Customize the Quick Access Toolbar

1-9: Excel Worksheet tabs - Everything There Is To Know

1-9: Excel Worksheet tabs - Everything There Is To Know

2-9: Automatically Re-size Multiple Excel Rows and Columns

2-9: Automatically Re-size Multiple Excel Rows and Columns

Excel 2007 Course: Lesson 2-3 Use AutoSum to quickly calculate totals

Excel 2007 Course: Lesson 2-3 Use AutoSum to quickly calculate totals