Course Curriculum
| Introduction | |||
| Welcome_Excel | 00:00:00 | ||
| What you should know before watching this course_Excel | 00:00:00 | ||
| Using the exercise files_Excel | 00:00:00 | ||
| Focusing Data Using Filters | |||
| Selecting the current region_Excel | 00:00:00 | ||
| Creating a filter_Excel | 00:00:00 | ||
| Chaining criteria using AND_Excel | 00:00:00 | ||
| Combining criteria using OR_Excel | 00:00:00 | ||
| Finding unique items using xlFilter_Excel | 00:00:00 | ||
| Restoring a range or worksheet to an unfiltered state_Excel | 00:00:00 | ||
| Managing Files Using VBA | |||
| Determining if a workbook exists_Excel | 00:00:00 | ||
| Determining if a folder (directory) exists_Excel | 00:00:00 | ||
| Detecting whether a file is open_Excel | 00:00:00 | ||
| Opening a workbook_Excel | 00:00:00 | ||
| Closing a workbook_Excel | 00:00:00 | ||
| Saving a workbook under a new name_Excel | 00:00:00 | ||
| Saving a workbook as a CSV file_Excel | 00:00:00 | ||
| Managing Worksheets Using VBA | |||
| Checking if a worksheet exists_Excel | 00:00:00 | ||
| Creating and renaming worksheets_Excel | 00:00:00 | ||
| Copying a worksheet within the active workbook_Excel | 00:00:00 | ||
| Copying a worksheet to a new workbook_Excel | 00:00:00 | ||
| Copying a worksheet to an existing workbook_Excel | 00:00:00 | ||
| Moving a worksheet within the active workbook_Excel | 00:00:00 | ||
| Moving a worksheet to a new workbook_Excel | 00:00:00 | ||
| Moving a worksheet to an existing workbook_Excel | 00:00:00 | ||
| Taking Advantage of Built-In Functions | |||
| Using the built-in Open dialog box_Excel | 00:00:00 | ||
| Suppressing and restoring alerts_Excel | 00:00:00 | ||
| Calculating data using Excel worksheet function_Excel | 00:00:00 | ||
| Using the current date and time_Excel | 00:00:00 | ||
| Removing spaces from before or after a string_Excel | 00:00:00 | ||
| Managing Charts Using VBA | |||
| Creating a chart_Excel | 00:00:00 | ||
| Moving a chart to a chart sheet_Excel | 00:00:00 | ||
| Adding a new data series to a chart_Excel | 00:00:00 | ||
| Exporting a chart as an image_Excel | 00:00:00 | ||
| Creating a line sparkline_Excel | 00:00:00 | ||
| Creating a column sparkline_Excel | 00:00:00 | ||
| Creating a win/loss sparkline_Excel | 00:00:00 | ||
| Deleting a sparkline_Excel | 00:00:00 | ||
| Creating User Forms | |||
| Creating a UserForm_Excel | 00:00:00 | ||
| Adding a TextBox to a UserForm_Excel | 00:00:00 | ||
| Adding a ListBox to a UserForm_Excel | 00:00:00 | ||
| Adding a ComboBox to a UserForm_Excel | 00:00:00 | ||
| Adding an option button to a UserForm_Excel | 00:00:00 | ||
| Adding graphics to a UserForm_Excel | 00:00:00 | ||
| Adding a SpinButton to a UserForm_Excel | 00:00:00 | ||
| Creating a multipage or multitab UserForm_Excel | 00:00:00 | ||
| Writing UserForm data to a worksheet_Excel | 00:00:00 | ||
| Running a UserForm_Excel | 00:00:00 | ||
| Conclusion | |||
| Further resources_Excel | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
0 STUDENTS ENROLLED
