Productivity in Excel using ExTool

Name: Productivity in Excel using ExTool
Rating: 4.3 (160 reviews)

Learn how to be a champion at work with cloud-powered Excel

Created byZhenyu Zhu

Last updated 8/2016

English

What you'll learn

At the end of this course, students will be able to master their Excel skills by learning both basic and extended functions using the ExTool Application. Through this mastery, work efficiency will increase and result in a more productive, positive work or educational environment.

Course content

20 sections • 120 lectures • 4h 5m total length

Lecture 1: ExTool Introduction6:00
In this lecture, ExTool will be introduced. ExTool is a cloud-based, add-on application for Excel designed to eliminate repetitive tasks and, therefore, increases your productivity.
Lecture 2: ExTool Initial Setup5:33
This lecture will demonstrate how to install, setup, and register ExTool for first time use.
Lecture 3: ExTool First Time Use15:38
This lecture will introduce ExTool's user interface and demonstrate how some apps are run and used.
Lecture 4: ExTool Import Ribbon0:57
For better accessing to ExTool app, we prepare customized ribbon (zip file) for each section. You can download it directly from Udemy or from link https://dl.dropboxusercontent.com/u/32072909/ExTool/RibbonLayout/Udemy_Ribbon/Udemy_Ribbon.zip
Unzip the zip file and follow the instruction in this lecture to import ribbon.

Excel Workbook Management5:28
This section will introduce how to manage Excel workbooks. The current practice relies on a file system and built-in functions without a record of any GUI actions. With ExTool, you can batch process workbooks and easily track changes. This section will also demonstrate how to convert .xls files to .xlsx files and how to manipulate workbooks.
Lecture 1: Convert .xls to .xlsx1:40
Lecture 2: Open Folder of This File1:17
Lecture 3: Combine Listed Workbook0:47
Lecture 4: List Recent Workbooks1:33
Lecture 5: Remove Listed Files from Recent Workbook List1:03
Lecture 5: List Opened Workbooks0:57

Excel Worksheet Management6:03
This section will introduce how to manage Excel worksheets. The current practice relies on a file system and built-in functions without a record of any GUI actions. With ExTool, you can batch process worksheets and easily track changes. This section will also demonstrate how to add, delete, copy, rename, hide, and protect worksheets.
Lecture 1: Add Listed Sheet1:23
Lecture 2: Delete Listed Sheet1:24
Lecture 3: List Sheet Name and Range (A1)1:37
Lecture 4: Excel—Copy Listed Sheet to New Workbook0:59
Lecture 5: Copy Each Listed Sheet to New Workbook1:14
Lecture 6: Combine Data in Listed Sheet0:50
Lecture 7: Copy Listed Sheet and Update Link0:59
Lecture 8: Sort Sheet in Listed Order1:04
Lecture 9: Rename Listed Sheet1:08
Lecture 10: Get Listed Sheet Color0:59
Lecture 11: Change Listed Sheet Color1:13
Lecture 12: Hide Listed Sheet0:55
Lecture 13: Unhide Listed Sheet0:55
Lecture 14: Protect Listed Sheets1:07
Lecture 15: Un-Protect Listed Sheets1:17

Excel Page Setup and Print6:45
In this section, setting up pages in Excel will be introduced. The current practice has no record of GUI actions and is not consistent in quality. With ExTool’s built-in feature to track changes, these actions can be reversed anytime. Moreover, this lesson will show how to copy and clear sheet page setup and how to print ranges.
Lecture 1: Copy Listed Sheet Page Setup2:05
Lecture 2: Clear Listed Sheet Page Setup1:07
Lecture 3: Print Selected Range to PDF1:08
Lecture 4: Print Listed Sheet to PDF1:09
Lecture 5: Print Charts in Sheets to GIF1:14

Excel Graphic Object Management4:10
This section will demonstrate how to manage objects in Excel. The current practice has no record of GUI actions and is not consistent in quality. With ExTool’s built-in feature to track changes, these actions can be reversed anytime. Moreover, this lesson will show how to print, list, rename, delete, relocate, and resize objects.
Lecture 1: List Objects in This Sheet1:03
Lecture 2: Rename Listed Objects0:52
Lecture 3: Delete Listed Objects1:07
Lecture 4: Relocate Listed Objects1:14
Lecture 5: Resize Listed Objects1:44

