Next steps - Microsoft Excel Tutorial

Contents

• Introduction Introduction

  • Automate processes using Visual Basic for application code

    34s
  • What you should know

    1m 41s
• 1. Focusing Data Using Filters 1. Focusing Data Using Filters

  • Select the active region

    3m 3s
  • Create a filter

    5m 46s
  • Chain criteria using AND

    2m 42s
  • Combine criteria using OR

    6m 14s
  • Find unique items using xlFilter

    7m 16s
  • Restore a range or worksheet to an unfiltered state

    2m 52s
• 2. Managing Files Using VBA 2. Managing Files Using VBA

  • Determine if a workbook exists

    4m 36s
  • Determine if a folder (directory) exists

    4m 49s
  • Detect whether a file is open

    5m 6s
  • Open a workbook

    2m 35s
  • Close a workbook

    5m 31s
  • Save a workbook under a new name

    4m 21s
  • Save a workbook as a CSV file

    4m 43s
• 3. Managing Worksheets Using VBA 3. Managing Worksheets Using VBA

  • Check if a worksheet exists

    5m 11s
  • Create and rename worksheets

    5m 28s
  • Copy a worksheet within the active workbook

    4m 20s
  • Copy a worksheet to a new workbook

    3m 58s
  • Copy a worksheet to an existing workbook

    5m 47s
  • Move a worksheet within the active workbook

    3m 15s
  • Move a worksheet to a new workbook

    4m 41s
  • Move a worksheet to an existing workbook

    6m 24s
• 4. Taking Advantage of Built-In Functions 4. Taking Advantage of Built-In Functions

  • Use the built-in Open dialog box

    3m 12s
  • Suppress and restore alerts

    3m 20s
  • Calculate data using Excel worksheet functions

    5m 26s
  • Use the current date and time

    7m 12s
  • Remove spaces from before or after a string

    4m 46s
• 5. Managing Charts Using VBA 5. Managing Charts Using VBA

  • Create a chart

    5m 1s
  • Move a chart to a chart sheet

    3m 49s
  • Add or remove data series from a chart

    5m 48s
  • Export a chart as an image

    4m 3s
  • Create a line sparkline

    3m
  • Create a column sparkline

    3m 25s
  • Create a win/loss sparkline

    4m 34s
  • Delete a sparkline

    2m 12s
• 6. Creating UserForms 6. Creating UserForms

  • Create a UserForm

    2m 38s
  • Add a TextBox to a UserForm

    3m 31s
  • Add a ListBox to a UserForm

    4m 52s
  • Add a ComboBox to a UserForm

    4m 55s
  • Add an option button to a UserForm

    3m 55s
  • Add graphics to a UserForm

    4m 28s
  • Add a SpinButton to a UserForm

    4m 16s
  • Create a multipage or multitab UserForm

    3m 50s
  • Write UserForm data to a worksheet

    7m 39s
  • Run a UserForm

    4m 8s
• 7. Managing PivotTables Using VBA 7. Managing PivotTables Using VBA

  • Record a PivotTable configuration

    4m 4s
  • Assign a PivotTable macro to the Quick Access Toolbar

    4m 39s
  • Advance one step forward in a PivotTable playlist

    7m 17s
  • Move to any PivotTable playlist position

    8m 8s
• Conclusion Conclusion

  • Next steps

    1m 32s