Setup Menus in Admin Panel

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

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

PRIVATE COURSE
  • PRIVATE
  • 1 week, 3 days
0 STUDENTS ENROLLED
    Copyright @2019