Range – Select & List4:35
This section will introduce how to efficiently manage Excel ranges. Sometimes, ranges need to be selected intelligently based on specific criteria. The current practice has no record of GUI actions and, sometimes, one mistake will ruin all previous steps and force the user to repeat the task. This section will also demonstrate how to list objects and how other apps can be used to conduct specific actions will be introduced.
Lecture 1: List Selected Ranges1:03
Lecture 2: Select Listed Ranges1:02
Lecture 3: Select Non-Empty Cells In Target Range0:46
Lecture 4: Select Empty Cells in Target Range0:53
Lecture 5: Select Maximum Value in Each Column of Target Range0:58
Lecture 6: Select Maximum Value in Each Row of Target Range0:47
Lecture 7: Select Maximum Value in Target Range0:44
Lecture 8: Select Minimum Value in Each Row of Target Range0:43
Lecture 9: Select Minimum Value in Target Range0:42

Range – Copy & Move5:18
This section will introduce how to efficiently manage Excel ranges. Sometimes, ranges need to be selected intelligently based on specific criteria. The current practice has no record of GUI actions and, sometimes, one mistake will ruin all previous steps and force the user to repeat the task. This section will also demonstrate how to select a minimum and maximum value from a range and convert a column to a range.
Lecture 1: Column to Range1:36
Lecture 2: Range to Column1:02
Lecture 3: Copy Selected Ranges1:59
Lecture 4: Copy Listed Ranges1:01
Lecture 5: Copy Range Exact Formula1:14

Range – Hyperlink3:01
This section will introduce how to efficiently manage Excel ranges. Sometimes, ranges need to be selected intelligently based on specific criteria. The current practice has no record of GUI actions and, sometimes, one mistake will ruin all previous steps and force the user to repeat the task. This section will also demonstrate how to add hyperlinks.
Lecture 1: Add External Hyperlink1:36
Lecture 2: Add Internal Hyperlink1:34
Lecture 3: List Internal Hyperlink1:09
Lecture 4: List External Hyperlink1:05

Range – Text4:26
This section will introduce how to efficiently manage Excel ranges. Sometimes, ranges need to be selected intelligently based on specific criteria. The current practice has no record of GUI actions and, sometimes, one mistake will ruin all previous steps and force the user to repeat the task. This section will also demonstrate how to manipulate the ranges’ text.
Lecture 1: Concat Cells1:20
Lecture 2: Reverse Text0:44
Lecture 3: Replace Star in Cell Text0:58
Lecture 4: Upper Case Text in Range0:49
Lecture 5: Capitalize Each Word in Range0:50
Lecture 6: Lower Case Text in Range1:06

Requirements

Students will need the Excel software and will also need to download the ExTool Add-on Application from the ParaTool website. It would be helpful to know the basic Excel functions, but not necessary.

Description

This course will include Excel topics such as working with templates, workbook and worksheet management, page setup & printing, range tools, formulas, and file & folder management. Each virtual lecture includes a visual demonstration along with audio or written commentary. At the end of the course, users are exposed to case studies—practical applications that are useful in both a workplace and educational setting. Students should take this course if they are using Excel in their daily lives—especially if they are manually completing redundant tasks with large amounts of data. Excel itself can seem very complex and not so user-friendly. By completing this course and learning the ExTool functions, users can execute basic and advanced tasks automatically and, therefore, more efficiently.

Who this course is for:

Students that use Excel in their daily work or education should take this course, no matter his or

Productivity in Excel using ExTool

What you'll learn

Explore related topics

Course content

ExTool Introduction4 lectures • 28min

Info & Template4 lectures • 3min

Excel Workbook Management7 lectures • 13min

Excel Worksheet Management16 lectures • 23min

Excel Page Setup and Print6 lectures • 13min

Excel Graphic Object Management6 lectures • 10min

Range – Select and List10 lectures • 12min

Range – Copy and Move6 lectures • 12min

Range – Hyperlink5 lectures • 8min

Range – Text7 lectures • 10min

Requirements

Description

Who this course is for: