Productivity in Excel using ExTool

Name: Productivity in Excel using ExTool
Rating: 4.4 (162 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.

Lecture 1: Information in Excel--Who's Who?0:47
Learn to organize information in Excel using ExTool and identify key data about people or roles, boosting productivity through clear data management and analysis in spreadsheets.
Lecture 2: Excel—Function Help Summary0:54
Explore Excel function help to improve efficiency in everyday tasks. Leverage ExTool to boost productivity in Excel.
Lecture 3: Information (ShortCut)—Excel 20100:43
Master essential information shortcuts in Excel 2010 using ExTool to boost productivity and streamline data tasks.
Lecture 4: Template Chart—Chandoo0:59

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
Convert .xls to .xlsx using ExTool to streamline Excel workflows. Improve compatibility and productivity in Excel.
Lecture 2: Open Folder of This File1:17
Lecture 3: Combine Listed Workbook0:47
Learn how to combine listed workbooks in Excel using ExTool to boost productivity. Apply practical steps to organize data across multiple files and improve workflow.
Lecture 4: List Recent Workbooks1:33
Lecture 5: Remove Listed Files from Recent Workbook List1:03
Lecture 5: List Opened Workbooks0:57
Discover how to list opened workbooks in Excel using ExTool for efficient workbook tracking and quick reference.

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
Master how to set a listed sheet color in Excel using ExTool to improve workbook organization, readability, and navigation.
Lecture 11: Change Listed Sheet Color1:13
Learn to change the listed sheet color in Excel with ExTool, boosting workbook navigation and visual organization.
Lecture 12: Hide Listed Sheet0:55
Lecture 13: Unhide Listed Sheet0:55
Learn to unhide a listed sheet in Excel using ExTool, boosting productivity by quickly accessing hidden data within workbooks.
Lecture 14: Protect Listed Sheets1:07
Protect listed sheets in Excel using ExTool to safeguard data and maintain productivity in real-world spreadsheet workflows.
Lecture 15: Un-Protect Listed Sheets1:17
Learn how to un-protect listed sheets in Excel using ExTool, boosting productivity by quickly managing sheet protection and access.

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
Print a selected range to pdf in Excel using ExTool to streamline sharing and documentation of precise data, boosting productivity.
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
Master how to resize listed objects in Excel using ExTool to boost productivity and streamline workbook formatting.

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
Master selecting the maximum value in each column of a target range using ExTool to boost productivity in Excel.
Lecture 6: Select Maximum Value in Each Row of Target Range0:47
Lecture 7: Select Maximum Value in Target Range0:44
Improve Excel productivity by using ExTool to select the maximum value in a target range.
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
Boost your productivity in Excel using ExTool by converting a range to a column efficiently.
Lecture 3: Copy Selected Ranges1:59
Leverage ExTool to efficiently copy selected ranges in Excel, mastering quick range duplication and paste options for productive spreadsheet workflows.
Lecture 4: Copy Listed Ranges1:01
Master copying listed ranges in Excel with ExTool, applying practical techniques to select, duplicate, and manage ranges efficiently for improved productivity.
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
Learn to add external hyperlinks in Excel using ExTool to streamline data navigation and improve productivity.
Lecture 2: Add Internal Hyperlink1:34
Lecture 3: List Internal Hyperlink1:09
Lecture 4: List External Hyperlink1:05
Learn to list external hyperlinks in Excel using ExTool to boost productivity in spreadsheet workflows.

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
Learn to replace star characters in cell text using ExTool to streamline Excel workflows and boost productivity.
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: